///
/// 更新一条数据
///
public void Update(MasterSoft.Model.PurchaseMain model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update PurchaseMain set ");
strSql.Append("CompanyNo=@CompanyNo,");
strSql.Append("PurchaseUser=@PurchaseUser,");
strSql.Append("PurchaseNoAudit=@PurchaseNoAudit,");
strSql.Append("PurchaseOrderConfirmNo=@PurchaseOrderConfirmNo,");
strSql.Append("PurchaseOrderConfirmDate=@PurchaseOrderConfirmDate,");
strSql.Append("PayTypeNo=@PayTypeNo,");
strSql.Append("CompanyRemark=@CompanyRemark");
strSql.Append(" where PurchaseNo=@PurchaseNo ");
SqlParameter[] parameters = {
new SqlParameter("@PurchaseNo", SqlDbType.VarChar,20),
new SqlParameter("@PurchaseDate", SqlDbType.DateTime),
new SqlParameter("@CompanyNo", SqlDbType.VarChar,20),
new SqlParameter("@PurchaseUser", SqlDbType.VarChar,20),
new SqlParameter("@PurchaseNoAudit", SqlDbType.VarChar,20),
new SqlParameter("@PurchaseOrderConfirmNo", SqlDbType.VarChar,20),
new SqlParameter("@PurchaseOrderConfirmDate", SqlDbType.DateTime),
new SqlParameter("@PayTypeNo", SqlDbType.VarChar,20),
new SqlParameter("@CompanyRemark", SqlDbType.VarChar,255)};
parameters[0].Value = model.PurchaseNo;
parameters[1].Value = model.PurchaseDate;
parameters[2].Value = model.CompanyNo;
parameters[3].Value = model.PurchaseUser;
parameters[4].Value = model.PurchaseNoAudit;
parameters[5].Value = model.PurchaseOrderConfirmNo;
parameters[6].Value = model.PurchaseOrderConfirmDate;
parameters[7].Value = model.PayTypeNo;
parameters[8].Value = model.CompanyRemark;

DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}