/// <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>
/// <param name="infoResourceModels"></param>
/// <returns></returns>
public long Insert(
Tz888.Model.Info.MainInfoModel mainInfoModel,
Tz888.Model.Info.CapitalInfoModel capitalInfoModel,
Tz888.Model.Info.InfoContactModel infoContactModel,
Tz888.Model.Info.ShortInfoModel shortInfoModel,
List <Tz888.Model.Info.CapitalInfoAreaModel> capitalInfoAreaModels,
// List<Tz888.Model.Info.InfoContactManModel> infoContactManModels,
List <Tz888.Model.Info.InfoResourceModel> infoResourceModels
)
{
// return dal.Insert(mainInfoModel, capitalInfoModel, infoContactModel, shortInfoModel, capitalInfoAreaModels, infoContactManModels, infoResourceModels);
return(dal.Insert(mainInfoModel, capitalInfoModel, infoContactModel, shortInfoModel, capitalInfoAreaModels, infoResourceModels));
}
/// <summary>
/// 查短信表信息
/// </summary>
/// <param name="infoId"></param>
/// <returns></returns>
public Tz888.Model.Info.ShortInfoModel selShortInfo(int infoId)
{
Tz888.Model.Info.ShortInfoModel shortInfo = new Tz888.Model.Info.ShortInfoModel();
string sql = "select ShortTitle,ShortContent from ShortInfoTab 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)
{
shortInfo.ShortTitle = ds.Tables[0].Rows[0]["ShortTitle"].ToString();
shortInfo.ShortContent = ds.Tables[0].Rows[0]["ShortContent"].ToString();
}
return(shortInfo);
}
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));
}
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);
}
public long Update(Tz888.Model.Info.MainInfoModel mainInfoModel, Tz888.Model.zx.NewsTabModel News, Tz888.Model.Info.ShortInfoModel shortInfoModel)
{
return(dal.Update(mainInfoModel, News, 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="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.");
}
/// <summary>
/// 资讯信息发布
/// </summary>
/// <param name="mainInfoModel"></param>
/// <param name="News"></param>
/// <param name="shortInfoModel"></param>
/// <returns></returns>
public long Insert(Tz888.Model.Info.MainInfoModel mainInfoModel, MerchantModel MerchantModel, Tz888.Model.Info.ShortInfoModel shortInfoModel)
{
return(dal.Insert(mainInfoModel, MerchantModel, 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));
}
/// <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);
}
/// <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="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);
}
/// <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));
}
/// <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="CarveOut"></param>
/// <param name="shortInfoModel"></param>
/// <returns></returns>
public long Update(Tz888.Model.Info.MainInfoModel mainInfoModel, Tz888.Model.Carveout.CarveOutInfoTabModel CarveOut, Tz888.Model.Info.ShortInfoModel shortInfoModel)
{
return(dal.Update(mainInfoModel, CarveOut, shortInfoModel));
}
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);
}
/// <summary>
/// 插入招商信息
/// </summary>
/// <param name="mainInfoModel">主信息表实体类</param>
/// <param name="MerchantModel">招商信息表实体类</param>
/// <param name="shortInfoModel">短信息表实体类</param>
/// <returns></returns>
public long Insert(Tz888.Model.Info.MainInfoModel mainInfoModel, MerchantModel MerchantModel, Tz888.Model.Info.ShortInfoModel shortInfoModel)
{
throw new Exception("The method or operation is not implemented.");
}
