/// <summary> /// 商机信息发布 /// </summary> /// <returns></returns> public long Insert(Tz888.Model.Info.MainInfoModel mainInfoModel, Tz888.Model.Info.OpportunityInfoModel opportunity, Tz888.Model.Info.ShortInfoModel shortInfoModel ) { return(dal.Insert(mainInfoModel, opportunity, shortInfoModel)); }
private void MainOppor(int num) { main = opp.SetMainInfo(num); this.txtTitle.Text = main.Title.ToString().Trim(); this.ddlGrade.SelectedValue = main.GradeID; this.ddlFixPrice.SelectedValue = main.FixPriceID; this.rblAuditing.SelectedValue = main.AuditingStatus.ToString().Trim(); this.txtKeyWord.Text = main.KeyWord.ToString().Trim(); this.txtDescript.Text = main.Descript.ToString().Trim(); this.rdbtXM.SelectedValue = main.ValidateTerm.ToString().Trim(); this.txtDisplayTitle.Text = main.DisplayTitle.ToString().Trim(); if (this.rblAuditing.SelectedValue == "1") { divAuditing.Style["display"] = "block"; } pOpportunity = opp.SetOpportunity(num); this.txtAdTitle.Text = pOpportunity.AdTitle.ToString().Trim(); this.ddlOpportunityType.SelectedValue = pOpportunity.OpportunityType; this.ZoneSelectControl2.CountryID = pOpportunity.CountryCode.ToString().Trim(); this.ZoneSelectControl2.ProvinceID = pOpportunity.ProvinceID.ToString().Trim(); this.ZoneSelectControl2.CountyID = pOpportunity.CountyID.ToString().Trim(); this.ddlIndustry.SelectedValue = pOpportunity.IndustryOpportunityID; // this.txtContent.Text =HtmlToTxt(pOpportunity.Content.ToString().Trim()); this.txtContent.Text = pOpportunity.Content.ToString().Trim(); this.txtAnalysis.Text = pOpportunity.Analysis.ToString().Trim(); this.txtRequest.Text = pOpportunity.Request.ToString().Trim(); this.txtFlow.Text = pOpportunity.Flow.ToString().Trim(); this.txtRemark.Text = pOpportunity.Remark.ToString().Trim(); this.txtComName.Text = pOpportunity.ComName.ToString().Trim(); this.txtLinkMan.Text = pOpportunity.LinkMan.ToString().Trim(); string[] tel = pOpportunity.Tel.ToString().Trim().Split('-'); this.txtTelCountry.Text = tel[0].ToString(); this.txtTelZoneCode.Text = tel[1].ToString(); this.txtTelNumber.Text = tel[2].ToString(); this.txtMobile.Text = pOpportunity.Mobile.ToString().Trim(); this.txtAddress.Text = pOpportunity.Address.ToString().Trim(); this.txtPostCode.Text = pOpportunity.PostCode.ToString().Trim(); this.txtEmail.Text = pOpportunity.Email.ToString().Trim(); this.txtWebSite.Text = pOpportunity.WebSite.ToString().Trim(); shortInfoRule = opp.SetShortInfo(num); this.txtShortContent.Text = shortInfoRule.ShortContent.ToString().Trim(); this.txtShortTitle.Text = shortInfoRule.ShortTitle.ToString().Trim(); }
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, "验证码错误!"); return; } } catch { Tz888.Common.MessageBox.Show(this.Page, "未知错误!"); } #region 参数 List <Tz888.Model.Common.IndustryModel> industryModels = new List <Tz888.Model.Common.IndustryModel>(); //融资行业实体列表 industryModels = this.SelectIndustryControl1.IndustryModels; #endregion int Hit = 0; Random rnd = new Random(); Hit = rnd.Next(25) + 5; #region 创建实例,将数据传入系统 #region 插入数据 //OpportunityInformation pOpportunity = new OpportunityInformation(); Tz888.Model.Info.MainInfoModel main = new Tz888.Model.Info.MainInfoModel(); //主表 Tz888.Model.Info.OpportunityInfoModel pOpportunity = new Tz888.Model.Info.OpportunityInfoModel(); //商机信息表 Tz888.Model.Info.ShortInfoModel shortInfoRule = new Tz888.Model.Info.ShortInfoModel(); //短消息表 #region 主表 main.Title = txtTitle.Text.Trim(); main.InfoCode = Tz888.BLL.Info.Common.CreateInfoCode("Oppor", industryModels[0].IndustryBID, this.ZoneSelectControl2.CountryID, DateTime.Now); main.publishT = Convert.ToDateTime(DateTime.Now); main.Hit = Hit; main.LoginName = "8ming"; main.InfoOriginRoleName = "0"; main.KeyWord = txtKeyWord.Text.Trim(); main.Descript = txtDescript.Text.Trim(); main.DisplayTitle = txtDisplayTitle.Text.Trim(); main.FrontDisplayTime = Convert.ToDateTime(DateTime.Now); main.ValidateStartTime = Convert.ToDateTime(DateTime.Now); main.ValidateTerm = Convert.ToInt32(this.rdbtXM.SelectedValue.Trim());; main.TemplateID = "001"; main.HtmlFile = ""; #endregion #region 商机信息表 pOpportunity.AdTitle = txtAdTitle.Text.Trim(); pOpportunity.OpportunityType = ddlOpportunityType.SelectedValue.ToString().Trim(); pOpportunity.CountryCode = ZoneSelectControl2.CountryID; pOpportunity.ProvinceID = ZoneSelectControl2.ProvinceID; pOpportunity.CountyID = ZoneSelectControl2.CountyID; pOpportunity.IndustryOpportunityID = this.SelectIndustryControl1.IndustryString; pOpportunity.ValidateID = this.rdbtXM.SelectedValue.Trim(); // pOpportunity.Pic1 = FilesUploadControl2.UploadImageURL; // pOpportunity.Pic1 = ""; //图片 pOpportunity.Pic1 = Convert.ToString(ViewState["strSavePath"]); pOpportunity.Content = txtContent.Text; //商机内容 pOpportunity.Analysis = txtAnalysis.Text; //商机分析 pOpportunity.Request = txtRequest.Text; //商机需求 pOpportunity.Flow = txtFlow.Text; //商机流程 pOpportunity.Remark = txtRemark.Text; //备注 pOpportunity.ComName = txtComName.Text.Trim(); //公司名称 pOpportunity.LinkMan = txtLinkMan.Text.Trim(); //联系人 pOpportunity.Tel = txtTelCountry.Text.Trim() + "-" + txtTelZoneCode.Text.Trim() + "-" + txtTelNumber.Text.Trim(); //电话 pOpportunity.Fax = ""; pOpportunity.Mobile = txtMobile.Text.Trim(); //手机 pOpportunity.Address = txtAddress.Text.Trim(); //地址 pOpportunity.PostCode = txtPostCode.Text.Trim(); // pOpportunity.Email = txtEmail.Text.Trim(); //邮箱 pOpportunity.WebSite = txtWebSite.Text.Trim(); // #endregion #region 短内容信息表 shortInfoRule.ShortInfoControlID = "OpporIndex1"; shortInfoRule.ShortTitle = txtShortTitle.Text.Trim(); shortInfoRule.ShortContent = txtShortContent.Text.Trim(); shortInfoRule.Remark = ""; #endregion //插入数据 Tz888.BLL.Info.OpportunityInfoBLL opportun = new Tz888.BLL.Info.OpportunityInfoBLL(); long InfoID = opportun.Insert(main, pOpportunity, shortInfoRule); #endregion #endregion if (InfoID != 0) { Response.Write("<script>alert('添加成功')</script>"); } else { Response.Write("<script language=\"javascript\">alert('添加失败');window.location.href='/PublishOppor.aspx';</script>"); } }
public long Insert(Tz888.Model.Info.MainInfoModel mainInfoModel, Tz888.Model.Info.OpportunityInfoModel opportunity, Tz888.Model.Info.ShortInfoModel shortInfoModel ) { SqlParameter[] parameters = { new SqlParameter("@InfoID", SqlDbType.BigInt), new SqlParameter("@Title", SqlDbType.VarChar, 100), new SqlParameter("@InfoCode", SqlDbType.Char, 30), new SqlParameter("@publishT", SqlDbType.DateTime), new SqlParameter("@Hit", SqlDbType.BigInt), new SqlParameter("@IsCore", SqlDbType.Bit), new SqlParameter("@IndexOrderNum", SqlDbType.BigInt), new SqlParameter("@IndexTopValidateDate", SqlDbType.Int), new SqlParameter("@IndexPicInfoNum", SqlDbType.BigInt), new SqlParameter("@InfoTypeOrderNum", SqlDbType.BigInt), new SqlParameter("@InfoTypeTopValidateDate", SqlDbType.Int), new SqlParameter("@InfoTypePicInfoNum", SqlDbType.BigInt), 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), //2005/12/12 add 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), new SqlParameter("@TemplateID", SqlDbType.Char, 10), new SqlParameter("@HtmlFile", SqlDbType.VarChar, 100), //该字段不需要更新,只有在审核时才更新 //商机信息 new SqlParameter("@AdTitle", SqlDbType.VarChar, 50), new SqlParameter("@OpportunityType", SqlDbType.Char, 10), new SqlParameter("@CountryCode", SqlDbType.Char, 10), new SqlParameter("@ProvinceID", SqlDbType.Char, 10), new SqlParameter("@CountyID", SqlDbType.Char, 10), new SqlParameter("@IndustryOpportunityID", SqlDbType.Char, 10), new SqlParameter("@ValidateID", SqlDbType.Char, 10), new SqlParameter("@Pic1", SqlDbType.VarChar, 100), new SqlParameter("@Content", SqlDbType.Text), new SqlParameter("@Analysis", SqlDbType.Text), new SqlParameter("@Request", SqlDbType.Text), new SqlParameter("@Flow", SqlDbType.Text), new SqlParameter("@Remark", SqlDbType.Text), new SqlParameter("@ComName", SqlDbType.VarChar, 40), new SqlParameter("@LinkMan", SqlDbType.VarChar, 20), new SqlParameter("@Tel", SqlDbType.VarChar, 30), new SqlParameter("@Fax", SqlDbType.VarChar, 30), new SqlParameter("@Mobile", SqlDbType.VarChar, 20), new SqlParameter("@Address", SqlDbType.VarChar, 50), new SqlParameter("@PostCode", SqlDbType.VarChar, 6), new SqlParameter("@Email", SqlDbType.VarChar, 40), new SqlParameter("@WebSite", SqlDbType.VarChar, 40), // 短内容信息表 new SqlParameter("@ShortInfoControlID", SqlDbType.Char, 20), new SqlParameter("@ShortTitle", SqlDbType.VarChar, 100), new SqlParameter("@ShortContent", SqlDbType.VarChar, 100), new SqlParameter("@strRemark", SqlDbType.VarChar, 50) }; parameters[0].Direction = ParameterDirection.InputOutput; parameters[0].Value = mainInfoModel.InfoID; 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 = 0; parameters[7].Value = 0; parameters[8].Value = 0; parameters[9].Value = 0; parameters[10].Value = 0; parameters[11].Value = 0; parameters[12].Value = mainInfoModel.LoginName; parameters[13].Value = mainInfoModel.InfoOriginRoleName; parameters[14].Value = "0"; parameters[15].Value = "1"; parameters[16].Value = 2; //付费 0付费,1未付费,2无需付费 parameters[17].Value = AlterKeyWord(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; //商机信息 parameters[25].Value = opportunity.AdTitle; parameters[26].Value = opportunity.OpportunityType; parameters[27].Value = opportunity.CountryCode; if (opportunity.ProvinceID == "") { parameters[28].Value = System.DBNull.Value; } else { parameters[28].Value = opportunity.ProvinceID; } if (opportunity.CountyID == "") { parameters[29].Value = System.DBNull.Value; } else { parameters[29].Value = opportunity.CountyID; } parameters[30].Value = opportunity.IndustryOpportunityID; parameters[31].Value = opportunity.ValidateID; parameters[32].Value = opportunity.Pic1; parameters[33].Value = opportunity.Content; parameters[34].Value = opportunity.Analysis; parameters[35].Value = opportunity.Request; parameters[36].Value = opportunity.Flow; parameters[37].Value = opportunity.Remark; parameters[38].Value = opportunity.ComName; parameters[39].Value = opportunity.LinkMan; parameters[40].Value = opportunity.Tel; parameters[41].Value = opportunity.Fax; parameters[42].Value = opportunity.Mobile; parameters[43].Value = opportunity.Address; parameters[44].Value = opportunity.PostCode; parameters[45].Value = opportunity.Email; parameters[46].Value = opportunity.WebSite; parameters[47].Value = shortInfoModel.ShortInfoControlID; parameters[48].Value = shortInfoModel.ShortTitle; parameters[49].Value = shortInfoModel.ShortContent; parameters[50].Value = shortInfoModel.Remark; int rowsAffected; long infoID; using (SqlConnection sqlConn = DbHelperSQL.GetSqlConnection()) { sqlConn.Open(); SqlTransaction sqlTran = sqlConn.BeginTransaction(); try { //插入融资(项目)资源信息 DbHelperSQL.RunProcedure(sqlConn, sqlTran, "OpportunityInfoTabnewss_Insert", parameters, out rowsAffected); infoID = (long)parameters[0].Value; if (infoID < 0) { throw new Exception(); } sqlTran.Commit(); } catch (Exception ex) { sqlTran.Rollback(); infoID = -1; throw ex; } finally { sqlConn.Close(); } } return(infoID); }
/// <summary> /// 修改商机信息 /// </summary> public long HasModify(Tz888.Model.Info.MainInfoModel mainInfoModel, Tz888.Model.Info.OpportunityInfoModel opportunity, Tz888.Model.Info.ShortInfoModel shortInfoModel, int infodd) { return(dal.HasModify(mainInfoModel, opportunity, shortInfoModel, infodd)); }