public long Insert(
Tz888.Model.Info.MainInfoModel mainInfoModel,
Tz888.Model.Info.CapitalInfoModel capitalInfoModel,
Tz888.Model.Info.InfoContactModel infoContactModel,
Tz888.Model.Info.ShortInfoModel shortInfoModel,
List <Tz888.Model.Info.CapitalInfoAreaModel> capitalInfoAreaModels,
// 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("@ComAbout", SqlDbType.VarChar, -1),
new SqlParameter("@ComBreif", SqlDbType.VarChar, -1),
//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("@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),
//---------------------------END---------------------------
//-----------------------资源联系信息--------------------------
new SqlParameter("@ComName", 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),
//---------------------------END---------------------------
new SqlParameter("@RegisteredCapital", SqlDbType.Char, 30),
};
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;
parameters[25].Value = capitalInfoModel.ComAbout;
parameters[26].Value = capitalInfoModel.ComBreif;
//parameters[25].Value = capitalInfoModel.CountryCode;
//parameters[26].Value = capitalInfoModel.ProvinceID;
//parameters[27].Value = capitalInfoModel.CityID;
//parameters[28].Value = capitalInfoModel.CountyID;
parameters[27].Value = capitalInfoModel.IndustryBID;
parameters[28].Value = capitalInfoModel.CooperationDemandType;
parameters[29].Value = capitalInfoModel.Currency;
parameters[30].Value = capitalInfoModel.CapitalID;
parameters[31].Value = capitalInfoModel.CapitalTypeID;
parameters[32].Value = infoContactModel.OrganizationName;
parameters[33].Value = infoContactModel.Name;
parameters[34].Value = infoContactModel.TelCountryCode;
parameters[35].Value = infoContactModel.TelStateCode;
parameters[36].Value = infoContactModel.TelNum;
parameters[37].Value = infoContactModel.FaxCountryCode;
parameters[38].Value = infoContactModel.FaxStateCode;
parameters[39].Value = infoContactModel.FaxNum;
parameters[40].Value = infoContactModel.Mobile;
parameters[41].Value = infoContactModel.Address;
parameters[42].Value = infoContactModel.PostCode;
parameters[43].Value = infoContactModel.Email;
parameters[44].Value = infoContactModel.WebSite;
parameters[45].Value = shortInfoModel.ShortInfoControlID;
parameters[46].Value = shortInfoModel.ShortTitle;
parameters[47].Value = shortInfoModel.ShortContent;
parameters[48].Value = shortInfoModel.Remark;
parameters[49].Value = capitalInfoModel.IsVip;
parameters[50].Value = capitalInfoModel.RegisteredCapital;
int rowsAffected;
long infoID;
using (SqlConnection sqlConn = DbHelperSQL.GetSqlConnection())
{
sqlConn.Open();
SqlTransaction sqlTran = sqlConn.BeginTransaction();
try
{
//插入投资资源信息
DbHelperSQL.RunProcedure(sqlConn, sqlTran, SP_CapitalInfoInfo_Insert, parameters, out rowsAffected);
infoID = (long)parameters[0].Value;
if (infoID < 0)
{
throw new Exception();
}
string countrycode = "";
string ProvinceID = "";
string CityID = "";
string countyID = "";
if (capitalInfoAreaModels != null)
{
//为投资信息添加多个投资区域
Tz888.SQLServerDAL.Info.CapitalInfoAreaDAL obj1 = new CapitalInfoAreaDAL();
foreach (Tz888.Model.Info.CapitalInfoAreaModel model in capitalInfoAreaModels)
{
model.InfoID = infoID;
obj1.Insert(sqlConn, sqlTran, model);
if (!string.IsNullOrEmpty(model.CountryCode))
{
countrycode += model.CountryCode.Trim() + ",";
}
if (!string.IsNullOrEmpty(model.ProvinceID))
{
ProvinceID += model.ProvinceID.Trim() + ",";
}
if (!string.IsNullOrEmpty(model.CityID))
{
CityID += model.CityID.Trim() + ",";
}
if (!string.IsNullOrEmpty(model.CountyID))
{
countyID += model.CountyID.Trim() + ",";
}
}
//序列化投资区域信息
this.CapitalInfoAreaQuery(infoID, countrycode, ProvinceID, CityID, countyID);
}
//if (infoContactManModels != null)
//{
// //为投资资源添加多个联系人
// Tz888.SQLServerDAL.Info.InfoContactManDAL obj2 = new InfoContactManDAL();
// foreach (Tz888.Model.Info.InfoContactManModel model in infoContactManModels)
// {
// model.InfoID = infoID;
// obj2.InsertContactMan(sqlConn, sqlTran, model);
// }
//}
if (infoResourceModels != null)
{
//为投资信息添加多个资源
Tz888.SQLServerDAL.Info.InfoResourceDAL obj3 = new InfoResourceDAL();
foreach (Tz888.Model.Info.InfoResourceModel model in infoResourceModels)
{
model.InfoID = infoID;
obj3.InsertInfoResource(sqlConn, sqlTran, model);
}
}
sqlTran.Commit();
}
catch
{
sqlTran.Rollback();
infoID = -1;
}
finally
{
sqlConn.Close();
}
}
return(infoID);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
/// <param name="InfoID"></param>
/// <returns></returns>
public Tz888.Model.Info.CapitalInfoModel GetModel(long InfoID)
{
SqlParameter[] parameters =
{
new SqlParameter("@InfoID", SqlDbType.BigInt, 8)
};
parameters[0].Value = InfoID;
Tz888.Model.Info.CapitalInfoModel model = new Tz888.Model.Info.CapitalInfoModel();
DataSet ds = DbHelperSQL.RunProcedure("CapitalInfoTab_GetModel", parameters, "ds");
model.InfoID = InfoID;
if (ds.Tables[0].Rows.Count > 0)
{
model.IndustryBID = ds.Tables[0].Rows[0]["IndustryBID"].ToString();
model.CooperationDemandType = ds.Tables[0].Rows[0]["CooperationDemandType"].ToString();
model.Currency = ds.Tables[0].Rows[0]["currency"].ToString();
model.CapitalID = ds.Tables[0].Rows[0]["CapitalID"].ToString();
model.CapitalTypeID = ds.Tables[0].Rows[0]["CapitalTypeID"].ToString();
model.CapitalTypeName = ds.Tables[0].Rows[0]["CapitalTypeName"].ToString();
model.ComAbout = ds.Tables[0].Rows[0]["ComAbout"].ToString();
model.ComBreif = ds.Tables[0].Rows[0]["ComBreif"].ToString();
model.Remrk = ds.Tables[0].Rows[0]["Remrk"].ToString();
model.CapitalName = ds.Tables[0].Rows[0]["CapitalName"].ToString();
model.RegisteredCapital = ds.Tables[0].Rows[0]["RegisteredCapital"].ToString().Trim();
model.AverageInvestment = ds.Tables[0].Rows[0]["AverageInvestment"].ToString().Trim();
model.TeamScale = ds.Tables[0].Rows[0]["TeamScale"].ToString().Trim();
model.SuccessfulInvestment = ds.Tables[0].Rows[0]["SuccessfulInvestment"].ToString().Trim();
model.InvestmentDemand = ds.Tables[0].Rows[0]["InvestmentDemand"].ToString().Trim();
model.Prorganizers = ds.Tables[0].Rows[0]["Prorganizers"].ToString().Trim();
model.SCountryID = ds.Tables[0].Rows[0]["CountryID"].ToString().Trim();
model.SCountyID = ds.Tables[0].Rows[0]["CountyID"].ToString().Trim();
model.ProvinceID = ds.Tables[0].Rows[0]["ProvinceID"].ToString().Trim();
if (ds.Tables[0].Rows[0]["EvaluationPop"].ToString() != "")
{
model.EvaluationPop = Convert.ToInt32(ds.Tables[0].Rows[0]["EvaluationPop"]);
}
if (ds.Tables[0].Rows[0]["TopCertification"].ToString().Trim() != "")
{
model.TopCertification = Convert.ToInt32(ds.Tables[0].Rows[0]["TopCertification"].ToString().Trim());
}
if (ds.Tables[0].Rows[0]["InformationIntegrity"].ToString().Trim() != "")
{
model.InformationIntegrity = Convert.ToInt32(ds.Tables[0].Rows[0]["InformationIntegrity"].ToString().Trim());
}
if (ds.Tables[0].Rows[0]["isVip"].ToString() != "")
{
model.IsVip = Convert.ToInt32(ds.Tables[0].Rows[0]["isVip"]);
}
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.IndustryBID.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;
return(model);
}
else
{
return(null);
}
}
protected void IbtnSubmit_Click(object sender, ImageClickEventArgs e)
{
Tz888.BLL.Info.CapitalInfoBLL capitalObj = new Tz888.BLL.Info.CapitalInfoBLL();
Tz888.Model.Info.MainInfoModel mainInfoModel = new Tz888.Model.Info.MainInfoModel(); //创建主体信息实体
Tz888.Model.Info.CapitalInfoModel capitalInfoModel = new Tz888.Model.Info.CapitalInfoModel(); //创建投资信息实体
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.CapitalInfoAreaModel> capitalInfoAreaModels = new List <Tz888.Model.Info.CapitalInfoAreaModel>(); //投资区域信息实体列表
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.CapitalAddressInfo1.InfoContact;
industryModels = this.SelectIndustryControl1.IndustryModels;
capitalInfoAreaModels = this.ZoneMoreSelectControl1.CapitalInfoAreaModels;
infoContactManModels = this.CapitalAddressInfo1.InfoContactMans;
#region 投资信息实体赋值
capitalInfoModel.ComAbout = Tz888.Common.Utility.PageValidate.TxtToHtml(this.txtCapitalIntent.Value.Trim());
capitalInfoModel.CapitalTypeID = this.rblCapitalType.SelectedValue;
capitalInfoModel.Currency = this.ddlCurrency.SelectedValue;
capitalInfoModel.CapitalID = this.ddlCapital.SelectedValue;
capitalInfoModel.ComBreif = "";
capitalInfoModel.CooperationDemandType = "";
capitalInfoModel.IndustryBID = "";
foreach (Tz888.Model.Common.IndustryModel model in industryModels)
{
capitalInfoModel.IndustryBID += model.IndustryBID + ",";
}
for (int i = 0; chkLstCooperationDemand.Items.Count > i; i++)
{
if (chkLstCooperationDemand.Items[i].Selected)
{
capitalInfoModel.CooperationDemandType += chkLstCooperationDemand.Items[i].Value + ",";
}
}
#endregion
if (!string.IsNullOrEmpty(this.txtCapitalName.Text.Trim()))
{
mainInfoModel.Title = Tz888.Common.Utility.PageValidate.FiltrateHTMLTag(this.txtCapitalName.Text.Trim());
}
string CountryCode;
try
{
CountryCode = capitalInfoAreaModels[0].CountryCode;
}
catch
{
CountryCode = "ALL";
}
mainInfoModel.InfoCode = Tz888.BLL.Info.Common.CreateInfoCode("Capital", industryModels[0].IndustryBID, CountryCode, time_now);
mainInfoModel.publishT = time_now;
mainInfoModel.Hit = 0;
mainInfoModel.IsCore = true;
mainInfoModel.LoginName = Page.User.Identity.Name;
//mainInfoModel.LoginName = "Clandylee"; //用户名称
mainInfoModel.InfoOriginRoleName = "0"; //用户角色
mainInfoModel.GradeID = "0";
mainInfoModel.FixPriceID = "1";
mainInfoModel.FeeStatus = 0;
string keyword = "";
if (!string.IsNullOrEmpty(this.txtKeyword1.Text.Trim()))
{
keyword += Tz888.Common.Utility.PageValidate.FiltrateHTMLTag(this.txtKeyword1.Text.Trim()) + ",";
}
if (!string.IsNullOrEmpty(this.txtKeyword2.Text.Trim()))
{
keyword += Tz888.Common.Utility.PageValidate.FiltrateHTMLTag(this.txtKeyword2.Text.Trim()) + ",";
}
if (!string.IsNullOrEmpty(this.txtKeyword3.Text.Trim()))
{
keyword += Tz888.Common.Utility.PageValidate.FiltrateHTMLTag(this.txtKeyword3.Text.Trim()) + ",";
}
mainInfoModel.KeyWord = keyword;
mainInfoModel.Descript = "";
if (!string.IsNullOrEmpty(this.txtCapitalName.Text.Trim()))
{
mainInfoModel.DisplayTitle = Tz888.Common.Utility.PageValidate.FiltrateHTMLTag(this.txtCapitalName.Text.Trim());
}
mainInfoModel.FrontDisplayTime = time_now;
mainInfoModel.ValidateStartTime = time_now;
mainInfoModel.ValidateTerm = Convert.ToInt32(this.ddlValiditeTerm.SelectedValue.Trim());
mainInfoModel.TemplateID = "001";
mainInfoModel.HtmlFile = "";
shortInfoModel.ShortInfoControlID = "CapitalIndex1";
if (!string.IsNullOrEmpty(this.txtCapitalName.Text.Trim()))
{
shortInfoModel.ShortTitle = Tz888.Common.Utility.PageValidate.FiltrateHTMLTag(this.txtCapitalName.Text.Trim());
}
shortInfoModel.ShortContent = "";
shortInfoModel.Remark = "";
//将已上传的图片从临时目录迁移到正式目录
//infoResourceModels = Tz888.Common.InfoResourceManage.ImageTransfer("Image", "Capital", Tz888.Common.ResourceType.Image, Tz888.Common.ResourceProperty.InfoImage, ImageUploadControl1.InfoList);
infoResourceModels = ImageUploadControl1.InfoList;
Tz888.BLL.Info.CapitalInfoBLL bll = new Tz888.BLL.Info.CapitalInfoBLL();
//long infoID = bll.Insert(mainInfoModel, capitalInfoModel, infoContactModel, shortInfoModel, capitalInfoAreaModels, infoContactManModels, infoResourceModels);
long infoID = bll.Insert(mainInfoModel, capitalInfoModel, infoContactModel, shortInfoModel, capitalInfoAreaModels, infoResourceModels);
if (infoID > 0)
{
bool isTof = Page.User.IsInRole("GT1002");
if (isTof)
{
string HtmlFile = Tz888.BLL.Info.Common.createStaticPageFileName("Capital", mainInfoModel.InfoCode, infoID);
Tz888.BLL.Info.MainInfoBLL mainBll = new Tz888.BLL.Info.MainInfoBLL();
mainBll.HasHtmlFile(infoID, HtmlFile);
string actionMsg = "";
Tz888.BLL.PageStatic.CapitalPageStatic staticobj = new Tz888.BLL.PageStatic.CapitalPageStatic();
staticobj.CreateStaticPageCapital(infoID.ToString(), ref actionMsg);
}
Response.Redirect("PublishCapital2.aspx?code=" + Tz888.Common.DEncrypt.DESEncrypt.Encrypt(infoID.ToString() + "|Capital|" + this.txtCapitalName.Text.Trim()));
}
else
{
Tz888.Common.MessageBox.Show(this.Page, "发布失败！");
}
}
