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