/// <summary> /// 获取某条信息的标题 /// </summary> /// <param name="infoID">信息ID</param> /// <param name="title">标题</param> /// <param name="info">某条信息</param> public void GetTitle(Tz888.Model.Info.MainInfoModel model, ref string title, string NewsLblStatus) { long currentPage = 1; long pageCount = 0; DataView dvInfo = Tz888.BLL.Info.Common.GetListByInfoType(model.InfoTypeID, "*", "InfoID=" + model.InfoID, "", ref currentPage, 1, ref pageCount ); if (dvInfo.Count == 0) { throw new Exception("没有找到id=" + model.InfoID.ToString() + "信息."); } if (NewsLblStatus == "0") { title = title + "-" + dvInfo[0]["AreaName"].ToString().Trim() + "-" + dvInfo[0]["NewsTypeName"].ToString().Trim() + "- 资讯频道 - 中国招商投资网"; } else { title = title + "-" + dvInfo[0]["NewsIndustryName"].ToString().Trim() + "-" + dvInfo[0]["NewsTypeName"].ToString().Trim() + "- 资讯频道 - 中国招商投资网"; } }
/// <summary> /// 添加案例信息 /// </summary> /// <param name="mainInfoModel">主表</param> /// <param name="casesInfoModel">案例表</param> /// <param name="shortInfoModel">短信表</param> /// <param name="infoResourceModels">图片</param> /// <returns></returns> public long insert(Tz888.Model.Info.MainInfoModel mainInfoModel, Tz888.Model.CasesInfoTab casesInfoModel, Tz888.Model.Info.ShortInfoModel shortInfoModel, List <Tz888.Model.Info.InfoResourceModel> infoResourceModels) { return(dal.insert(mainInfoModel, casesInfoModel, shortInfoModel, infoResourceModels)); }
/// <summary> /// 修改案例信息 /// </summary> /// <param name="mainInfoModel">主表</param> /// <param name="casesInfoModel">案例表</param> /// <param name="shortInfoModel">短信表</param> /// <param name="infoResourceModels">图片</param> /// <returns></returns> public long update(Tz888.Model.Info.MainInfoModel mainInfoModel, Tz888.Model.CasesInfoTab casesInfoModel, Tz888.Model.Info.ShortInfoModel shortInfoModel, List <Tz888.Model.Info.InfoResourceModel> infoResourceModels, int infodd) { return(dal.update(mainInfoModel, casesInfoModel, shortInfoModel, infoResourceModels, infodd)); }
/// <summary> /// 查主表信息 /// </summary> /// <param name="infoId"></param> /// <returns></returns> public Tz888.Model.Info.MainInfoModel selMainInfo(int infoId) { Tz888.Model.Info.MainInfoModel MainInfo = new Tz888.Model.Info.MainInfoModel(); string sql = "select Title,IsCore,Hit,AuditingStatus,KeyWord,Descript,DisplayTitle,ValidateTerm from MainInfoTab where InfoID=@infoId"; SqlParameter[] para = { new SqlParameter("@infoId", SqlDbType.Int, 8) }; para[0].Value = infoId; DataSet ds = DbHelperSQL.Query(sql, para); if (ds != null & ds.Tables[0].Rows.Count > 0) { MainInfo.Title = ds.Tables[0].Rows[0]["Title"].ToString(); MainInfo.Hit = Convert.ToInt32(ds.Tables[0].Rows[0]["Hit"].ToString()); MainInfo.AuditingStatus = Convert.ToInt32(ds.Tables[0].Rows[0]["AuditingStatus"].ToString()); MainInfo.KeyWord = ds.Tables[0].Rows[0]["KeyWord"].ToString(); MainInfo.IsCore = Convert.ToBoolean(ds.Tables[0].Rows[0]["IsCore"].ToString()); MainInfo.Descript = ds.Tables[0].Rows[0]["Descript"].ToString(); MainInfo.DisplayTitle = ds.Tables[0].Rows[0]["DisplayTitle"].ToString(); MainInfo.ValidateTerm = Convert.ToInt32(ds.Tables[0].Rows[0]["ValidateTerm"].ToString()); } return(MainInfo); }
/// <summary> /// 创业信息修改 /// </summary> /// <param name="mainInfoModel"></param> /// <param name="opportunity"></param> /// <param name="shortInfoModel"></param> /// <returns></returns> public long Update(Tz888.Model.Info.MainInfoModel mainInfoModel, Tz888.Model.Info.CarveOutInfoTabModel CarveMode, Tz888.Model.Info.ShortInfoModel shortInfoModel ) { return(dal.Update(mainInfoModel, CarveMode, shortInfoModel)); }
/// <summary> /// 商机信息发布 /// </summary> /// <param name="mainInfoModel"></param> /// <param name="opportunity"></param> /// <param name="shortInfoModel"></param> /// <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)); }
/// <summary> /// 发布需求信息 /// </summary> /// <param name="mainInfoModel"></param> /// <param name="model">发布需求信息</param> /// <returns></returns> public long ReleaseInsert( Tz888.Model.Info.MainInfoModel mainInfoModel, Tz888.Model.BusinesProcess model, Tz888.Model.Info.ShortInfoModel shortInfoModel) { return(dal.ReleaseInsert(mainInfoModel, model, shortInfoModel)); }
/// <summary> /// 新属性 股权 发布 第一步 /// </summary> /// <param name="mainInfoModel"></param> /// <param name="projectInfoModel"></param> /// <returns></returns> public long PublishProjectGQ1( Tz888.Model.Info.MainInfoModel mainInfoModel, Tz888.Model.Info.ProjectInfoModel projectInfoModel, Tz888.Model.Info.ShortInfoModel shortInfoModel) { return(dal.PublishProjectGQ1(mainInfoModel, projectInfoModel, shortInfoModel)); }
/// <summary> /// 增加一条数据 申请提供专业服务 /// </summary> public long OfferInsert( Tz888.Model.Info.MainInfoModel mainInfoModel, Tz888.Model.UserInfoZ model, Tz888.Model.Info.ShortInfoModel shortInfoModel) { return(dal.OfferInsert(mainInfoModel, model, shortInfoModel)); }
/// <summary> /// 添加融资资源信息最新 /// </summary> public long InsertNew( Tz888.Model.Info.MainInfoModel mainInfoModel, Tz888.Model.Info.ProjectInfoModel projectInfoModel, Tz888.Model.Info.InfoContactModel infoContactModel, List <Tz888.Model.Info.InfoResourceModel> infoResourceModels ) { return(dal.InsertNew(mainInfoModel, projectInfoModel, infoContactModel, infoResourceModels)); }
/// <summary> /// 新属性 股权 发布(包括上传文件) /// </summary> /// <param name="mainInfoModel"></param> /// <param name="projectInfoModel"></param> /// <returns></returns> public long PublishProjectGQ1( Tz888.Model.Info.MainInfoModel mainInfoModel, Tz888.Model.Info.ProjectInfoModel projectInfoModel, Tz888.Model.Info.ShortInfoModel shortInfoModel, List <Tz888.Model.Info.InfoResourceModel> infoResourceModels ) { return(dal.PublishProjectGQ1(mainInfoModel, projectInfoModel, shortInfoModel, infoResourceModels)); }
/// <summary> /// 招商信息发布 /// </summary> /// <param name="mainInfoModel"></param> /// <param name="merchantInfoModel"></param> /// <param name="infoContactModel"></param> /// <param name="shortInfoModel"></param> /// <param name="infoContactManModels"></param> /// <param name="infoResourceModels"></param> /// <returns></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 ) { return(dal.Insert(mainInfoModel, merchantInfoModel, infoContactModel, shortInfoModel, infoResourceModels)); }
/// <summary> /// 投资信息发布 /// </summary> /// <param name="mainInfoModel"></param> /// <param name="capitalInfoModel"></param> /// <param name="infoContactModel"></param> /// <param name="shortInfoModel"></param> /// <param name="capitalInfoAreaModels"></param> /// <param name="infoContactManModels"></param> /// <returns></returns> public long Insert( Tz888.Model.Info.MainInfoModel mainInfoModel, Tz888.Model.Info.V124.CapitalInfoModel capitalInfoModel, Tz888.Model.Info.InfoContactModel infoContactModel, Tz888.Model.Info.ShortInfoModel shortInfoModel, List <Tz888.Model.Info.CapitalInfoAreaModel> capitalInfoAreaModels, // List<Tz888.Model.Info.InfoContactManModel> infoContactManModelsm, List <Tz888.Model.Info.InfoResourceModel> infoResourceModels ) { // return dal.Insert(mainInfoModel, capitalInfoModel, infoContactModel, shortInfoModel, capitalInfoAreaModels, infoContactManModelsm,infoResourceModels); return(dal.Insert(mainInfoModel, capitalInfoModel, infoContactModel, shortInfoModel, capitalInfoAreaModels, infoResourceModels)); }
/// <summary> /// 获取某条信息的关键字,标题,网页描述 /// </summary> /// <param name="infoID">信息ID</param>http://localhost:3200/InterFace/Info/Employee/EliteView.aspx /// <param name="keyWord">关键字</param> /// <param name="title">标题</param> /// <param name="description">网页描述</param> /// <param name="contentKeyWord">内容关键字</param> /// <param name="info">某条信息</param> public void GetKeyWordTitleDes(Tz888.Model.Info.MainInfoModel model, ref string keyWord, ref string title, ref string description) { long currentPage = 1; long pageCount = 0; DataView dv = GetList(model.InfoID, 0); if (dv == null || dv.Count == 0) { Tz888.BLL.Info.SetDefaultValue defaultValueObj = new SetDefaultValue(); dv = defaultValueObj.GetValue(model); if (dv == null || dv.Count == 0) { return; } } DataView dvInfo = Tz888.BLL.Info.Common.GetListByInfoType(model.InfoTypeID, "*", "InfoID=" + model.InfoID, "", ref currentPage, 1, ref pageCount ); if (dvInfo.Count == 0) { throw new Exception("没有找到id=" + model.InfoID.ToString() + "信息."); } //生成关键字 dv.RowFilter = "DefType=2 OR DefType=3 OR DefType=6 OR DefType=7"; dv.Sort = "Seq"; keyWord = GetStr(dv, keyWord, dvInfo, ',', dvInfo[0]["contentKeyWord"].ToString()); //生成标题 dv.RowFilter = "DefType=1 OR DefType=3 OR DefType=5 OR DefType=7"; title = GetStr(dv, title, dvInfo, '-', ""); //生成描述 if (description.Trim() == "") { dv.RowFilter = "DefType=4 OR DefType=5 OR DefType=6 OR DefType=7"; description = GetStr(dv, "", dvInfo, ',', ""); } }
public DataView DefaultViewDataBind(Tz888.Model.Info.MainInfoModel model) { Tz888.BLL.Info.SetDefaultValue bll = new Tz888.BLL.Info.SetDefaultValue(); DataView dv = bll.GetValue(model); if (dv != null && dv.Count > 0) { for (int i = 0; i < dv.Count; i++) { if (dv[i]["FromColumn"].ToString().Trim() != "") { dv[i]["FromColumnName"] = dv[i]["FromColumnName"].ToString().Trim() + "[字段]"; } } } return(dv); }
/// <summary> /// 取与某条信息最相关的的参数定义表 /// </summary> /// <param name="info">某条具体的信息</param> /// <returns>返回相应的关键字等参数定义表</returns> public DataView GetValue(Tz888.Model.Info.MainInfoModel model) { Tz888.Model.Info.DefaultValueModel model1 = new Tz888.Model.Info.DefaultValueModel(); model1.InfoTypeID = model.InfoTypeID; string subTypeID1 = ""; string subTypeID2 = ""; SetInfoTypeRef.GetSubTypeID(model1.InfoTypeID, ref subTypeID1, ref subTypeID2); Type infoObjType = model.GetType(); if (subTypeID1 != "") { System.Reflection.PropertyInfo pi = infoObjType.GetProperty(subTypeID1); if (pi != null) { model1.SubTypeID1 = pi.GetValue(model, null).ToString().Trim(); } if (subTypeID2 != "") { pi = infoObjType.GetProperty(subTypeID2); if (pi != null) { model1.SubTypeID2 = pi.GetValue(model, null).ToString().Trim(); } } } if (model1.SubTypeID1 == null) { model1.SubTypeID1 = ""; } if (model1.SubTypeID2 == null) { model1.SubTypeID2 = ""; } return(GetValue(model1)); }
public long Update(Tz888.Model.Info.MainInfoModel mainInfoModel, Tz888.Model.zx.NewsTabModel News, Tz888.Model.Info.ShortInfoModel shortInfoModel) { return(dal.Update(mainInfoModel, News, shortInfoModel)); }
/// <summary> /// 资讯信息发布 /// </summary> /// <param name="mainInfoModel"></param> /// <param name="News"></param> /// <param name="shortInfoModel"></param> /// <returns></returns> public long Insert(Tz888.Model.Info.MainInfoModel mainInfoModel, CapitalInfoModel CapitalInfoModel, Tz888.Model.Info.ShortInfoModel shortInfoModel) { return(dal.Insert(mainInfoModel, CapitalInfoModel, shortInfoModel)); }
/// <summary> /// 更新信息 /// </summary> /// <param name="mainInfoModel"></param> /// <param name="CarveOut"></param> /// <param name="shortInfoModel"></param> /// <returns></returns> public long Update(Tz888.Model.Info.MainInfoModel mainInfoModel, CapitalInfoModel CapitalInfoModel, Tz888.Model.Info.ShortInfoModel shortInfoModel) { return(dal.Update(mainInfoModel, CapitalInfoModel, shortInfoModel)); }
public bool update(Tz888.Model.Info.MainInfoModel mainInfoModel, Tz888.Model.BusinesProcess model, Tz888.Model.Info.ShortInfoModel shortInfoModel) { return(dal.update(mainInfoModel, model, shortInfoModel)); }
/// <summary> /// 添加案例信息 /// </summary> /// <param name="mainInfoModel">主表</param> /// <param name="casesInfoModel">案例表</param> /// <param name="shortInfoModel">短信表</param> /// <param name="infoResourceModels">图片</param> /// <returns></returns> public long insert(Tz888.Model.Info.MainInfoModel mainInfoModel, Tz888.Model.CasesInfoTab casesInfoModel, Tz888.Model.Info.ShortInfoModel shortInfoModel, List <Tz888.Model.Info.InfoResourceModel> infoResourceModels) { 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("@CasesTypeID", SqlDbType.Char, 10), new SqlParameter("@Content", SqlDbType.Text), new SqlParameter("@Pic1", SqlDbType.VarChar, 100), new SqlParameter("@Pic2", SqlDbType.VarChar, 100), // 短内容信息表 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 = 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 = 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 = casesInfoModel.CasesTypeID; parameters[26].Value = casesInfoModel.Content; parameters[27].Value = ""; parameters[28].Value = ""; parameters[29].Value = shortInfoModel.ShortInfoControlID; parameters[30].Value = shortInfoModel.ShortTitle; parameters[31].Value = shortInfoModel.ShortContent; parameters[32].Value = shortInfoModel.Remark; int rowsAffected; long infoID; using (SqlConnection sqlConn = DbHelperSQL.GetSqlConnection()) { sqlConn.Open(); SqlTransaction sqlTran = sqlConn.BeginTransaction(); try { //插入融资(项目)资源信息 DbHelperSQL.RunProcedure(sqlConn, sqlTran, "CasesInfoTab_Insert", parameters, out rowsAffected); infoID = (long)parameters[0].Value; if (infoID < 0) { throw new Exception(); } //将上传文件 if (infoResourceModels != null) { int iUploadCount = 0; //记录上传数 //为投资信息添加多个资源 Tz888.SQLServerDAL.Info.InfoResourceDAL obj3 = new Tz888.SQLServerDAL.Info.InfoResourceDAL(); foreach (Tz888.Model.Info.InfoResourceModel model in infoResourceModels) { model.InfoID = infoID; if (obj3.InsertInfoResource(sqlConn, sqlTran, model, 1)) { iUploadCount += 1; } } //没有成功 if (iUploadCount != infoResourceModels.Count) { return(0); } } sqlTran.Commit(); } catch (Exception ex) { sqlTran.Rollback(); infoID = -1; throw ex; } finally { sqlConn.Close(); } } return(infoID); }
public long OfferInsert( Tz888.Model.Info.MainInfoModel mainInfoModel, Tz888.Model.UserInfoZ model, Tz888.Model.Info.ShortInfoModel shortInfoModel) { SqlParameter[] parameters = { //---------------------资源信息主体---------------------- new SqlParameter("@InfoID", SqlDbType.BigInt, 8), new SqlParameter("@HtmlFile", SqlDbType.VarChar, 100), //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("@ValidateTerm", SqlDbType.Int, 4), new SqlParameter("@TemplateID", SqlDbType.Char, 10), //new SqlParameter("@Descript", SqlDbType.NChar,2000), //new SqlParameter("@DisplayTitle", SqlDbType.VarChar,50), new SqlParameter("@FrontDisplayTime", SqlDbType.SmallDateTime), new SqlParameter("@ValidateStartTime", SqlDbType.SmallDateTime), new SqlParameter("@Descript", SqlDbType.NVarChar, 100), //---------------------------END--------------------------- //-------------------------短信息-------------------------- new SqlParameter("@ShortTitle", SqlDbType.VarChar, 100), new SqlParameter("@ShortContent", SqlDbType.VarChar, 100), new SqlParameter("@strRemark", SqlDbType.VarChar, 50), new SqlParameter("@ShortInfoControlID", SqlDbType.Char, 20), //---------------------------END--------------------------- //-----------------------申请提供服务详细信息----------------- new SqlParameter("@CompanyName", SqlDbType.VarChar, 50), new SqlParameter("@CountryCode", SqlDbType.VarChar, 10), new SqlParameter("@ProvinceID", SqlDbType.VarChar, 10), new SqlParameter("@CityID", SqlDbType.VarChar, 10), new SqlParameter("@CountyID", SqlDbType.VarChar, 10), new SqlParameter("@ServiesBID", SqlDbType.VarChar, 150), new SqlParameter("@ServiesMID", SqlDbType.VarChar, 150), new SqlParameter("@EmployeeCount", SqlDbType.Int, 4), new SqlParameter("@RegistMoeny", SqlDbType.Float, 8), new SqlParameter("@RegistYear", SqlDbType.Float, 8), new SqlParameter("@Turnover", SqlDbType.Float, 8), new SqlParameter("@BusinesDetails", SqlDbType.VarChar, 500), new SqlParameter("@WebSite", SqlDbType.VarChar, 100), new SqlParameter("@LinkMan", SqlDbType.VarChar, 20), new SqlParameter("@LinkTel", SqlDbType.VarChar, 20), new SqlParameter("@LinkFax", SqlDbType.VarChar, 20), new SqlParameter("@Email", SqlDbType.VarChar, 50), new SqlParameter("@CompanyAbout", SqlDbType.Text), new SqlParameter("@isOpen", SqlDbType.Bit), new SqlParameter("@AuditStatus", SqlDbType.Int), new SqlParameter("@AuditMan", SqlDbType.VarChar, 20), new SqlParameter("@ContactDefault", SqlDbType.Bit), new SqlParameter("@StructID", SqlDbType.VarChar, 10), //---------------------------END--------------------------- }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = mainInfoModel.HtmlFile; 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.ValidateTerm; parameters[19].Value = mainInfoModel.TemplateID; //parameters[18].Value = mainInfoModel.Descript; //parameters[19].Value = mainInfoModel.DisplayTitle; parameters[20].Value = mainInfoModel.FrontDisplayTime; parameters[21].Value = mainInfoModel.ValidateStartTime; parameters[22].Value = mainInfoModel.Descript; parameters[23].Value = shortInfoModel.ShortTitle; parameters[24].Value = shortInfoModel.ShortContent; parameters[25].Value = shortInfoModel.Remark; parameters[26].Value = shortInfoModel.ShortInfoControlID; // parameters[26].Value = model.UserName; parameters[27].Value = model.CompanyName; parameters[28].Value = model.CountryCode; parameters[29].Value = model.ProvinceID; parameters[30].Value = model.CityID; parameters[31].Value = model.CountyID; parameters[32].Value = model.ServiesBID; parameters[33].Value = model.ServiesMID; parameters[34].Value = model.EmployeeCount; parameters[35].Value = model.RegistMoeny; parameters[36].Value = model.RegistYear; parameters[37].Value = model.Turnover; parameters[38].Value = model.BusinesDetails; parameters[39].Value = model.WebSite; parameters[40].Value = model.LinkMan; parameters[41].Value = model.LinkTel; parameters[42].Value = model.LinkFax; parameters[43].Value = model.Email; parameters[44].Value = model.CompanyAbout; parameters[45].Value = model.isOpen; parameters[46].Value = model.AuditStatus; parameters[47].Value = model.AuditMan; parameters[48].Value = model.ContactDefault; parameters[49].Value = model.Structid; int rowsAffected; long infoID; using (SqlConnection sqlConn = DbHelperSQL.GetSqlConnection()) { sqlConn.Open(); SqlTransaction sqlTran = sqlConn.BeginTransaction(); try { //插入融资(项目)资源信息 DbHelperSQL.RunProcedure(sqlConn, sqlTran, "Offer_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> /// <param name="mainInfoModel">主信息表</param> /// <param name="Carve">创业表</param> /// <param name="shortInfoModel">短信息表</param> /// <returns></returns> public long Update(Tz888.Model.Info.MainInfoModel mainInfoModel, CarveOutInfoTabModel CarveModel, 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("@CarveOutInfoType", SqlDbType.Char, 10), //new SqlParameter("@InfoID", SqlDbType.BigInt,8), new SqlParameter("@AdTitle", SqlDbType.VarChar, 80), new SqlParameter("@CountryCode", SqlDbType.Char, 10), new SqlParameter("@ProvinceID", SqlDbType.Char, 10), new SqlParameter("@CountyID", SqlDbType.Char, 10), new SqlParameter("@IndustryCarveOutID", SqlDbType.Char, 10), new SqlParameter("@CapitalID", SqlDbType.Char, 10), new SqlParameter("@InvestObject", SqlDbType.Char, 10), new SqlParameter("@ValidateID", SqlDbType.Char, 10), new SqlParameter("@Content", SqlDbType.Text), new SqlParameter("@InvestReturn", SqlDbType.Text), new SqlParameter("@Pic1", SqlDbType.VarChar, 100), 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("@CityID", SqlDbType.Char, 10), // 短内容信息表 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("@AuditingStatus", SqlDbType.TinyInt), }; 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 = mainInfoModel.GradeID; 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 = CarveModel.CarveOutInfoType; parameters[26].Value = CarveModel.AdTitle; parameters[27].Value = CarveModel.CountryCode; if (CarveModel.ProvinceID == "") { parameters[28].Value = System.DBNull.Value; } else { parameters[28].Value = CarveModel.ProvinceID; } if (CarveModel.CountyID == "") { parameters[29].Value = System.DBNull.Value; } else { parameters[29].Value = CarveModel.CountyID; } parameters[30].Value = CarveModel.IndustryCarveOutID; parameters[31].Value = CarveModel.CapitalID; parameters[32].Value = CarveModel.InvestObject; parameters[33].Value = CarveModel.ValidateID; parameters[34].Value = CarveModel.Content; parameters[35].Value = CarveModel.InvestReturn; parameters[36].Value = CarveModel.Pic1; parameters[37].Value = CarveModel.Remark; parameters[38].Value = CarveModel.ComName; parameters[39].Value = CarveModel.LinkMan; parameters[40].Value = CarveModel.Tel; parameters[41].Value = CarveModel.Fax; parameters[42].Value = CarveModel.Mobile; parameters[43].Value = CarveModel.Address; parameters[44].Value = CarveModel.PostCode; parameters[45].Value = CarveModel.Email; parameters[46].Value = CarveModel.WebSite; parameters[47].Value = CarveModel.CityID; parameters[48].Value = shortInfoModel.ShortInfoControlID; parameters[49].Value = shortInfoModel.ShortTitle; parameters[50].Value = shortInfoModel.ShortContent; parameters[51].Value = shortInfoModel.Remark; parameters[52].Value = mainInfoModel.AuditingStatus; int rowsAffected; long infoID; using (SqlConnection sqlConn = DbHelperSQL.GetSqlConnection()) { sqlConn.Open(); SqlTransaction sqlTran = sqlConn.BeginTransaction(); try { DbHelperSQL.RunProcedure(sqlConn, sqlTran, "CarveOutShenH_Update", 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); }
public long Update(Tz888.Model.Info.MainInfoModel mainInfoModel, NewsTabModel News, 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("@InfoID", SqlDbType.BigInt,8), new SqlParameter("@NewsTypeID", SqlDbType.Char, 10), new SqlParameter("@subTitle", SqlDbType.VarChar, 100), new SqlParameter("@NewsLblStatus", SqlDbType.Char, 10), new SqlParameter("@AreaID", SqlDbType.Char, 10), new SqlParameter("@NewsIndustryID", SqlDbType.Char, 10), new SqlParameter("@Origin", SqlDbType.VarChar, 100), new SqlParameter("@Author", SqlDbType.VarChar, 20), //new SqlParameter("@Keyword", SqlDbType.VarChar,50), new SqlParameter("@RedirectUrl", SqlDbType.VarChar, 100), new SqlParameter("@IsRedirect", SqlDbType.Bit, 1), new SqlParameter("@Summary", SqlDbType.Text), new SqlParameter("@Content", SqlDbType.Text), new SqlParameter("@Pic1", SqlDbType.VarChar, 100), new SqlParameter("@PicAbout", SqlDbType.VarChar, 60), new SqlParameter("@PageStatus", SqlDbType.Int, 4), new SqlParameter("@PageCharCount", SqlDbType.BigInt, 8), new SqlParameter("@ResearchSpot", SqlDbType.Char, 10), //new SqlParameter("@ProvinceID", SqlDbType.Char,10), //new SqlParameter("@CityID", SqlDbType.Char,10), //new SqlParameter("@CountyID", SqlDbType.Char,10), //new SqlParameter("@activeAdress", SqlDbType.VarChar,100), //new SqlParameter("@activeDateFrom", SqlDbType.VarChar,30), //new SqlParameter("@activeDateTo", SqlDbType.VarChar,30), //new SqlParameter("@mainUnit", SqlDbType.VarChar,100), //new SqlParameter("@secondUnit", SqlDbType.VarChar,100), //new SqlParameter("@AuditingRemark", SqlDbType.VarChar,100), // 短内容信息表 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("@AuditingStatus", 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[15].Value = mainInfoModel.GradeID; parameters[16].Value = mainInfoModel.FixPriceID; //付费 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 = News.NewsTypeID; parameters[26].Value = News.subTitle; parameters[27].Value = News.NewsLblStatus; parameters[28].Value = News.AreaID; parameters[29].Value = News.NewsIndustryID; parameters[30].Value = News.Origin; parameters[31].Value = News.Author; //parameters[32].Value = AlterKeyWord(mainInfoModel.KeyWord); parameters[33].Value = News.RedirectUrl; parameters[33].Value = News.IsRedirect; parameters[34].Value = News.Summary; parameters[35].Value = News.Content; parameters[36].Value = News.Pic1; parameters[37].Value = News.PicAbout; parameters[38].Value = News.PageStatus; parameters[39].Value = News.PageCharCount; parameters[40].Value = News.ResearchSpot; //parameters[42].Value = News.ProvinceID; //parameters[43].Value = News.CityID; //parameters[44].Value = News.CountyID; //parameters[45].Value = News.activeAdress; //parameters[46].Value = News.activeDateFrom; //parameters[47].Value = News.activeDateTo; //parameters[48].Value = News.mainUnit; //parameters[49].Value = News.secondUnit; //parameters[50].Value = News.AuditingRemark; parameters[41].Value = shortInfoModel.ShortInfoControlID; parameters[42].Value = shortInfoModel.ShortTitle; parameters[43].Value = shortInfoModel.ShortContent; parameters[44].Value = shortInfoModel.Remark; parameters[45].Value = mainInfoModel.AuditingStatus; int rowsAffected; long infoID; using (SqlConnection sqlConn = DbHelperSQL.GetSqlConnection()) { sqlConn.Open(); SqlTransaction sqlTran = sqlConn.BeginTransaction(); try { DbHelperSQL.RunProcedure(sqlConn, sqlTran, "NewsTab_Update", 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); }
public bool update(Tz888.Model.Info.MainInfoModel mainInfoModel, Tz888.Model.UserInfoZ model, Tz888.Model.Info.ShortInfoModel shortInfoModel) { SqlParameter[] parameters = { //-------------------------短信息-------------------------- new SqlParameter("@ShortTitle", SqlDbType.VarChar, 100), //---------------------------END--------------------------- //---------------------资源信息主体---------------------- new SqlParameter("@Title", SqlDbType.VarChar, 100), new SqlParameter("@InfoCode", SqlDbType.Char, 30), new SqlParameter("@Descript", SqlDbType.NVarChar, 2000), //---------------------------END--------------------------- //-----------------------申请提供服务详细信息----------------- new SqlParameter("@CountryCode", SqlDbType.VarChar, 10), new SqlParameter("@ProvinceID", SqlDbType.VarChar, 10), new SqlParameter("@CityID", SqlDbType.VarChar, 10), new SqlParameter("@CountyID", SqlDbType.VarChar, 10), new SqlParameter("@Email", SqlDbType.VarChar, 50), new SqlParameter("@ServiesBID", SqlDbType.VarChar, 150), new SqlParameter("@ServiesMID", SqlDbType.VarChar, 150), new SqlParameter("@EmployeeCount", SqlDbType.Int, 4), new SqlParameter("@RegistMoeny", SqlDbType.Float, 8), new SqlParameter("@RegistYear", SqlDbType.Float, 8), new SqlParameter("@Turnover", SqlDbType.Float, 8), new SqlParameter("@BusinesDetails", SqlDbType.VarChar, 500), new SqlParameter("@WebSite", SqlDbType.VarChar, 100), new SqlParameter("@LinkMan", SqlDbType.VarChar, 20), new SqlParameter("@LinkTel", SqlDbType.VarChar, 20), new SqlParameter("@LinkFax", SqlDbType.VarChar, 20), new SqlParameter("@InfoID", SqlDbType.Int), new SqlParameter("@StructID", SqlDbType.VarChar, 10), new SqlParameter("@LoginName", SqlDbType.VarChar, 50), new SqlParameter("@flag", SqlDbType.VarChar, 50), //---------------------------END--------------------------- }; parameters[0].Value = shortInfoModel.ShortTitle; parameters[1].Value = mainInfoModel.Title; parameters[2].Value = mainInfoModel.InfoCode; parameters[3].Value = mainInfoModel.Descript; parameters[4].Value = model.CountryCode; parameters[5].Value = model.ProvinceID; parameters[6].Value = model.CityID; parameters[7].Value = model.CountyID; parameters[8].Value = model.Email; parameters[9].Value = model.ServiesBID; parameters[10].Value = model.ServiesMID; parameters[11].Value = model.EmployeeCount; parameters[12].Value = model.RegistMoeny; parameters[13].Value = model.RegistYear; parameters[14].Value = model.Turnover; parameters[15].Value = model.BusinesDetails; parameters[16].Value = model.WebSite; parameters[17].Value = model.LinkMan; parameters[18].Value = model.LinkTel; parameters[19].Value = model.LinkFax; parameters[20].Value = model.InfoID; parameters[21].Value = model.Structid; parameters[22].Value = model.UserName; parameters[23].Value = "userupdate"; return(DbHelperSQL.RunProcLob("OfferUpdate", parameters)); }
/// <summary> /// 资讯信息发布 /// </summary> /// <param name="mainInfoModel"></param> /// <param name="News"></param> /// <param name="shortInfoModel"></param> /// <returns></returns> public long Insert(Tz888.Model.Info.MainInfoModel mainInfoModel, Tz888.Model.Carveout.CarveOutInfoTabModel CarveOut, Tz888.Model.Info.ShortInfoModel shortInfoModel) { return(dal.Insert(mainInfoModel, CarveOut, shortInfoModel)); }
/// <summary> /// 修改一条数据 申请提供专业服务 /// </summary> public bool update(Tz888.Model.Info.MainInfoModel mainInfoModel, Tz888.Model.UserInfoZ model, Tz888.Model.Info.ShortInfoModel shortInfoModel) { return(dal.update(mainInfoModel, model, shortInfoModel)); }
/// <summary> /// 更新投资信息 /// </summary> /// <param name="mainInfoModel">主信息表实体类</param> /// <param name="MerchantModel">投资信息表实体类</param> /// <param name="shortInfoModel">短信息表实体类</param> /// <returns></returns> public long Update(Tz888.Model.Info.MainInfoModel mainInfoModel, CapitalInfoModel CapitalInfoModel, Tz888.Model.Info.ShortInfoModel shortInfoModel) { throw new Exception("The method or operation is not implemented."); }
public static string[][] InitKeywordTitleDes(System.Web.UI.Page page, long infoID, Tz888.Model.Info.MainInfoModel model, CheckBoxList chkKeyWord, CheckBoxList chkTitles, CheckBoxList chkDes, ref string defaultValueID) { bool isPostback = page.IsPostBack;//初始化时需要判断是否是PostBack ArrayList disableInputs = new ArrayList(); PageIniControl pic = new PageIniControl(); //注册ajax脚本 if (page.IsClientScriptBlockRegistered("ajaxInvokeadfsf") == false) { page.RegisterClientScriptBlock("ajaxInvokeadfsf", ajaxInvoke); } DataTable dt = null; if (isPostback == false) // || defaultValueID == null || defaultValueID == "" || defaultValueID == "0" ) { dt = pic.DefaultViewDataBind(model).Table; //Load对应信息类型的关键字等设置 if (dt != null && dt.Rows.Count > 0) { defaultValueID = dt.Rows[0]["ID"].ToString(); } else { return(new string[][] { new string[] {}, new string[] {}, new string[] {} }); } } else { if (defaultValueID == null || defaultValueID == "" || defaultValueID == "0") { return(new string[][] { new string[] {}, new string[] {}, new string[] {} }); //返回空串 } long currentPage = 1; long pageCount = 0; Tz888.BLL.Info.SetSubDefaultValueRule ssdv = new SetSubDefaultValueRule(); dt = (ssdv.GetList("ID as SubDefaultID,DefType,IsNeeded,IsDefaultSelect", "SetDefaultValueID=" + defaultValueID, "", ref currentPage, -1, ref pageCount)).Table; } bool isFirst = true;//这条信息第一次加载 //Load该信息的关键字等设置 Tz888.BLL.Info.InfoDefaultDEFRule infoDefault = new InfoDefaultDEFRule(); DataView dvInfoDefault = infoDefault.GetList(infoID, 0); DataView dvKeyWord = new DataView(dt); if (isPostback == false) { dvKeyWord.Sort = "Seq"; dvKeyWord.RowFilter = "DefType=2 OR DefType=3 OR DefType=6 OR DefType=7"; chkKeyWord.DataSource = dvKeyWord; chkKeyWord.DataBind(); //该信息的定义 dvInfoDefault.RowFilter = "DefType = 2"; for (int i = 0; i < dvInfoDefault.Count; i++) { string subDefaultValueID = dvInfoDefault[i]["SubDefaultValueID"].ToString().Trim(); ListItem li = chkKeyWord.Items.FindByValue(subDefaultValueID); if (li != null) { li.Selected = true; isFirst = false; } } } ArrayList keyDefaults = new ArrayList();//默认选择和必填项,ID的集合 //默认选择 for (int i = 0; i < dvKeyWord.Count; i++) { bool isDefaultSelect = Convert.ToBoolean(dvKeyWord[i]["IsDefaultSelect"]); bool isNeeded = Convert.ToBoolean(dvKeyWord[i]["IsNeeded"]); string subDefaultID = dvKeyWord[i]["SubDefaultID"].ToString().Trim(); if (isDefaultSelect || isNeeded) { keyDefaults.Add(subDefaultID); } if ((isDefaultSelect && isFirst) || isNeeded) { ListItem li = chkKeyWord.Items.FindByValue(subDefaultID); if (li != null) { if (isPostback == false) { li.Selected = true; } if (isNeeded) { disableInputs.Add(chkKeyWord.ClientID + "_" + chkKeyWord.Items.IndexOf(li).ToString()); } } } } dvKeyWord = null; //绑定Title isFirst = true; //这条信息第一次加载 ArrayList titleDefaults = new ArrayList(); //默认选择和必填项,ID的集合 DataView dvTitle = new DataView(dt); if (isPostback == false) { dvTitle.Sort = "Seq"; dvTitle.RowFilter = "DefType=1 OR DefType=3 OR DefType=5 OR DefType=7"; chkTitles.DataSource = dvTitle; chkTitles.DataBind(); dvInfoDefault.RowFilter = "DefType = 1"; for (int i = 0; i < dvInfoDefault.Count; i++) { string subDefaultValueID = dvInfoDefault[i]["SubDefaultValueID"].ToString().Trim(); ListItem li = chkTitles.Items.FindByValue(subDefaultValueID); if (li != null) { li.Selected = true; isFirst = false; } } } //默认选择 for (int i = 0; i < dvTitle.Count; i++) { bool isDefaultSelect = Convert.ToBoolean(dvTitle[i]["IsDefaultSelect"]); bool isNeeded = Convert.ToBoolean(dvTitle[i]["IsNeeded"]); string subDefaultID = dvTitle[i]["SubDefaultID"].ToString().Trim(); if (isDefaultSelect || isNeeded) { titleDefaults.Add(subDefaultID); } if ((isDefaultSelect && isFirst) || isNeeded) { ListItem li = chkTitles.Items.FindByValue(subDefaultID); if (li != null) { if (isPostback == false) { li.Selected = true; } if (isNeeded) { disableInputs.Add(chkTitles.ClientID + "_" + chkTitles.Items.IndexOf(li).ToString()); } } } } dvTitle = null; //绑定描述 isFirst = true;//这条信息第一次加载 DataView dvDes = new DataView(dt); if (isPostback == false) { dvDes.Sort = "Seq"; dvDes.RowFilter = "DefType=4 OR DefType=5 OR DefType=6 OR DefType=7"; chkDes.DataSource = dvDes; chkDes.DataBind(); dvInfoDefault.RowFilter = "DefType = 4"; for (int i = 0; i < dvInfoDefault.Count; i++) { string subDefaultValueID = dvInfoDefault[i]["SubDefaultValueID"].ToString().Trim(); ListItem li = chkDes.Items.FindByValue(subDefaultValueID); if (li != null) { li.Selected = true; isFirst = false; } } } //默认选择 ArrayList desDefaults = new ArrayList();//默认选择和必填项,ID的集合 for (int i = 0; i < dvDes.Count; i++) { bool isDefaultSelect = Convert.ToBoolean(dvDes[i]["IsDefaultSelect"]); bool isNeeded = Convert.ToBoolean(dvDes[i]["IsNeeded"]); string subDefaultID = dvDes[i]["SubDefaultID"].ToString().Trim(); if (isDefaultSelect || isNeeded) { desDefaults.Add(subDefaultID); } if ((isDefaultSelect && isFirst) || isNeeded) { ListItem li = chkDes.Items.FindByValue(subDefaultID); if (li != null) { if (isPostback == false) { li.Selected = true; } if (isNeeded) { disableInputs.Add(chkDes.ClientID + "_" + chkDes.Items.IndexOf(li).ToString()); } } } } dvDes = null; string disableInputStr = ""; for (int i = 0; i < disableInputs.Count; i++) { disableInputStr += @"'" + disableInputs[i].ToString() + @"',"; } if (disableInputStr != "")//注册禁用必选项的脚本 { disableInputStr = disableInputStr.TrimEnd(new char[] { ',' }); if (page.IsStartupScriptRegistered("DisabledScript") == false) { page.RegisterStartupScript("DisabledScritp", string.Format(DisableScript, disableInputStr)); } } string[][] allDefaults = new string[3][]; allDefaults[0] = new string[keyDefaults.Count]; allDefaults[1] = new string[titleDefaults.Count]; allDefaults[2] = new string[desDefaults.Count]; keyDefaults.CopyTo(allDefaults[0]); titleDefaults.CopyTo(allDefaults[1]); desDefaults.CopyTo(allDefaults[2]); return(allDefaults); }
/// <summary> /// 更新信息 /// </summary> /// <param name="mainInfoModel"></param> /// <param name="CarveOut"></param> /// <param name="shortInfoModel"></param> /// <returns></returns> public long Update(Tz888.Model.Info.MainInfoModel mainInfoModel, MerchantModel MerchantModel, Tz888.Model.Info.ShortInfoModel shortInfoModel) { return(dal.Update(mainInfoModel, MerchantModel, shortInfoModel)); }