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, "发布失败！");
}
}
