1.后台脚本注册
StringBuilder sb = new StringBuilder();
sb.Append( "<script language='javascript'>" );
sb.Append( "parent.location.href ='../Logout.aspx'" );
sb.Append( "</script>");
ClientScript.RegisterStartupScript( this.GetType(), "LoadPicScript" , sb.ToString());
2.DataTable数据Select后转会DataTable
/// <summary>
/// Add By:DataTable数据Select后转会DataTable
/// </summary>
/// <param name="dt"></param>
/// <param name="condition"></param>
/// <returns></returns>
private DataTable GetNewDataTable( DataTable dt, string condition)
{
DataTable newdt = new DataTable();
newdt = dt.Clone();
DataRow [] dr = dt.Select(condition);
for (int i = 0; i < dr.Length; i++)
{
newdt.ImportRow(( DataRow )dr[i]);
}
return newdt; //返回的查询结果
3.通用的添加修改处理数据保存到数据库
a.拼接SQL 不用参数化处理
/// <summary>
/// Function:向数据库添加分组数据
/// Add By:Major 2013-07-13
/// </summary>
/// <returns></returns>
public string AddData( Hashtable ht, string strTableName)
{
StringBuilder sb = new StringBuilder();
sb.Append( string .Format(" insert into {0}(" , strTableName));
string strKey = null ;
string strValues = null ;
foreach (DictionaryEntry de in ht)
{
if (!string .IsNullOrEmpty(strKey))
{
strKey = strKey + de.Key + "," ;
strValues = strValues + "'" + de.Value.ToString() + "'," ;
}
else
{
strKey = de.Key.ToString() + "," ;
strValues = "'" + de.Value.ToString() + "'," ;
}
}
//去掉最后一个","
strKey = strKey.ToString().Trim().Substring(0, strKey.ToString().Trim().LastIndexOf("," ));
strValues = strValues.ToString().Trim().Substring(0, strValues.ToString().Trim().LastIndexOf("," ));
sb.Append(strKey + ") values(" );
sb.Append(strValues + ") " );
return sb.ToString();
}
/// <summary>
/// Function:修改数据库中信息
/// Add By:Major 2013-01-17
/// </summary>
/// <returns></returns>
public string UpdateData( Hashtable ht, string strTableName, int intUpdataId)
{
ht.Add( "id" , intUpdataId);
StringBuilder sb = new StringBuilder();
sb.Append( string .Format(" update {0} set " , strTableName));
string strKey = null ;
foreach (DictionaryEntry de in ht)
{
if (!string .IsNullOrEmpty(strKey))
{
strKey = strKey + de.Key + " = '" + de.Value.ToString() + "'," ;
}
else
{
strKey = de.Key + " = '" + de.Value.ToString() + "'," ;
}
}
//去掉最后一个","
strKey = strKey.ToString().Trim().Substring(0, strKey.ToString().Trim().LastIndexOf("," ));
sb.Append(strKey);
sb.Append( string .Format(" where id=" + intUpdataId + " "));
return sb.ToString();
}
b.拼接SQL使用参数化处理
/// <summary>
/// Function:向数据库添加数据
/// Add By:Major 2013-01-16
/// </summary>
/// <returns></returns>
public bool AddData( Hashtable ht, string strTableName)
{
//获取数据库中数值最大的ID值
int intMaxID = new CommonBll().GetMaxID(strTableName);
if (intMaxID <= 0)
{
return false ;
}
ht.Add( "id" , intMaxID);
StringBuilder sb = new StringBuilder();
sb.Append( string .Format(" insert into {0}(" , strTableName));
string strKey = null ;
string strValues = null ;
foreach (DictionaryEntry de in ht)
{
if (!string .IsNullOrEmpty(strKey))
{
strKey = strKey + de.Key + "," ;
strValues = strValues + "@" + de.Key.ToString() + "," ;
}
else
{
strKey = de.Key.ToString() + "," ;
strValues = "@" + de.Key.ToString() + "," ;
}
}
//去掉最后一个","
strKey = strKey.ToString().Trim().Substring(0, strKey.ToString().Trim().LastIndexOf("," ));
strValues = strValues.ToString().Trim().Substring(0, strValues.ToString().Trim().LastIndexOf("," ));
sb.Append(strKey + ") values(" );
sb.Append(strValues + ") " );
return ExecuteSql(ht, sb.ToString());
}
/// <summary>
/// Function:修改数据库中信息
/// Add By:Major 2013-01-17
/// </summary>
/// <returns></returns>
public bool UpdateData( Hashtable ht, string strTableName, int intUpdataId)
{
ht.Add( "id" , intUpdataId);
StringBuilder sb = new StringBuilder();
sb.Append( string .Format(" update {0} set " , strTableName));
string strKey = null ;
foreach (DictionaryEntry de in ht)
{
if (!string .IsNullOrEmpty(strKey))
{
strKey = strKey + de.Key + " = " + "@" + de.Key.ToString() + ",";
}
else
{
strKey = de.Key + " = " + "@" + de.Key.ToString() + ",";
}
}
//去掉最后一个","
strKey = strKey.ToString().Trim().Substring(0, strKey.ToString().Trim().LastIndexOf("," ));
sb.Append(strKey);
sb.Append( string .Format(" where id=@id" ));
return ExecuteSql(ht, sb.ToString());
}
/// <summary>
/// Function:执行SQL语句，返回影响的记录数
/// Add by:Major 2013-01-16
/// </summary>
/// <param name="SQLString"> SQL语句 </param>
/// <returns> 影响的记录数 </returns>
public bool ExecuteSql( Hashtable ht, string strSQL)
{
using (MySqlConnection connection = new MySqlConnection (constr))
{
using (MySqlCommand cmd = new MySqlCommand ())
{
try
{
if (connection.State == ConnectionState .Closed)
{
connection.Open();
}
cmd.CommandType = CommandType .Text;
cmd.CommandText = strSQL;
cmd.Connection = connection;
foreach (DictionaryEntry de in ht)
{
cmd.Parameters.Add( new MySqlParameter (de.Key.ToString(), de.Value));
}
int rows = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
if (connection.State == ConnectionState .Open)
{
connection.Close();
}
if (rows > 0)
{
return true ;
}
else
{
return false ;
}
}
catch (MySql.Data.MySqlClient.MySqlException e)
{
if (connection.State == ConnectionState .Open)
{
connection.Close();
}
return false ;
}
}
}
}
