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