protected void IbtnSubmit_Click(object sender, ImageClickEventArgs e) { //这里是判断验证码 try//验证验证码 { if (Session["valationNo"] == null || ImageCode.Text.ToUpper().Trim() != Session["valationNo"].ToString().ToUpper().Trim() || Session["valationNo"].ToString().Trim() == "") { Tz888.Common.MessageBox.Show(this.Page, "验证码错误!"); //this.imgLoding.Visible = false; return; } } catch { Tz888.Common.MessageBox.Show(this.Page, "未知错误!"); } //结束部分 //实体部分 this.imgLoding.Visible = true; Tz888.Model.Info.MainInfoModel mainInfoModel = new Tz888.Model.Info.MainInfoModel(); //创建主体信息实体 Tz888.Model.Info.MerchantInfoModel merchantInfoModel = new Tz888.Model.Info.MerchantInfoModel(); //创建招商信息实体 Tz888.Model.Info.InfoContactModel infoContactModel = new Tz888.Model.Info.InfoContactModel(); //创建信息联系方式主体 Tz888.Model.Info.ShortInfoModel shortInfoModel = new Tz888.Model.Info.ShortInfoModel(); //创建短信息实体 List <Tz888.Model.Common.IndustryModel> industryModels = new List <Tz888.Model.Common.IndustryModel>(); //融资行业实体列表 // List<Tz888.Model.Info.InfoContactManModel> infoContactManModels = new List<Tz888.Model.Info.InfoContactManModel>(); //联系人实体列表 List <Tz888.Model.Info.InfoResourceModel> infoResourceModels = new List <Tz888.Model.Info.InfoResourceModel>(); //招商信息资源信息实体 DateTime time_now = DateTime.Now; //注意这里是联系方式的重新添加 //infoContactModel = this.MerchantInfoAddressInfo1.InfoContact; industryModels = this.SelectIndustryControl1.IndustryModels; #region 招商信息实体赋值 merchantInfoModel.MerchantTypeID = rblMerchantType.SelectedValue; merchantInfoModel.CountryCode = ZoneSelectControl1.CountryID; merchantInfoModel.ProvinceID = ZoneSelectControl1.ProvinceID; merchantInfoModel.CityID = ZoneSelectControl1.CityID; merchantInfoModel.CountyID = ZoneSelectControl1.CountyID; //if (!string.IsNullOrEmpty(MerchantInfoAddressInfo1.Undertaker)) // merchantInfoModel.ReceiveOrganization = Tz888.Common.Utility.PageValidate.FiltrateHTMLTag(MerchantInfoAddressInfo1.Undertaker); for (int i = 0; cblCooperationDemandType.Items.Count > i; i++) { if (cblCooperationDemandType.Items[i].Selected) { merchantInfoModel.CooperationDemandType += cblCooperationDemandType.Items[i].Value + ","; } } merchantInfoModel.CapitalCurrency = this.ddlCapitalCurrency.SelectedValue; if (!string.IsNullOrEmpty(this.txtCapitalTotal.Text.Trim())) { merchantInfoModel.CapitalTotal = Convert.ToDecimal(this.txtCapitalTotal.Text.Trim()); } merchantInfoModel.MerchantCurrency = this.ddlMerchantCurrency.SelectedValue; merchantInfoModel.MerchantTotal = this.ddlMerchantTotal.SelectedValue; if (!string.IsNullOrEmpty(this.txtZoneAbout.Value.Trim())) { merchantInfoModel.ZoneAbout = Tz888.Common.Utility.PageValidate.TxtToHtml(this.txtZoneAbout.Value.Trim()); } //这里是2010-06-01新加的招商信息 if (!string.IsNullOrEmpty(this.txtZoneAboutBrief.Value.Trim())) { merchantInfoModel.ZoneAboutBrief = Tz888.Common.Utility.PageValidate.TxtToHtml(this.txtZoneAboutBrief.Value.Trim()); } if (!string.IsNullOrEmpty(this.txtBenefit.Value.Trim())) { merchantInfoModel.Benefit = Tz888.Common.Utility.PageValidate.TxtToHtml(this.txtBenefit.Value.Trim()); } if (!string.IsNullOrEmpty(this.txtEconomicIndicators.Value.Trim())) { merchantInfoModel.EconomicIndicators = Tz888.Common.Utility.PageValidate.TxtToHtml(this.txtEconomicIndicators.Value.Trim()); } if (!string.IsNullOrEmpty(this.txtInvestmentEnvironment.Value.Trim())) { merchantInfoModel.InvestmentEnvironment = Tz888.Common.Utility.PageValidate.TxtToHtml(this.txtInvestmentEnvironment.Value.Trim()); } if (!string.IsNullOrEmpty(this.txtProjectStatus.Value.Trim())) { merchantInfoModel.ProjectStatus = Tz888.Common.Utility.PageValidate.TxtToHtml(this.txtProjectStatus.Value.Trim()); } if (!string.IsNullOrEmpty(this.txtMarket.Value.Trim())) { merchantInfoModel.Market = Tz888.Common.Utility.PageValidate.TxtToHtml(this.txtMarket.Value.Trim()); } //结束处 foreach (Tz888.Model.Common.IndustryModel model in industryModels) { merchantInfoModel.IndustryClassList += model.IndustryBID + ","; } //2010-06-08以下是对信息完整度的统计 merchantInfoModel.InformationIntegrity = Tz888.BLL.Info.MarchantInfoBLL.CountInfoInte(merchantInfoModel, infoContactModel); #endregion if (!string.IsNullOrEmpty(this.txtMerchantTopic.Text.Trim())) { mainInfoModel.Title = Tz888.Common.Utility.PageValidate.FiltrateHTMLTag(this.txtMerchantTopic.Text.Trim()); } mainInfoModel.InfoCode = Tz888.BLL.Info.Common.CreateInfoCode("Merchant", industryModels[0].IndustryBID, this.ZoneSelectControl1.CountryID, DateTime.Now); mainInfoModel.publishT = time_now; mainInfoModel.Hit = 0; mainInfoModel.IsCore = true; //注意这里是添加主信息表与用户登陆表的通过用户名相联系 mainInfoModel.LoginName = Page.User.Identity.Name; mainInfoModel.InfoOriginRoleName = "0"; //用户角色 mainInfoModel.GradeID = "0"; mainInfoModel.FixPriceID = "1"; mainInfoModel.FeeStatus = 0; string keyword = ""; if (!string.IsNullOrEmpty(this.txtKeyword1.Text.Trim())) { keyword += this.txtKeyword1.Text.Trim() + ","; } if (!string.IsNullOrEmpty(this.txtKeyword2.Text.Trim())) { keyword += this.txtKeyword2.Text.Trim() + ","; } if (!string.IsNullOrEmpty(this.txtKeyword3.Text.Trim())) { keyword += this.txtKeyword3.Text.Trim() + ","; } if (!string.IsNullOrEmpty(keyword)) { mainInfoModel.KeyWord = Tz888.Common.Utility.PageValidate.FiltrateHTMLTag(keyword); } mainInfoModel.Descript = ""; if (!string.IsNullOrEmpty(this.txtMerchantTopic.Text.Trim())) { mainInfoModel.DisplayTitle = Tz888.Common.Utility.PageValidate.FiltrateHTMLTag(this.txtMerchantTopic.Text.Trim()); } mainInfoModel.FrontDisplayTime = time_now; mainInfoModel.ValidateStartTime = time_now; mainInfoModel.ValidateTerm = Convert.ToInt32(this.rdlValiditeTerm.SelectedValue.Trim()); mainInfoModel.TemplateID = "001"; mainInfoModel.HtmlFile = ""; shortInfoModel.ShortInfoControlID = "MerchantIndex1"; if (!string.IsNullOrEmpty(this.txtMerchantTopic.Text.Trim())) { shortInfoModel.ShortTitle = Tz888.Common.Utility.PageValidate.FiltrateHTMLTag(this.txtMerchantTopic.Text.Trim()); } shortInfoModel.ShortContent = ""; shortInfoModel.Remark = ""; //将已上传的图片从临时目录迁移到正式目录 //infoResourceModels = Tz888.Common.InfoResourceManage.ImageTransfer("Image", "Merchant", Tz888.Common.ResourceType.Image, Tz888.Common.ResourceProperty.InfoImage, FilesUploadControl1.InfoList); infoResourceModels = FilesUploadControl1.InfoList; //联系方式赋值 infoContactModel.OrganizationName = this.txtCompanyName.Text; infoContactModel.Name = this.txtName.Text; infoContactModel.Position = this.txtPosition.Text; infoContactModel.TelCountryCode = this.txtTelCountry.Text; infoContactModel.TelStateCode = this.txtTelZoneCode.Text; infoContactModel.TelNum = this.txtTelNumber.Text; infoContactModel.Mobile = this.txtMobile.Text; infoContactModel.Email = this.txtEmail.Text; infoContactModel.Address = this.txtAddress.Text; Tz888.BLL.Info.MarchantInfoBLL marchantObj = new Tz888.BLL.Info.MarchantInfoBLL(); //插入数据 long infoID = marchantObj.Insert(mainInfoModel, merchantInfoModel, infoContactModel, shortInfoModel, infoResourceModels); if (infoID > 0) { bool isTof = Page.User.IsInRole("GT1002"); if (isTof) { string HtmlFile = Tz888.BLL.Info.Common.createStaticPageFileName("Merchant", mainInfoModel.InfoCode, infoID); Tz888.BLL.Info.MainInfoBLL mainBll = new Tz888.BLL.Info.MainInfoBLL(); mainBll.HasHtmlFile(infoID, HtmlFile); string actionMsg = ""; Tz888.BLL.PageStatic.MerchantPageStatic staticobj = new Tz888.BLL.PageStatic.MerchantPageStatic(); staticobj.CreateStaticPageMerchant(infoID.ToString(), ref actionMsg); } Session["valationNo"] = null; Response.Redirect("PublishMerchant3.aspx?code=" + Tz888.Common.DEncrypt.DESEncrypt.Encrypt(infoID.ToString() + "|Merchant|" + this.txtMerchantTopic.Text.Trim())); } else { Tz888.Common.MessageBox.Show(this.Page, "发布失败!"); } }
/// <summary> /// 添加招商资源信息 /// </summary> /// <param name="mainInfoModel">资源信息主体</param> /// <param name="merchantInfoModel">招商资源个性信息</param> /// <param name="infoContactModel">资源联系信息</param> /// <param name="shortInfoModel">资源短信息</param> /// <param name="infoContactManModels">多联系人列表</param> /// <returns>招商资源ID</returns> public long Insert( Tz888.Model.Info.MainInfoModel mainInfoModel, Tz888.Model.Info.MerchantInfoModel merchantInfoModel, Tz888.Model.Info.InfoContactModel infoContactModel, Tz888.Model.Info.ShortInfoModel shortInfoModel, // List<Tz888.Model.Info.InfoContactManModel> infoContactManModels, List <Tz888.Model.Info.InfoResourceModel> infoResourceModels ) { SqlParameter[] parameters = { //---------------------资源信息主体---------------------- new SqlParameter("@InfoID", SqlDbType.BigInt, 8), new SqlParameter("@Title", SqlDbType.VarChar, 100), new SqlParameter("@InfoCode", SqlDbType.Char, 30), new SqlParameter("@publishT", SqlDbType.DateTime), new SqlParameter("@Hit", SqlDbType.BigInt, 8), new SqlParameter("@IsCore", SqlDbType.Bit, 1), new SqlParameter("@IndexOrderNum", SqlDbType.BigInt, 8), new SqlParameter("@IndexTopValidateDate", SqlDbType.Int, 4), new SqlParameter("@IndexPicInfoNum", SqlDbType.BigInt, 8), new SqlParameter("@InfoTypeOrderNum", SqlDbType.BigInt, 8), new SqlParameter("@InfoTypeTopValidateDate", SqlDbType.Int, 4), new SqlParameter("@InfoTypePicInfoNum", SqlDbType.BigInt, 8), new SqlParameter("@LoginName", SqlDbType.Char, 16), new SqlParameter("@InfoOriginRoleName", SqlDbType.Char, 10), new SqlParameter("@GradeID", SqlDbType.Char, 10), new SqlParameter("@FixPriceID", SqlDbType.Char, 10), new SqlParameter("@FeeStatus", SqlDbType.TinyInt, 1), new SqlParameter("@KeyWord", SqlDbType.VarChar, 50), new SqlParameter("@Descript", SqlDbType.VarChar, 100), new SqlParameter("@DisplayTitle", SqlDbType.VarChar, 50), new SqlParameter("@FrontDisplayTime", SqlDbType.SmallDateTime), new SqlParameter("@ValidateStartTime", SqlDbType.SmallDateTime), new SqlParameter("@ValidateTerm", SqlDbType.Int, 4), new SqlParameter("@TemplateID", SqlDbType.Char, 10), new SqlParameter("@HtmlFile", SqlDbType.VarChar, 100), //---------------------------END--------------------------- //--------------------招商资源个性信息--------------------- new SqlParameter("@MerchantTypeID", SqlDbType.Char, 10), new SqlParameter("@IndustryClassList", SqlDbType.VarChar, 150), new SqlParameter("@CapitalCurrency", SqlDbType.Char, 10), new SqlParameter("@CapitalTotal", SqlDbType.Float, 8), new SqlParameter("@MerchantCurrency", SqlDbType.Char, 10), new SqlParameter("@MerchantTotal", SqlDbType.Char, 10), new SqlParameter("@CooperationDemandType", SqlDbType.VarChar, 30), new SqlParameter("@CountryCode", SqlDbType.Char, 10), new SqlParameter("@ProvinceID", SqlDbType.Char, 10), new SqlParameter("@CityID", SqlDbType.Char, 10), new SqlParameter("@CountyID", SqlDbType.Char, 10), new SqlParameter("@ZoneAbout", SqlDbType.VarChar, -1), new SqlParameter("@ZoneAboutBrief", SqlDbType.VarChar, -1), new SqlParameter("@ReceiveOrganization", SqlDbType.VarChar, 100), new SqlParameter("@MerchantOrganization", SqlDbType.Int, 4), //---------------------------END--------------------------- //-----------------------资源联系信息-------------------------- new SqlParameter("@Organization", SqlDbType.VarChar, 40), new SqlParameter("@LinkMan", SqlDbType.VarChar, 20), new SqlParameter("@TelCountryCode", SqlDbType.Char, 3), new SqlParameter("@TelStateCode", SqlDbType.Char, 4), new SqlParameter("@TelNum", SqlDbType.VarChar, 60), new SqlParameter("@FaxCountryCode", SqlDbType.Char, 3), new SqlParameter("@FaxStateCode", SqlDbType.Char, 4), new SqlParameter("@FaxNum", SqlDbType.VarChar, 60), new SqlParameter("@Mobile", SqlDbType.VarChar, 30), new SqlParameter("@Address", SqlDbType.VarChar, 100), new SqlParameter("@PostCode", SqlDbType.VarChar, 10), new SqlParameter("@Email", SqlDbType.VarChar, 50), new SqlParameter("@WebSite", SqlDbType.VarChar, 200), //---------------------------END--------------------------- //-------------------------短信息-------------------------- new SqlParameter("@ShortInfoControlID", SqlDbType.Char, 20), new SqlParameter("@ShortTitle", SqlDbType.VarChar, 100), new SqlParameter("@ShortContent", SqlDbType.VarChar, 100), new SqlParameter("@strRemark", SqlDbType.VarChar, 50), //这里是2010-06-01 添加政府招商的参数 有5个参数 new SqlParameter("@EconomicIndicators", SqlDbType.NVarChar, 100), new SqlParameter("@InvestmentEnvironment", SqlDbType.NVarChar, 100), new SqlParameter("@ProjectStatus", SqlDbType.NVarChar, 100), new SqlParameter("@Market", SqlDbType.NVarChar, 100), new SqlParameter("@Benefit", SqlDbType.NVarChar, 100), //新添加结束处 //这里是2010-06-02添加政府招商联系信息的参数 new SqlParameter("@Position", SqlDbType.VarChar, 50), //这里是2010-06-08添加信息完整度 new SqlParameter("@InformationIntegrity", SqlDbType.Int, 8), new SqlParameter("@Merchanreturns", SqlDbType.Int, 8) //---------------------------END--------------------------- }; //---------------------资源信息主体参数---------------------- parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = mainInfoModel.Title; parameters[2].Value = mainInfoModel.InfoCode; parameters[3].Value = mainInfoModel.publishT; parameters[4].Value = mainInfoModel.Hit; parameters[5].Value = mainInfoModel.IsCore; parameters[6].Value = mainInfoModel.IndexOrderNum; parameters[7].Value = mainInfoModel.IndexTopValidateDate; parameters[8].Value = mainInfoModel.IndexPicInfoNum; parameters[9].Value = mainInfoModel.InfoTypeOrderNum; parameters[10].Value = mainInfoModel.InfoTypeTopValidateDate; parameters[11].Value = mainInfoModel.InfoTypePicInfoNum; parameters[12].Value = mainInfoModel.LoginName; parameters[13].Value = mainInfoModel.InfoOriginRoleName; parameters[14].Value = mainInfoModel.GradeID; parameters[15].Value = mainInfoModel.FixPriceID; parameters[16].Value = mainInfoModel.FeeStatus; parameters[17].Value = mainInfoModel.KeyWord; parameters[18].Value = mainInfoModel.Descript; parameters[19].Value = mainInfoModel.DisplayTitle; parameters[20].Value = mainInfoModel.FrontDisplayTime; parameters[21].Value = mainInfoModel.ValidateStartTime; parameters[22].Value = mainInfoModel.ValidateTerm; parameters[23].Value = mainInfoModel.TemplateID; parameters[24].Value = mainInfoModel.HtmlFile; //End parameters[25].Value = merchantInfoModel.MerchantTypeID; parameters[26].Value = merchantInfoModel.IndustryClassList; parameters[27].Value = merchantInfoModel.CapitalCurrency; parameters[28].Value = merchantInfoModel.CapitalTotal; parameters[29].Value = merchantInfoModel.MerchantCurrency; parameters[30].Value = merchantInfoModel.MerchantTotal; parameters[31].Value = merchantInfoModel.CooperationDemandType; parameters[32].Value = merchantInfoModel.CountryCode; parameters[33].Value = merchantInfoModel.ProvinceID; parameters[34].Value = merchantInfoModel.CityID; parameters[35].Value = merchantInfoModel.CountyID; parameters[36].Value = merchantInfoModel.ZoneAbout; parameters[37].Value = merchantInfoModel.ZoneAboutBrief; parameters[38].Value = merchantInfoModel.ReceiveOrganization; parameters[39].Value = merchantInfoModel.MerchantOrganization; //2010-06-01以下是根据需求添加的 parameters[57].Value = merchantInfoModel.EconomicIndicators; parameters[58].Value = merchantInfoModel.InvestmentEnvironment; parameters[59].Value = merchantInfoModel.ProjectStatus; parameters[60].Value = merchantInfoModel.Market; parameters[61].Value = merchantInfoModel.Benefit; //添加信息完整度 parameters[63].Value = merchantInfoModel.InformationIntegrity; //End parameters[40].Value = infoContactModel.OrganizationName; parameters[41].Value = infoContactModel.Name; parameters[42].Value = infoContactModel.TelCountryCode; parameters[43].Value = infoContactModel.TelStateCode; parameters[44].Value = infoContactModel.TelNum; parameters[45].Value = infoContactModel.FaxCountryCode; parameters[46].Value = infoContactModel.FaxStateCode; parameters[47].Value = infoContactModel.FaxNum; parameters[48].Value = infoContactModel.Mobile; parameters[49].Value = infoContactModel.Address; parameters[50].Value = infoContactModel.PostCode; parameters[51].Value = infoContactModel.Email; parameters[52].Value = infoContactModel.WebSite; //2010-06-02以下是招商联系人职位 parameters[62].Value = infoContactModel.Position; //end parameters[53].Value = shortInfoModel.ShortInfoControlID; parameters[54].Value = shortInfoModel.ShortTitle; parameters[55].Value = shortInfoModel.ShortContent; parameters[56].Value = shortInfoModel.Remark; parameters[64].Value = merchantInfoModel.Merchanreturns; int rowsAffected; long infoID; using (SqlConnection sqlConn = DbHelperSQL.GetSqlConnection()) { sqlConn.Open(); SqlTransaction sqlTran = sqlConn.BeginTransaction(); try { //插入招商资源信息插如方法 DbHelperSQL.RunProcedure(sqlConn, sqlTran, SP_MarchantInfo_Insert, parameters, out rowsAffected); infoID = (long)parameters[0].Value; if (infoID < 0) { throw new Exception(); } //注释掉多个联系人 //if (infoContactManModels != null) //{ // //为招商资源添加多个联系人 // Tz888.SQLServerDAL.Info.InfoContactManDAL obj1 = new InfoContactManDAL(); // foreach (Tz888.Model.Info.InfoContactManModel model in infoContactManModels) // { // model.InfoID = infoID; // obj1.InsertContactMan(sqlConn, sqlTran, model); // } //} if (infoResourceModels != null) { //为招商信息添加多个资源 Tz888.SQLServerDAL.Info.InfoResourceDAL obj2 = new InfoResourceDAL(); foreach (Tz888.Model.Info.InfoResourceModel model in infoResourceModels) { model.InfoID = infoID; obj2.InsertInfoResource(sqlConn, sqlTran, model); } } sqlTran.Commit(); } catch { sqlTran.Rollback(); infoID = -1; } finally { sqlConn.Close(); } } return(infoID); }
/// <summary> /// 得到一个对象实体 /// </summary> public Tz888.Model.Info.MerchantInfoModel GetModel(long InfoID) { SqlParameter[] parameters = { new SqlParameter("@InfoID", SqlDbType.BigInt, 8) }; parameters[0].Value = InfoID; Tz888.Model.Info.MerchantInfoModel model = new Tz888.Model.Info.MerchantInfoModel(); DataSet ds = DbHelperSQL.RunProcedure("MerchantInfoTab_GetModel", parameters, "ds"); model.InfoID = InfoID; if (ds.Tables[0].Rows.Count > 0) { model.MerchantTypeID = ds.Tables[0].Rows[0]["MerchantTypeID"].ToString(); model.VipAbout = ds.Tables[0].Rows[0]["VipAbout"].ToString(); model.MerchantTypeName = ds.Tables[0].Rows[0]["MerchantAttributeName"].ToString(); model.IndustryClassList = ds.Tables[0].Rows[0]["IndustryClassList"].ToString(); model.CapitalCurrency = ds.Tables[0].Rows[0]["CapitalCurrency"].ToString(); if (ds.Tables[0].Rows[0]["CapitalTotal"].ToString() != "") { model.CapitalTotal = decimal.Parse(ds.Tables[0].Rows[0]["CapitalTotal"].ToString()); } if (ds.Tables[0].Rows[0]["Merchanreturns"].ToString() != "") { model.Merchanreturns = Convert.ToInt32(ds.Tables[0].Rows[0]["Merchanreturns"].ToString()); } //2010-06-11新增 model.Market = ds.Tables[0].Rows[0]["Market"].ToString(); model.EconomicIndicators = ds.Tables[0].Rows[0]["EconomicIndicators"].ToString(); model.InvestmentEnvironment = ds.Tables[0].Rows[0]["InvestmentEnvironment"].ToString(); model.ProjectStatus = ds.Tables[0].Rows[0]["ProjectStatus"].ToString(); model.Benefit = ds.Tables[0].Rows[0]["Benefit"].ToString(); model.InformationIntegrity = 0; if (ds.Tables[0].Rows[0]["InformationIntegrity"].ToString() != "") { model.InformationIntegrity = Convert.ToInt32(ds.Tables[0].Rows[0]["InformationIntegrity"]); } //end model.MerchantCurrency = ds.Tables[0].Rows[0]["MerchantCurrency"].ToString(); model.MerchantTotal = ds.Tables[0].Rows[0]["MerchantTotal"].ToString(); model.CooperationDemandType = ds.Tables[0].Rows[0]["CooperationDemandType"].ToString(); model.CountryCode = ds.Tables[0].Rows[0]["CountryCode"].ToString(); model.ProvinceID = ds.Tables[0].Rows[0]["ProvinceID"].ToString(); model.CityID = ds.Tables[0].Rows[0]["CityID"].ToString(); model.CountyID = ds.Tables[0].Rows[0]["CountyID"].ToString(); model.ZoneAbout = ds.Tables[0].Rows[0]["ZoneAbout"].ToString(); model.ZoneAboutBrief = ds.Tables[0].Rows[0]["ZoneAboutBrief"].ToString(); model.ReceiveOrganization = ds.Tables[0].Rows[0]["ReceiveOrganization"].ToString(); if (ds.Tables[0].Rows[0]["MerchantOrganization"].ToString() != "") { model.MerchantOrganization = int.Parse(ds.Tables[0].Rows[0]["MerchantOrganization"].ToString()); } model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString(); List <string> lstIndustryBName = new List <string>(); for (int i = 0; i < ds.Tables[1].Rows.Count; i++) { string sIndustryNameTemp = ds.Tables[1].Rows[i]["IndustryBName"].ToString().Trim(); string sIndustryIDTemp = ds.Tables[1].Rows[i]["IndustryBID"].ToString().Trim(); if (model.IndustryClassList.IndexOf(sIndustryIDTemp) != -1) { lstIndustryBName.Add(sIndustryNameTemp); } } model.IndustryBName = lstIndustryBName; List <string> lstCooperationDemandTypeName = new List <string>(); for (int i = 0; i < ds.Tables[2].Rows.Count; i++) { string sCooperationDemandTypeNameTemp = ds.Tables[2].Rows[i]["CooperationDemandName"].ToString().Trim(); string sCooperationDemandTypeIDTemp = ds.Tables[2].Rows[i]["CooperationDemandTypeID"].ToString().Trim(); if (model.CooperationDemandType.Trim().IndexOf(sCooperationDemandTypeIDTemp.Trim()) != -1) { lstCooperationDemandTypeName.Add(sCooperationDemandTypeNameTemp); } } model.CooperationDemandTypeName = lstCooperationDemandTypeName; if (ds.Tables[3] != null && ds.Tables[3].Rows.Count > 0) { model.CountryName = ds.Tables[3].Rows[0]["CountryName"].ToString(); } if (ds.Tables[4] != null && ds.Tables[4].Rows.Count > 0) { model.ProvinceName = ds.Tables[4].Rows[0]["ProvinceName"].ToString(); } if (ds.Tables[5] != null && ds.Tables[5].Rows.Count > 0) { model.CityName = ds.Tables[5].Rows[0]["CityName"].ToString(); } if (ds.Tables[6] != null && ds.Tables[6].Rows.Count > 0) { model.CountyName = ds.Tables[6].Rows[0]["CountyName"].ToString(); } if (ds.Tables[7] != null && ds.Tables[7].Rows.Count > 0) { model.Merchanttotalname = ds.Tables[7].Rows[0]["CapitalName"].ToString(); } return(model); } else { return(null); } }
protected void btnUpdate_Click(object sender, EventArgs e) { //结束部分 //实体部分 // this.imgLoding.Visible = true; Tz888.Model.Info.MainInfoModel mainInfoModel = new Tz888.Model.Info.MainInfoModel(); //创建主体信息实体 Tz888.Model.Info.MerchantInfoModel merchantInfoModel = new Tz888.Model.Info.MerchantInfoModel(); //创建招商信息实体 Tz888.Model.Info.InfoContactModel infoContactModel = new Tz888.Model.Info.InfoContactModel(); //创建信息联系方式主体 Tz888.Model.Info.ShortInfoModel shortInfoModel = new Tz888.Model.Info.ShortInfoModel(); //创建短信息实体 List <Tz888.Model.Common.IndustryModel> industryModels = new List <Tz888.Model.Common.IndustryModel>(); //融资行业实体列表 List <Tz888.Model.Info.InfoContactManModel> infoContactManModels = new List <Tz888.Model.Info.InfoContactManModel>(); //联系人实体列表 List <Tz888.Model.Info.InfoResourceModel> infoResourceModels = new List <Tz888.Model.Info.InfoResourceModel>(); //招商信息资源信息实体 DateTime time_now = DateTime.Now; industryModels = this.SelectIndustryControl1.IndustryModels; //这里是多个联系方式的添加 #region 招商信息实体赋值 merchantInfoModel.MerchantTypeID = "";// rblMerchantType.SelectedValue; merchantInfoModel.CountryCode = ZoneSelectControl1.CountryID; merchantInfoModel.ProvinceID = ZoneSelectControl1.ProvinceID; merchantInfoModel.CityID = ZoneSelectControl1.CityID; merchantInfoModel.CountyID = ZoneSelectControl1.CountyID; //联系方式赋值 infoContactModel.OrganizationName = this.txtCompanyName.Text; infoContactModel.Name = this.txtName.Text; infoContactModel.Position = "";// this.txtPosition.Text; infoContactModel.TelCountryCode = this.txtTelCountry.Text; infoContactModel.TelStateCode = this.txtTelZoneCode.Text; infoContactModel.TelNum = this.txtTelNumber.Text; infoContactModel.Mobile = this.txtMobile.Text; infoContactModel.Email = this.txtEmail.Text; infoContactModel.Address = this.txtAddress.Text; merchantInfoModel.CooperationDemandType = ""; merchantInfoModel.CapitalCurrency = this.ddlCapitalCurrency.SelectedValue; if (!string.IsNullOrEmpty(this.txtCapitalTotal.Text.Trim())) { merchantInfoModel.CapitalTotal = Convert.ToDecimal(this.txtCapitalTotal.Text.Trim()); } merchantInfoModel.MerchantCurrency = ""; // this.ddlMerchantCurrency.SelectedValue; merchantInfoModel.MerchantTotal = ""; // this.ddlMerchantTotal.SelectedValue; if (!string.IsNullOrEmpty(this.txtZoneAbout.Value.Trim())) { merchantInfoModel.ZoneAbout = Tz888.Common.Utility.PageValidate.TxtToHtml(this.txtZoneAbout.Value.Trim()); } //这里是2010-06-01新加的招商信息 //if (!string.IsNullOrEmpty(this.txtZoneAboutBrief.Value.Trim())) merchantInfoModel.ZoneAboutBrief = Tz888.Common.Utility.PageValidate.TxtToHtml(""); // if (!string.IsNullOrEmpty(this.txtBenefit.Value.Trim())) merchantInfoModel.Benefit = Tz888.Common.Utility.PageValidate.TxtToHtml(""); // if (!string.IsNullOrEmpty(this.txtEconomicIndicators.Value.Trim())) merchantInfoModel.EconomicIndicators = Tz888.Common.Utility.PageValidate.TxtToHtml(""); //if (!string.IsNullOrEmpty(this.txtInvestmentEnvironment.Value.Trim())) merchantInfoModel.InvestmentEnvironment = Tz888.Common.Utility.PageValidate.TxtToHtml(""); //if (!string.IsNullOrEmpty(this.txtProjectStatus.Value.Trim())) merchantInfoModel.ProjectStatus = Tz888.Common.Utility.PageValidate.TxtToHtml(""); // if (!string.IsNullOrEmpty(this.txtMarket.Value.Trim())) merchantInfoModel.Market = Tz888.Common.Utility.PageValidate.TxtToHtml(""); //merchantInfoModel.Merchanreturns = Convert.ToInt32(this.txtHuiBao.Text.Trim());//回报率 if (txtHuiBao.Text.ToString().Trim() == "") { merchantInfoModel.Merchanreturns = 0; } else { merchantInfoModel.Merchanreturns = Convert.ToInt32(this.txtHuiBao.Text.Trim()); } //结束处 foreach (Tz888.Model.Common.IndustryModel model in industryModels) { merchantInfoModel.IndustryClassList += model.IndustryBID + ","; } //2010-06-08以下是对信息完整度的统计 merchantInfoModel.InformationIntegrity = Tz888.BLL.Info.MarchantInfoBLL.CountInfoInte(merchantInfoModel, infoContactModel); #endregion if (!string.IsNullOrEmpty(this.txtMerchantTopic.Text.Trim())) { mainInfoModel.Title = Tz888.Common.Utility.PageValidate.FiltrateHTMLTag(this.txtMerchantTopic.Text.Trim()); } mainInfoModel.InfoCode = Tz888.BLL.Info.Common.CreateInfoCode("Merchant", industryModels[0].IndustryBID, this.ZoneSelectControl1.CountryID, DateTime.Now); mainInfoModel.publishT = time_now; mainInfoModel.Hit = Convert.ToInt32(tbHits.Text.Trim()); mainInfoModel.IsCore = true; //注意这里是添加主信息表与用户登陆表的通过用户名相联系 //mainInfoModel.LoginName = "111111"; mainInfoModel.LoginName = bp.LoginName; mainInfoModel.InfoOriginRoleName = "0"; //用户角色 mainInfoModel.GradeID = "0"; if (chkIsPoint.Checked == true) { mainInfoModel.FixPriceID = "2"; mainInfoModel.MainPointCount = Convert.ToInt32(txtPointCount.Text.Trim()); } else { mainInfoModel.MainPointCount = 0; mainInfoModel.FixPriceID = "1"; } mainInfoModel.FeeStatus = 0; mainInfoModel.KeyWord = Tz888.Common.Utility.PageValidate.FiltrateHTMLTag(this.txtMerchantTopic.Text.Trim()); mainInfoModel.Descript = Tz888.Common.Utility.PageValidate.FiltrateHTMLTag(this.txtMerchantTopic.Text.Trim()); if (!string.IsNullOrEmpty(this.txtMerchantTopic.Text.Trim())) { mainInfoModel.DisplayTitle = Tz888.Common.Utility.PageValidate.FiltrateHTMLTag(this.txtMerchantTopic.Text.Trim()); } mainInfoModel.FrontDisplayTime = time_now; mainInfoModel.ValidateStartTime = time_now; mainInfoModel.ValidateTerm = Convert.ToInt32(this.rdlValiditeTerm.SelectedValue.Trim()); mainInfoModel.TemplateID = "001"; byte AuditingStatus = 0; if (rdAudit.Checked == true) { AuditingStatus = 0; } if (rdPass.Checked == true) { AuditingStatus = 1; } if (rdNopass.Checked == true) { AuditingStatus = 2; } mainInfoModel.AuditingStatus = AuditingStatus; mainInfoModel.HtmlFile = Tz888.Common.Utility.PageValidate.TxtToHtml(""); shortInfoModel.ShortInfoControlID = "MerchantIndex1"; if (!string.IsNullOrEmpty(this.txtMerchantTopic.Text.Trim())) { shortInfoModel.ShortTitle = Tz888.Common.Utility.PageValidate.FiltrateHTMLTag(this.txtMerchantTopic.Text.Trim()); } shortInfoModel.ShortContent = ""; shortInfoModel.Remark = ""; //将已上传的图片从临时目录迁移到正式目录 //infoResourceModels = Tz888.Common.InfoResourceManage.ImageTransfer("Image", "Merchant", Tz888.Common.ResourceType.Image, Tz888.Common.ResourceProperty.InfoImage, FilesUploadControl1.InfoList); infoResourceModels = FilesUploadControl1.InfoList; Tz888.BLL.Info.MarchantInfoBLL marchantObj = new Tz888.BLL.Info.MarchantInfoBLL(); //插入数据 long infoID = marchantObj.Insert(mainInfoModel, merchantInfoModel, infoContactModel, shortInfoModel, infoResourceModels); if (infoID > 0) { if (rdPass.Checked == true) { Tz888.Model.Info.MerchantSetModel model = new Tz888.Model.Info.MerchantSetModel(); string url = "Merchant/" + DateTime.Now.ToString("yyyyMM") + "/Merchant" + DateTime.Now.ToString("yyyyMMdd") + "_" + infoID + ".shtml"; merstatic.UpdateUrl(url, infoID); page = page.objGetMerchantInfoByInfoID(infoID); //根ID获取信息 string IsVip = Mercahrstatic.SelIsVip(); //查询为重大商机的信息 string Idstuny = page.SelectLndus(ZoneSelectControl1.ProvinceID); //根据区域查询信息 int sum = page.StaticHtml(Convert.ToInt32(infoID), page.Title, page.PublishT, page.AreaName, page.Content, page.IndustryCarveOutID, page.MerchantNameTotal, page.ValidateID, Idstuny, IsVip, page.Title, page.Title, page.Title, page.Merchanreturns); } //招商重大投资商机设置 Tz888.BLL.MerchantOppor objOppor = new Tz888.BLL.MerchantOppor(); if (chkIsVip.Checked) { objOppor.IsVip(infoID, 1, txtIsVipAbout.Text.Trim()); } else { objOppor.IsVip(infoID, 0, ""); } Response.Redirect("MerchantManage.aspx"); } else { Tz888.Common.MessageBox.Show(this.Page, "发布失败!"); } }