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