/// <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);
}
private void LoadInfo(long InfoID)
{
Tz888.BLL.Info.CapitalInfoBLL bll = new Tz888.BLL.Info.CapitalInfoBLL();
Tz888.Model.Info.CapitalSetModel model = new Tz888.Model.Info.CapitalSetModel();
model = bll.GetIntegrityModel(InfoID);
this.txtCapitalName.Text = model.MainInfoModel.Title;
this.rblCapitalType.SelectedValue = model.CapitalInfoModel.CapitalTypeID.Trim();;
string CooperationDemandType = model.CapitalInfoModel.CooperationDemandType;
string CooperationDemandTypeItems;
for (int i = 0; i < chkLstCooperationDemand.Items.Count; i++)
{
CooperationDemandTypeItems = chkLstCooperationDemand.Items[i].Value;
//CooperationDemandTypeItems += ",";
if (CooperationDemandType.IndexOf(CooperationDemandTypeItems) != -1)
{
chkLstCooperationDemand.Items[i].Selected = true;
}
}
if (!string.IsNullOrEmpty(model.MainInfoModel.KeyWord.Trim()))
{
string[] keys = model.MainInfoModel.KeyWord.Trim().Split(',');
for (int i = 0; i < keys.Length; i++)
{
string key = keys[i].ToString().Trim();
switch (i)
{
case 0:
this.txtKeyword1.Text = key;
break;
case 1:
this.txtKeyword2.Text = key;
break;
case 2:
this.txtKeyword3.Text = key;
break;
default:
break;
}
}
}
this.ZoneMoreSelectControl1.CapitalInfoAreaModels = model.CapitalInfoAreaModels;
this.SelectIndustryControl1.IndustryString = model.CapitalInfoModel.IndustryBID;
this.ImageUploadControl1.InfoList = model.InfoResourceModels;
this.ddlCurrency.SelectedValue = model.CapitalInfoModel.Currency.Trim();;
this.ddlCapital.SelectedValue = model.CapitalInfoModel.CapitalID;
this.txtCapitalIntent.Value = model.CapitalInfoModel.ComAbout;
this.ddlValiditeTerm.SelectedValue = model.MainInfoModel.ValidateTerm.ToString();
this.CapitalAddressInfo1.InfoContact = model.InfoContactModel;
this.CapitalAddressInfo1.InfoContactMans = model.InfoContactManModels;
if (Request.UrlReferrer != null)
{
ViewState["strPrePage"] = Request.UrlReferrer.ToString();
}
else
{
ViewState["strPrePage"] = "";
}
ViewState["InfoID"] = model.MainInfoModel.InfoID;
ViewState["PublishT"] = model.MainInfoModel.publishT;
ViewState["ComBreif"] = model.CapitalInfoModel.ComBreif;
ViewState["AuditingStatus"] = model.MainInfoModel.AuditingStatus;
ViewState["HtmlFile"] = model.MainInfoModel.HtmlFile;
ViewState["ShortTitle"] = model.ShortInfoModel.ShortTitle;
ViewState["ShortContent"] = model.ShortInfoModel.ShortContent;
ViewState["ShortInfoControlID"] = model.ShortInfoModel.ShortInfoControlID;
}
private void LoadInfo(long InfoID)
{
Tz888.BLL.Conn dal = new Tz888.BLL.Conn();
DataTable dt = dal.GetList("dicttab", "*", "idictvalue", 10, 1, 0, 0, " cdicttype='xmyxqxx' ");
this.rdlValiditeTerm.DataTextField = "cdictname";
this.rdlValiditeTerm.DataValueField = "idictvalue";
this.rdlValiditeTerm.DataSource = dt;
this.rdlValiditeTerm.DataBind();
//2010-07-28 以上绑定项目有效期限
Tz888.BLL.Info.CapitalInfoBLL bll = new Tz888.BLL.Info.CapitalInfoBLL();
Tz888.Model.Info.CapitalSetModel model = new Tz888.Model.Info.CapitalSetModel();
model = bll.GetIntegrityModel(InfoID);
//07-28项目有效期限
this.rdlValiditeTerm.SelectedValue = model.MainInfoModel.ValidateTerm.ToString();
this.txtCapitalName.Text = model.MainInfoModel.Title;
this.rblCapitalType.SelectedValue = model.CapitalInfoModel.CapitalTypeID.Trim();;
string CooperationDemandType = model.CapitalInfoModel.CooperationDemandType;
string CooperationDemandTypeItems;
for (int i = 0; i < chkLstCooperationDemand.Items.Count; i++)
{
CooperationDemandTypeItems = chkLstCooperationDemand.Items[i].Value;
//CooperationDemandTypeItems += ",";
if (CooperationDemandType.IndexOf(CooperationDemandTypeItems) != -1)
{
chkLstCooperationDemand.Items[i].Selected = true;
}
}
if (!string.IsNullOrEmpty(model.MainInfoModel.KeyWord.Trim()))
{
string[] keys = model.MainInfoModel.KeyWord.Trim().Split(',');
for (int i = 0; i < keys.Length; i++)
{
string key = keys[i].ToString().Trim();
switch (i)
{
case 0:
this.txtKeyword1.Text = key;
break;
case 1:
this.txtKeyword2.Text = key;
break;
case 2:
this.txtKeyword3.Text = key;
break;
default:
break;
}
}
}
this.ZoneMoreSelectControl1.CapitalInfoAreaModels = model.CapitalInfoAreaModels;
this.SelectIndustryControl1.IndustryString = model.CapitalInfoModel.IndustryBID;
this.ImageUploadControl1.InfoList = model.InfoResourceModels;
this.ddlCurrency.SelectedValue = model.CapitalInfoModel.Currency.Trim();;
this.ddlCapital.SelectedValue = model.CapitalInfoModel.CapitalID;
this.txtCapitalIntent.Value = Tz888.Common.Utility.PageValidate.FiltrateHTMLTag(Tz888.Common.Utility.PageValidate.HtmlToTxt(model.CapitalInfoModel.ComAbout));
// this.ddlValiditeTerm.SelectedValue = model.MainInfoModel.ValidateTerm.ToString();
this.CapitalAddressInfo1.InfoContact = model.InfoContactModel;
this.CapitalAddressInfo1.InfoContactMans = model.InfoContactManModels;
if (Request.UrlReferrer != null)
{
ViewState["strPrePage"] = Request.UrlReferrer.ToString();
}
else
{
ViewState["strPrePage"] = "";
}
ViewState["InfoID"] = model.MainInfoModel.InfoID;
ViewState["PublishT"] = model.MainInfoModel.publishT;
ViewState["ComBreif"] = model.CapitalInfoModel.ComBreif;
ViewState["AuditingStatus"] = model.MainInfoModel.AuditingStatus;
ViewState["HtmlFile"] = model.MainInfoModel.HtmlFile;
ViewState["ShortTitle"] = model.ShortInfoModel.ShortTitle;
ViewState["ShortContent"] = model.ShortInfoModel.ShortContent;
ViewState["ShortInfoControlID"] = model.ShortInfoModel.ShortInfoControlID;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Tz888.Model.Info.CapitalSetModel model = new Tz888.Model.Info.CapitalSetModel();
model.InfoContactModel = this.CapitalAddressInfo1.InfoContact;
model.InfoContactManModels = this.CapitalAddressInfo1.InfoContactMans;
model.CapitalInfoAreaModels = this.ZoneMoreSelectControl1.CapitalInfoAreaModels;
#region 投资信息实体赋值
model.CapitalInfoModel.ComAbout = this.txtCapitalIntent.Value.Trim();
model.CapitalInfoModel.CapitalTypeID = this.rblCapitalType.SelectedValue;
model.CapitalInfoModel.Currency = this.ddlCurrency.SelectedValue;
model.CapitalInfoModel.CapitalID = this.ddlCapital.SelectedValue;
model.CapitalInfoModel.ComBreif = this.ViewState["ComBreif"].ToString();
model.CapitalInfoModel.IndustryBID = this.SelectIndustryControl1.IndustryString;
model.CapitalInfoModel.CooperationDemandType = "";
for (int i = 0; chkLstCooperationDemand.Items.Count > i; i++)
{
if (chkLstCooperationDemand.Items[i].Selected)
{
model.CapitalInfoModel.CooperationDemandType += chkLstCooperationDemand.Items[i].Value + ",";
}
}
#endregion
model.MainInfoModel.InfoID = Convert.ToInt64(this.ViewState["InfoID"]);
if (!string.IsNullOrEmpty(this.txtCapitalName.Text.Trim()))
{
model.MainInfoModel.Title = this.txtCapitalName.Text.Trim();
}
model.MainInfoModel.publishT = Convert.ToDateTime(this.ViewState["PublishT"]);
model.MainInfoModel.LoginName = ""; //用户名称
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() + ",";
}
model.MainInfoModel.KeyWord = keyword;
model.MainInfoModel.Descript = "";
model.MainInfoModel.DisplayTitle = this.txtCapitalName.Text.Trim();
model.MainInfoModel.FrontDisplayTime = System.DateTime.Now;
model.MainInfoModel.ValidateStartTime = System.DateTime.Now.AddDays(1);
model.MainInfoModel.ValidateTerm = Convert.ToInt32(this.ddlValiditeTerm.SelectedValue.Trim());
model.MainInfoModel.TemplateID = "001";
model.MainInfoModel.HtmlFile = ViewState["HtmlFile"].ToString();
model.ShortInfoModel.ShortInfoControlID = Convert.ToString(ViewState["ShortInfoControlID"]);
model.ShortInfoModel.ShortTitle = ViewState["ShortTitle"].ToString();
model.ShortInfoModel.ShortContent = ViewState["ShortContent"].ToString();
model.ShortInfoModel.Remark = "";
List <Tz888.Model.Info.InfoResourceModel> infoResourceModels = Tz888.Common.InfoResourceManage.ImageTransfer("Image", "Capital", Tz888.Common.ResourceType.Image, Tz888.Common.ResourceProperty.InfoImage, ImageUploadControl1.InfoList);
if (infoResourceModels != null)
{
model.InfoResourceModels.AddRange(infoResourceModels);
}
Tz888.BLL.Info.CapitalInfoBLL bll = new Tz888.BLL.Info.CapitalInfoBLL();
if (bll.Update(model))
{
Tz888.Common.MessageBox.ShowAndRedirect(this.Page, "修改信息成功！", Request.Url.ToString());
}
else
{
Tz888.Common.MessageBox.ShowAndRedirect(this.Page, "修改信息失败！", Request.Url.ToString());
}
}
public string GetInfoContractDetail(string InfoID)
{
string cacheStr = "ContractDetail_" + InfoID;
if (HttpContext.Current.Cache[cacheStr] != null)
{
return(HttpContext.Current.Cache[cacheStr].ToString().Trim());
}
else
{
#region 获取资源的联系方式
//最终显示的信息
string sOut = "";
//免费的信息的内容
string sFree = "<a href='#88' onclick=\"javascript:GetContactDetail(" + InfoID + ");\" class='spaces' ><img src='/Web13/images/project/button_cklxfs.gif' width='150' height='30' align='absmiddle' /></a> <i></i>我的MSN在线，联系我：<img src='/web13/images/project/icon_msn.gif' width='29' height='26' align='absmiddle' /><i></i>或<i></i><a href=\"Javascript:alert('系统升级中。。。');\"> 给项目方留言></a><p>发布者：<a href='#'>1234</a><i></i><img src='/web13/images/project/icon_05.gif' width='15' height='12' /> <i></i> <a href=\"javascript:alert('系统升级中。。。');\">加为好友</a></p>|1";
//收费的信息内容
string sChange = "<a href=\"http://pay.topfo.com/order_item.aspx?InfoID=" + InfoID + "\" class=\"spaces\"><img src=\"/web13/images/project/button_ljgm.gif\" width=\"130\" height=\"30\" border=\"0\" align=\"absmiddle\" /></a><i></i><a href=\"http://member.topfo.com/PayManage/shopcar.aspx?InfoID=" + InfoID + "\" class=\"spaces\"><img src=\"/web13/images/project/button_flgwc.gif\" width=\"150\" height=\"30\" border=\"0\" align=\"absmiddle\" /></a><p color='#CCCCCC'>支持多种支付方式，资源若无效经中国招商投资网确认后可全额返还所付款项，请放心购买。</p>|2";
//当前用户名
string CurrentUserName = "";
CurrentUserName = User.Identity.Name.Trim();
//用户是否是拓富通会员
bool bIsTofMember = false;
if (User.IsInRole("GT1002"))
{
if (CurrentUserName.Trim() != "")
{
bIsTofMember = true;
}
}
Tz888.Model.Info.CapitalSetModel objCSM = new Tz888.Model.Info.CapitalSetModel();
Tz888.BLL.Info.CapitalInfoBLL ciBll = new Tz888.BLL.Info.CapitalInfoBLL();
objCSM = ciBll.GetIntegrityModel(long.Parse(InfoID));
if (objCSM.MainInfoModel.MainPointCount > 0)
{
//这是一条收费信息
if (bIsTofMember)
{
//是拓富通会员
bool bIsBuy = false;
bIsBuy = ciBll.bIsBuyInfoOfUser(CurrentUserName, InfoID);
if (bIsBuy)
{
//拓富通会员购买了此信息
sOut = sFree;
}
else
{
//拓富通会员没有购买了此信息
sOut = sChange;
}
}
else
{
//非拓富通会员
sOut = sChange;
}
}
else
{
//这是一条免费信息
sOut = sFree;
}
//return sOut;
#endregion
HttpContext.Current.Cache.Insert(cacheStr, sOut.ToString().Trim(), null, System.Web.Caching.Cache.NoAbsoluteExpiration, TimeSpan.FromDays(7));
return(sOut.ToString().Trim());
}
}