/// <summary>
/// 更新一条数据
/// </summary>
public void Update(CardCenter.Entity.Stock_InList model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Stock_InList set ");
strSql.Append("CommodityGuid=@CommodityGuid,");
strSql.Append("Before=@Before,");
strSql.Append("After=@After,");
strSql.Append("Num=@Num,");
strSql.Append("SubmitUser=@SubmitUser,");
strSql.Append("SubmitTime=@SubmitTime,");
strSql.Append("Remark=@Remark");
strSql.Append(" where Guid=@Guid ");
SqlParameter[] parameters =
{
new SqlParameter("@CommodityGuid", SqlDbType.NVarChar, 64),
new SqlParameter("@Before", SqlDbType.Int, 4),
new SqlParameter("@After", SqlDbType.Int, 4),
new SqlParameter("@Num", SqlDbType.Int, 4),
new SqlParameter("@SubmitUser", SqlDbType.NVarChar, 64),
new SqlParameter("@SubmitTime", SqlDbType.DateTime),
new SqlParameter("@Remark", SqlDbType.NVarChar, 512),
new SqlParameter("@Guid", SqlDbType.NVarChar, 64)
};
parameters[0].Value = model.CommodityGuid;
parameters[1].Value = model.Before;
parameters[2].Value = model.After;
parameters[3].Value = model.Num;
parameters[4].Value = model.SubmitUser;
parameters[5].Value = model.SubmitTime;
parameters[6].Value = model.Remark;
parameters[7].Value = model.Guid;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(CardCenter.Entity.Para_JobType model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Para_JobType set ");
strSql.Append("JobTypeParent=@JobTypeParent,");
strSql.Append("JobName=@JobName,");
strSql.Append("JobDbName=@JobDbName,");
strSql.Append("WorkDay=@WorkDay,");
strSql.Append("HandlingFee=@HandlingFee,");
strSql.Append("CostFee=@CostFee");
strSql.Append("CardType=@CardType");
strSql.Append(" where JobTypeID=@JobTypeID ");
SqlParameter[] parameters =
{
new SqlParameter("@JobTypeParent", SqlDbType.NVarChar, 8),
new SqlParameter("@JobName", SqlDbType.NVarChar, 64),
new SqlParameter("@JobDbName", SqlDbType.NVarChar, 64),
new SqlParameter("@WorkDay", SqlDbType.Int, 4),
new SqlParameter("@HandlingFee", SqlDbType.Float, 8),
new SqlParameter("@CostFee", SqlDbType.Float, 8),
new SqlParameter("@CardType", SqlDbType.NVarChar, 64),
new SqlParameter("@JobTypeID", SqlDbType.NVarChar, 8)
};
parameters[0].Value = model.JobTypeParent;
parameters[1].Value = model.JobName;
parameters[2].Value = model.JobDbName;
parameters[3].Value = model.WorkDay;
parameters[4].Value = model.HandlingFee;
parameters[5].Value = model.CostFee;
parameters[6].Value = model.CardType;
parameters[7].Value = model.JobTypeID;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(CardCenter.Entity.FlowInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update FlowInfo set ");
strSql.Append("JobID=@JobID,");
strSql.Append("FlowID=@FlowID,");
strSql.Append("SubmitDate=@SubmitDate,");
strSql.Append("SubmitUser=@SubmitUser,");
strSql.Append("Content=@Content,");
strSql.Append("IsDelete=@IsDelete,");
strSql.Append("Remark=@Remark");
strSql.Append(" where Guid=@Guid ");
SqlParameter[] parameters =
{
new SqlParameter("@JobID", SqlDbType.NVarChar, 64),
new SqlParameter("@FlowID", SqlDbType.Int, 4),
new SqlParameter("@SubmitDate", SqlDbType.DateTime),
new SqlParameter("@SubmitUser", SqlDbType.NVarChar, 64),
new SqlParameter("@Content", SqlDbType.NVarChar, 512),
new SqlParameter("@IsDelete", SqlDbType.Bit, 1),
new SqlParameter("@Remark", SqlDbType.NVarChar, 512),
new SqlParameter("@Guid", SqlDbType.NVarChar, 64)
};
parameters[0].Value = model.JobID;
parameters[1].Value = model.FlowID;
parameters[2].Value = model.SubmitDate;
parameters[3].Value = model.SubmitUser;
parameters[4].Value = model.Content;
parameters[5].Value = model.IsDelete;
parameters[6].Value = model.Remark;
parameters[7].Value = model.Guid;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(CardCenter.Entity.Flow model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Flow set ");
strSql.Append("JobType=@JobType,");
strSql.Append("FlowOrder=@FlowOrder,");
strSql.Append("FlowStatus=@FlowStatus,");
strSql.Append("IsSend=@IsSend,");
strSql.Append("SendTxt=@SendTxt");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@JobType", SqlDbType.NVarChar, 16),
new SqlParameter("@FlowOrder", SqlDbType.Int, 4),
new SqlParameter("@FlowStatus", SqlDbType.Int, 4),
new SqlParameter("@IsSend", SqlDbType.Bit, 1),
new SqlParameter("@SendTxt", SqlDbType.NVarChar, 1024),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.JobType;
parameters[1].Value = model.FlowOrder;
parameters[2].Value = model.FlowStatus;
parameters[3].Value = model.IsSend;
parameters[4].Value = model.SendTxt;
parameters[5].Value = model.ID;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(CardCenter.Entity.HandleList model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into HandleList(");
strSql.Append("Guid,JobID,No,FunctionID,OpeartionID,IsChecked,Status,OpeartionUser,OpeartionTime,Remark)");
strSql.Append(" values (");
strSql.Append("@Guid,@JobID,@No,@FunctionID,@OpeartionID,@IsChecked,@Status,@OpeartionUser,@OpeartionTime,@Remark)");
SqlParameter[] parameters =
{
new SqlParameter("@Guid", SqlDbType.NVarChar, 64),
new SqlParameter("@JobID", SqlDbType.NVarChar, 64),
new SqlParameter("@No", SqlDbType.Int, 4),
new SqlParameter("@FunctionID", SqlDbType.NVarChar, 8),
new SqlParameter("@OpeartionID", SqlDbType.Int, 4),
new SqlParameter("@IsChecked", SqlDbType.Bit, 1),
new SqlParameter("@Status", SqlDbType.NVarChar, 32),
new SqlParameter("@OpeartionUser", SqlDbType.NVarChar, 64),
new SqlParameter("@OpeartionTime", SqlDbType.DateTime),
new SqlParameter("@Remark", SqlDbType.NVarChar, 512)
};
parameters[0].Value = model.Guid;
parameters[1].Value = model.JobID;
parameters[2].Value = model.No;
parameters[3].Value = model.FunctionID;
parameters[4].Value = model.OpeartionID;
parameters[5].Value = model.IsChecked;
parameters[6].Value = model.Status;
parameters[7].Value = model.OpeartionUser;
parameters[8].Value = model.OpeartionTime;
parameters[9].Value = model.Remark;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(CardCenter.Entity.Flow model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Flow(");
strSql.Append("JobType,FlowOrder,FlowStatus,IsSend,SendTxt)");
strSql.Append(" values (");
strSql.Append("@JobType,@FlowOrder,@FlowStatus,@IsSend,@SendTxt)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@JobType", SqlDbType.NVarChar, 16),
new SqlParameter("@FlowOrder", SqlDbType.Int, 4),
new SqlParameter("@FlowStatus", SqlDbType.Int, 4),
new SqlParameter("@IsSend", SqlDbType.Bit, 1),
new SqlParameter("@SendTxt", SqlDbType.NVarChar, 1024)
};
parameters[0].Value = model.JobType;
parameters[1].Value = model.FlowOrder;
parameters[2].Value = model.FlowStatus;
parameters[3].Value = model.IsSend;
parameters[4].Value = model.SendTxt;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(CardCenter.Entity.FlowInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into FlowInfo(");
strSql.Append("Guid,JobID,FlowID,SubmitDate,SubmitUser,Content,IsDelete,Remark)");
strSql.Append(" values (");
strSql.Append("@Guid,@JobID,@FlowID,@SubmitDate,@SubmitUser,@Content,@IsDelete,@Remark)");
SqlParameter[] parameters =
{
new SqlParameter("@Guid", SqlDbType.NVarChar, 64),
new SqlParameter("@JobID", SqlDbType.NVarChar, 64),
new SqlParameter("@FlowID", SqlDbType.Int, 4),
new SqlParameter("@SubmitDate", SqlDbType.DateTime),
new SqlParameter("@SubmitUser", SqlDbType.NVarChar, 64),
new SqlParameter("@Content", SqlDbType.NVarChar, 512),
new SqlParameter("@IsDelete", SqlDbType.Bit, 1),
new SqlParameter("@Remark", SqlDbType.NVarChar, 512)
};
parameters[0].Value = model.Guid;
parameters[1].Value = model.JobID;
parameters[2].Value = model.FlowID;
parameters[3].Value = model.SubmitDate;
parameters[4].Value = model.SubmitUser;
parameters[5].Value = model.Content;
parameters[6].Value = model.IsDelete;
parameters[7].Value = model.Remark;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(CardCenter.Entity.Stock_Commodity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Stock_Commodity set ");
strSql.Append("CommodityName=@CommodityName,");
strSql.Append("CommodityType=@CommodityType,");
strSql.Append("AdditionalAttributes=@AdditionalAttributes,");
strSql.Append("SellingPrice=@SellingPrice,");
strSql.Append("CostPrice=@CostPrice,");
strSql.Append("StockDesplay=@StockDesplay,");
strSql.Append("StockActual=@StockActual");
strSql.Append(" where Guid=@Guid ");
SqlParameter[] parameters =
{
new SqlParameter("@CommodityName", SqlDbType.NVarChar, 128),
new SqlParameter("@CommodityType", SqlDbType.NVarChar, 128),
new SqlParameter("@AdditionalAttributes", SqlDbType.NVarChar, 128),
new SqlParameter("@SellingPrice", SqlDbType.Decimal, 9),
new SqlParameter("@CostPrice", SqlDbType.Decimal, 9),
new SqlParameter("@StockDesplay", SqlDbType.Int, 4),
new SqlParameter("@StockActual", SqlDbType.Int, 4),
new SqlParameter("@Guid", SqlDbType.NVarChar, 64)
};
parameters[0].Value = model.CommodityName;
parameters[1].Value = model.CommodityType;
parameters[2].Value = model.AdditionalAttributes;
parameters[3].Value = model.SellingPrice;
parameters[4].Value = model.CostPrice;
parameters[5].Value = model.StockDesplay;
parameters[6].Value = model.StockActual;
parameters[7].Value = model.Guid;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(CardCenter.Entity.Question model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Question(");
strSql.Append("Guid,CustomCode,CreateTime,Q1,Q1Content,Q2,Q2Content,Q3,Q3Content,Q4,Q4Content,Q5,Q5Content,Q6,Q6Content,Q7,Q7Content,Q8,Q8Content,Q9,Q9Content,Q10,Q10Content)");
strSql.Append(" values (");
strSql.Append("@Guid,@CustomCode,@CreateTime,@Q1,@Q1Content,@Q2,@Q2Content,@Q3,@Q3Content,@Q4,@Q4Content,@Q5,@Q5Content,@Q6,@Q6Content,@Q7,@Q7Content,@Q8,@Q8Content,@Q9,@Q9Content,@Q10,@Q10Content)");
SqlParameter[] parameters =
{
new SqlParameter("@Guid", SqlDbType.NVarChar, 64),
new SqlParameter("@CustomCode", SqlDbType.NVarChar, 10),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@Q1", SqlDbType.Int, 4),
new SqlParameter("@Q1Content", SqlDbType.NVarChar, 512),
new SqlParameter("@Q2", SqlDbType.Int, 4),
new SqlParameter("@Q2Content", SqlDbType.NVarChar, 512),
new SqlParameter("@Q3", SqlDbType.Int, 4),
new SqlParameter("@Q3Content", SqlDbType.NVarChar, 512),
new SqlParameter("@Q4", SqlDbType.Int, 4),
new SqlParameter("@Q4Content", SqlDbType.NVarChar, 512),
new SqlParameter("@Q5", SqlDbType.Int, 4),
new SqlParameter("@Q5Content", SqlDbType.NVarChar, 512),
new SqlParameter("@Q6", SqlDbType.Int, 4),
new SqlParameter("@Q6Content", SqlDbType.NVarChar, 512),
new SqlParameter("@Q7", SqlDbType.Int, 4),
new SqlParameter("@Q7Content", SqlDbType.NVarChar, 512),
new SqlParameter("@Q8", SqlDbType.Int, 4),
new SqlParameter("@Q8Content", SqlDbType.NVarChar, 512),
new SqlParameter("@Q9", SqlDbType.Int, 4),
new SqlParameter("@Q9Content", SqlDbType.NVarChar, 512),
new SqlParameter("@Q10", SqlDbType.Int, 4),
new SqlParameter("@Q10Content", SqlDbType.NVarChar, 512)
};
parameters[0].Value = model.Guid;
parameters[1].Value = model.CustomCode;
parameters[2].Value = model.CreateTime;
parameters[3].Value = model.Q1;
parameters[4].Value = model.Q1Content;
parameters[5].Value = model.Q2;
parameters[6].Value = model.Q2Content;
parameters[7].Value = model.Q3;
parameters[8].Value = model.Q3Content;
parameters[9].Value = model.Q4;
parameters[10].Value = model.Q4Content;
parameters[11].Value = model.Q5;
parameters[12].Value = model.Q5Content;
parameters[13].Value = model.Q6;
parameters[14].Value = model.Q6Content;
parameters[15].Value = model.Q7;
parameters[16].Value = model.Q7Content;
parameters[17].Value = model.Q8;
parameters[18].Value = model.Q8Content;
parameters[19].Value = model.Q9;
parameters[20].Value = model.Q9Content;
parameters[21].Value = model.Q10;
parameters[22].Value = model.Q10Content;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(CardCenter.Entity.FileList model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into FileList(");
strSql.Append("Guid,FileType,FileName,JobID,ListID,IsDelete,Remark)");
strSql.Append(" values (");
strSql.Append("@Guid,@FileType,@FileName,@JobID,@ListID,@IsDelete,@Remark)");
SqlParameter[] parameters =
{
new SqlParameter("@Guid", SqlDbType.NVarChar, 64),
new SqlParameter("@FileType", SqlDbType.NVarChar, 8),
new SqlParameter("@FileName", SqlDbType.NVarChar, 128),
new SqlParameter("@JobID", SqlDbType.NVarChar, 64),
new SqlParameter("@ListID", SqlDbType.NVarChar, 64),
new SqlParameter("@IsDelete", SqlDbType.Bit, 1),
new SqlParameter("@Remark", SqlDbType.NVarChar, 512)
};
parameters[0].Value = model.Guid;
parameters[1].Value = model.FileType;
parameters[2].Value = model.FileName;
parameters[3].Value = model.JobID;
parameters[4].Value = model.ListID;
parameters[5].Value = model.IsDelete;
parameters[6].Value = model.Remark;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(CardCenter.Entity.ReMakeList model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ReMakeList set ");
strSql.Append("JobID=@JobID,");
strSql.Append("JobType=@JobType,");
strSql.Append("CardType=@CardType,");
strSql.Append("CardholderName=@CardholderName,");
strSql.Append("CardNum=@CardNum,");
strSql.Append("IsDelete=@IsDelete,");
strSql.Append("Remark=@Remark");
strSql.Append(" where ListID=@ListID ");
SqlParameter[] parameters =
{
new SqlParameter("@JobID", SqlDbType.NVarChar, 64),
new SqlParameter("@JobType", SqlDbType.NVarChar, 8),
new SqlParameter("@CardType", SqlDbType.NVarChar, 64),
new SqlParameter("@CardholderName", SqlDbType.NVarChar, 32),
new SqlParameter("@CardNum", SqlDbType.NVarChar, 32),
new SqlParameter("@IsDelete", SqlDbType.Bit, 1),
new SqlParameter("@Remark", SqlDbType.NVarChar, 512),
new SqlParameter("@ListID", SqlDbType.NVarChar, 64)
};
parameters[0].Value = model.JobID;
parameters[1].Value = model.JobType;
parameters[2].Value = model.CardType;
parameters[3].Value = model.CardholderName;
parameters[4].Value = model.CardNum;
parameters[5].Value = model.IsDelete;
parameters[6].Value = model.Remark;
parameters[7].Value = model.ListID;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(CardCenter.Entity.Para_Department model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Para_Department(");
strSql.Append("ID,City,Area,GS,ZJ,SW,HG,WJ,WH)");
strSql.Append(" values (");
strSql.Append("@ID,@City,@Area,@GS,@ZJ,@SW,@HG,@WJ,@WH)");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.NVarChar, 6),
new SqlParameter("@City", SqlDbType.NVarChar, 64),
new SqlParameter("@Area", SqlDbType.NVarChar, 64),
new SqlParameter("@GS", SqlDbType.NVarChar, 16),
new SqlParameter("@ZJ", SqlDbType.NVarChar, 16),
new SqlParameter("@SW", SqlDbType.NVarChar, 16),
new SqlParameter("@HG", SqlDbType.NVarChar, 16),
new SqlParameter("@WJ", SqlDbType.NVarChar, 16),
new SqlParameter("@WH", SqlDbType.NVarChar, 16)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.City;
parameters[2].Value = model.Area;
parameters[3].Value = model.GS;
parameters[4].Value = model.ZJ;
parameters[5].Value = model.SW;
parameters[6].Value = model.HG;
parameters[7].Value = model.WJ;
parameters[8].Value = model.WH;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(CardCenter.Entity.ReMakeList model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ReMakeList(");
strSql.Append("ListID,JobID,JobType,CardType,CardholderName,CardNum,IsDelete,Remark)");
strSql.Append(" values (");
strSql.Append("@ListID,@JobID,@JobType,@CardType,@CardholderName,@CardNum,@IsDelete,@Remark)");
SqlParameter[] parameters =
{
new SqlParameter("@ListID", SqlDbType.NVarChar, 64),
new SqlParameter("@JobID", SqlDbType.NVarChar, 64),
new SqlParameter("@JobType", SqlDbType.NVarChar, 8),
new SqlParameter("@CardType", SqlDbType.NVarChar, 64),
new SqlParameter("@CardholderName", SqlDbType.NVarChar, 32),
new SqlParameter("@CardNum", SqlDbType.NVarChar, 32),
new SqlParameter("@IsDelete", SqlDbType.Bit, 1),
new SqlParameter("@Remark", SqlDbType.NVarChar, 512)
};
parameters[0].Value = model.ListID;
parameters[1].Value = model.JobID;
parameters[2].Value = model.JobType;
parameters[3].Value = model.CardType;
parameters[4].Value = model.CardholderName;
parameters[5].Value = model.CardNum;
parameters[6].Value = model.IsDelete;
parameters[7].Value = model.Remark;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(CardCenter.Entity.FileList model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update FileList set ");
strSql.Append("FileType=@FileType,");
strSql.Append("FileName=@FileName,");
strSql.Append("JobID=@JobID,");
strSql.Append("ListID=@ListID,");
strSql.Append("IsDelete=@IsDelete,");
strSql.Append("Remark=@Remark");
strSql.Append(" where Guid=@Guid ");
SqlParameter[] parameters =
{
new SqlParameter("@FileType", SqlDbType.NVarChar, 8),
new SqlParameter("@FileName", SqlDbType.NVarChar, 128),
new SqlParameter("@JobID", SqlDbType.NVarChar, 64),
new SqlParameter("@ListID", SqlDbType.NVarChar, 64),
new SqlParameter("@IsDelete", SqlDbType.Bit, 1),
new SqlParameter("@Remark", SqlDbType.NVarChar, 512),
new SqlParameter("@Guid", SqlDbType.NVarChar, 64)
};
parameters[0].Value = model.FileType;
parameters[1].Value = model.FileName;
parameters[2].Value = model.JobID;
parameters[3].Value = model.ListID;
parameters[4].Value = model.IsDelete;
parameters[5].Value = model.Remark;
parameters[6].Value = model.Guid;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(CardCenter.Entity.SendLog model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SendLog set ");
strSql.Append("IsSend=@IsSend,");
strSql.Append("Error=@Error,");
strSql.Append("SendPhone=@SendPhone,");
strSql.Append("SendContext=@SendContext");
strSql.Append(" where Guid=@Guid ");
SqlParameter[] parameters =
{
new SqlParameter("@IsSend", SqlDbType.Bit, 1),
new SqlParameter("@Error", SqlDbType.NVarChar, 512),
new SqlParameter("@SendPhone", SqlDbType.NVarChar, 32),
new SqlParameter("@SendContext", SqlDbType.NVarChar, 512),
new SqlParameter("@Guid", SqlDbType.NVarChar, 64)
};
parameters[0].Value = model.IsSend;
parameters[1].Value = model.Error;
parameters[2].Value = model.SendPhone;
parameters[3].Value = model.SendContext;
parameters[4].Value = model.Guid;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(CardCenter.Entity.Para_JobType model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Para_JobType(");
strSql.Append("JobTypeID,JobTypeParent,JobName,JobDbName,WorkDay,HandlingFee,CostFee,CardType)");
strSql.Append(" values (");
strSql.Append("@JobTypeID,@JobTypeParent,@JobName,@JobDbName,@WorkDay,@HandlingFee,@CostFee,@CardType)");
SqlParameter[] parameters =
{
new SqlParameter("@JobTypeID", SqlDbType.NVarChar, 8),
new SqlParameter("@JobTypeParent", SqlDbType.NVarChar, 8),
new SqlParameter("@JobName", SqlDbType.NVarChar, 64),
new SqlParameter("@JobDbName", SqlDbType.NVarChar, 64),
new SqlParameter("@WorkDay", SqlDbType.Int, 4),
new SqlParameter("@HandlingFee", SqlDbType.Float, 8),
new SqlParameter("@CostFee", SqlDbType.Float, 8),
new SqlParameter("@CardType", SqlDbType.NVarChar, 64)
};
parameters[0].Value = model.JobTypeID;
parameters[1].Value = model.JobTypeParent;
parameters[2].Value = model.JobName;
parameters[3].Value = model.JobDbName;
parameters[4].Value = model.WorkDay;
parameters[5].Value = model.HandlingFee;
parameters[6].Value = model.CostFee;
parameters[7].Value = model.CardType;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(CardCenter.Entity.Stock_OutList model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Stock_OutList(");
strSql.Append("Guid,CommodityGuid,JobID,Before,After,Num,SubmitUser,SubmitTime,Remark)");
strSql.Append(" values (");
strSql.Append("@Guid,@CommodityGuid,@JobID,@Before,@After,@Num,@SubmitUser,@SubmitTime,@Remark)");
SqlParameter[] parameters =
{
new SqlParameter("@Guid", SqlDbType.NVarChar, 64),
new SqlParameter("@CommodityGuid", SqlDbType.NVarChar, 64),
new SqlParameter("@JobID", SqlDbType.NVarChar, 64),
new SqlParameter("@Before", SqlDbType.Int, 4),
new SqlParameter("@After", SqlDbType.Int, 4),
new SqlParameter("@Num", SqlDbType.Int, 4),
new SqlParameter("@SubmitUser", SqlDbType.NVarChar, 64),
new SqlParameter("@SubmitTime", SqlDbType.DateTime),
new SqlParameter("@Remark", SqlDbType.NVarChar, 512)
};
parameters[0].Value = model.Guid;
parameters[1].Value = model.CommodityGuid;
parameters[2].Value = model.JobID;
parameters[3].Value = model.Before;
parameters[4].Value = model.After;
parameters[5].Value = model.Num;
parameters[6].Value = model.SubmitUser;
parameters[7].Value = model.SubmitTime;
parameters[8].Value = model.Remark;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(CardCenter.Entity.SaleList model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SaleList(");
strSql.Append("ListID,JobID,JobType,ProductType,Num,IsDelete,Remark,ManagerFlag,ManagerUser,ManagerTime)");
strSql.Append(" values (");
strSql.Append("@ListID,@JobID,@JobType,@ProductType,@Num,@IsDelete,@Remark,@ManagerFlag,@ManagerUser,@ManagerTime)");
SqlParameter[] parameters =
{
new SqlParameter("@ListID", SqlDbType.NVarChar, 64),
new SqlParameter("@JobID", SqlDbType.NVarChar, 64),
new SqlParameter("@JobType", SqlDbType.NVarChar, 8),
new SqlParameter("@ProductType", SqlDbType.NVarChar, 64),
new SqlParameter("@Num", SqlDbType.Int, 4),
new SqlParameter("@IsDelete", SqlDbType.Bit, 1),
new SqlParameter("@Remark", SqlDbType.NVarChar, 512),
new SqlParameter("@ManagerFlag", SqlDbType.Int, 4),
new SqlParameter("@ManagerUser", SqlDbType.NVarChar, 64),
new SqlParameter("@ManagerTime", SqlDbType.DateTime)
};
parameters[0].Value = model.ListID;
parameters[1].Value = model.JobID;
parameters[2].Value = model.JobType;
parameters[3].Value = model.ProductType;
parameters[4].Value = model.Num;
parameters[5].Value = model.IsDelete;
parameters[6].Value = model.Remark;
parameters[7].Value = model.ManagerFlag;
parameters[8].Value = model.ManagerUser;
parameters[9].Value = model.ManagerTime;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(CardCenter.Entity.Stock_Commodity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Stock_Commodity(");
strSql.Append("Guid,CommodityName,CommodityType,AdditionalAttributes,SellingPrice,CostPrice,StockDesplay,StockActual)");
strSql.Append(" values (");
strSql.Append("@Guid,@CommodityName,@CommodityType,@AdditionalAttributes,@SellingPrice,@CostPrice,@StockDesplay,@StockActual)");
SqlParameter[] parameters =
{
new SqlParameter("@Guid", SqlDbType.NVarChar, 64),
new SqlParameter("@CommodityName", SqlDbType.NVarChar, 128),
new SqlParameter("@CommodityType", SqlDbType.NVarChar, 128),
new SqlParameter("@AdditionalAttributes", SqlDbType.NVarChar, 128),
new SqlParameter("@SellingPrice", SqlDbType.Decimal, 9),
new SqlParameter("@CostPrice", SqlDbType.Decimal, 9),
new SqlParameter("@StockDesplay", SqlDbType.Int, 4),
new SqlParameter("@StockActual", SqlDbType.Int, 4)
};
parameters[0].Value = model.Guid;
parameters[1].Value = model.CommodityName;
parameters[2].Value = model.CommodityType;
parameters[3].Value = model.AdditionalAttributes;
parameters[4].Value = model.SellingPrice;
parameters[5].Value = model.CostPrice;
parameters[6].Value = model.StockDesplay;
parameters[7].Value = model.StockActual;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 删除一条数据
/// </summary>
public void Delete()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from HandleLog ");
strSql.Append(" where ");
SqlParameter[] parameters =
{
};
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 删除一条数据
/// </summary>
public void Delete(string Guid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from Stock_Commodity ");
strSql.Append(" where Guid=@Guid ");
SqlParameter[] parameters =
{
new SqlParameter("@Guid", SqlDbType.NVarChar, 64)
};
parameters[0].Value = Guid;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 删除一条数据
/// </summary>
public void Delete(string QYXZ_Value)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from Para_QYXZ ");
strSql.Append(" where QYXZ_Value=@QYXZ_Value ");
SqlParameter[] parameters =
{
new SqlParameter("@QYXZ_Value", SqlDbType.NVarChar, 2)
};
parameters[0].Value = QYXZ_Value;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 删除一条数据
/// </summary>
public void Delete(string ListID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from ReMakeList ");
strSql.Append(" where ListID=@ListID ");
SqlParameter[] parameters =
{
new SqlParameter("@ListID", SqlDbType.NVarChar, 64)
};
parameters[0].Value = ListID;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 删除一条数据
/// </summary>
public void Delete(string ZGHG_Value)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from Para_ZGHG ");
strSql.Append(" where ZGHG_Value=@ZGHG_Value ");
SqlParameter[] parameters =
{
new SqlParameter("@ZGHG_Value", SqlDbType.NVarChar, 4)
};
parameters[0].Value = ZGHG_Value;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 删除一条数据
/// </summary>
public void Delete(string JobTypeID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from Para_JobType ");
strSql.Append(" where JobTypeID=@JobTypeID ");
SqlParameter[] parameters =
{
new SqlParameter("@JobTypeID", SqlDbType.NVarChar, 8)
};
parameters[0].Value = JobTypeID;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 删除一条数据
/// </summary>
public void Delete(string District_Code)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from Para_District ");
strSql.Append(" where District_Code=@District_Code ");
SqlParameter[] parameters =
{
new SqlParameter("@District_Code", SqlDbType.NVarChar, 5)
};
parameters[0].Value = District_Code;
TranHelper.AddTran(strSql, parameters);
}
public void DeleteJobID(string jobID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from HandleList ");
strSql.Append(" where JobID=@JobID ");
SqlParameter[] parameters =
{
new SqlParameter("@JobID", SqlDbType.NVarChar, 64)
};
parameters[0].Value = jobID;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 删除一条数据
/// </summary>
public void Delete(string ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from Para_Department ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.NVarChar, 6)
};
parameters[0].Value = ID;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 删除一条数据
/// </summary>
public void Delete(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from PrintList ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 删除一条数据
/// </summary>
public void Delete(string HYDM_Value)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from Para_HYDM ");
strSql.Append(" where HYDM_Value=@HYDM_Value ");
SqlParameter[] parameters =
{
new SqlParameter("@HYDM_Value", SqlDbType.NVarChar, 3)
};
parameters[0].Value = HYDM_Value;
TranHelper.AddTran(strSql, parameters);
}