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