/// <summary>
/// 添加一条记录
/// </summary>
/// <param name="sql">添加sql命令</param>
/// <returns></returns>
public int AddExecSql(string sql, string UserName, string English, string Chinese)
{
DBSql dbObj = new DBSql();
int i = 0;
SqlConnection myConn = dbObj.GetConnection();
SqlCommand myCmd = new SqlCommand(sql, myConn);
myConn.Open();
try
{
myCmd.Parameters.Add("@UserName", SqlDbType.VarChar).Value = UserName;
myCmd.Parameters.Add("@English", SqlDbType.VarChar).Value = English;
myCmd.Parameters.Add("@Chinese", SqlDbType.VarChar).Value = Chinese;
i = myCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
myCmd.Dispose();
myConn.Close();
}
return(i);
}
/// <summary>
/// 执行一条Sql语句
/// </summary>
/// <param name="sql">添加sql命令</param>
/// <returns></returns>
public void DoExecSql(string sql)
{
DBSql dbObj = new DBSql();
SqlConnection myConn = dbObj.GetConnection();
SqlCommand myCmd = new SqlCommand(sql, myConn);
myConn.Open();
try
{
myCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
myCmd.Dispose();
myConn.Close();
}
}
