/// <summary>
/// 更新一条数据
/// </summary>
public void Update(CardCenter.Entity.Para_JobNeedFileType model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Para_JobNeedFileType set ");
strSql.Append("JobType=@JobType,");
strSql.Append("FileType=@FileType");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@JobType", SqlDbType.NVarChar, 8),
new SqlParameter("@FileType", SqlDbType.NVarChar, 8),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.JobType;
parameters[1].Value = model.FileType;
parameters[2].Value = model.ID;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(CardCenter.Entity.Sys_Log model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Sys_Log set ");
strSql.Append("LogTime=@LogTime,");
strSql.Append("LogContent=@LogContent");
strSql.Append(" where Guid=@Guid ");
SqlParameter[] parameters =
{
new SqlParameter("@LogTime", SqlDbType.DateTime),
new SqlParameter("@LogContent", SqlDbType.NVarChar, -1),
new SqlParameter("@Guid", SqlDbType.NVarChar, 64)
};
parameters[0].Value = model.LogTime;
parameters[1].Value = model.LogContent;
parameters[2].Value = model.Guid;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(CardCenter.Entity.SaleList model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SaleList set ");
strSql.Append("JobID=@JobID,");
strSql.Append("JobType=@JobType,");
strSql.Append("ProductType=@ProductType,");
strSql.Append("Num=@Num,");
strSql.Append("IsDelete=@IsDelete,");
strSql.Append("Remark=@Remark,");
strSql.Append("ManagerFlag=@ManagerFlag,");
strSql.Append("ManagerUser=@ManagerUser,");
strSql.Append("ManagerTime=@ManagerTime");
strSql.Append(" where ListID=@ListID ");
SqlParameter[] parameters =
{
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),
new SqlParameter("@ListID", SqlDbType.NVarChar, 64)
};
parameters[0].Value = model.JobID;
parameters[1].Value = model.JobType;
parameters[2].Value = model.ProductType;
parameters[3].Value = model.Num;
parameters[4].Value = model.IsDelete;
parameters[5].Value = model.Remark;
parameters[6].Value = model.ManagerFlag;
parameters[7].Value = model.ManagerUser;
parameters[8].Value = model.ManagerTime;
parameters[9].Value = model.ListID;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(CardCenter.Entity.UpdateUnlockList model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update UpdateUnlockList set ");
strSql.Append("JobID=@JobID,");
strSql.Append("JobType=@JobType,");
strSql.Append("CardType=@CardType,");
strSql.Append("CardNum=@CardNum,");
strSql.Append("CardholderName=@CardholderName,");
strSql.Append("CardholderIdentificationType=@CardholderIdentificationType,");
strSql.Append("CardholderIdentificationNum=@CardholderIdentificationNum,");
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("@CardNum", SqlDbType.NVarChar, 32),
new SqlParameter("@CardholderName", SqlDbType.NVarChar, 32),
new SqlParameter("@CardholderIdentificationType", SqlDbType.Int, 4),
new SqlParameter("@CardholderIdentificationNum", 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.CardNum;
parameters[4].Value = model.CardholderName;
parameters[5].Value = model.CardholderIdentificationType;
parameters[6].Value = model.CardholderIdentificationNum;
parameters[7].Value = model.IsDelete;
parameters[8].Value = model.Remark;
parameters[9].Value = model.ListID;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(CardCenter.Entity.HandleList model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update HandleList set ");
strSql.Append("JobID=@JobID,");
strSql.Append("No=@No,");
strSql.Append("FunctionID=@FunctionID,");
strSql.Append("OpeartionID=@OpeartionID,");
strSql.Append("IsChecked=@IsChecked,");
strSql.Append("Status=@Status,");
strSql.Append("OpeartionUser=@OpeartionUser,");
strSql.Append("OpeartionTime=@OpeartionTime,");
strSql.Append("Remark=@Remark");
strSql.Append(" where Guid=@Guid ");
SqlParameter[] parameters =
{
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),
new SqlParameter("@Guid", SqlDbType.NVarChar, 64)
};
parameters[0].Value = model.JobID;
parameters[1].Value = model.No;
parameters[2].Value = model.FunctionID;
parameters[3].Value = model.OpeartionID;
parameters[4].Value = model.IsChecked;
parameters[5].Value = model.Status;
parameters[6].Value = model.OpeartionUser;
parameters[7].Value = model.OpeartionTime;
parameters[8].Value = model.Remark;
parameters[9].Value = model.Guid;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(CardCenter.Entity.HandleLog model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update HandleLog set ");
strSql.Append("Guid=@Guid,");
strSql.Append("LastOpeartion=@LastOpeartion,");
strSql.Append("LastRemark=@LastRemark");
strSql.Append(" where ");
SqlParameter[] parameters =
{
new SqlParameter("@Guid", SqlDbType.NVarChar, 64),
new SqlParameter("@LastOpeartion", SqlDbType.NVarChar, 8),
new SqlParameter("@LastRemark", SqlDbType.NVarChar, 512)
};
parameters[0].Value = model.Guid;
parameters[1].Value = model.LastOpeartion;
parameters[2].Value = model.LastRemark;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(CardCenter.Entity.JobBar model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into JobBar(");
strSql.Append("Guid,JobID,BarCode,IsDelete)");
strSql.Append(" values (");
strSql.Append("@Guid,@JobID,@BarCode,@IsDelete)");
SqlParameter[] parameters =
{
new SqlParameter("@Guid", SqlDbType.NVarChar, 64),
new SqlParameter("@JobID", SqlDbType.NVarChar, 64),
new SqlParameter("@BarCode", SqlDbType.NVarChar, 64),
new SqlParameter("@IsDelete", SqlDbType.Bit, 1)
};
parameters[0].Value = model.Guid;
parameters[1].Value = model.JobID;
parameters[2].Value = model.BarCode;
parameters[3].Value = model.IsDelete;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(CardCenter.Entity.Para_Department model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Para_Department set ");
strSql.Append("City=@City,");
strSql.Append("Area=@Area,");
strSql.Append("GS=@GS,");
strSql.Append("ZJ=@ZJ,");
strSql.Append("SW=@SW,");
strSql.Append("HG=@HG,");
strSql.Append("WJ=@WJ,");
strSql.Append("WH=@WH");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
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),
new SqlParameter("@ID", SqlDbType.NVarChar, 6)
};
parameters[0].Value = model.City;
parameters[1].Value = model.Area;
parameters[2].Value = model.GS;
parameters[3].Value = model.ZJ;
parameters[4].Value = model.SW;
parameters[5].Value = model.HG;
parameters[6].Value = model.WJ;
parameters[7].Value = model.WH;
parameters[8].Value = model.ID;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(CardCenter.Entity.Stock_OutList model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Stock_OutList set ");
strSql.Append("CommodityGuid=@CommodityGuid,");
strSql.Append("JobID=@JobID,");
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("@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),
new SqlParameter("@Guid", SqlDbType.NVarChar, 64)
};
parameters[0].Value = model.CommodityGuid;
parameters[1].Value = model.JobID;
parameters[2].Value = model.Before;
parameters[3].Value = model.After;
parameters[4].Value = model.Num;
parameters[5].Value = model.SubmitUser;
parameters[6].Value = model.SubmitTime;
parameters[7].Value = model.Remark;
parameters[8].Value = model.Guid;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(CardCenter.Entity.JobBar model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update JobBar set ");
strSql.Append("JobID=@JobID,");
strSql.Append("BarCode=@BarCode,");
strSql.Append("IsDelete=@IsDelete");
strSql.Append(" where Guid=@Guid ");
SqlParameter[] parameters =
{
new SqlParameter("@JobID", SqlDbType.NVarChar, 64),
new SqlParameter("@BarCode", SqlDbType.NVarChar, 64),
new SqlParameter("@IsDelete", SqlDbType.Bit, 1),
new SqlParameter("@Guid", SqlDbType.NVarChar, 64)
};
parameters[0].Value = model.JobID;
parameters[1].Value = model.BarCode;
parameters[2].Value = model.IsDelete;
parameters[3].Value = model.Guid;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(CardCenter.Entity.SendLog model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SendLog(");
strSql.Append("Guid,IsSend,Error,SendPhone,SendContext)");
strSql.Append(" values (");
strSql.Append("@Guid,@IsSend,@Error,@SendPhone,@SendContext)");
SqlParameter[] parameters =
{
new SqlParameter("@Guid", SqlDbType.NVarChar, 64),
new SqlParameter("@IsSend", SqlDbType.Bit, 1),
new SqlParameter("@Error", SqlDbType.NVarChar, 512),
new SqlParameter("@SendPhone", SqlDbType.NVarChar, 32),
new SqlParameter("@SendContext", SqlDbType.NVarChar, 512)
};
parameters[0].Value = model.Guid;
parameters[1].Value = model.IsSend;
parameters[2].Value = model.Error;
parameters[3].Value = model.SendPhone;
parameters[4].Value = model.SendContext;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(CardCenter.Entity.Question model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Question set ");
strSql.Append("CustomCode=@CustomCode,");
strSql.Append("CreateTime=@CreateTime");
strSql.Append("Q1=@Q1,");
strSql.Append("Q1Content=@Q1Content,");
strSql.Append("Q2=@Q2,");
strSql.Append("Q2Content=@Q2Content,");
strSql.Append("Q3=@Q3,");
strSql.Append("Q3Content=@Q3Content,");
strSql.Append("Q4=@Q4,");
strSql.Append("Q4Content=@Q4Content,");
strSql.Append("Q5=@Q5,");
strSql.Append("Q5Content=@Q5Content,");
strSql.Append("Q6=@Q6,");
strSql.Append("Q6Content=@Q6Content,");
strSql.Append("Q7=@Q7,");
strSql.Append("Q7Content=@Q7Content,");
strSql.Append("Q8=@Q8,");
strSql.Append("Q8Content=@Q8Content,");
strSql.Append("Q9=@Q9,");
strSql.Append("Q9Content=@Q9Content,");
strSql.Append("Q10=@Q10,");
strSql.Append("Q10Content=@Q10Content");
strSql.Append(" where Guid=@Guid ");
SqlParameter[] parameters =
{
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),
new SqlParameter("@Guid", SqlDbType.NVarChar, 64)
};
parameters[0].Value = model.CustomCode;
parameters[1].Value = model.CreateTime;
parameters[2].Value = model.Q1;
parameters[3].Value = model.Q1Content;
parameters[4].Value = model.Q2;
parameters[5].Value = model.Q2Content;
parameters[6].Value = model.Q3;
parameters[7].Value = model.Q3Content;
parameters[8].Value = model.Q4;
parameters[9].Value = model.Q4Content;
parameters[10].Value = model.Q5;
parameters[11].Value = model.Q5Content;
parameters[12].Value = model.Q6;
parameters[13].Value = model.Q6Content;
parameters[14].Value = model.Q7;
parameters[15].Value = model.Q7Content;
parameters[16].Value = model.Q8;
parameters[17].Value = model.Q8Content;
parameters[18].Value = model.Q9;
parameters[19].Value = model.Q9Content;
parameters[20].Value = model.Q10;
parameters[21].Value = model.Q10Content;
parameters[22].Value = model.Guid;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(CardCenter.Entity.JobInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into JobInfo(");
strSql.Append("JobID,JobType,CreateTime,CreateUser,IsDelete,EnterpriseName,EnterpriseAddress,EnterpriseCode,AgentName,AgentIdentificationType,AgentIdentificationNum,AgentPhone,ConsigneeName,ConsigneeAddress,ConsigneePhone,Remark,ExpressFlat,FeeFlat,CustomsCode,ApprovalFile,IsOnline,InvoiceName,InvoicePhone,InvoiceAddress,InvoicePostCode,InvoiceEmail,InvoiceCode,Fee)");
strSql.Append(" values (");
strSql.Append("@JobID,@JobType,@CreateTime,@CreateUser,@IsDelete,@EnterpriseName,@EnterpriseAddress,@EnterpriseCode,@AgentName,@AgentIdentificationType,@AgentIdentificationNum,@AgentPhone,@ConsigneeName,@ConsigneeAddress,@ConsigneePhone,@Remark,@ExpressFlat,@FeeFlat,@CustomsCode,@ApprovalFile,@IsOnline,@InvoiceName,@InvoicePhone,@InvoiceAddress,@InvoicePostCode,@InvoiceEmail,@InvoiceCode,@Fee)");
SqlParameter[] parameters =
{
new SqlParameter("@JobID", SqlDbType.NVarChar, 64),
new SqlParameter("@JobType", SqlDbType.NVarChar, 8),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUser", SqlDbType.NVarChar, 64),
new SqlParameter("@IsDelete", SqlDbType.Bit, 1),
new SqlParameter("@EnterpriseName", SqlDbType.NVarChar, 128),
new SqlParameter("@EnterpriseAddress", SqlDbType.NVarChar, 512),
new SqlParameter("@EnterpriseCode", SqlDbType.NVarChar, 18),
new SqlParameter("@AgentName", SqlDbType.NVarChar, 32),
new SqlParameter("@AgentIdentificationType", SqlDbType.Int, 4),
new SqlParameter("@AgentIdentificationNum", SqlDbType.NVarChar, 32),
new SqlParameter("@AgentPhone", SqlDbType.NVarChar, 16),
new SqlParameter("@ConsigneeName", SqlDbType.NVarChar, 32),
new SqlParameter("@ConsigneeAddress", SqlDbType.NVarChar, 512),
new SqlParameter("@ConsigneePhone", SqlDbType.NVarChar, 32),
new SqlParameter("@Remark", SqlDbType.NVarChar, 512),
new SqlParameter("@ExpressFlat", SqlDbType.Bit, 1),
new SqlParameter("@FeeFlat", SqlDbType.NVarChar, 32),
new SqlParameter("@CustomsCode", SqlDbType.NVarChar, 10),
new SqlParameter("@ApprovalFile", SqlDbType.NVarChar, 64),
new SqlParameter("@IsOnline", SqlDbType.Bit, 1),
new SqlParameter("@InvoiceName", SqlDbType.NVarChar, 32),
new SqlParameter("@InvoicePhone", SqlDbType.NVarChar, 32),
new SqlParameter("@InvoiceAddress", SqlDbType.NVarChar, 512),
new SqlParameter("@InvoicePostCode", SqlDbType.NVarChar, 6),
new SqlParameter("@InvoiceEmail", SqlDbType.NVarChar, 64),
new SqlParameter("@InvoiceCode", SqlDbType.NVarChar, 18),
new SqlParameter("@Fee", SqlDbType.Float, 8)
};
parameters[0].Value = model.JobID;
parameters[1].Value = model.JobType;
parameters[2].Value = model.CreateTime;
parameters[3].Value = model.CreateUser;
parameters[4].Value = model.IsDelete;
parameters[5].Value = model.EnterpriseName;
parameters[6].Value = model.EnterpriseAddress;
parameters[7].Value = model.EnterpriseCode;
parameters[8].Value = model.AgentName;
parameters[9].Value = model.AgentIdentificationType;
parameters[10].Value = model.AgentIdentificationNum;
parameters[11].Value = model.AgentPhone;
parameters[12].Value = model.ConsigneeName;
parameters[13].Value = model.ConsigneeAddress;
parameters[14].Value = model.ConsigneePhone;
parameters[15].Value = model.Remark;
parameters[16].Value = model.ExpressFlat;
parameters[17].Value = model.FeeFlat;
parameters[18].Value = model.CustomsCode;
parameters[19].Value = model.ApprovalFile;
parameters[20].Value = model.IsOnline;
parameters[21].Value = model.InvoiceName;
parameters[22].Value = model.InvoicePhone;
parameters[23].Value = model.InvoiceAddress;
parameters[24].Value = model.InvoicePostCode;
parameters[25].Value = model.InvoiceEmail;
parameters[26].Value = model.InvoiceCode;
parameters[27].Value = model.Fee;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(CardCenter.Entity.JobInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update JobInfo set ");
strSql.Append("JobType=@JobType,");
strSql.Append("CreateTime=@CreateTime,");
strSql.Append("CreateUser=@CreateUser,");
strSql.Append("IsDelete=@IsDelete,");
strSql.Append("EnterpriseName=@EnterpriseName,");
strSql.Append("EnterpriseAddress=@EnterpriseAddress,");
strSql.Append("EnterpriseCode=@EnterpriseCode,");
strSql.Append("AgentName=@AgentName,");
strSql.Append("AgentIdentificationType=@AgentIdentificationType,");
strSql.Append("AgentIdentificationNum=@AgentIdentificationNum,");
strSql.Append("AgentPhone=@AgentPhone,");
strSql.Append("ConsigneeName=@ConsigneeName,");
strSql.Append("ConsigneeAddress=@ConsigneeAddress,");
strSql.Append("ConsigneePhone=@ConsigneePhone,");
strSql.Append("Remark=@Remark,");
strSql.Append("ExpressFlat=@ExpressFlat,");
strSql.Append("FeeFlat=@FeeFlat,");
strSql.Append("CustomsCode=@CustomsCode,");
strSql.Append("ApprovalFile=@ApprovalFile,");
strSql.Append("IsOnline=@IsOnline,");
strSql.Append("InvoiceName=@InvoiceName,");
strSql.Append("InvoicePhone=@InvoicePhone,");
strSql.Append("InvoiceAddress=@InvoiceAddress,");
strSql.Append("InvoicePostCode=@InvoicePostCode,");
strSql.Append("InvoiceEmail=@InvoiceEmail,");
strSql.Append("InvoiceCode=@InvoiceCode,");
strSql.Append("Fee=@Fee");
strSql.Append(" where JobID=@JobID ");
SqlParameter[] parameters =
{
new SqlParameter("@JobType", SqlDbType.NVarChar, 8),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUser", SqlDbType.NVarChar, 64),
new SqlParameter("@IsDelete", SqlDbType.Bit, 1),
new SqlParameter("@EnterpriseName", SqlDbType.NVarChar, 128),
new SqlParameter("@EnterpriseAddress", SqlDbType.NVarChar, 512),
new SqlParameter("@EnterpriseCode", SqlDbType.NVarChar, 18),
new SqlParameter("@AgentName", SqlDbType.NVarChar, 32),
new SqlParameter("@AgentIdentificationType", SqlDbType.Int, 4),
new SqlParameter("@AgentIdentificationNum", SqlDbType.NVarChar, 32),
new SqlParameter("@AgentPhone", SqlDbType.NVarChar, 16),
new SqlParameter("@ConsigneeName", SqlDbType.NVarChar, 32),
new SqlParameter("@ConsigneeAddress", SqlDbType.NVarChar, 512),
new SqlParameter("@ConsigneePhone", SqlDbType.NVarChar, 32),
new SqlParameter("@Remark", SqlDbType.NVarChar, 512),
new SqlParameter("@JobID", SqlDbType.NVarChar, 64),
new SqlParameter("@ExpressFlat", SqlDbType.Bit, 1),
new SqlParameter("@FeeFlat", SqlDbType.NVarChar, 32),
new SqlParameter("@CustomsCode", SqlDbType.NVarChar, 10),
new SqlParameter("@ApprovalFile", SqlDbType.NVarChar, 64),
new SqlParameter("@IsOnline", SqlDbType.Bit, 1),
new SqlParameter("@InvoiceName", SqlDbType.NVarChar, 32),
new SqlParameter("@InvoicePhone", SqlDbType.NVarChar, 32),
new SqlParameter("@InvoiceAddress", SqlDbType.NVarChar, 512),
new SqlParameter("@InvoicePostCode", SqlDbType.NVarChar, 6),
new SqlParameter("@InvoiceEmail", SqlDbType.NVarChar, 64),
new SqlParameter("@InvoiceCode", SqlDbType.NVarChar, 18),
new SqlParameter("@Fee", SqlDbType.Float, 8)
};
parameters[0].Value = model.JobType;
parameters[1].Value = model.CreateTime;
parameters[2].Value = model.CreateUser;
parameters[3].Value = model.IsDelete;
parameters[4].Value = model.EnterpriseName;
parameters[5].Value = model.EnterpriseAddress;
parameters[6].Value = model.EnterpriseCode;
parameters[7].Value = model.AgentName;
parameters[8].Value = model.AgentIdentificationType;
parameters[9].Value = model.AgentIdentificationNum;
parameters[10].Value = model.AgentPhone;
parameters[11].Value = model.ConsigneeName;
parameters[12].Value = model.ConsigneeAddress;
parameters[13].Value = model.ConsigneePhone;
parameters[14].Value = model.Remark;
parameters[15].Value = model.JobID;
parameters[16].Value = model.ExpressFlat;
parameters[17].Value = model.FeeFlat;
parameters[18].Value = model.CustomsCode;
parameters[19].Value = model.ApprovalFile;
parameters[20].Value = model.IsOnline;
parameters[21].Value = model.InvoiceName;
parameters[22].Value = model.InvoicePhone;
parameters[23].Value = model.InvoiceAddress;
parameters[24].Value = model.InvoicePostCode;
parameters[25].Value = model.InvoiceEmail;
parameters[26].Value = model.InvoiceCode;
parameters[27].Value = model.Fee;
TranHelper.AddTran(strSql, parameters);
}
