/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WisdCar.Model.PO.ClubCardPO model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ClubCard(");
strSql.Append("ClubCardTypeName,CustName,ClubCardPwd,OpenCardStore,SalesMan,SalesTime,Balance,CustomerID,ClubCardTypeID,ExpireDate,CardStatus,ClubCardNo,LogicalStatus,CreatorID,CreatedDate,LastModifierID,LastModifiedDate,Reserved1,Reserved2,Reserved3)");
strSql.Append(" values (");
strSql.Append("@ClubCardTypeName,@CustName,@ClubCardPwd,@OpenCardStore,@SalesMan,@SalesTime,@Balance,@CustomerID,@ClubCardTypeID,@ExpireDate,@CardStatus,@ClubCardNo,@LogicalStatus,@CreatorID,@CreatedDate,@LastModifierID,@LastModifiedDate,@Reserved1,@Reserved2,@Reserved3)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@ClubCardTypeName", SqlDbType.NVarChar,50),
new SqlParameter("@CustName", SqlDbType.NVarChar,50),
new SqlParameter("@ClubCardPwd", SqlDbType.NVarChar,50),
new SqlParameter("@OpenCardStore", SqlDbType.NVarChar,50),
new SqlParameter("@SalesMan", SqlDbType.NVarChar,50),
new SqlParameter("@SalesTime", SqlDbType.DateTime),
new SqlParameter("@Balance", SqlDbType.Decimal,5),
new SqlParameter("@CustomerID", SqlDbType.Int,4),
new SqlParameter("@ClubCardTypeID", SqlDbType.Int,4),
new SqlParameter("@ExpireDate", SqlDbType.DateTime),
new SqlParameter("@CardStatus", SqlDbType.Int,4),
new SqlParameter("@ClubCardNo", SqlDbType.NVarChar,50),
new SqlParameter("@LogicalStatus", SqlDbType.Int,4),
new SqlParameter("@CreatorID", SqlDbType.NVarChar,50),
new SqlParameter("@CreatedDate", SqlDbType.DateTime),
new SqlParameter("@LastModifierID", SqlDbType.NVarChar,50),
new SqlParameter("@LastModifiedDate", SqlDbType.DateTime),
new SqlParameter("@Reserved1", SqlDbType.NVarChar,100),
new SqlParameter("@Reserved2", SqlDbType.NVarChar,100),
new SqlParameter("@Reserved3", SqlDbType.NVarChar,100)};
parameters[0].Value = model.ClubCardTypeName;
parameters[1].Value = model.CustName;
parameters[2].Value = model.ClubCardPwd;
parameters[3].Value = model.OpenCardStore;
parameters[4].Value = model.SalesMan;
parameters[5].Value = model.SalesTime;
parameters[6].Value = model.Balance;
parameters[7].Value = model.CustomerID;
parameters[8].Value = model.ClubCardTypeID;
parameters[9].Value = model.ExpireDate;
parameters[10].Value = model.CardStatus;
parameters[11].Value = model.ClubCardNo;
parameters[12].Value = model.LogicalStatus;
parameters[13].Value = model.CreatorID;
parameters[14].Value = model.CreatedDate;
parameters[15].Value = model.LastModifierID;
parameters[16].Value = model.LastModifiedDate;
parameters[17].Value = model.Reserved1;
parameters[18].Value = model.Reserved2;
parameters[19].Value = model.Reserved3;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WisdCar.Model.PO.ClubCardPackagePO model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ClubCardPackage(");
strSql.Append("ClubCardPackageID,PackageName,OriginalAmount,ActualAmount,DiscountRate,DiscountInfo,PackageStatus,Salesman,SalesTime,SaleStore,PackageID,ClubCardID,LogicalStatus,CreatorID,CreatedDate,LastModifierID,LastModifiedDate,Reserved1,Reserved2,Reserved3)");
strSql.Append(" values (");
strSql.Append("@ClubCardPackageID,@PackageName,@OriginalAmount,@ActualAmount,@DiscountRate,@DiscountInfo,@PackageStatus,@Salesman,@SalesTime,@SaleStore,@PackageID,@ClubCardID,@LogicalStatus,@CreatorID,@CreatedDate,@LastModifierID,@LastModifiedDate,@Reserved1,@Reserved2,@Reserved3)");
SqlParameter[] parameters = {
new SqlParameter("@ClubCardPackageID", SqlDbType.NVarChar,50),
new SqlParameter("@PackageName", SqlDbType.NVarChar,50),
new SqlParameter("@OriginalAmount", SqlDbType.Decimal,5),
new SqlParameter("@ActualAmount", SqlDbType.Decimal,5),
new SqlParameter("@DiscountRate", SqlDbType.Decimal,5),
new SqlParameter("@DiscountInfo", SqlDbType.NVarChar,50),
new SqlParameter("@PackageStatus", SqlDbType.Int,4),
new SqlParameter("@Salesman", SqlDbType.NVarChar,50),
new SqlParameter("@SalesTime", SqlDbType.DateTime),
new SqlParameter("@SaleStore", SqlDbType.NVarChar,50),
new SqlParameter("@PackageID", SqlDbType.Int,4),
new SqlParameter("@ClubCardID", SqlDbType.Int,4),
new SqlParameter("@LogicalStatus", SqlDbType.Int,4),
new SqlParameter("@CreatorID", SqlDbType.NVarChar,50),
new SqlParameter("@CreatedDate", SqlDbType.DateTime),
new SqlParameter("@LastModifierID", SqlDbType.NVarChar,50),
new SqlParameter("@LastModifiedDate", SqlDbType.DateTime),
new SqlParameter("@Reserved1", SqlDbType.NVarChar,100),
new SqlParameter("@Reserved2", SqlDbType.NVarChar,100),
new SqlParameter("@Reserved3", SqlDbType.NVarChar,100)};
parameters[0].Value = model.ClubCardPackageID;
parameters[1].Value = model.PackageName;
parameters[2].Value = model.OriginalAmount;
parameters[3].Value = model.ActualAmount;
parameters[4].Value = model.DiscountRate;
parameters[5].Value = model.DiscountInfo;
parameters[6].Value = model.PackageStatus;
parameters[7].Value = model.Salesman;
parameters[8].Value = model.SalesTime;
parameters[9].Value = model.SaleStore;
parameters[10].Value = model.PackageID;
parameters[11].Value = model.ClubCardID;
parameters[12].Value = model.LogicalStatus;
parameters[13].Value = model.CreatorID;
parameters[14].Value = model.CreatedDate;
parameters[15].Value = model.LastModifierID;
parameters[16].Value = model.LastModifiedDate;
parameters[17].Value = model.Reserved1;
parameters[18].Value = model.Reserved2;
parameters[19].Value = model.Reserved3;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WisdCar.Model.PO.CarPO model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Car(");
strSql.Append("CarNo,Brand,CarModel,Capacity,Color,FrameNo,EngineNo,MaintainKM,InsureDate,ASDate,CustomerID,LogicalStatus,CreatorID,CreatedDate,LastModifierID,LastModifiedDate,Reserved1,Reserved2,Reserved3)");
strSql.Append(" values (");
strSql.Append("@CarNo,@Brand,@CarModel,@Capacity,@Color,@FrameNo,@EngineNo,@MaintainKM,@InsureDate,@ASDate,@CustomerID,@LogicalStatus,@CreatorID,@CreatedDate,@LastModifierID,@LastModifiedDate,@Reserved1,@Reserved2,@Reserved3)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@CarNo", SqlDbType.NVarChar,50),
new SqlParameter("@Brand", SqlDbType.NVarChar,50),
new SqlParameter("@CarModel", SqlDbType.NVarChar,50),
new SqlParameter("@Capacity", SqlDbType.NVarChar,50),
new SqlParameter("@Color", SqlDbType.NVarChar,50),
new SqlParameter("@FrameNo", SqlDbType.NVarChar,50),
new SqlParameter("@EngineNo", SqlDbType.NVarChar,50),
new SqlParameter("@MaintainKM", SqlDbType.NVarChar,50),
new SqlParameter("@InsureDate", SqlDbType.DateTime),
new SqlParameter("@ASDate", SqlDbType.DateTime),
new SqlParameter("@CustomerID", SqlDbType.Int,4),
new SqlParameter("@LogicalStatus", SqlDbType.Int,4),
new SqlParameter("@CreatorID", SqlDbType.NVarChar,50),
new SqlParameter("@CreatedDate", SqlDbType.DateTime),
new SqlParameter("@LastModifierID", SqlDbType.NVarChar,50),
new SqlParameter("@LastModifiedDate", SqlDbType.DateTime),
new SqlParameter("@Reserved1", SqlDbType.NVarChar,100),
new SqlParameter("@Reserved2", SqlDbType.NVarChar,100),
new SqlParameter("@Reserved3", SqlDbType.NVarChar,100)};
parameters[0].Value = model.CarNo;
parameters[1].Value = model.Brand;
parameters[2].Value = model.CarModel;
parameters[3].Value = model.Capacity;
parameters[4].Value = model.Color;
parameters[5].Value = model.FrameNo;
parameters[6].Value = model.EngineNo;
parameters[7].Value = model.MaintainKM;
parameters[8].Value = model.InsureDate;
parameters[9].Value = model.ASDate;
parameters[10].Value = model.CustomerID;
parameters[11].Value = model.LogicalStatus;
parameters[12].Value = model.CreatorID;
parameters[13].Value = model.CreatedDate;
parameters[14].Value = model.LastModifierID;
parameters[15].Value = model.LastModifiedDate;
parameters[16].Value = model.Reserved1;
parameters[17].Value = model.Reserved2;
parameters[18].Value = model.Reserved3;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WisdCar.Model.PO.EmployeePO model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Employee(");
strSql.Append("EmployeeNo,Name,Sex,Phone,JobType,EmployeeAddr,EmployeeResume,StoreID,StoreName,LogicalStatus,CreatorID,CreatedDate,LastModifierID,LastModifiedDate,Reserved1,Reserved2,Reserved3)");
strSql.Append(" values (");
strSql.Append("@EmployeeNo,@Name,@Sex,@Phone,@JobType,@EmployeeAddr,@EmployeeResume,@StoreID,@StoreName,@LogicalStatus,@CreatorID,@CreatedDate,@LastModifierID,@LastModifiedDate,@Reserved1,@Reserved2,@Reserved3)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@EmployeeNo", SqlDbType.NVarChar,50),
new SqlParameter("@Name", SqlDbType.NVarChar,50),
new SqlParameter("@Sex", SqlDbType.NVarChar,50),
new SqlParameter("@Phone", SqlDbType.NVarChar,50),
new SqlParameter("@JobType", SqlDbType.NVarChar,50),
new SqlParameter("@EmployeeAddr", SqlDbType.NVarChar,50),
new SqlParameter("@EmployeeResume", SqlDbType.NVarChar,50),
new SqlParameter("@StoreID", SqlDbType.Int,4),
new SqlParameter("@StoreName", SqlDbType.NVarChar,50),
new SqlParameter("@LogicalStatus", SqlDbType.Int,4),
new SqlParameter("@CreatorID", SqlDbType.NVarChar,50),
new SqlParameter("@CreatedDate", SqlDbType.DateTime),
new SqlParameter("@LastModifierID", SqlDbType.NVarChar,50),
new SqlParameter("@LastModifiedDate", SqlDbType.DateTime),
new SqlParameter("@Reserved1", SqlDbType.NVarChar,100),
new SqlParameter("@Reserved2", SqlDbType.NVarChar,100),
new SqlParameter("@Reserved3", SqlDbType.NVarChar,100)};
parameters[0].Value = model.EmployeeNo;
parameters[1].Value = model.Name;
parameters[2].Value = model.Sex;
parameters[3].Value = model.Phone;
parameters[4].Value = model.JobType;
parameters[5].Value = model.EmployeeAddr;
parameters[6].Value = model.EmployeeResume;
parameters[7].Value = model.StoreID;
parameters[8].Value = model.StoreName;
parameters[9].Value = model.LogicalStatus;
parameters[10].Value = model.CreatorID;
parameters[11].Value = model.CreatedDate;
parameters[12].Value = model.LastModifierID;
parameters[13].Value = model.LastModifiedDate;
parameters[14].Value = model.Reserved1;
parameters[15].Value = model.Reserved2;
parameters[16].Value = model.Reserved3;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WisdCar.Model.PO.CustomerPO model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Customer(");
strSql.Append("Name,MobileNO,Sex,Birthday,ICNo,Weixin,Company,CardFlag,LogicalStatus,CreatorID,CreatedDate,LastModifierID,LastModifiedDate,Reserved1,Reserved2,Reserved3)");
strSql.Append(" values (");
strSql.Append("@Name,@MobileNO,@Sex,@Birthday,@ICNo,@Weixin,@Company,@CardFlag,@LogicalStatus,@CreatorID,@CreatedDate,@LastModifierID,@LastModifiedDate,@Reserved1,@Reserved2,@Reserved3)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Name", SqlDbType.NVarChar,50),
new SqlParameter("@MobileNO", SqlDbType.NVarChar,50),
new SqlParameter("@Sex", SqlDbType.NVarChar,50),
new SqlParameter("@Birthday", SqlDbType.NVarChar,50),
new SqlParameter("@ICNo", SqlDbType.NVarChar,50),
new SqlParameter("@Weixin", SqlDbType.NVarChar,50),
new SqlParameter("@Company", SqlDbType.NVarChar,50),
new SqlParameter("@CardFlag", SqlDbType.Int,4),
new SqlParameter("@LogicalStatus", SqlDbType.Int,4),
new SqlParameter("@CreatorID", SqlDbType.NVarChar,50),
new SqlParameter("@CreatedDate", SqlDbType.DateTime),
new SqlParameter("@LastModifierID", SqlDbType.NVarChar,50),
new SqlParameter("@LastModifiedDate", SqlDbType.DateTime),
new SqlParameter("@Reserved1", SqlDbType.NVarChar,100),
new SqlParameter("@Reserved2", SqlDbType.NVarChar,100),
new SqlParameter("@Reserved3", SqlDbType.NVarChar,100)};
parameters[0].Value = model.Name;
parameters[1].Value = model.MobileNO;
parameters[2].Value = model.Sex;
parameters[3].Value = model.Birthday;
parameters[4].Value = model.ICNo;
parameters[5].Value = model.Weixin;
parameters[6].Value = model.Company;
parameters[7].Value = model.CardFlag;
parameters[8].Value = model.LogicalStatus;
parameters[9].Value = model.CreatorID;
parameters[10].Value = model.CreatedDate;
parameters[11].Value = model.LastModifierID;
parameters[12].Value = model.LastModifiedDate;
parameters[13].Value = model.Reserved1;
parameters[14].Value = model.Reserved2;
parameters[15].Value = model.Reserved3;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WisdCar.Model.PO.ClubCardPackageDetailPO model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into ClubCardPackageDetail(");
strSql.Append("ItemID,ItemName,UnitPrice,OriginalCount,RemainCount,ClubCardPackageID,LogicalStatus,CreatorID,CreatedDate,LastModifierID,LastModifiedDate,Reserved1,Reserved2,Reserved3)");
strSql.Append(" values (");
strSql.Append("@ItemID,@ItemName,@UnitPrice,@OriginalCount,@RemainCount,@ClubCardPackageID,@LogicalStatus,@CreatorID,@CreatedDate,@LastModifierID,@LastModifiedDate,@Reserved1,@Reserved2,@Reserved3)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@ItemID", SqlDbType.Int,4),
new SqlParameter("@ItemName", SqlDbType.NVarChar,50),
new SqlParameter("@UnitPrice", SqlDbType.Decimal,5),
new SqlParameter("@OriginalCount", SqlDbType.Int,4),
new SqlParameter("@RemainCount", SqlDbType.Int,4),
new SqlParameter("@ClubCardPackageID", SqlDbType.NVarChar,50),
new SqlParameter("@LogicalStatus", SqlDbType.Int,4),
new SqlParameter("@CreatorID", SqlDbType.NVarChar,50),
new SqlParameter("@CreatedDate", SqlDbType.DateTime),
new SqlParameter("@LastModifierID", SqlDbType.NVarChar,50),
new SqlParameter("@LastModifiedDate", SqlDbType.DateTime),
new SqlParameter("@Reserved1", SqlDbType.NVarChar,100),
new SqlParameter("@Reserved2", SqlDbType.NVarChar,100),
new SqlParameter("@Reserved3", SqlDbType.NVarChar,100)};
parameters[0].Value = model.ItemID;
parameters[1].Value = model.ItemName;
parameters[2].Value = model.UnitPrice;
parameters[3].Value = model.OriginalCount;
parameters[4].Value = model.RemainCount;
parameters[5].Value = model.ClubCardPackageID;
parameters[6].Value = model.LogicalStatus;
parameters[7].Value = model.CreatorID;
parameters[8].Value = model.CreatedDate;
parameters[9].Value = model.LastModifierID;
parameters[10].Value = model.LastModifiedDate;
parameters[11].Value = model.Reserved1;
parameters[12].Value = model.Reserved2;
parameters[13].Value = model.Reserved3;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WisdCar.Model.PO.KVLookupPO model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into KVLookup(");
strSql.Append("LookupKey,LookupValue,CategoryID,LogicalStatus,CreatorID,CreatedDate,LastModifierID,LastModifiedDate,Reserved1,Reserved2,Reserved3)");
strSql.Append(" values (");
strSql.Append("@LookupKey,@LookupValue,@CategoryID,@LogicalStatus,@CreatorID,@CreatedDate,@LastModifierID,@LastModifiedDate,@Reserved1,@Reserved2,@Reserved3)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@LookupKey", SqlDbType.NVarChar,100),
new SqlParameter("@LookupValue", SqlDbType.NVarChar,200),
new SqlParameter("@CategoryID", SqlDbType.Int,4),
new SqlParameter("@LogicalStatus", SqlDbType.Int,4),
new SqlParameter("@CreatorID", SqlDbType.NVarChar,50),
new SqlParameter("@CreatedDate", SqlDbType.DateTime),
new SqlParameter("@LastModifierID", SqlDbType.NVarChar,50),
new SqlParameter("@LastModifiedDate", SqlDbType.DateTime),
new SqlParameter("@Reserved1", SqlDbType.NVarChar,100),
new SqlParameter("@Reserved2", SqlDbType.NVarChar,100),
new SqlParameter("@Reserved3", SqlDbType.NVarChar,100)};
parameters[0].Value = model.LookupKey;
parameters[1].Value = model.LookupValue;
parameters[2].Value = model.CategoryID;
parameters[3].Value = model.LogicalStatus;
parameters[4].Value = model.CreatorID;
parameters[5].Value = model.CreatedDate;
parameters[6].Value = model.LastModifierID;
parameters[7].Value = model.LastModifiedDate;
parameters[8].Value = model.Reserved1;
parameters[9].Value = model.Reserved2;
parameters[10].Value = model.Reserved3;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WisdCar.Model.PO.ClubCardTypePO model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ClubCardType set ");
strSql.Append("CardTypeName=@CardTypeName,");
strSql.Append("PackageDiscount=@PackageDiscount,");
strSql.Append("PayDiscount=@PayDiscount,");
strSql.Append("LogicalStatus=@LogicalStatus,");
strSql.Append("CreatorID=@CreatorID,");
strSql.Append("CreatedDate=@CreatedDate,");
strSql.Append("LastModifierID=@LastModifierID,");
strSql.Append("LastModifiedDate=@LastModifiedDate,");
strSql.Append("Reserved1=@Reserved1,");
strSql.Append("Reserved2=@Reserved2,");
strSql.Append("Reserved3=@Reserved3");
strSql.Append(" where ClubCardTypeID=@ClubCardTypeID");
SqlParameter[] parameters = {
new SqlParameter("@CardTypeName", SqlDbType.NVarChar,50),
new SqlParameter("@PackageDiscount", SqlDbType.Decimal,5),
new SqlParameter("@PayDiscount", SqlDbType.Decimal,5),
new SqlParameter("@LogicalStatus", SqlDbType.Int,4),
new SqlParameter("@CreatorID", SqlDbType.NVarChar,50),
new SqlParameter("@CreatedDate", SqlDbType.DateTime),
new SqlParameter("@LastModifierID", SqlDbType.NVarChar,50),
new SqlParameter("@LastModifiedDate", SqlDbType.DateTime),
new SqlParameter("@Reserved1", SqlDbType.NVarChar,100),
new SqlParameter("@Reserved2", SqlDbType.NVarChar,100),
new SqlParameter("@Reserved3", SqlDbType.NVarChar,100),
new SqlParameter("@ClubCardTypeID", SqlDbType.Int,4)};
parameters[0].Value = model.CardTypeName;
parameters[1].Value = model.PackageDiscount;
parameters[2].Value = model.PayDiscount;
parameters[3].Value = model.LogicalStatus;
parameters[4].Value = model.CreatorID;
parameters[5].Value = model.CreatedDate;
parameters[6].Value = model.LastModifierID;
parameters[7].Value = model.LastModifiedDate;
parameters[8].Value = model.Reserved1;
parameters[9].Value = model.Reserved2;
parameters[10].Value = model.Reserved3;
parameters[11].Value = model.ClubCardTypeID;
string cardsql = "update clubcard set clubcardtypename = @cardtypename where clubcardtypeid = @typeid";
SqlParameter[] cardsps ={
new SqlParameter("@cardtypename",model.CardTypeName),new SqlParameter("@typeid",model.ClubCardTypeID)
};
//int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
try
{
Hashtable hs = new Hashtable();
hs.Add(strSql,parameters);
hs.Add(cardsql,cardsps);
DbHelperSQL.ExecuteSqlTranWithIndentity(hs);
return true;
}
catch
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WisdCar.Model.PO.ConsumeItemPO model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update ConsumeItem set ");
strSql.Append("ItemName=@ItemName,");
strSql.Append("ItemPrice=@ItemPrice,");
strSql.Append("LogicalStatus=@LogicalStatus,");
strSql.Append("CreatorID=@CreatorID,");
strSql.Append("CreatedDate=@CreatedDate,");
strSql.Append("LastModifierID=@LastModifierID,");
strSql.Append("LastModifiedDate=@LastModifiedDate,");
strSql.Append("Reserved1=@Reserved1,");
strSql.Append("Reserved2=@Reserved2,");
strSql.Append("Reserved3=@Reserved3");
strSql.Append(" where ItemID=@ItemID");
SqlParameter[] parameters = {
new SqlParameter("@ItemName", SqlDbType.NVarChar,50),
new SqlParameter("@ItemPrice", SqlDbType.Decimal,5),
new SqlParameter("@LogicalStatus", SqlDbType.Int,4),
new SqlParameter("@CreatorID", SqlDbType.NVarChar,50),
new SqlParameter("@CreatedDate", SqlDbType.DateTime),
new SqlParameter("@LastModifierID", SqlDbType.NVarChar,50),
new SqlParameter("@LastModifiedDate", SqlDbType.DateTime),
new SqlParameter("@Reserved1", SqlDbType.NVarChar,100),
new SqlParameter("@Reserved2", SqlDbType.NVarChar,100),
new SqlParameter("@Reserved3", SqlDbType.NVarChar,100),
new SqlParameter("@ItemID", SqlDbType.Int,4)};
parameters[0].Value = model.ItemName;
parameters[1].Value = model.ItemPrice;
parameters[2].Value = model.LogicalStatus;
parameters[3].Value = model.CreatorID;
parameters[4].Value = model.CreatedDate;
parameters[5].Value = model.LastModifierID;
parameters[6].Value = model.LastModifiedDate;
parameters[7].Value = model.Reserved1;
parameters[8].Value = model.Reserved2;
parameters[9].Value = model.Reserved3;
parameters[10].Value = model.ItemID;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WisdCar.Model.PO.EmployeePO model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Employee set ");
strSql.Append("EmployeeNo=@EmployeeNo,");
strSql.Append("Name=@Name,");
strSql.Append("Sex=@Sex,");
strSql.Append("Phone=@Phone,");
strSql.Append("JobType=@JobType,");
strSql.Append("EmployeeAddr=@EmployeeAddr,");
strSql.Append("EmployeeResume=@EmployeeResume,");
strSql.Append("StoreID=@StoreID,");
strSql.Append("StoreName=@StoreName,");
strSql.Append("LogicalStatus=@LogicalStatus,");
strSql.Append("CreatorID=@CreatorID,");
strSql.Append("CreatedDate=@CreatedDate,");
strSql.Append("LastModifierID=@LastModifierID,");
strSql.Append("LastModifiedDate=@LastModifiedDate,");
strSql.Append("Reserved1=@Reserved1,");
strSql.Append("Reserved2=@Reserved2,");
strSql.Append("Reserved3=@Reserved3");
strSql.Append(" where EmployeeID=@EmployeeID");
SqlParameter[] parameters = {
new SqlParameter("@EmployeeNo", SqlDbType.NVarChar,50),
new SqlParameter("@Name", SqlDbType.NVarChar,50),
new SqlParameter("@Sex", SqlDbType.NVarChar,50),
new SqlParameter("@Phone", SqlDbType.NVarChar,50),
new SqlParameter("@JobType", SqlDbType.NVarChar,50),
new SqlParameter("@EmployeeAddr", SqlDbType.NVarChar,50),
new SqlParameter("@EmployeeResume", SqlDbType.NVarChar,50),
new SqlParameter("@StoreID", SqlDbType.Int,4),
new SqlParameter("@StoreName", SqlDbType.NVarChar,50),
new SqlParameter("@LogicalStatus", SqlDbType.Int,4),
new SqlParameter("@CreatorID", SqlDbType.NVarChar,50),
new SqlParameter("@CreatedDate", SqlDbType.DateTime),
new SqlParameter("@LastModifierID", SqlDbType.NVarChar,50),
new SqlParameter("@LastModifiedDate", SqlDbType.DateTime),
new SqlParameter("@Reserved1", SqlDbType.NVarChar,100),
new SqlParameter("@Reserved2", SqlDbType.NVarChar,100),
new SqlParameter("@Reserved3", SqlDbType.NVarChar,100),
new SqlParameter("@EmployeeID", SqlDbType.Int,4)};
parameters[0].Value = model.EmployeeNo;
parameters[1].Value = model.Name;
parameters[2].Value = model.Sex;
parameters[3].Value = model.Phone;
parameters[4].Value = model.JobType;
parameters[5].Value = model.EmployeeAddr;
parameters[6].Value = model.EmployeeResume;
parameters[7].Value = model.StoreID;
parameters[8].Value = model.StoreName;
parameters[9].Value = model.LogicalStatus;
parameters[10].Value = model.CreatorID;
parameters[11].Value = model.CreatedDate;
parameters[12].Value = model.LastModifierID;
parameters[13].Value = model.LastModifiedDate;
parameters[14].Value = model.Reserved1;
parameters[15].Value = model.Reserved2;
parameters[16].Value = model.Reserved3;
parameters[17].Value = model.EmployeeID;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WisdCar.Model.PO.KVLookupPO model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update KVLookup set ");
strSql.Append("LookupKey=@LookupKey,");
strSql.Append("LookupValue=@LookupValue,");
strSql.Append("CategoryID=@CategoryID,");
strSql.Append("LogicalStatus=@LogicalStatus,");
strSql.Append("CreatorID=@CreatorID,");
strSql.Append("CreatedDate=@CreatedDate,");
strSql.Append("LastModifierID=@LastModifierID,");
strSql.Append("LastModifiedDate=@LastModifiedDate,");
strSql.Append("Reserved1=@Reserved1,");
strSql.Append("Reserved2=@Reserved2,");
strSql.Append("Reserved3=@Reserved3");
strSql.Append(" where LookupID=@LookupID");
SqlParameter[] parameters = {
new SqlParameter("@LookupKey", SqlDbType.NVarChar,100),
new SqlParameter("@LookupValue", SqlDbType.NVarChar,200),
new SqlParameter("@CategoryID", SqlDbType.Int,4),
new SqlParameter("@LogicalStatus", SqlDbType.Int,4),
new SqlParameter("@CreatorID", SqlDbType.NVarChar,50),
new SqlParameter("@CreatedDate", SqlDbType.DateTime),
new SqlParameter("@LastModifierID", SqlDbType.NVarChar,50),
new SqlParameter("@LastModifiedDate", SqlDbType.DateTime),
new SqlParameter("@Reserved1", SqlDbType.NVarChar,100),
new SqlParameter("@Reserved2", SqlDbType.NVarChar,100),
new SqlParameter("@Reserved3", SqlDbType.NVarChar,100),
new SqlParameter("@LookupID", SqlDbType.Int,4)};
parameters[0].Value = model.LookupKey;
parameters[1].Value = model.LookupValue;
parameters[2].Value = model.CategoryID;
parameters[3].Value = model.LogicalStatus;
parameters[4].Value = model.CreatorID;
parameters[5].Value = model.CreatedDate;
parameters[6].Value = model.LastModifierID;
parameters[7].Value = model.LastModifiedDate;
parameters[8].Value = model.Reserved1;
parameters[9].Value = model.Reserved2;
parameters[10].Value = model.Reserved3;
parameters[11].Value = model.LookupID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WisdCar.Model.PO.CarPO model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Car set ");
strSql.Append("CarNo=@CarNo,");
strSql.Append("Brand=@Brand,");
strSql.Append("CarModel=@CarModel,");
strSql.Append("Capacity=@Capacity,");
strSql.Append("Color=@Color,");
strSql.Append("FrameNo=@FrameNo,");
strSql.Append("EngineNo=@EngineNo,");
strSql.Append("MaintainKM=@MaintainKM,");
strSql.Append("InsureDate=@InsureDate,");
strSql.Append("ASDate=@ASDate,");
strSql.Append("CustomerID=@CustomerID,");
strSql.Append("LogicalStatus=@LogicalStatus,");
//strSql.Append("CreatorID=@CreatorID,");
//strSql.Append("CreatedDate=@CreatedDate,");
strSql.Append("LastModifierID=@LastModifierID,");
strSql.Append("LastModifiedDate=@LastModifiedDate,");
strSql.Append("Reserved1=@Reserved1,");
strSql.Append("Reserved2=@Reserved2,");
strSql.Append("Reserved3=@Reserved3");
strSql.Append(" where CarID=@CarID");
SqlParameter[] parameters = {
new SqlParameter("@CarNo", SqlDbType.NVarChar,50),
new SqlParameter("@Brand", SqlDbType.NVarChar,50),
new SqlParameter("@CarModel", SqlDbType.NVarChar,50),
new SqlParameter("@Capacity", SqlDbType.NVarChar,50),
new SqlParameter("@Color", SqlDbType.NVarChar,50),
new SqlParameter("@FrameNo", SqlDbType.NVarChar,50),
new SqlParameter("@EngineNo", SqlDbType.NVarChar,50),
new SqlParameter("@MaintainKM", SqlDbType.NVarChar,50),
new SqlParameter("@InsureDate", SqlDbType.DateTime),
new SqlParameter("@ASDate", SqlDbType.DateTime),
new SqlParameter("@CustomerID", SqlDbType.Int,4),
new SqlParameter("@LogicalStatus", SqlDbType.Int,4),
//new SqlParameter("@CreatorID", SqlDbType.NVarChar,50),
//new SqlParameter("@CreatedDate", SqlDbType.DateTime),
new SqlParameter("@LastModifierID", SqlDbType.NVarChar,50),
new SqlParameter("@LastModifiedDate", SqlDbType.DateTime),
new SqlParameter("@Reserved1", SqlDbType.NVarChar,100),
new SqlParameter("@Reserved2", SqlDbType.NVarChar,100),
new SqlParameter("@Reserved3", SqlDbType.NVarChar,100),
new SqlParameter("@CarID", SqlDbType.Int,4)};
parameters[0].Value = model.CarNo;
parameters[1].Value = model.Brand;
parameters[2].Value = model.CarModel;
parameters[3].Value = model.Capacity;
parameters[4].Value = model.Color;
parameters[5].Value = model.FrameNo;
parameters[6].Value = model.EngineNo;
parameters[7].Value = model.MaintainKM;
parameters[8].Value = model.InsureDate;
parameters[9].Value = model.ASDate;
parameters[10].Value = model.CustomerID;
parameters[11].Value = model.LogicalStatus;
//parameters[12].Value = model.CreatorID;
//parameters[13].Value = model.CreatedDate;
parameters[12].Value = model.LastModifierID;
parameters[13].Value = model.LastModifiedDate;
parameters[14].Value = model.Reserved1;
parameters[15].Value = model.Reserved2;
parameters[16].Value = model.Reserved3;
parameters[17].Value = model.CarID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WisdCar.Model.PO.ClubCardPO model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ClubCard set ");
strSql.Append("ClubCardTypeName=@ClubCardTypeName,");
strSql.Append("CustName=@CustName,");
strSql.Append("ClubCardPwd=@ClubCardPwd,");
strSql.Append("OpenCardStore=@OpenCardStore,");
strSql.Append("SalesMan=@SalesMan,");
strSql.Append("SalesTime=@SalesTime,");
strSql.Append("Balance=@Balance,");
strSql.Append("CustomerID=@CustomerID,");
strSql.Append("ClubCardTypeID=@ClubCardTypeID,");
strSql.Append("ExpireDate=@ExpireDate,");
strSql.Append("CardStatus=@CardStatus,");
strSql.Append("ClubCardNo=@ClubCardNo,");
strSql.Append("LogicalStatus=@LogicalStatus,");
strSql.Append("CreatorID=@CreatorID,");
strSql.Append("CreatedDate=@CreatedDate,");
strSql.Append("LastModifierID=@LastModifierID,");
strSql.Append("LastModifiedDate=@LastModifiedDate,");
strSql.Append("Reserved1=@Reserved1,");
strSql.Append("Reserved2=@Reserved2,");
strSql.Append("Reserved3=@Reserved3");
strSql.Append(" where ClubCardID=@ClubCardID");
SqlParameter[] parameters = {
new SqlParameter("@ClubCardTypeName", SqlDbType.NVarChar,50),
new SqlParameter("@CustName", SqlDbType.NVarChar,50),
new SqlParameter("@ClubCardPwd", SqlDbType.NVarChar,50),
new SqlParameter("@OpenCardStore", SqlDbType.NVarChar,50),
new SqlParameter("@SalesMan", SqlDbType.NVarChar,50),
new SqlParameter("@SalesTime", SqlDbType.DateTime),
new SqlParameter("@Balance", SqlDbType.Decimal,5),
new SqlParameter("@CustomerID", SqlDbType.Int,4),
new SqlParameter("@ClubCardTypeID", SqlDbType.Int,4),
new SqlParameter("@ExpireDate", SqlDbType.DateTime),
new SqlParameter("@CardStatus", SqlDbType.Int,4),
new SqlParameter("@ClubCardNo", SqlDbType.NVarChar,50),
new SqlParameter("@LogicalStatus", SqlDbType.Int,4),
new SqlParameter("@CreatorID", SqlDbType.NVarChar,50),
new SqlParameter("@CreatedDate", SqlDbType.DateTime),
new SqlParameter("@LastModifierID", SqlDbType.NVarChar,50),
new SqlParameter("@LastModifiedDate", SqlDbType.DateTime),
new SqlParameter("@Reserved1", SqlDbType.NVarChar,100),
new SqlParameter("@Reserved2", SqlDbType.NVarChar,100),
new SqlParameter("@Reserved3", SqlDbType.NVarChar,100),
new SqlParameter("@ClubCardID", SqlDbType.Int,4)};
parameters[0].Value = model.ClubCardTypeName;
parameters[1].Value = model.CustName;
parameters[2].Value = model.ClubCardPwd;
parameters[3].Value = model.OpenCardStore;
parameters[4].Value = model.SalesMan;
parameters[5].Value = model.SalesTime;
parameters[6].Value = model.Balance;
parameters[7].Value = model.CustomerID;
parameters[8].Value = model.ClubCardTypeID;
parameters[9].Value = model.ExpireDate;
parameters[10].Value = model.CardStatus;
parameters[11].Value = model.ClubCardNo;
parameters[12].Value = model.LogicalStatus;
parameters[13].Value = model.CreatorID;
parameters[14].Value = model.CreatedDate;
parameters[15].Value = model.LastModifierID;
parameters[16].Value = model.LastModifiedDate;
parameters[17].Value = model.Reserved1;
parameters[18].Value = model.Reserved2;
parameters[19].Value = model.Reserved3;
parameters[20].Value = model.ClubCardID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WisdCar.Model.PO.ConsumeLogPO model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update ConsumeLog set ");
strSql.Append("ConsumeBatchNo=@ConsumeBatchNo,");
strSql.Append("ClubCardID=@ClubCardID,");
strSql.Append("ClubCardNo=@ClubCardNo,");
strSql.Append("CustID=@CustID,");
strSql.Append("CustName=@CustName,");
strSql.Append("ConsumeDate=@ConsumeDate,");
strSql.Append("ConsumeStore=@ConsumeStore,");
strSql.Append("OriginalStore=@OriginalStore,");
strSql.Append("ConsumeType=@ConsumeType,");
strSql.Append("PayType=@PayType,");
strSql.Append("ClubCardPackageID=@ClubCardPackageID,");
strSql.Append("PackageDetailID=@PackageDetailID,");
strSql.Append("ItemName=@ItemName,");
strSql.Append("ConsumeCount=@ConsumeCount,");
strSql.Append("OriginalPrice=@OriginalPrice,");
strSql.Append("ItemID=@ItemID,");
strSql.Append("LogicalStatus=@LogicalStatus,");
strSql.Append("CreatorID=@CreatorID,");
strSql.Append("CreatedDate=@CreatedDate,");
strSql.Append("LastModifierID=@LastModifierID,");
strSql.Append("LastModifiedDate=@LastModifiedDate,");
strSql.Append("Reserved1=@Reserved1,");
strSql.Append("Reserved2=@Reserved2,");
strSql.Append("Reserved3=@Reserved3");
strSql.Append(" where ConsumeLogID=@ConsumeLogID");
SqlParameter[] parameters = {
new SqlParameter("@ConsumeBatchNo", SqlDbType.NVarChar,50),
new SqlParameter("@ClubCardID", SqlDbType.Int,4),
new SqlParameter("@ClubCardNo", SqlDbType.NVarChar,50),
new SqlParameter("@CustID", SqlDbType.Int,4),
new SqlParameter("@CustName", SqlDbType.NVarChar,50),
new SqlParameter("@ConsumeDate", SqlDbType.DateTime),
new SqlParameter("@ConsumeStore", SqlDbType.NVarChar,50),
new SqlParameter("@OriginalStore", SqlDbType.NVarChar,50),
new SqlParameter("@ConsumeType", SqlDbType.Int,4),
new SqlParameter("@PayType", SqlDbType.Int,4),
new SqlParameter("@ClubCardPackageID",SqlDbType.NVarChar,50),
new SqlParameter("@PackageDetailID", SqlDbType.Int,4),
new SqlParameter("@ItemName", SqlDbType.NVarChar,50),
new SqlParameter("@ConsumeCount", SqlDbType.Int,4),
new SqlParameter("@OriginalPrice", SqlDbType.Decimal,5),
new SqlParameter("@ItemID", SqlDbType.Int,4),
new SqlParameter("@LogicalStatus", SqlDbType.Int,4),
new SqlParameter("@CreatorID", SqlDbType.NVarChar,50),
new SqlParameter("@CreatedDate", SqlDbType.DateTime),
new SqlParameter("@LastModifierID", SqlDbType.NVarChar,50),
new SqlParameter("@LastModifiedDate", SqlDbType.DateTime),
new SqlParameter("@Reserved1", SqlDbType.NVarChar,100),
new SqlParameter("@Reserved2", SqlDbType.NVarChar,100),
new SqlParameter("@Reserved3", SqlDbType.NVarChar,100),
new SqlParameter("@ConsumeLogID", SqlDbType.Int,4)};
parameters[0].Value = model.ConsumeBatchNo;
parameters[1].Value = model.ClubCardID;
parameters[2].Value = model.ClubCardNo;
parameters[3].Value = model.CustID;
parameters[4].Value = model.CustName;
parameters[5].Value = model.ConsumeDate;
parameters[6].Value = model.ConsumeStore;
parameters[7].Value = model.OriginalStore;
parameters[8].Value = model.ConsumeType;
parameters[9].Value = model.PayType;
parameters[10].Value = model.ClubCardPackageID;
parameters[11].Value = model.PackageDetailID;
parameters[12].Value = model.ItemName;
parameters[13].Value = model.ConsumeCount;
parameters[14].Value = model.OriginalPrice;
parameters[15].Value = model.ItemID;
parameters[16].Value = model.LogicalStatus;
parameters[17].Value = model.CreatorID;
parameters[18].Value = model.CreatedDate;
parameters[19].Value = model.LastModifierID;
parameters[20].Value = model.LastModifiedDate;
parameters[21].Value = model.Reserved1;
parameters[22].Value = model.Reserved2;
parameters[23].Value = model.Reserved3;
parameters[24].Value = model.ConsumeLogID;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WisdCar.Model.PO.ClubCardPackagePO model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ClubCardPackage set ");
strSql.Append("PackageName=@PackageName,");
strSql.Append("OriginalAmount=@OriginalAmount,");
strSql.Append("ActualAmount=@ActualAmount,");
strSql.Append("DiscountRate=@DiscountRate,");
strSql.Append("DiscountInfo=@DiscountInfo,");
strSql.Append("PackageStatus=@PackageStatus,");
strSql.Append("Salesman=@Salesman,");
strSql.Append("SalesTime=@SalesTime,");
strSql.Append("SaleStore=@SaleStore,");
strSql.Append("PackageID=@PackageID,");
strSql.Append("ClubCardID=@ClubCardID,");
strSql.Append("LogicalStatus=@LogicalStatus,");
strSql.Append("CreatorID=@CreatorID,");
strSql.Append("CreatedDate=@CreatedDate,");
strSql.Append("LastModifierID=@LastModifierID,");
strSql.Append("LastModifiedDate=@LastModifiedDate,");
strSql.Append("Reserved1=@Reserved1,");
strSql.Append("Reserved2=@Reserved2,");
strSql.Append("Reserved3=@Reserved3");
strSql.Append(" where ClubCardPackageID=@ClubCardPackageID");
SqlParameter[] parameters = {
new SqlParameter("@PackageName", SqlDbType.NVarChar,50),
new SqlParameter("@OriginalAmount", SqlDbType.Decimal,5),
new SqlParameter("@ActualAmount", SqlDbType.Decimal,5),
new SqlParameter("@DiscountRate", SqlDbType.Decimal,5),
new SqlParameter("@DiscountInfo", SqlDbType.NVarChar,50),
new SqlParameter("@PackageStatus", SqlDbType.Int,4),
new SqlParameter("@Salesman", SqlDbType.NVarChar,50),
new SqlParameter("@SalesTime", SqlDbType.DateTime),
new SqlParameter("@SaleStore", SqlDbType.NVarChar,50),
new SqlParameter("@PackageID", SqlDbType.Int,4),
new SqlParameter("@ClubCardID", SqlDbType.Int,4),
new SqlParameter("@LogicalStatus", SqlDbType.Int,4),
new SqlParameter("@CreatorID", SqlDbType.NVarChar,50),
new SqlParameter("@CreatedDate", SqlDbType.DateTime),
new SqlParameter("@LastModifierID", SqlDbType.NVarChar,50),
new SqlParameter("@LastModifiedDate", SqlDbType.DateTime),
new SqlParameter("@Reserved1", SqlDbType.NVarChar,100),
new SqlParameter("@Reserved2", SqlDbType.NVarChar,100),
new SqlParameter("@Reserved3", SqlDbType.NVarChar,100),
new SqlParameter("@ClubCardPackageID", SqlDbType.NVarChar,50)};
parameters[0].Value = model.PackageName;
parameters[1].Value = model.OriginalAmount;
parameters[2].Value = model.ActualAmount;
parameters[3].Value = model.DiscountRate;
parameters[4].Value = model.DiscountInfo;
parameters[5].Value = model.PackageStatus;
parameters[6].Value = model.Salesman;
parameters[7].Value = model.SalesTime;
parameters[8].Value = model.SaleStore;
parameters[9].Value = model.PackageID;
parameters[10].Value = model.ClubCardID;
parameters[11].Value = model.LogicalStatus;
parameters[12].Value = model.CreatorID;
parameters[13].Value = model.CreatedDate;
parameters[14].Value = model.LastModifierID;
parameters[15].Value = model.LastModifiedDate;
parameters[16].Value = model.Reserved1;
parameters[17].Value = model.Reserved2;
parameters[18].Value = model.Reserved3;
parameters[19].Value = model.ClubCardPackageID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WisdCar.Model.PO.CustomerPO model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Customer set ");
strSql.Append("Name=@Name,");
strSql.Append("MobileNO=@MobileNO,");
strSql.Append("Sex=@Sex,");
strSql.Append("Birthday=@Birthday,");
strSql.Append("ICNo=@ICNo,");
strSql.Append("Weixin=@Weixin,");
strSql.Append("Company=@Company,");
strSql.Append("CardFlag=@CardFlag,");
strSql.Append("LogicalStatus=@LogicalStatus,");
strSql.Append("CreatorID=@CreatorID,");
strSql.Append("CreatedDate=@CreatedDate,");
strSql.Append("LastModifierID=@LastModifierID,");
strSql.Append("LastModifiedDate=@LastModifiedDate,");
strSql.Append("Reserved1=@Reserved1,");
strSql.Append("Reserved2=@Reserved2,");
strSql.Append("Reserved3=@Reserved3");
strSql.Append(" where CustomerID=@CustomerID");
SqlParameter[] parameters = {
new SqlParameter("@Name", SqlDbType.NVarChar,50),
new SqlParameter("@MobileNO", SqlDbType.NVarChar,50),
new SqlParameter("@Sex", SqlDbType.NVarChar,50),
new SqlParameter("@Birthday", SqlDbType.NVarChar,50),
new SqlParameter("@ICNo", SqlDbType.NVarChar,50),
new SqlParameter("@Weixin", SqlDbType.NVarChar,50),
new SqlParameter("@Company", SqlDbType.NVarChar,50),
new SqlParameter("@CardFlag", SqlDbType.Int,4),
new SqlParameter("@LogicalStatus", SqlDbType.Int,4),
new SqlParameter("@CreatorID", SqlDbType.NVarChar,50),
new SqlParameter("@CreatedDate", SqlDbType.DateTime),
new SqlParameter("@LastModifierID", SqlDbType.NVarChar,50),
new SqlParameter("@LastModifiedDate", SqlDbType.DateTime),
new SqlParameter("@Reserved1", SqlDbType.NVarChar,100),
new SqlParameter("@Reserved2", SqlDbType.NVarChar,100),
new SqlParameter("@Reserved3", SqlDbType.NVarChar,100),
new SqlParameter("@CustomerID", SqlDbType.Int,4)};
parameters[0].Value = model.Name;
parameters[1].Value = model.MobileNO;
parameters[2].Value = model.Sex;
parameters[3].Value = model.Birthday;
parameters[4].Value = model.ICNo;
parameters[5].Value = model.Weixin;
parameters[6].Value = model.Company;
parameters[7].Value = model.CardFlag;
parameters[8].Value = model.LogicalStatus;
parameters[9].Value = model.CreatorID;
parameters[10].Value = model.CreatedDate;
parameters[11].Value = model.LastModifierID;
parameters[12].Value = model.LastModifiedDate;
parameters[13].Value = model.Reserved1;
parameters[14].Value = model.Reserved2;
parameters[15].Value = model.Reserved3;
parameters[16].Value = model.CustomerID;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
