public bool UpdateMrContact(EmpConData empData)
{
SqlCommand command = new SqlCommand();
command.CommandText = "UpdateMrContact";
command.CommandType = CommandType.StoredProcedure;
command.Connection = con; command.Parameters.Add(paramChg(EmpConData.CONID_FIELD),SqlDbType.Int);
command.Parameters.Add(paramChg(EmpConData.CATETORY_FIELD),SqlDbType.VarChar);
command.Parameters.Add(paramChg(EmpConData.FDATE_FIELD),SqlDbType.DateTime);
command.Parameters.Add(paramChg(EmpConData.TDATE_FIELD),SqlDbType.DateTime);
command.Parameters.Add(paramChg(EmpConData.POSILEVL_FIELD),SqlDbType.VarChar);
command.Parameters.Add(paramChg(EmpConData.SALALEVL_FIELD),SqlDbType.VarChar);
command.Parameters.Add(paramChg(EmpConData.ANNSALA_FIELD),SqlDbType.VarChar);
command.Parameters.Add(paramChg(EmpConData.STATUS_FIELD),SqlDbType.VarChar);
command.Parameters.Add(paramChg(EmpConData.CONNOTE_FIELD),SqlDbType.Text);
command.Parameters[paramChg(EmpConData.CONID_FIELD)].SourceColumn = EmpConData.CONID_FIELD;
command.Parameters[paramChg(EmpConData.CATETORY_FIELD)].SourceColumn = EmpConData.CATETORY_FIELD;
command.Parameters[paramChg(EmpConData.FDATE_FIELD)].SourceColumn = EmpConData.FDATE_FIELD;
command.Parameters[paramChg(EmpConData.TDATE_FIELD)].SourceColumn = EmpConData.TDATE_FIELD;
command.Parameters[paramChg(EmpConData.POSILEVL_FIELD)].SourceColumn = EmpConData.POSILEVL_FIELD;
command.Parameters[paramChg(EmpConData.SALALEVL_FIELD)].SourceColumn = EmpConData.SALALEVL_FIELD;
command.Parameters[paramChg(EmpConData.ANNSALA_FIELD)].SourceColumn = EmpConData.ANNSALA_FIELD;
command.Parameters[paramChg(EmpConData.STATUS_FIELD)].SourceColumn = EmpConData.STATUS_FIELD;
command.Parameters[paramChg(EmpConData.CONNOTE_FIELD)].SourceColumn = EmpConData.CONNOTE_FIELD;
commandAdp.UpdateCommand = command;
commandAdp.Update(empData,EmpConData.EMPCONTACT_TABLE_NAME); if(empData.HasErrors)
{
empData.Tables[EmpBaseData.EMP_TABLE_NAME].GetErrors()[0].ClearErrors();
return false;
}
else
{
empData.AcceptChanges();
return true;
}
}
{
SqlCommand command = new SqlCommand();
command.CommandText = "UpdateMrContact";
command.CommandType = CommandType.StoredProcedure;
command.Connection = con; command.Parameters.Add(paramChg(EmpConData.CONID_FIELD),SqlDbType.Int);
command.Parameters.Add(paramChg(EmpConData.CATETORY_FIELD),SqlDbType.VarChar);
command.Parameters.Add(paramChg(EmpConData.FDATE_FIELD),SqlDbType.DateTime);
command.Parameters.Add(paramChg(EmpConData.TDATE_FIELD),SqlDbType.DateTime);
command.Parameters.Add(paramChg(EmpConData.POSILEVL_FIELD),SqlDbType.VarChar);
command.Parameters.Add(paramChg(EmpConData.SALALEVL_FIELD),SqlDbType.VarChar);
command.Parameters.Add(paramChg(EmpConData.ANNSALA_FIELD),SqlDbType.VarChar);
command.Parameters.Add(paramChg(EmpConData.STATUS_FIELD),SqlDbType.VarChar);
command.Parameters.Add(paramChg(EmpConData.CONNOTE_FIELD),SqlDbType.Text);
command.Parameters[paramChg(EmpConData.CONID_FIELD)].SourceColumn = EmpConData.CONID_FIELD;
command.Parameters[paramChg(EmpConData.CATETORY_FIELD)].SourceColumn = EmpConData.CATETORY_FIELD;
command.Parameters[paramChg(EmpConData.FDATE_FIELD)].SourceColumn = EmpConData.FDATE_FIELD;
command.Parameters[paramChg(EmpConData.TDATE_FIELD)].SourceColumn = EmpConData.TDATE_FIELD;
command.Parameters[paramChg(EmpConData.POSILEVL_FIELD)].SourceColumn = EmpConData.POSILEVL_FIELD;
command.Parameters[paramChg(EmpConData.SALALEVL_FIELD)].SourceColumn = EmpConData.SALALEVL_FIELD;
command.Parameters[paramChg(EmpConData.ANNSALA_FIELD)].SourceColumn = EmpConData.ANNSALA_FIELD;
command.Parameters[paramChg(EmpConData.STATUS_FIELD)].SourceColumn = EmpConData.STATUS_FIELD;
command.Parameters[paramChg(EmpConData.CONNOTE_FIELD)].SourceColumn = EmpConData.CONNOTE_FIELD;
commandAdp.UpdateCommand = command;
commandAdp.Update(empData,EmpConData.EMPCONTACT_TABLE_NAME); if(empData.HasErrors)
{
empData.Tables[EmpBaseData.EMP_TABLE_NAME].GetErrors()[0].ClearErrors();
return false;
}
else
{
empData.AcceptChanges();
return true;
}
}
SqlCommand command = new SqlCommand();
command.CommandText = "UpdateMrContact";
command.CommandType = CommandType.StoredProcedure;
command.Connection = con; command.Parameters.Add(paramChg(EmpConData.CONID_FIELD),SqlDbType.Int);
……
是生命一个SqlCommand对象,他可以用来执行一段Sql语句脚本。
command.Parameters.Add是用来为SqlCommand中的Sql脚本添加参数。
然后commandAdp.UpdateCommand = command; 是把前面的那个加号参数的SqlCommand对象赋给DataAdapter(数据适配器)的UpdateCommand属性,这样,这个DataAdapter就可以对数据源进行Update操作(Sql语句的Update),最后执行DataAdapter的Update方法更新数据源
后面是对可能的错误进行一些处理
是什么意思
http://blog.csdn.net/zhzuo/archive/2004/08/06/67016.aspx
http://blog.csdn.net/zhzuo/archive/2004/08/06/67037.aspx
http://blog.csdn.net/zhzuo/archive/2005/01/03/238273.aspx