/// <summary>
/// 查找短信信息表
/// </summary>
public ShortInfoModel SetShortInfo(int infoId)
{
ShortInfoModel shortInfo = new 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)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataRow row = ds.Tables[0].Rows[i];
shortInfo.ShortContent = row["ShortContent"].ToString();
shortInfo.ShortTitle = row["ShortTitle"].ToString();
}
}
return(shortInfo);
}
public long Update(MainInfoModel mainInfoModel, CarveOutInfoTabModel CarveModel, 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) };
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[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;
int rowsAffected;
long infoID;
using (SqlConnection sqlConn = DbHelperSQL.GetSqlConnection())
{
sqlConn.Open();
SqlTransaction sqlTran = sqlConn.BeginTransaction();
try
{
DbHelperSQL.RunProcedure(sqlConn, sqlTran, "CarveOutInfoTab_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);
}
