/// <summary>
/// 跟新单据单据
/// </summary>
/// <param name="sellChanceModel">销售机会表实体</param>
/// <param name="sellChancePushModel">销售阶段表实体</param>
/// <returns>是否添加成功</returns>
public static bool UpdateOrder(AdversaryInfoModel adversaryInfoModel, List <AdversaryDynamicModel> adversaryDynamicModelList)
{
bool isSucc = false;//是否添加成功
string strSql = "delete from officedba.AdversaryDynamic where CustNo=@CustNo and CompanyCD=@CompanyCD";
SqlParameter[] paras = { new SqlParameter("@CustNo", adversaryInfoModel.CustNo), new SqlParameter("@CompanyCD", adversaryInfoModel.CompanyCD) };
TransactionManager tran = new TransactionManager();
tran.BeginTransaction();
try
{
UpdateAdversaryInfo(adversaryInfoModel, tran);
SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, strSql.ToString(), paras);
InsertAdversaryDynamic(adversaryDynamicModelList, tran);
tran.Commit();
isSucc = true;
}
catch (Exception ex)
{
tran.Rollback();
isSucc = false;
throw ex;
}
return(isSucc);
}
/// <summary>
/// 跟新单据单据
/// </summary>
/// <param name="sellChanceModel">销售机会表实体</param>
/// <param name="sellChancePushModel">销售阶段表实体</param>
/// <returns>是否添加成功</returns>
public static bool UpdateOrder(AdversaryInfoModel adversaryInfoModel, List <AdversaryDynamicModel> adversaryDynamicModelList)
{
bool isSucc = false;//是否添加成功
//定义变量
string remark = string.Empty;
//获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
try
{
isSucc = AdversaryInfoDBHelper.UpdateOrder(adversaryInfoModel, adversaryDynamicModelList);
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
catch (Exception ex)
{
//输出日志
WriteSystemLog(userInfo, ex);
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
}
LogInfoModel logModel = InitLogInfo(adversaryInfoModel.CustNo);
//涉及关键元素 这个需要根据每个页面具体设置，本页面暂时设置为空
logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
//设置操作成功标识
logModel.Remark = remark;
//登陆日志
LogDBHelper.InsertLog(logModel);
return(isSucc);
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
//设置行为参数
string orderString = hiddExpOrder.Value.Trim(); //排序
string order = "desc"; //排序：降序
string orderBy = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "CreatDate"; //要排序的字段，如果为空，默认为"ID"
if (orderString.EndsWith("_a"))
{
order = "asc"; //排序：升序
}
int pageCount = int.Parse(hiddExpTotal.Value); //每页显示记录数
int pageIndex = 1; //当前页
int totalCount = 0; //总记录数
string ord = orderBy + " " + order; //排序字段
DataTable dt = new DataTable();
AdversaryInfoModel adversaryInfoModel = new AdversaryInfoModel();
string strCustNo = hiddExpCustNo.Value;
string strCustType = hiddExpCustType.Value;
string strCustName = hiddExpCustName.Value;
string strPYShort = hiddExpPYShort.Value;
string CustNo = strCustNo.Length == 0 ? null : strCustNo;
int? CustType = strCustType.Length == 0 ? null : (int?)Convert.ToInt32(strCustType);
string CustName = strCustName.Length == 0 ? null : strCustName;
string PYShort = strPYShort.Length == 0 ? null : strPYShort;
adversaryInfoModel.CustNo = CustNo;
adversaryInfoModel.CustType = CustType;
adversaryInfoModel.CustName = CustName;
adversaryInfoModel.PYShort = PYShort;
dt = AdversaryInfoBus.GetOrderList(adversaryInfoModel, pageIndex, pageCount, ord, ref totalCount);
//导出标题
string headerTitle = "对手编号|对手名称|对手类别|对手拼音代码|联系人|联系电话|创建人|创建日期";
//string headerTitle = "建档日期|启用状态";
string[] header = headerTitle.Split('|');
//导出标题所对应的列字段名称
string columnFiled = "CustNo|CustName|TypeName|PYShort|ContactName|Tel|EmployeeName|CreatDate";
//string columnFiled = "CreateDate|strUsedStatus";
string[] field = columnFiled.Split('|');
XBase.Common.OutputToExecl.ExportToTable(this.Page, dt, header, field, "竞争对手档案列表");
}
/// <summary>
/// 获取单据列表
/// </summary>
/// <param name="sellContractModel">sellContractModel表实体</param>
/// <param name="FlowStatus">审批状态</param>
/// <returns></returns>
public static DataTable GetOrderList(AdversaryInfoModel adversaryInfoModel, int pageIndex, int pageCount, string ord, ref int TotalCount)
{
string strSql = string.Empty;
string strCompanyCD = string.Empty; //单位编号
strCompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
strSql = "SELECT ISNULL(c.TypeName, '') AS TypeName, ISNULL(e.EmployeeName, '') AS EmployeeName, ";
strSql += "a.CustNo, a.CustName, a.PYShort, a.Tel, a.ContactName,a.ModifiedDate, ";
strSql += "CONVERT(varchar(100), a.CreatDate, 23) AS CreatDate, isnull(CASE ";
strSql += "(SELECT count(1) FROM officedba.AdversarySell AS ab ";
strSql += "WHERE ab.CustNo = a.CustNo and ab.CompanyCD=a.CompanyCD ) WHEN 0 THEN '不存在' END, '存在') AS FromBillText , a.ID ";
strSql += "FROM officedba.AdversaryInfo AS a LEFT OUTER JOIN ";
strSql += "officedba.CodePublicType AS c ON a.CustType = c.ID LEFT OUTER JOIN ";
strSql += "officedba.EmployeeInfo AS e ON a.Creator = e.ID where a.CompanyCD=@CompanyCD ";
ArrayList arr = new ArrayList();
arr.Add(new SqlParameter("@CompanyCD", strCompanyCD));
if (adversaryInfoModel.CustName != null)
{
strSql += " and a.CustName like @CustName ";
arr.Add(new SqlParameter("@CustName", "%" + adversaryInfoModel.CustName + "%"));
}
if (adversaryInfoModel.CustNo != null)
{
strSql += " and a.CustNo like @CustNo ";
arr.Add(new SqlParameter("@CustNo", "%" + adversaryInfoModel.CustNo + "%"));
}
if (adversaryInfoModel.PYShort != null)
{
strSql += " and a.PYShort like @PYShort ";
arr.Add(new SqlParameter("@PYShort", "%" + adversaryInfoModel.PYShort + "%"));
}
if (adversaryInfoModel.CustType != null)
{
strSql += " and a.CustType= @CustType ";
arr.Add(new SqlParameter("@CustType", adversaryInfoModel.CustType));
}
return(SqlHelper.CreateSqlByPageExcuteSqlArr(strSql.ToString(), pageIndex, pageCount, ord, arr, ref TotalCount));
}
/// <summary>
/// 添加单据
/// </summary>
/// <param name="sellChanceModel">销售机会表实体</param>
/// <param name="sellChancePushModel">销售阶段表实体</param>
/// <returns>是否添加成功</returns>
public static bool InsertOrder(AdversaryInfoModel adversaryInfoModel, List <AdversaryDynamicModel> adversaryDynamicModelList)
{
bool isSucc = false;//是否添加成功
TransactionManager tran = new TransactionManager();
tran.BeginTransaction();
try
{
InsertAdversaryInfo(adversaryInfoModel, tran);
InsertAdversaryDynamic(adversaryDynamicModelList, tran);
tran.Commit();
isSucc = true;
}
catch (Exception ex)
{
tran.Rollback();
isSucc = false;
throw ex;
}
return(isSucc);
}
protected void LoadPrintInfo()
{
PrintParameterSettingModel model = new PrintParameterSettingModel();
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
model.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_SALE);
model.PrintTypeFlag = ConstUtil.PRINTBILL_ADVERSARY;
AdversaryInfoModel modelMRP = new AdversaryInfoModel();
modelMRP.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
modelMRP.CustNo = this.PlanNo;
/*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
#region 信息的字段
string[,] aBase =
{
{ "对手编号", "CustNo" },
{ "对手类别", "CustTypeName" },
{ "对手细分", "CustClassName" },
{ "对手名称", "CustName" },
{ "对手简称", "ShortNam" },
{ "对手拼音代码", "PYShort" },
{ "对手所在区域", "AreaIDName" },
{ "成立时间", "SetupDate" },
{ "法人代表", "ArtiPerson" },
{ "单位性质", "CompanyTypeName" },
{ "员工总数", "StaffCount" },
{ "注册资本(万元)", "SetupMoney" },
{ "注册地址", "SetupAddress" },
{ "公司网址", "website" },
{ "资产规模(万元)", "CapitalScale" },
{ "经营范围", "SellArea" },
{ "年销售额(万元)", "SaleroomY" },
{ "年利润额(万元)", "ProfitY" },
{ "税务登记号", "TaxCD" },
{ "营业执照号", "BusiNumber" },
{ "一般纳税人", "IsTaxName" },
{ "地址", "Address" },
{ "邮编", "Post" },
{ "联系人", "ContactName" },
{ "电话", "Tel" },
{ "手机", "Mobile" },
{ "邮件", "email" },
{ "对手简介", "CustNote" },
{ "主打产品 ", "Product" },
{ "竞争产品/方案", "Project" },
{ "竞争能力", "Power" },
{ "竞争优势", "Advantage" },
{ "竞争劣势", "disadvantage" },
{ "应对策略", "Policy" },
{ "市场占有率(%)", "Market" },
{ "销售模式", "SellMode" },
{ "启用状态", "UsedStatusName" },
{ "制单人", "EmployeeName" },
{ "制单日期", "CreatDate" },
{ "最后更新人", "ModifiedUserID" },
{ "最后更新日", "ModifiedDate" },
{ "备注", "Remark" },
};
string[,] aDetail =
{
{ "对手动态", "Dynamic" },
};
#endregion
DataTable dbPrint = XBase.Business.Common.PrintParameterSettingBus.GetPrintParameterSettingInfo(model);
DataTable dtMRP = AdversaryInfoBus.GetRepOrder(PlanNo); //SellContractBus.GetRepOrder(OfferNo);
DataTable dtDetail = AdversaryInfoBus.GetRepOrderDetail(PlanNo); // SellContractBus.GetRepOrderDetail(OfferNo);
string strBaseFields = "";
string strDetailFields = "";
if (dbPrint.Rows.Count > 0)
{
isSeted.Value = "1";
strBaseFields = dbPrint.Rows[0]["BaseFields"].ToString();
strDetailFields = dbPrint.Rows[0]["DetailFields"].ToString();
}
else
{
isSeted.Value = "0";
strBaseFields = "CustNo|CustTypeName|CustClassName|CustName|ShortNam|PYShort|AreaIDName|SetupDate|ArtiPerson|CompanyTypeName|StaffCount|SetupMoney|" +
"SetupAddress|website|CapitalScale|SellArea|SaleroomY|ProfitY|TaxCD|BusiNumber|IsTaxName|Address|Post|ContactName|Tel|Mobile|email|" +
"CustNote|Product|Project|Power|Advantage|disadvantage|Policy|Market|SellMode|UsedStatusName|EmployeeName|CreatDate|ModifiedUserID|" +
"ModifiedDate|Remark";
strDetailFields = "Dynamic";
}
#region 主表信息
if (!string.IsNullOrEmpty(strBaseFields))
{
tableBase.InnerHtml = WritePrintPageTable("竞争对手档案", strBaseFields, strDetailFields, aBase, aDetail, dtMRP, dtDetail, true);
}
#endregion
#region 明细信息
if (!string.IsNullOrEmpty(strDetailFields))
{
tableDetail.InnerHtml = WritePrintPageTable("对手动态信息", strBaseFields, strDetailFields, aBase, aDetail, dtMRP, dtDetail, false);
}
#endregion
}
/// <summary>
/// 添加zhu表信息
/// </summary>
/// <param name="adversaryInfoModel"></param>
/// <param name="tran"></param>
private static void InsertAdversaryInfo(AdversaryInfoModel adversaryInfoModel, TransactionManager tran)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into officedba.AdversaryInfo(");
strSql.Append("CompanyCD,BigType,CustType,CustClass,CustNo,CustName,ShortNam,PYShort,AreaID,SetupDate,ArtiPerson,CompanyType,StaffCount,SetupMoney,SetupAddress,website,CapitalScale,SellArea,SaleroomY,ProfitY,TaxCD,BusiNumber,IsTax,Address,Post,ContactName,Tel,Mobile,email,CustNote,Product,Market,SellMode,Project,Power,Advantage,disadvantage,Policy,Remark,UsedStatus,Creator,CreatDate,ModifiedDate,ModifiedUserID)");
strSql.Append(" values (");
strSql.Append("@CompanyCD,@BigType,@CustType,@CustClass,@CustNo,@CustName,@ShortNam,@PYShort,@AreaID,@SetupDate,@ArtiPerson,@CompanyType,@StaffCount,@SetupMoney,@SetupAddress,@website,@CapitalScale,@SellArea,@SaleroomY,@ProfitY,@TaxCD,@BusiNumber,@IsTax,@Address,@Post,@ContactName,@Tel,@Mobile,@email,@CustNote,@Product,@Market,@SellMode,@Project,@Power,@Advantage,@disadvantage,@Policy,@Remark,@UsedStatus,@Creator,getdate(),getdate(),@ModifiedUserID)");
#region 参数
SqlParameter[] parameters =
{
new SqlParameter("@CompanyCD", SqlDbType.VarChar, 8),
new SqlParameter("@BigType", SqlDbType.Char, 1),
new SqlParameter("@CustType", SqlDbType.Int, 4),
new SqlParameter("@CustClass", SqlDbType.Int, 4),
new SqlParameter("@CustNo", SqlDbType.VarChar, 50),
new SqlParameter("@CustName", SqlDbType.VarChar, 100),
new SqlParameter("@ShortNam", SqlDbType.VarChar, 50),
new SqlParameter("@PYShort", SqlDbType.VarChar, 50),
new SqlParameter("@AreaID", SqlDbType.Int, 4),
new SqlParameter("@SetupDate", SqlDbType.DateTime),
new SqlParameter("@ArtiPerson", SqlDbType.VarChar, 20),
new SqlParameter("@CompanyType", SqlDbType.Char, 1),
new SqlParameter("@StaffCount", SqlDbType.Int, 4),
new SqlParameter("@SetupMoney", SqlDbType.Decimal, 9),
new SqlParameter("@SetupAddress", SqlDbType.VarChar, 100),
new SqlParameter("@website", SqlDbType.VarChar, 100),
new SqlParameter("@CapitalScale", SqlDbType.Decimal, 9),
new SqlParameter("@SellArea", SqlDbType.VarChar, 200),
new SqlParameter("@SaleroomY", SqlDbType.Decimal, 9),
new SqlParameter("@ProfitY", SqlDbType.Decimal, 9),
new SqlParameter("@TaxCD", SqlDbType.VarChar, 50),
new SqlParameter("@BusiNumber", SqlDbType.VarChar, 50),
new SqlParameter("@IsTax", SqlDbType.Char, 1),
new SqlParameter("@Address", SqlDbType.VarChar, 100),
new SqlParameter("@Post", SqlDbType.VarChar, 10),
new SqlParameter("@ContactName", SqlDbType.VarChar, 50),
new SqlParameter("@Tel", SqlDbType.VarChar, 50),
new SqlParameter("@Mobile", SqlDbType.VarChar, 50),
new SqlParameter("@email", SqlDbType.VarChar, 50),
new SqlParameter("@CustNote", SqlDbType.VarChar, 1024),
new SqlParameter("@Product", SqlDbType.VarChar, 800),
new SqlParameter("@Market", SqlDbType.VarChar, 50),
new SqlParameter("@SellMode", SqlDbType.VarChar, 50),
new SqlParameter("@Project", SqlDbType.VarChar, 1024),
new SqlParameter("@Power", SqlDbType.VarChar, 1024),
new SqlParameter("@Advantage", SqlDbType.VarChar, 1024),
new SqlParameter("@disadvantage", SqlDbType.VarChar, 1024),
new SqlParameter("@Policy", SqlDbType.VarChar, 1024),
new SqlParameter("@Remark", SqlDbType.VarChar, 1024),
new SqlParameter("@UsedStatus", SqlDbType.Char, 1),
new SqlParameter("@Creator", SqlDbType.Int, 4),
new SqlParameter("@ModifiedUserID", SqlDbType.VarChar, 10)
};
parameters[0].Value = adversaryInfoModel.CompanyCD;
parameters[1].Value = adversaryInfoModel.BigType;
parameters[2].Value = adversaryInfoModel.CustType;
parameters[3].Value = adversaryInfoModel.CustClass;
parameters[4].Value = adversaryInfoModel.CustNo;
parameters[5].Value = adversaryInfoModel.CustName;
parameters[6].Value = adversaryInfoModel.ShortNam;
parameters[7].Value = adversaryInfoModel.PYShort;
parameters[8].Value = adversaryInfoModel.AreaID;
parameters[9].Value = adversaryInfoModel.SetupDate;
parameters[10].Value = adversaryInfoModel.ArtiPerson;
parameters[11].Value = adversaryInfoModel.CompanyType;
parameters[12].Value = adversaryInfoModel.StaffCount;
parameters[13].Value = adversaryInfoModel.SetupMoney;
parameters[14].Value = adversaryInfoModel.SetupAddress;
parameters[15].Value = adversaryInfoModel.website;
parameters[16].Value = adversaryInfoModel.CapitalScale;
parameters[17].Value = adversaryInfoModel.SellArea;
parameters[18].Value = adversaryInfoModel.SaleroomY;
parameters[19].Value = adversaryInfoModel.ProfitY;
parameters[20].Value = adversaryInfoModel.TaxCD;
parameters[21].Value = adversaryInfoModel.BusiNumber;
parameters[22].Value = adversaryInfoModel.IsTax;
parameters[23].Value = adversaryInfoModel.Address;
parameters[24].Value = adversaryInfoModel.Post;
parameters[25].Value = adversaryInfoModel.ContactName;
parameters[26].Value = adversaryInfoModel.Tel;
parameters[27].Value = adversaryInfoModel.Mobile;
parameters[28].Value = adversaryInfoModel.email;
parameters[29].Value = adversaryInfoModel.CustNote;
parameters[30].Value = adversaryInfoModel.Product;
parameters[31].Value = adversaryInfoModel.Market;
parameters[32].Value = adversaryInfoModel.SellMode;
parameters[33].Value = adversaryInfoModel.Project;
parameters[34].Value = adversaryInfoModel.Power;
parameters[35].Value = adversaryInfoModel.Advantage;
parameters[36].Value = adversaryInfoModel.disadvantage;
parameters[37].Value = adversaryInfoModel.Policy;
parameters[38].Value = adversaryInfoModel.Remark;
parameters[39].Value = adversaryInfoModel.UsedStatus;
parameters[40].Value = adversaryInfoModel.Creator;
parameters[41].Value = adversaryInfoModel.ModifiedUserID;
foreach (SqlParameter para in parameters)
{
if (para.Value == null)
{
para.Value = DBNull.Value;
}
}
#endregion
SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, strSql.ToString(), parameters);
}
/// <summary>
/// 跟新主表信息
/// </summary>
/// <param name="adversaryInfoModel"></param>
/// <param name="tran"></param>
private static void UpdateAdversaryInfo(AdversaryInfoModel adversaryInfoModel, TransactionManager tran)
{
StringBuilder strSql = new StringBuilder();
#region sql语句
strSql.Append("update officedba.AdversaryInfo set ");
strSql.Append("BigType=@BigType,");
strSql.Append("CustType=@CustType,");
strSql.Append("CustClass=@CustClass,");
strSql.Append("CustName=@CustName,");
strSql.Append("ShortNam=@ShortNam,");
strSql.Append("PYShort=@PYShort,");
strSql.Append("AreaID=@AreaID,");
strSql.Append("SetupDate=@SetupDate,");
strSql.Append("ArtiPerson=@ArtiPerson,");
strSql.Append("CompanyType=@CompanyType,");
strSql.Append("StaffCount=@StaffCount,");
strSql.Append("SetupMoney=@SetupMoney,");
strSql.Append("SetupAddress=@SetupAddress,");
strSql.Append("website=@website,");
strSql.Append("CapitalScale=@CapitalScale,");
strSql.Append("SellArea=@SellArea,");
strSql.Append("SaleroomY=@SaleroomY,");
strSql.Append("ProfitY=@ProfitY,");
strSql.Append("TaxCD=@TaxCD,");
strSql.Append("BusiNumber=@BusiNumber,");
strSql.Append("IsTax=@IsTax,");
strSql.Append("Address=@Address,");
strSql.Append("Post=@Post,");
strSql.Append("ContactName=@ContactName,");
strSql.Append("Tel=@Tel,");
strSql.Append("Mobile=@Mobile,");
strSql.Append("email=@email,");
strSql.Append("CustNote=@CustNote,");
strSql.Append("Product=@Product,");
strSql.Append("Market=@Market,");
strSql.Append("SellMode=@SellMode,");
strSql.Append("Project=@Project,");
strSql.Append("Power=@Power,");
strSql.Append("Advantage=@Advantage,");
strSql.Append("disadvantage=@disadvantage,");
strSql.Append("Policy=@Policy,");
strSql.Append("Remark=@Remark,");
strSql.Append("UsedStatus=@UsedStatus,");
strSql.Append("ModifiedDate=getdate(),");
strSql.Append("ModifiedUserID=@ModifiedUserID");
strSql.Append(" where CompanyCD=@CompanyCD and CustNo=@CustNo");
#endregion
#region 参数
SqlParameter[] parameters =
{
new SqlParameter("@CompanyCD", SqlDbType.VarChar, 8),
new SqlParameter("@BigType", SqlDbType.Char, 1),
new SqlParameter("@CustType", SqlDbType.Int, 4),
new SqlParameter("@CustClass", SqlDbType.Int, 4),
new SqlParameter("@CustNo", SqlDbType.VarChar, 50),
new SqlParameter("@CustName", SqlDbType.VarChar, 100),
new SqlParameter("@ShortNam", SqlDbType.VarChar, 50),
new SqlParameter("@PYShort", SqlDbType.VarChar, 50),
new SqlParameter("@AreaID", SqlDbType.Int, 4),
new SqlParameter("@SetupDate", SqlDbType.DateTime),
new SqlParameter("@ArtiPerson", SqlDbType.VarChar, 20),
new SqlParameter("@CompanyType", SqlDbType.Char, 1),
new SqlParameter("@StaffCount", SqlDbType.Int, 4),
new SqlParameter("@SetupMoney", SqlDbType.Decimal, 9),
new SqlParameter("@SetupAddress", SqlDbType.VarChar, 100),
new SqlParameter("@website", SqlDbType.VarChar, 100),
new SqlParameter("@CapitalScale", SqlDbType.Decimal, 9),
new SqlParameter("@SellArea", SqlDbType.VarChar, 200),
new SqlParameter("@SaleroomY", SqlDbType.Decimal, 9),
new SqlParameter("@ProfitY", SqlDbType.Decimal, 9),
new SqlParameter("@TaxCD", SqlDbType.VarChar, 50),
new SqlParameter("@BusiNumber", SqlDbType.VarChar, 50),
new SqlParameter("@IsTax", SqlDbType.Char, 1),
new SqlParameter("@Address", SqlDbType.VarChar, 100),
new SqlParameter("@Post", SqlDbType.VarChar, 10),
new SqlParameter("@ContactName", SqlDbType.VarChar, 50),
new SqlParameter("@Tel", SqlDbType.VarChar, 50),
new SqlParameter("@Mobile", SqlDbType.VarChar, 50),
new SqlParameter("@email", SqlDbType.VarChar, 50),
new SqlParameter("@CustNote", SqlDbType.VarChar, 1024),
new SqlParameter("@Product", SqlDbType.VarChar, 800),
new SqlParameter("@Market", SqlDbType.VarChar, 50),
new SqlParameter("@SellMode", SqlDbType.VarChar, 50),
new SqlParameter("@Project", SqlDbType.VarChar, 1024),
new SqlParameter("@Power", SqlDbType.VarChar, 1024),
new SqlParameter("@Advantage", SqlDbType.VarChar, 1024),
new SqlParameter("@disadvantage", SqlDbType.VarChar, 1024),
new SqlParameter("@Policy", SqlDbType.VarChar, 1024),
new SqlParameter("@Remark", SqlDbType.VarChar, 1024),
new SqlParameter("@UsedStatus", SqlDbType.Char, 1),
new SqlParameter("@ModifiedUserID", SqlDbType.VarChar, 10)
};
parameters[0].Value = adversaryInfoModel.CompanyCD;
parameters[1].Value = adversaryInfoModel.BigType;
parameters[2].Value = adversaryInfoModel.CustType;
parameters[3].Value = adversaryInfoModel.CustClass;
parameters[4].Value = adversaryInfoModel.CustNo;
parameters[5].Value = adversaryInfoModel.CustName;
parameters[6].Value = adversaryInfoModel.ShortNam;
parameters[7].Value = adversaryInfoModel.PYShort;
parameters[8].Value = adversaryInfoModel.AreaID;
parameters[9].Value = adversaryInfoModel.SetupDate;
parameters[10].Value = adversaryInfoModel.ArtiPerson;
parameters[11].Value = adversaryInfoModel.CompanyType;
parameters[12].Value = adversaryInfoModel.StaffCount;
parameters[13].Value = adversaryInfoModel.SetupMoney;
parameters[14].Value = adversaryInfoModel.SetupAddress;
parameters[15].Value = adversaryInfoModel.website;
parameters[16].Value = adversaryInfoModel.CapitalScale;
parameters[17].Value = adversaryInfoModel.SellArea;
parameters[18].Value = adversaryInfoModel.SaleroomY;
parameters[19].Value = adversaryInfoModel.ProfitY;
parameters[20].Value = adversaryInfoModel.TaxCD;
parameters[21].Value = adversaryInfoModel.BusiNumber;
parameters[22].Value = adversaryInfoModel.IsTax;
parameters[23].Value = adversaryInfoModel.Address;
parameters[24].Value = adversaryInfoModel.Post;
parameters[25].Value = adversaryInfoModel.ContactName;
parameters[26].Value = adversaryInfoModel.Tel;
parameters[27].Value = adversaryInfoModel.Mobile;
parameters[28].Value = adversaryInfoModel.email;
parameters[29].Value = adversaryInfoModel.CustNote;
parameters[30].Value = adversaryInfoModel.Product;
parameters[31].Value = adversaryInfoModel.Market;
parameters[32].Value = adversaryInfoModel.SellMode;
parameters[33].Value = adversaryInfoModel.Project;
parameters[34].Value = adversaryInfoModel.Power;
parameters[35].Value = adversaryInfoModel.Advantage;
parameters[36].Value = adversaryInfoModel.disadvantage;
parameters[37].Value = adversaryInfoModel.Policy;
parameters[38].Value = adversaryInfoModel.Remark;
parameters[39].Value = adversaryInfoModel.UsedStatus;
parameters[40].Value = adversaryInfoModel.ModifiedUserID;
foreach (SqlParameter para in parameters)
{
if (para.Value == null)
{
para.Value = DBNull.Value;
}
}
#endregion
SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, strSql.ToString(), parameters);
}
/// <summary>
/// 获取单据列表
/// </summary>
/// <param name="sellContractModel">sellContractModel表实体</param>
/// <param name="FlowStatus">审批状态</param>
/// <returns></returns>
public static DataTable GetOrderList(AdversaryInfoModel adversaryInfoModel, int pageIndex, int pageCount, string ord, ref int TotalCount)
{
return(AdversaryInfoDBHelper.GetOrderList(adversaryInfoModel, pageIndex, pageCount, ord, ref TotalCount));
}
