/// <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); }