/// <summary> /// 查询往来单位信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public static DataTable SearchRectOtherCorpInfo(OtherCorpInfoModel model, int pageIndex, int pageCount, string OrderBy, ref int totalCount) { try { UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; model.CompanyCD = userInfo.CompanyCD; //model.CompanyCD = "AAAAAA"; return OtherCorpInfoDBHelper.SearchRectOtherCorpInfo(model, pageIndex, pageCount, OrderBy, ref totalCount); } catch (Exception) { return null; throw; } }
/// <summary> /// 更新其他往来单位信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool UpdateCropInfo(OtherCorpInfoModel model) { UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //登陆日志 try { bool succ = false; LogInfoModel logModel = InitLogInfo(model.CustNo); logModel.Element = ConstUtil.LOG_PROCESS_UPDATE; succ = OtherCorpInfoDBHelper.UpdateOtherCorpInfo(model); if (!succ) logModel.Remark = ConstUtil.LOG_PROCESS_FAILED; else logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS; LogDBHelper.InsertLog(logModel); return succ; } catch (Exception) { return false; throw; } }
/// <summary> /// 插入其他往来单位 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool InsertCropInfo(OtherCorpInfoModel model) { UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //登陆日志 try { bool succ = false; LogInfoModel logModel = InitLogInfo(model.CustNo); logModel.Element = ConstUtil.LOG_PROCESS_INSERT; succ = OtherCorpInfoDBHelper.InsertOtherCorpInfo(model); if (!succ) logModel.Remark = ConstUtil.LOG_PROCESS_FAILED; else logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS; LogDBHelper.InsertLog(logModel); return succ; } catch (Exception ex) { WriteSystemLog(userInfo, ex); return false; } }
private static OtherCorpInfoModel ChangeOtherCorpInfoModel(DataRow data) { //定义返回的 EmployeeInfoModel OtherCorpInfoModel model = new OtherCorpInfoModel(); //人员信息存在时,转化为model形式的数据 if (data != null) { model.ID = GetSafeData.ValidateDataRow_Int(data, "ID"); model.CompanyCD = GetSafeData.ValidateDataRow_String(data, "CompanyCD"); model.BigType = GetSafeData.ValidateDataRow_String(data, "BigType"); model.CustNo = GetSafeData.ValidateDataRow_String(data, "CustNo"); model.CustName = GetSafeData.ValidateDataRow_String(data, "CustName"); model.CorpNam = GetSafeData.ValidateDataRow_String(data, "CorpNam"); model.PYShort = GetSafeData.ValidateDataRow_String(data, "PYShort"); model.CustNote = GetSafeData.ValidateDataRow_String(data, "CustNote"); model.AreaID = GetSafeData.GetStringFromInt(data, "AreaID"); model.CompanyType = GetSafeData.ValidateDataRow_String(data, "CompanyType"); model.StaffCount = GetSafeData.GetStringFromInt(data, "StaffCount"); model.SetupDate = GetSafeData.ValidateDataRow_String(data, "SetupDate"); model.ArtiPerson = GetSafeData.ValidateDataRow_String(data, "ArtiPerson"); model.SetupMoney = GetSafeData.GetStringFromDecimal(data, "SetupMoney"); model.SetupAddress = GetSafeData.ValidateDataRow_String(data, "SetupAddress"); model.CapitalScale = GetSafeData.GetStringFromDecimal(data, "CapitalScale"); model.SaleroomY = GetSafeData.GetStringFromDecimal(data, "SaleroomY"); model.ProfitY = GetSafeData.GetStringFromDecimal(data, "ProfitY"); model.TaxCD = GetSafeData.ValidateDataRow_String(data, "TaxCD"); model.BusiNumber = GetSafeData.ValidateDataRow_String(data, "BusiNumber"); model.isTax = GetSafeData.ValidateDataRow_String(data, "isTax"); model.SellArea = GetSafeData.ValidateDataRow_String(data, "SellArea"); model.CountryID = GetSafeData.GetStringFromInt(data, "CountryID"); model.Province = GetSafeData.ValidateDataRow_String(data, "Province"); model.City = GetSafeData.ValidateDataRow_String(data, "City"); model.Post = GetSafeData.ValidateDataRow_String(data, "Post"); model.ContactName = GetSafeData.ValidateDataRow_String(data, "ContactName"); model.Tel = GetSafeData.ValidateDataRow_String(data, "Tel"); model.Fax = GetSafeData.ValidateDataRow_String(data, "Fax"); model.Mobile = GetSafeData.ValidateDataRow_String(data, "Mobile"); model.email = GetSafeData.ValidateDataRow_String(data, "email"); model.Addr = GetSafeData.ValidateDataRow_String(data, "Addr"); model.BillType = GetSafeData.ValidateDataRow_String(data, "BillType"); model.PayType = GetSafeData.GetStringFromInt(data, "PayType"); model.MoneyType = GetSafeData.GetStringFromInt(data, "MoneyType"); model.CurrencyType = GetSafeData.GetStringFromInt(data, "CurrencyType"); model.Remark = GetSafeData.ValidateDataRow_String(data, "Remark"); model.UsedStatus = GetSafeData.ValidateDataRow_String(data, "UsedStatus"); model.Creator = GetSafeData.GetStringFromInt(data, "Creator"); model.CreateDate = GetSafeData.GetStringFromDateTime(data, "CreateDate","yyyy-MM-dd"); model.ModifiedDate = GetSafeData.GetStringFromDateTime(data, "ModifiedDate","yyyy-MM-dd"); model.ModifiedUserID = GetSafeData.ValidateDataRow_String(data, "ModifiedUserID"); model.EmployeeName = GetSafeData.ValidateDataRow_String(data, "EmployeeName"); } return model; }
/// <summary> ///查询其他往来单位信息 /// </summary> /// <param name="model">查询条件</param> /// <returns></returns> public static DataTable SearchRectOtherCorpInfo(OtherCorpInfoModel model, int pageIndex, int pageCount, string OrderBy, ref int totalCount) { StringBuilder searchSql = new StringBuilder(); searchSql.AppendLine("SELECT a.ID "); searchSql.AppendLine(" ,a.CustNo "); searchSql.AppendLine(" ,a.CustName "); searchSql.AppendLine(" ,isnull(a.AreaID,'') as AreaID "); searchSql.AppendLine(" ,isnull(a.CompanyType,'')as CompanyType "); searchSql.AppendLine(" ,isnull(a.SaleroomY,0)as SaleroomY "); searchSql.AppendLine(" ,isnull(a.ProfitY,0)as ProfitY "); searchSql.AppendLine(" ,isnull(a.CapitalScale,0)as CapitalScale "); searchSql.AppendLine(" ,isnull(a.BusiNumber,'')as BusiNumber "); searchSql.AppendLine(" ,isnull(a.isTax,'') as isTax "); searchSql.AppendLine(" ,isnull(a.CountryID,'')as CountryID "); searchSql.AppendLine(" ,isnull(a.BillType,'')as BillType "); searchSql.AppendLine(" ,isnull(a.ContactName,'')as ContactName "); searchSql.AppendLine(" ,isnull(a.Tel,'')as Tel "); searchSql.AppendLine(" ,isnull(a.PayType,'') as PayType "); searchSql.AppendLine(" ,isnull(a.BigType,'') as BigType "); searchSql.AppendLine(" ,isnull(a.UsedStatus,'') as UsedStatus "); searchSql.AppendLine(" ,isnull(a.MoneyType,'')as MoneyType "); searchSql.AppendLine(" ,isnull(a.CurrencyType,'') as CurrencyType "); searchSql.AppendLine(" ,isnull(a.Creator,'') as Creator "); searchSql.AppendLine(" ,isnull(b.EmployeeName,'') as EmployeeName "); searchSql.AppendLine(" ,isnull(c.TypeName,'') as Area "); searchSql.AppendLine(" ,isnull(d.TypeName,'') as Pay "); searchSql.AppendLine(" ,isnull(e.TypeName,'') as Money "); searchSql.AppendLine(" , isnull( CONVERT(CHAR(10), a.CreateDate, 23),'') as CreateDate "); searchSql.AppendLine(" FROM [officedba].[OtherCorpInfo] as a "); searchSql.AppendLine("left join officedba.EmployeeInfo as b on a.Creator=b.ID and a.CompanyCD=b.CompanyCD "); searchSql.AppendLine("left join officedba.CodePublicType as c on a.AreaID=c.ID and a.CompanyCD=c.CompanyCD "); searchSql.AppendLine("left join officedba.CodePublicType as d on a.PayType=d.ID and a.CompanyCD=c.CompanyCD "); searchSql.AppendLine("left join officedba.CodePublicType as e on a.MoneyType=e.ID and a.CompanyCD=e.CompanyCD "); searchSql.AppendLine(" where a.CompanyCD=@CompanyCD "); //#endregion //定义查询的命令 SqlCommand comm = new SqlCommand(); ////公司代码 comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD)); //编号 if (!string.IsNullOrEmpty(model.CustNo)) { searchSql.AppendLine(" and a.CustNo LIKE @CustNo "); comm.Parameters.Add(SqlHelper.GetParameterFromString("@CustNo", "%" + model.CustNo + "%")); } //名称 if (!string.IsNullOrEmpty(model.CustName)) { searchSql.AppendLine(" AND a.CustName LIKE @CustName "); comm.Parameters.Add(SqlHelper.GetParameterFromString("@CustName", "%" + model.CustName + "%")); } if (!string.IsNullOrEmpty(model.BigType)) { searchSql.AppendLine(" AND a.BigType = @BigType "); comm.Parameters.Add(SqlHelper.GetParameterFromString("@BigType", model.BigType)); } if (!string.IsNullOrEmpty(model.AreaID)) { searchSql.AppendLine(" AND a.AreaID = @AreaID "); comm.Parameters.Add(SqlHelper.GetParameterFromString("@AreaID", model.AreaID)); } if (!string.IsNullOrEmpty(model.UsedStatus)) { searchSql.AppendLine(" AND a.UsedStatus = @UsedStatus "); comm.Parameters.Add(SqlHelper.GetParameterFromString("@UsedStatus", model.UsedStatus)); } if (!string.IsNullOrEmpty(model.isTax)) { searchSql.AppendLine(" AND a.isTax = @isTax "); comm.Parameters.Add(SqlHelper.GetParameterFromString("@isTax", model.isTax)); } //指定命令的SQL文 comm.CommandText = searchSql.ToString(); //执行查询 return SqlHelper.PagerWithCommand(comm, pageIndex, pageCount, OrderBy, ref totalCount); }
/// <summary> /// 添加其他往来单位 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool InsertOtherCorpInfo(OtherCorpInfoModel model) { //SQL拼写 StringBuilder sql = new StringBuilder(); sql.AppendLine("INSERT INTO [officedba].[OtherCorpInfo]"); sql.AppendLine(" (CompanyCD "); sql.AppendLine(" ,BigType "); sql.AppendLine(" ,CustNo "); sql.AppendLine(" ,CustName "); sql.AppendLine(" ,CorpNam "); sql.AppendLine(" ,PYShort "); sql.AppendLine(" ,CustNote "); sql.AppendLine(" ,AreaID "); sql.AppendLine(" ,CompanyType "); sql.AppendLine(" ,StaffCount "); sql.AppendLine(" ,SetupDate "); sql.AppendLine(" ,ArtiPerson "); sql.AppendLine(" ,SetupMoney "); sql.AppendLine(" ,SetupAddress "); sql.AppendLine(" ,CapitalScale "); sql.AppendLine(" ,SaleroomY "); sql.AppendLine(" ,ProfitY "); sql.AppendLine(" ,TaxCD "); sql.AppendLine(" ,BusiNumber "); sql.AppendLine(" ,isTax "); sql.AppendLine(" ,SellArea "); sql.AppendLine(" ,CountryID "); sql.AppendLine(" ,Province "); sql.AppendLine(" ,City "); sql.AppendLine(" ,Post "); sql.AppendLine(" ,ContactName "); sql.AppendLine(" ,Tel "); sql.AppendLine(" ,Fax "); sql.AppendLine(" ,Mobile "); sql.AppendLine(" ,email "); sql.AppendLine(" ,MoneyType "); sql.AppendLine(" ,Addr "); sql.AppendLine(" ,BillType "); sql.AppendLine(" ,PayType "); sql.AppendLine(" ,CurrencyType "); sql.AppendLine(" ,Remark "); sql.AppendLine(" ,UsedStatus "); sql.AppendLine(" ,Creator "); sql.AppendLine(" ,CreateDate "); sql.AppendLine(" ,ModifiedDate "); sql.AppendLine(" ,ModifiedUserID) "); sql.AppendLine(" VALUES "); sql.AppendLine(" (@CompanyCD "); sql.AppendLine(" ,@BigType "); sql.AppendLine(" ,@CustNo "); sql.AppendLine(" ,@CustName "); sql.AppendLine(" ,@CorpNam "); sql.AppendLine(" ,@PYShort "); sql.AppendLine(" ,@CustNote "); sql.AppendLine(" ,@AreaID "); sql.AppendLine(" ,@CompanyType "); sql.AppendLine(" ,@StaffCount "); sql.AppendLine(" ,@SetupDate "); sql.AppendLine(" ,@ArtiPerson "); sql.AppendLine(" ,@SetupMoney "); sql.AppendLine(" ,@SetupAddress "); sql.AppendLine(" ,@CapitalScale "); sql.AppendLine(" ,@SaleroomY "); sql.AppendLine(" ,@ProfitY "); sql.AppendLine(" ,@TaxCD "); sql.AppendLine(" ,@BusiNumber "); sql.AppendLine(" ,@isTax "); sql.AppendLine(" ,@SellArea "); sql.AppendLine(" ,@CountryID "); sql.AppendLine(" ,@Province "); sql.AppendLine(" ,@City "); sql.AppendLine(" ,@Post "); sql.AppendLine(" ,@ContactName "); sql.AppendLine(" ,@Tel "); sql.AppendLine(" ,@Fax "); sql.AppendLine(" ,@Mobile "); sql.AppendLine(" ,@email "); sql.AppendLine(" ,@MoneyType "); sql.AppendLine(" ,@Addr "); sql.AppendLine(" ,@BillType "); sql.AppendLine(" ,@PayType "); sql.AppendLine(" ,@CurrencyType "); sql.AppendLine(" ,@Remark "); sql.AppendLine(" ,@UsedStatus "); sql.AppendLine(" ,@Creator "); sql.AppendLine(" ,@CreateDate "); sql.AppendLine(" ,@ModifiedDate "); sql.AppendLine(" ,@ModifiedUserID) "); //定义更新基本信息的命令 SqlCommand comm = new SqlCommand(); //设置存储过程名 comm.CommandText = sql.ToString(); //设置保存的参数 SetSaveParameter(comm, model); //添加返回参数 comm.Parameters.Add(SqlHelper.GetOutputParameter("@OtherCorpInfoID", System.Data.SqlDbType.Int)); //执行登陆操作 bool isSucc = SqlHelper.ExecuteTransWithCommand(comm); //设置ID //执行插入并返回插入结果 return isSucc; }
/// <summary> /// 修改其他往来单位信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool UpdateOtherCorpInfo(OtherCorpInfoModel model) { #region SQL文拼写 StringBuilder sql = new StringBuilder(); sql.AppendLine("UPDATE officedba.OtherCorpInfo "); sql.AppendLine(" SET BigType = @BigType "); sql.AppendLine(" ,CustName = @CustName "); sql.AppendLine(" ,CorpNam = @CorpNam "); sql.AppendLine(" ,PYShort = @PYShort "); sql.AppendLine(" ,CustNote = @CustNote "); sql.AppendLine(" ,AreaID = @AreaID "); sql.AppendLine(" ,CompanyType = @CompanyType "); sql.AppendLine(" ,MoneyType = @MoneyType "); sql.AppendLine(" ,StaffCount = @StaffCount "); sql.AppendLine(" ,SetupDate = @SetupDate "); sql.AppendLine(" ,ArtiPerson = @ArtiPerson "); sql.AppendLine(" ,SetupMoney = @SetupMoney "); sql.AppendLine(" ,SetupAddress = @SetupAddress "); sql.AppendLine(" ,CapitalScale = @CapitalScale "); sql.AppendLine(" ,SaleroomY = @SaleroomY "); sql.AppendLine(" ,ProfitY = @ProfitY "); sql.AppendLine(" ,TaxCD = @TaxCD "); sql.AppendLine(" ,BusiNumber = @BusiNumber "); sql.AppendLine(" ,isTax = @isTax "); sql.AppendLine(" ,SellArea = @SellArea "); sql.AppendLine(" ,CountryID = @CountryID "); sql.AppendLine(" ,Province = @Province "); sql.AppendLine(" ,City = @City "); sql.AppendLine(" ,Post = @Post "); sql.AppendLine(" ,ContactName = @ContactName "); sql.AppendLine(" ,Tel = @Tel "); sql.AppendLine(" ,Fax = @Fax "); sql.AppendLine(" ,Mobile = @Mobile "); sql.AppendLine(" ,email = @email "); sql.AppendLine(" ,Addr = @Addr "); sql.AppendLine(" ,BillType = @BillType "); sql.AppendLine(" ,PayType = @PayType "); sql.AppendLine(" ,CurrencyType = @CurrencyType "); sql.AppendLine(" ,Remark = @Remark "); sql.AppendLine(" ,UsedStatus = @UsedStatus "); sql.AppendLine(" ,Creator = @Creator "); sql.AppendLine(" ,CreateDate = @CreateDate "); sql.AppendLine(" ,ModifiedDate = @ModifiedDate "); sql.AppendLine(" ,ModifiedUserID = @ModifiedUserID"); sql.AppendLine(" WHERE CompanyCD = @CompanyCD "); sql.AppendLine(" AND CustNo = @CustNo "); #endregion //定义更新基本信息的命令 SqlCommand comm = new SqlCommand(); comm.CommandText = sql.ToString(); SetSaveParameter(comm, model);//其他参数 //执行更新并设置更新结果 bool result = false; result = SqlHelper.ExecuteTransWithCommand(comm); return result; }
private static void SetSaveParameter(SqlCommand comm, OtherCorpInfoModel model) { comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD ", model.CompanyCD));// 公司代码 comm.Parameters.Add(SqlHelper.GetParameterFromString("@BigType", model.BigType));// 往来单位大类(1客户,2供应商,3竞争对手,4银行,5外协加? comm.Parameters.Add(SqlHelper.GetParameterFromString("@CustNo", model.CustNo));// 往来单位编号 comm.Parameters.Add(SqlHelper.GetParameterFromString("@CustName", model.CustName));// 往来单位名称 comm.Parameters.Add(SqlHelper.GetParameterFromString("@CorpNam", model.CorpNam));// 往来单位简称 comm.Parameters.Add(SqlHelper.GetParameterFromString("@PYShort", model.PYShort));// 往来单位拼音代码 comm.Parameters.Add(SqlHelper.GetParameterFromString("@CustNote", model.CustNote));// 往来单位简介 comm.Parameters.Add(SqlHelper.GetParameterFromString("@AreaID", model.AreaID));// 所在区域(对应分类代码表定义,(客户)区域) comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyType", model.CompanyType));// 单位性质 comm.Parameters.Add(SqlHelper.GetParameterFromString("@StaffCount", model.StaffCount));// 人员规模 comm.Parameters.Add(SqlHelper.GetParameterFromString("@SetupDate ", model.SetupDate));// 成立时间 comm.Parameters.Add(SqlHelper.GetParameterFromString("@ArtiPerson", model.ArtiPerson));// 法人代表 comm.Parameters.Add(SqlHelper.GetParameterFromString("@SetupMoney", model.SetupMoney));// 注册资本(万元) comm.Parameters.Add(SqlHelper.GetParameterFromString("@SetupAddress", model.SetupAddress));// 注册地址 comm.Parameters.Add(SqlHelper.GetParameterFromString("@CapitalScale", model.CapitalScale));// 资产规模(万元) comm.Parameters.Add(SqlHelper.GetParameterFromString("@SaleroomY", model.SaleroomY));// 年销售额(万元) comm.Parameters.Add(SqlHelper.GetParameterFromString("@ProfitY", model.ProfitY));// 年利润额(万元) comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaxCD ", model.TaxCD));// 税务登记号 comm.Parameters.Add(SqlHelper.GetParameterFromString("@BusiNumber", model.BusiNumber));// 营业执照号 comm.Parameters.Add(SqlHelper.GetParameterFromString("@isTax", model.isTax));// 是否为一般纳税人(0否,1是) comm.Parameters.Add(SqlHelper.GetParameterFromString("@SellArea", model.SellArea));// 经营范围 comm.Parameters.Add(SqlHelper.GetParameterFromString("@CountryID", model.CountryID));// 国家地区(对应分类代码表定义,(人事)国家地区) comm.Parameters.Add(SqlHelper.GetParameterFromString("@Province", model.Province));// 省 comm.Parameters.Add(SqlHelper.GetParameterFromString("@City", model.City));// 市(县) comm.Parameters.Add(SqlHelper.GetParameterFromString("@Post", model.Post));// 邮编 comm.Parameters.Add(SqlHelper.GetParameterFromString("@ContactName", model.ContactName));// 联系人 comm.Parameters.Add(SqlHelper.GetParameterFromString("@Tel", model.Tel));// 电话 comm.Parameters.Add(SqlHelper.GetParameterFromString("@Fax", model.Fax));// 传真 comm.Parameters.Add(SqlHelper.GetParameterFromString("@Mobile", model.Mobile));// 手机 comm.Parameters.Add(SqlHelper.GetParameterFromString("@email", model.email));// 邮件 comm.Parameters.Add(SqlHelper.GetParameterFromString("@Addr", model.Addr));// 地址 comm.Parameters.Add(SqlHelper.GetParameterFromString("@BillType", model.BillType));// 发票类型(1增值税发票,2普通地税,3普通国税,4收据) comm.Parameters.Add(SqlHelper.GetParameterFromString("@PayType", model.PayType));// 结算方式(对应分类代码表定义,(客户)结算方式) comm.Parameters.Add(SqlHelper.GetParameterFromString("@MoneyType", model.MoneyType));// 支付方式(对应分类代码表定义,(客户)支付方式) comm.Parameters.Add(SqlHelper.GetParameterFromString("@CurrencyType", model.CurrencyType));// 结算币种(财务)(对应币种代码表ID) comm.Parameters.Add(SqlHelper.GetParameterFromString("@Remark", model.Remark));// 备注 comm.Parameters.Add(SqlHelper.GetParameterFromString("@UsedStatus", model.UsedStatus));// 启用状态(0停用,1启用) comm.Parameters.Add(SqlHelper.GetParameterFromString("@Creator", model.Creator));// 建档人ID comm.Parameters.Add(SqlHelper.GetParameterFromString("@CreateDate", model.CreateDate));// 建档日期 comm.Parameters.Add(SqlHelper.GetParameterFromString("@ModifiedDate", model.ModifiedDate));// 最后更新日期 comm.Parameters.Add(SqlHelper.GetParameterFromString("@ModifiedUserID", model.ModifiedUserID));// 最后更新用户ID(对应操作用户表中的UserID) }
protected void Page_Load(object sender, EventArgs e) { BindSel(); BindArea(); BindPayType(); BindMoney(); BindCurrencyType(); if (!IsPostBack) { hidModuleID.Value = ConstUtil.Menu_OtherCorpInfo; txt_CreateDate.Text = Convert.ToString(DateTime.Now.ToShortDateString()); this.UserPrincipal.Text =((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeName; this.txtPrincipal.Value =Convert.ToString(((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID); string requestParam = Request.QueryString.ToString(); int firstIndex = requestParam.IndexOf("&"); //从列表过来时 if (firstIndex > 0) { //获取列表的查询条件 string searchCondition = requestParam.Substring(firstIndex); //去除参数 searchCondition = searchCondition.Replace("&ModuleID=" + ConstUtil.Menu_OtherCorpInfoAdd, string.Empty); //设置检索条件 hidSearchCondition.Value = searchCondition; //迁移页面 } if (Request["intOtherCorpInfoID"] != "" && Request["intOtherCorpInfoID"]!=null) { //通过参数个数来判断是否从菜单过来 OtherCorpInfoModel model=new OtherCorpInfoModel (); model = XBase.Business.Office.SupplyChain.OtherCorpInfoBus.GetOtherCorpById(int.Parse(Request["intOtherCorpInfoID"])); sel_BigType.Value= model.BigType ; txt_CustNo.Value =model.CustNo; txt_CustName.Text = model.CustName; txt_CorpNam.Value = model.CorpNam; txt_PYShort.Value = model.PYShort; txt_CustNote.Value = model.CustNote; sel_AreaID.SelectedValue = model.AreaID; txt_CompanyType.Value = model.CompanyType; txt_StaffCount.Text = model.StaffCount; txt_SetupDate.Value =model.SetupDate; txt_ArtiPerson.Value = model.ArtiPerson; txt_SetupMoney.Text = model.SetupMoney; txt_SetupAddress.Value = model.SetupAddress; txt_CapitalScale.Value = model.CapitalScale; txt_SaleroomY.Text = model.SaleroomY; txt_ProfitY.Text = model.ProfitY; txt_TaxCD.Value = model.TaxCD; txt_BusiNumber.Text = model.BusiNumber; txt_SellArea.Value = model.SellArea; sel_CountryID.SelectedValue = model.CountryID; txt_Province.Text = model.Province; txt_City.Value = model.City; txt_Post.Value = model.Post; txt_ContactName.Text = model.ContactName; txt_Tel.Text = model.Tel; txt_Fax.Value = model.Fax; txt_Mobile.Text = model.Mobile; txt_email.Text = model.email; txt_Addr.Value = model.Addr; sel_BillType.Value = model.BillType; sel_PayType.SelectedValue = model.PayType; sel_MoneyType.SelectedValue = model.MoneyType; sel_CurrencyType.SelectedValue = model.CurrencyType; txt_Remark.Text = model.Remark; sel_UsedStatus.Value = model.UsedStatus; txtPrincipal.Value = model.Creator; txt_CreateDate.Text = model.CreateDate; this.UserPrincipal.Text = model.EmployeeName; chk_isTax.Checked = model.isTax == "1" ? true : false; } else { } } }