/// <summary> /// 修改投资资源 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Update(Tz888.Model.Info.CapitalSetModel model) { SqlParameter[] parameters = { //主表信息 new SqlParameter("@InfoID", SqlDbType.BigInt, 8), new SqlParameter("@Title", SqlDbType.VarChar, 100), new SqlParameter("@publishT", SqlDbType.DateTime), new SqlParameter("@LoginName", SqlDbType.Char, 10), 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), new SqlParameter("@AuditingStatus", SqlDbType.TinyInt, 8), //投资资源表信息 new SqlParameter("@ComAbout", SqlDbType.VarChar, -1), new SqlParameter("@ComBreif", SqlDbType.VarChar, -1), new SqlParameter("@IndustryBID", SqlDbType.Char, 10), new SqlParameter("@CooperationDemandType", SqlDbType.Char, 30), new SqlParameter("@currency", SqlDbType.Char, 10), new SqlParameter("@CapitalID", SqlDbType.Char, 10), new SqlParameter("@CapitalTypeID", SqlDbType.Char, 10), //联系信息 new SqlParameter("@ComName", SqlDbType.VarChar, 100), new SqlParameter("@LinkMan", SqlDbType.VarChar, 20), new SqlParameter("@TelCountryCode", SqlDbType.Char, 6), new SqlParameter("@TelStateCode", SqlDbType.Char, 8), new SqlParameter("@TelNum", SqlDbType.VarChar, 100), new SqlParameter("@FaxCountryCode", SqlDbType.Char, 6), new SqlParameter("@FaxStateCode", SqlDbType.Char, 8), new SqlParameter("@FaxNum", SqlDbType.VarChar, 100), 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), //短信息 new SqlParameter("@ShortInfoControlID", SqlDbType.Char, 20), new SqlParameter("@ShortTitle", SqlDbType.VarChar, 100), new SqlParameter("@ShortContent", SqlDbType.VarChar, 100), new SqlParameter("@strRemark", SqlDbType.VarChar, 50), new SqlParameter("@IsVip", SqlDbType.Int), //投资资源表信息 2010-7-7修改 new SqlParameter("@RegisteredCapital", SqlDbType.Char, 30), new SqlParameter("@TeamScale", SqlDbType.Char, 30), new SqlParameter("@AverageInvestment", SqlDbType.Char, 30), new SqlParameter("@SuccessfulInvestment", SqlDbType.Char, 30), new SqlParameter("@InvestmentDemand", SqlDbType.VarChar, 100), new SqlParameter("@Prorganizers", SqlDbType.VarChar, 100), new SqlParameter("@CountryID", SqlDbType.Char, 30), new SqlParameter("@ProvinceID", SqlDbType.Char, 30), new SqlParameter("@CityID", SqlDbType.Char, 30), new SqlParameter("@CountyID", SqlDbType.Char, 30), new SqlParameter("@Position", SqlDbType.VarChar, 50) }; parameters[0].Value = model.MainInfoModel.InfoID; parameters[1].Value = model.MainInfoModel.Title; parameters[2].Value = model.MainInfoModel.publishT; parameters[3].Value = model.MainInfoModel.LoginName; parameters[4].Value = model.MainInfoModel.KeyWord; parameters[5].Value = model.MainInfoModel.Descript; parameters[6].Value = model.MainInfoModel.DisplayTitle; parameters[7].Value = model.MainInfoModel.FrontDisplayTime; parameters[8].Value = model.MainInfoModel.ValidateStartTime; parameters[9].Value = model.MainInfoModel.ValidateTerm; parameters[10].Value = model.MainInfoModel.TemplateID; //parameters[11].Value = model.MainInfoModel.HtmlFile; parameters[11].Value = model.MainInfoModel.AuditingStatus; parameters[12].Value = model.CapitalInfoModel.ComAbout; parameters[13].Value = model.CapitalInfoModel.ComBreif; parameters[14].Value = model.CapitalInfoModel.IndustryBID; parameters[15].Value = model.CapitalInfoModel.CooperationDemandType; parameters[16].Value = model.CapitalInfoModel.Currency; parameters[17].Value = model.CapitalInfoModel.CapitalID; parameters[18].Value = model.CapitalInfoModel.CapitalTypeID; parameters[19].Value = model.InfoContactModel.OrganizationName; parameters[20].Value = model.InfoContactModel.Name; parameters[21].Value = model.InfoContactModel.TelCountryCode; parameters[22].Value = model.InfoContactModel.TelStateCode; parameters[23].Value = model.InfoContactModel.TelNum; parameters[24].Value = model.InfoContactModel.FaxCountryCode; parameters[25].Value = model.InfoContactModel.FaxStateCode; parameters[26].Value = model.InfoContactModel.FaxNum; parameters[27].Value = model.InfoContactModel.Mobile; parameters[28].Value = model.InfoContactModel.Address; parameters[29].Value = model.InfoContactModel.PostCode; parameters[30].Value = model.InfoContactModel.Email; parameters[31].Value = model.InfoContactModel.WebSite; parameters[32].Value = model.ShortInfoModel.ShortInfoControlID; parameters[33].Value = model.ShortInfoModel.ShortTitle; parameters[34].Value = model.ShortInfoModel.ShortContent; parameters[35].Value = model.ShortInfoModel.Remark; parameters[36].Value = model.CapitalInfoModel.IsVip; parameters[37].Value = model.CapitalInfoModel.RegisteredCapital; parameters[38].Value = model.CapitalInfoModel.TeamScale; parameters[39].Value = model.CapitalInfoModel.AverageInvestment; parameters[40].Value = model.CapitalInfoModel.SuccessfulInvestment; parameters[41].Value = model.CapitalInfoModel.InvestmentDemand; parameters[42].Value = model.CapitalInfoModel.Prorganizers; parameters[43].Value = model.CapitalInfoModel.SCountryID; parameters[44].Value = model.CapitalInfoModel.SProvinceID; parameters[45].Value = model.CapitalInfoModel.SCityID; parameters[46].Value = model.CapitalInfoModel.SCountyID; parameters[47].Value = model.InfoContactModel.Position; bool ReturnValue = false; long infoID = model.MainInfoModel.InfoID; using (SqlConnection sqlConn = DbHelperSQL.GetSqlConnection()) { sqlConn.Open(); SqlTransaction sqlTran = sqlConn.BeginTransaction(); try { int rowsAffected; //插入投资资源信息 DbHelperSQL.RunProcedure(sqlConn, sqlTran, "CapitalInfoTab_Update", parameters, out rowsAffected); string countrycode = ""; string ProvinceID = ""; string CityID = ""; string countyID = ""; //为投资资源更新投资区域信息 Tz888.SQLServerDAL.Info.CapitalInfoAreaDAL obj1 = new CapitalInfoAreaDAL(); obj1.DeleteByInfoID(sqlConn, sqlTran, infoID); if (model.CapitalInfoAreaModels != null) { foreach (Tz888.Model.Info.CapitalInfoAreaModel tmpModel in model.CapitalInfoAreaModels) { tmpModel.InfoID = infoID; obj1.Insert(sqlConn, sqlTran, tmpModel); if (!string.IsNullOrEmpty(tmpModel.CountryCode)) { countrycode += tmpModel.CountryCode.Trim() + ","; } if (!string.IsNullOrEmpty(tmpModel.ProvinceID)) { ProvinceID += tmpModel.ProvinceID.Trim() + ","; } if (!string.IsNullOrEmpty(tmpModel.CityID)) { CityID += tmpModel.CityID.Trim() + ","; } if (!string.IsNullOrEmpty(tmpModel.CountyID)) { countyID += tmpModel.CountyID.Trim() + ","; } } } //为投资资源更新联系人信息 Tz888.SQLServerDAL.Info.InfoContactManDAL obj2 = new InfoContactManDAL(); obj2.DeleteByInfoID(sqlConn, sqlTran, infoID); if (model.InfoContactManModels != null) { foreach (Tz888.Model.Info.InfoContactManModel tmpModel in model.InfoContactManModels) { tmpModel.InfoID = infoID; obj2.InsertContactMan(sqlConn, sqlTran, tmpModel); } } //为投资信息添加多个资源 Tz888.SQLServerDAL.Info.InfoResourceDAL obj3 = new InfoResourceDAL(); obj3.DeleteByInfoID(sqlConn, sqlTran, infoID); if (model.InfoResourceModels != null) { foreach (Tz888.Model.Info.InfoResourceModel tmpModel in model.InfoResourceModels) { tmpModel.InfoID = infoID; obj3.InsertInfoResource(sqlConn, sqlTran, tmpModel); } } ReturnValue = true; //序列化投资区域信息 this.CapitalInfoAreaQuery(infoID, countrycode, ProvinceID, CityID, countyID); sqlTran.Commit(); } catch { sqlTran.Rollback(); ReturnValue = false; } finally { sqlConn.Close(); } } return(ReturnValue); }
private void LoadInfo(long InfoID) { Tz888.BLL.Info.CapitalInfoBLL bll = new Tz888.BLL.Info.CapitalInfoBLL(); Tz888.Model.Info.CapitalSetModel model = new Tz888.Model.Info.CapitalSetModel(); model = bll.GetIntegrityModel(InfoID); this.txtCapitalName.Text = model.MainInfoModel.Title; this.rblCapitalType.SelectedValue = model.CapitalInfoModel.CapitalTypeID.Trim();; string CooperationDemandType = model.CapitalInfoModel.CooperationDemandType; string CooperationDemandTypeItems; for (int i = 0; i < chkLstCooperationDemand.Items.Count; i++) { CooperationDemandTypeItems = chkLstCooperationDemand.Items[i].Value; //CooperationDemandTypeItems += ","; if (CooperationDemandType.IndexOf(CooperationDemandTypeItems) != -1) { chkLstCooperationDemand.Items[i].Selected = true; } } if (!string.IsNullOrEmpty(model.MainInfoModel.KeyWord.Trim())) { string[] keys = model.MainInfoModel.KeyWord.Trim().Split(','); for (int i = 0; i < keys.Length; i++) { string key = keys[i].ToString().Trim(); switch (i) { case 0: this.txtKeyword1.Text = key; break; case 1: this.txtKeyword2.Text = key; break; case 2: this.txtKeyword3.Text = key; break; default: break; } } } this.ZoneMoreSelectControl1.CapitalInfoAreaModels = model.CapitalInfoAreaModels; this.SelectIndustryControl1.IndustryString = model.CapitalInfoModel.IndustryBID; this.ImageUploadControl1.InfoList = model.InfoResourceModels; this.ddlCurrency.SelectedValue = model.CapitalInfoModel.Currency.Trim();; this.ddlCapital.SelectedValue = model.CapitalInfoModel.CapitalID; this.txtCapitalIntent.Value = model.CapitalInfoModel.ComAbout; this.ddlValiditeTerm.SelectedValue = model.MainInfoModel.ValidateTerm.ToString(); this.CapitalAddressInfo1.InfoContact = model.InfoContactModel; this.CapitalAddressInfo1.InfoContactMans = model.InfoContactManModels; if (Request.UrlReferrer != null) { ViewState["strPrePage"] = Request.UrlReferrer.ToString(); } else { ViewState["strPrePage"] = ""; } ViewState["InfoID"] = model.MainInfoModel.InfoID; ViewState["PublishT"] = model.MainInfoModel.publishT; ViewState["ComBreif"] = model.CapitalInfoModel.ComBreif; ViewState["AuditingStatus"] = model.MainInfoModel.AuditingStatus; ViewState["HtmlFile"] = model.MainInfoModel.HtmlFile; ViewState["ShortTitle"] = model.ShortInfoModel.ShortTitle; ViewState["ShortContent"] = model.ShortInfoModel.ShortContent; ViewState["ShortInfoControlID"] = model.ShortInfoModel.ShortInfoControlID; }
private void LoadInfo(long InfoID) { Tz888.BLL.Conn dal = new Tz888.BLL.Conn(); DataTable dt = dal.GetList("dicttab", "*", "idictvalue", 10, 1, 0, 0, " cdicttype='xmyxqxx' "); this.rdlValiditeTerm.DataTextField = "cdictname"; this.rdlValiditeTerm.DataValueField = "idictvalue"; this.rdlValiditeTerm.DataSource = dt; this.rdlValiditeTerm.DataBind(); //2010-07-28 以上绑定项目有效期限 Tz888.BLL.Info.CapitalInfoBLL bll = new Tz888.BLL.Info.CapitalInfoBLL(); Tz888.Model.Info.CapitalSetModel model = new Tz888.Model.Info.CapitalSetModel(); model = bll.GetIntegrityModel(InfoID); //07-28项目有效期限 this.rdlValiditeTerm.SelectedValue = model.MainInfoModel.ValidateTerm.ToString(); this.txtCapitalName.Text = model.MainInfoModel.Title; this.rblCapitalType.SelectedValue = model.CapitalInfoModel.CapitalTypeID.Trim();; string CooperationDemandType = model.CapitalInfoModel.CooperationDemandType; string CooperationDemandTypeItems; for (int i = 0; i < chkLstCooperationDemand.Items.Count; i++) { CooperationDemandTypeItems = chkLstCooperationDemand.Items[i].Value; //CooperationDemandTypeItems += ","; if (CooperationDemandType.IndexOf(CooperationDemandTypeItems) != -1) { chkLstCooperationDemand.Items[i].Selected = true; } } if (!string.IsNullOrEmpty(model.MainInfoModel.KeyWord.Trim())) { string[] keys = model.MainInfoModel.KeyWord.Trim().Split(','); for (int i = 0; i < keys.Length; i++) { string key = keys[i].ToString().Trim(); switch (i) { case 0: this.txtKeyword1.Text = key; break; case 1: this.txtKeyword2.Text = key; break; case 2: this.txtKeyword3.Text = key; break; default: break; } } } this.ZoneMoreSelectControl1.CapitalInfoAreaModels = model.CapitalInfoAreaModels; this.SelectIndustryControl1.IndustryString = model.CapitalInfoModel.IndustryBID; this.ImageUploadControl1.InfoList = model.InfoResourceModels; this.ddlCurrency.SelectedValue = model.CapitalInfoModel.Currency.Trim();; this.ddlCapital.SelectedValue = model.CapitalInfoModel.CapitalID; this.txtCapitalIntent.Value = Tz888.Common.Utility.PageValidate.FiltrateHTMLTag(Tz888.Common.Utility.PageValidate.HtmlToTxt(model.CapitalInfoModel.ComAbout)); // this.ddlValiditeTerm.SelectedValue = model.MainInfoModel.ValidateTerm.ToString(); this.CapitalAddressInfo1.InfoContact = model.InfoContactModel; this.CapitalAddressInfo1.InfoContactMans = model.InfoContactManModels; if (Request.UrlReferrer != null) { ViewState["strPrePage"] = Request.UrlReferrer.ToString(); } else { ViewState["strPrePage"] = ""; } ViewState["InfoID"] = model.MainInfoModel.InfoID; ViewState["PublishT"] = model.MainInfoModel.publishT; ViewState["ComBreif"] = model.CapitalInfoModel.ComBreif; ViewState["AuditingStatus"] = model.MainInfoModel.AuditingStatus; ViewState["HtmlFile"] = model.MainInfoModel.HtmlFile; ViewState["ShortTitle"] = model.ShortInfoModel.ShortTitle; ViewState["ShortContent"] = model.ShortInfoModel.ShortContent; ViewState["ShortInfoControlID"] = model.ShortInfoModel.ShortInfoControlID; }
protected void btnUpdate_Click(object sender, EventArgs e) { Tz888.Model.Info.CapitalSetModel model = new Tz888.Model.Info.CapitalSetModel(); model.InfoContactModel = this.CapitalAddressInfo1.InfoContact; model.InfoContactManModels = this.CapitalAddressInfo1.InfoContactMans; model.CapitalInfoAreaModels = this.ZoneMoreSelectControl1.CapitalInfoAreaModels; #region 投资信息实体赋值 model.CapitalInfoModel.ComAbout = this.txtCapitalIntent.Value.Trim(); model.CapitalInfoModel.CapitalTypeID = this.rblCapitalType.SelectedValue; model.CapitalInfoModel.Currency = this.ddlCurrency.SelectedValue; model.CapitalInfoModel.CapitalID = this.ddlCapital.SelectedValue; model.CapitalInfoModel.ComBreif = this.ViewState["ComBreif"].ToString(); model.CapitalInfoModel.IndustryBID = this.SelectIndustryControl1.IndustryString; model.CapitalInfoModel.CooperationDemandType = ""; for (int i = 0; chkLstCooperationDemand.Items.Count > i; i++) { if (chkLstCooperationDemand.Items[i].Selected) { model.CapitalInfoModel.CooperationDemandType += chkLstCooperationDemand.Items[i].Value + ","; } } #endregion model.MainInfoModel.InfoID = Convert.ToInt64(this.ViewState["InfoID"]); if (!string.IsNullOrEmpty(this.txtCapitalName.Text.Trim())) { model.MainInfoModel.Title = this.txtCapitalName.Text.Trim(); } model.MainInfoModel.publishT = Convert.ToDateTime(this.ViewState["PublishT"]); model.MainInfoModel.LoginName = ""; //用户名称 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() + ","; } model.MainInfoModel.KeyWord = keyword; model.MainInfoModel.Descript = ""; model.MainInfoModel.DisplayTitle = this.txtCapitalName.Text.Trim(); model.MainInfoModel.FrontDisplayTime = System.DateTime.Now; model.MainInfoModel.ValidateStartTime = System.DateTime.Now.AddDays(1); model.MainInfoModel.ValidateTerm = Convert.ToInt32(this.ddlValiditeTerm.SelectedValue.Trim()); model.MainInfoModel.TemplateID = "001"; model.MainInfoModel.HtmlFile = ViewState["HtmlFile"].ToString(); model.ShortInfoModel.ShortInfoControlID = Convert.ToString(ViewState["ShortInfoControlID"]); model.ShortInfoModel.ShortTitle = ViewState["ShortTitle"].ToString(); model.ShortInfoModel.ShortContent = ViewState["ShortContent"].ToString(); model.ShortInfoModel.Remark = ""; List <Tz888.Model.Info.InfoResourceModel> infoResourceModels = Tz888.Common.InfoResourceManage.ImageTransfer("Image", "Capital", Tz888.Common.ResourceType.Image, Tz888.Common.ResourceProperty.InfoImage, ImageUploadControl1.InfoList); if (infoResourceModels != null) { model.InfoResourceModels.AddRange(infoResourceModels); } Tz888.BLL.Info.CapitalInfoBLL bll = new Tz888.BLL.Info.CapitalInfoBLL(); if (bll.Update(model)) { Tz888.Common.MessageBox.ShowAndRedirect(this.Page, "修改信息成功!", Request.Url.ToString()); } else { Tz888.Common.MessageBox.ShowAndRedirect(this.Page, "修改信息失败!", Request.Url.ToString()); } }
public string GetInfoContractDetail(string InfoID) { string cacheStr = "ContractDetail_" + InfoID; if (HttpContext.Current.Cache[cacheStr] != null) { return(HttpContext.Current.Cache[cacheStr].ToString().Trim()); } else { #region 获取资源的联系方式 //最终显示的信息 string sOut = ""; //免费的信息的内容 string sFree = "<a href='#88' onclick=\"javascript:GetContactDetail(" + InfoID + ");\" class='spaces' ><img src='/Web13/images/project/button_cklxfs.gif' width='150' height='30' align='absmiddle' /></a> <i></i>我的MSN在线,联系我:<img src='/web13/images/project/icon_msn.gif' width='29' height='26' align='absmiddle' /><i></i>或<i></i><a href=\"Javascript:alert('系统升级中。。。');\"> 给项目方留言></a><p>发布者:<a href='#'>1234</a><i></i><img src='/web13/images/project/icon_05.gif' width='15' height='12' /> <i></i> <a href=\"javascript:alert('系统升级中。。。');\">加为好友</a></p>|1"; //收费的信息内容 string sChange = "<a href=\"http://pay.topfo.com/order_item.aspx?InfoID=" + InfoID + "\" class=\"spaces\"><img src=\"/web13/images/project/button_ljgm.gif\" width=\"130\" height=\"30\" border=\"0\" align=\"absmiddle\" /></a><i></i><a href=\"http://member.topfo.com/PayManage/shopcar.aspx?InfoID=" + InfoID + "\" class=\"spaces\"><img src=\"/web13/images/project/button_flgwc.gif\" width=\"150\" height=\"30\" border=\"0\" align=\"absmiddle\" /></a><p color='#CCCCCC'>支持多种支付方式,资源若无效经中国招商投资网确认后可全额返还所付款项,请放心购买。</p>|2"; //当前用户名 string CurrentUserName = ""; CurrentUserName = User.Identity.Name.Trim(); //用户是否是拓富通会员 bool bIsTofMember = false; if (User.IsInRole("GT1002")) { if (CurrentUserName.Trim() != "") { bIsTofMember = true; } } Tz888.Model.Info.CapitalSetModel objCSM = new Tz888.Model.Info.CapitalSetModel(); Tz888.BLL.Info.CapitalInfoBLL ciBll = new Tz888.BLL.Info.CapitalInfoBLL(); objCSM = ciBll.GetIntegrityModel(long.Parse(InfoID)); if (objCSM.MainInfoModel.MainPointCount > 0) { //这是一条收费信息 if (bIsTofMember) { //是拓富通会员 bool bIsBuy = false; bIsBuy = ciBll.bIsBuyInfoOfUser(CurrentUserName, InfoID); if (bIsBuy) { //拓富通会员购买了此信息 sOut = sFree; } else { //拓富通会员没有购买了此信息 sOut = sChange; } } else { //非拓富通会员 sOut = sChange; } } else { //这是一条免费信息 sOut = sFree; } //return sOut; #endregion HttpContext.Current.Cache.Insert(cacheStr, sOut.ToString().Trim(), null, System.Web.Caching.Cache.NoAbsoluteExpiration, TimeSpan.FromDays(7)); return(sOut.ToString().Trim()); } }