/// <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));
}
public Tz888.Model.BusinesProcess getModel(int id)
{
Tz888.Model.BusinesProcess model = new Tz888.Model.BusinesProcess();
SqlParameter[] parameters = { new SqlParameter("@InfoID", SqlDbType.Int), };
parameters[0].Value = id;
DataSet ds = DbHelperSQL.RunProcedure("ReleaseGetModel", parameters, "Release");
DataTable dt = ds.Tables[0];
if (dt != null)
{
if (!string.IsNullOrEmpty(dt.Rows[0]["InfoID"].ToString()))
{
model.InfoID = int.Parse(dt.Rows[0]["InfoID"].ToString());
}
if (!string.IsNullOrEmpty(dt.Rows[0]["Price"].ToString()))
{
model.Price = decimal.Parse(dt.Rows[0]["Price"].ToString());
}
}
model.ProvinceID = dt.Rows[0]["ProvinceID"].ToString();
if (!string.IsNullOrEmpty(dt.Rows[0]["ServiesBID"].ToString()))
{
model.ServiesBID = int.Parse(dt.Rows[0]["ServiesBID"].ToString());
}
if (!string.IsNullOrEmpty(dt.Rows[0]["ServiesMID"].ToString()))
{
model.ServiesMID = int.Parse(dt.Rows[0]["ServiesMID"].ToString());
}
model.SubmitMan = dt.Rows[0]["SubmitMan"].ToString();
model.Tel = dt.Rows[0]["Tel"].ToString();
model.Title = dt.Rows[0]["Title"].ToString();
model.UserName = dt.Rows[0]["UserName"].ToString();
model.Fax = dt.Rows[0]["Fax"].ToString();
model.Email = dt.Rows[0]["Email"].ToString();
model.Descript = dt.Rows[0]["Descript"].ToString();
if (!string.IsNullOrEmpty(dt.Rows[0]["CreateDate"].ToString()))
{
model.CreateDate = DateTime.Parse(dt.Rows[0]["CreateDate"].ToString());
}
model.CountyID = dt.Rows[0]["CountyID"].ToString();
model.CountryCode = dt.Rows[0]["CountryCode"].ToString();
model.CompanyName = dt.Rows[0]["CompanyName"].ToString();
model.CityID = dt.Rows[0]["CityID"].ToString();
if (!string.IsNullOrEmpty(dt.Rows[0]["AuditStatus"].ToString()))
{
model.AuditStatus = int.Parse(dt.Rows[0]["AuditStatus"].ToString());
}
model.Address = dt.Rows[0]["Address"].ToString();
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Tz888.Model.BusinesProcess model)
{
SqlParameter[] parameters =
{
new SqlParameter("@flag", SqlDbType.VarChar, 30),
new SqlParameter("@UserName", SqlDbType.VarChar, 16),
new SqlParameter("@Title", SqlDbType.VarChar, 50),
new SqlParameter("@CompanyName", SqlDbType.VarChar, 50),
new SqlParameter("@SubmitMan", SqlDbType.VarChar, 16),
new SqlParameter("@Descript", SqlDbType.VarChar, 300),
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("@Address", SqlDbType.VarChar, 50),
new SqlParameter("@Tel", SqlDbType.VarChar, 20),
new SqlParameter("@Fax", SqlDbType.VarChar, 20),
new SqlParameter("@Email", SqlDbType.VarChar, 30),
new SqlParameter("@ServiesBID", SqlDbType.Int),
new SqlParameter("@ServiesMID", SqlDbType.Int),
};
parameters[0].Value = "Insert";
parameters[1].Value = model.UserName;
parameters[2].Value = model.Title;
parameters[3].Value = model.CompanyName;
parameters[4].Value = model.SubmitMan;
parameters[5].Value = model.Descript;
parameters[6].Value = model.CountryCode;
parameters[7].Value = model.ProvinceID;
parameters[8].Value = model.CityID;
parameters[9].Value = model.CountyID;
parameters[10].Value = model.Address;
parameters[11].Value = model.Tel;
parameters[12].Value = model.Fax;
parameters[13].Value = model.Email;
parameters[14].Value = model.ServiesBID;
parameters[15].Value = model.ServiesMID;
bool b = DbHelperSQL.RunProcLobHO("BusinesProcess", parameters);
return(b);
}
public bool update(Tz888.Model.Info.MainInfoModel mainInfoModel,
Tz888.Model.BusinesProcess model,
Tz888.Model.Info.ShortInfoModel shortInfoModel)
{
return(dal.update(mainInfoModel, model, shortInfoModel));
}
public bool update(Tz888.Model.Info.MainInfoModel mainInfoModel,
Tz888.Model.BusinesProcess 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.NChar, 2000),
//---------------------------END---------------------------
//-----------------------发布需求详细信息-----------------
//new SqlParameter("@Title", SqlDbType.VarChar,50),（上方已有）
new SqlParameter("@CompanyName", SqlDbType.VarChar, 200),
new SqlParameter("@SubmitMan", SqlDbType.VarChar, 16),
//new SqlParameter("@Descript", SqlDbType.VarChar,300),（上方已有）
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("@Address", SqlDbType.VarChar, 100),
new SqlParameter("@Tel", SqlDbType.VarChar, 20),
new SqlParameter("@Fax", SqlDbType.VarChar, 20),
new SqlParameter("@Email", SqlDbType.VarChar, 100),
new SqlParameter("@ServiesBID", SqlDbType.Int),
new SqlParameter("@ServiesMID", SqlDbType.Int),
new SqlParameter("@LoginName", SqlDbType.Char, 50),
new SqlParameter("@InfoID", SqlDbType.BigInt),
//---------------------------END---------------------------
};
parameters[0].Value = shortInfoModel.ShortTitle;
parameters[1].Value = mainInfoModel.Title;
parameters[2].Value = mainInfoModel.InfoCode;
parameters[3].Value = mainInfoModel.Descript;
// parameters[26].Value = model.Title;
parameters[4].Value = model.CompanyName;
parameters[5].Value = model.SubmitMan;
//parameters[29].Value = model.Descript;
parameters[6].Value = model.CountryCode;
parameters[7].Value = model.ProvinceID;
parameters[8].Value = model.CityID;
parameters[9].Value = model.CountyID;
parameters[10].Value = model.Address;
parameters[11].Value = model.Tel;
parameters[12].Value = model.Fax;
parameters[13].Value = model.Email;
parameters[14].Value = model.ServiesBID;
parameters[15].Value = model.ServiesMID;
parameters[16].Value = model.UserName;
parameters[17].Value = mainInfoModel.InfoID;
return(DbHelperSQL.RunProcLob("ReleaseUserUpdate", parameters));
}
public long ReleaseInsert(
Tz888.Model.Info.MainInfoModel mainInfoModel,
Tz888.Model.BusinesProcess model,
Tz888.Model.Info.ShortInfoModel shortInfoModel)
{
SqlParameter[] parameters =
{
//---------------------资源信息主体----------------------
new SqlParameter("@InfoID", SqlDbType.BigInt, 8),
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("@Descript", SqlDbType.NChar, 2000),
new SqlParameter("@DisplayTitle", SqlDbType.VarChar, 50),
new SqlParameter("@FrontDisplayTime", SqlDbType.SmallDateTime),
new SqlParameter("@ValidateStartTime", SqlDbType.SmallDateTime),
new SqlParameter("@ValidateTerm", SqlDbType.Int, 4),
new SqlParameter("@TemplateID", SqlDbType.Char, 10),
new SqlParameter("@HtmlFile", SqlDbType.VarChar, 100),
//---------------------------END---------------------------
//-----------------------发布需求详细信息-----------------
new SqlParameter("@UserName", SqlDbType.VarChar, 50),
//new SqlParameter("@Title", SqlDbType.VarChar,50),（上方已有）
new SqlParameter("@CompanyName", SqlDbType.VarChar, 200),
new SqlParameter("@SubmitMan", SqlDbType.VarChar, 16),
//new SqlParameter("@Descript", SqlDbType.VarChar,300),（上方已有）
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("@Address", SqlDbType.VarChar, 100),
new SqlParameter("@Tel", SqlDbType.VarChar, 20),
new SqlParameter("@Fax", SqlDbType.VarChar, 20),
new SqlParameter("@Email", SqlDbType.VarChar, 100),
new SqlParameter("@ServiesBID", SqlDbType.Int),
new SqlParameter("@ServiesMID", SqlDbType.Int),
//---------------------------END---------------------------
//-------------------------短信息--------------------------
new SqlParameter("@ShortInfoControlID", SqlDbType.Char, 20),
new SqlParameter("@ShortTitle", SqlDbType.VarChar, 100),
new SqlParameter("@ShortContent", SqlDbType.VarChar, 100),
new SqlParameter("@strRemark", SqlDbType.VarChar, 50),
//---------------------------END---------------------------
};
parameters[0].Direction = ParameterDirection.Output;
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 = 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 = model.UserName;
// parameters[26].Value = model.Title;
parameters[26].Value = model.CompanyName;
parameters[27].Value = model.SubmitMan;
//parameters[29].Value = model.Descript;
parameters[28].Value = model.CountryCode;
parameters[29].Value = model.ProvinceID;
parameters[30].Value = model.CityID;
parameters[31].Value = model.CountyID;
parameters[32].Value = model.Address;
parameters[33].Value = model.Tel;
parameters[34].Value = model.Fax;
parameters[35].Value = model.Email;
parameters[36].Value = model.ServiesBID;
parameters[37].Value = model.ServiesMID;
parameters[38].Value = shortInfoModel.ShortInfoControlID;
parameters[39].Value = shortInfoModel.ShortTitle;
parameters[40].Value = shortInfoModel.ShortContent;
parameters[41].Value = shortInfoModel.Remark;
int rowsAffected;
long infoID;
using (SqlConnection sqlConn = DbHelperSQL.GetSqlConnection())
{
sqlConn.Open();
SqlTransaction sqlTran = sqlConn.BeginTransaction();
try
{
//插入融资(项目)资源信息
DbHelperSQL.RunProcedure(sqlConn, sqlTran, "Release_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);
}
