/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ZhongLi.Model.Person_Reward model)
{
int rowsAffected = 0;
SqlParameter[] parameters =
{
new SqlParameter("@PerRewardID", SqlDbType.Int, 4),
new SqlParameter("@PerID", SqlDbType.Int, 4),
new SqlParameter("@Trade", SqlDbType.NVarChar, 50),
new SqlParameter("@CompanySize", SqlDbType.NVarChar, 50),
new SqlParameter("@CompanyNature", SqlDbType.NVarChar, 50),
new SqlParameter("@EngagePost", SqlDbType.NVarChar, 50),
new SqlParameter("@DemandPay", SqlDbType.NVarChar, 50),
new SqlParameter("@JobCity", SqlDbType.NVarChar, 50),
new SqlParameter("@OtherDemand", SqlDbType.NVarChar, 50),
new SqlParameter("@CompanyMatching", SqlDbType.NVarChar, 50),
new SqlParameter("@OtherDemandDes", SqlDbType.NVarChar, 500),
new SqlParameter("@RewardMoney", SqlDbType.Decimal, 9),
new SqlParameter("@RewardTime", SqlDbType.DateTime),
new SqlParameter("@RewardState", SqlDbType.Int, 4),
new SqlParameter("@IsDelete", SqlDbType.Int, 4),
new SqlParameter("@Education", SqlDbType.NVarChar, 50),
new SqlParameter("@WorkLife", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.PerRewardID;
parameters[1].Value = model.PerID;
parameters[2].Value = model.Trade;
parameters[3].Value = model.CompanySize;
parameters[4].Value = model.CompanyNature;
parameters[5].Value = model.EngagePost;
parameters[6].Value = model.DemandPay;
parameters[7].Value = model.JobCity;
parameters[8].Value = model.OtherDemand;
parameters[9].Value = model.CompanyMatching;
parameters[10].Value = model.OtherDemandDes;
parameters[11].Value = model.RewardMoney;
parameters[12].Value = model.RewardTime;
parameters[13].Value = model.RewardState;
parameters[14].Value = model.IsDelete;
parameters[15].Value = model.Education;
parameters[16].Value = model.WorkLife;
DbHelperSQL.RunProcedure("Person_Reward_Update", parameters, out rowsAffected);
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ZhongLi.Model.Person_Reward GetModel(int PerRewardID)
{
SqlParameter[] parameters =
{
new SqlParameter("@PerRewardID", SqlDbType.Int, 4)
};
parameters[0].Value = PerRewardID;
ZhongLi.Model.Person_Reward model = new ZhongLi.Model.Person_Reward();
DataSet ds = DbHelperSQL.RunProcedure("Person_Reward_GetModel", parameters, "ds");
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/*
* /// <summary>
* /// 分页获取数据列表
* /// </summary>
* public DataSet GetList(int PageSize,int PageIndex,string strWhere)
* {
* SqlParameter[] parameters = {
* new SqlParameter("@tblName", SqlDbType.VarChar, 255),
* new SqlParameter("@fldName", SqlDbType.VarChar, 255),
* new SqlParameter("@PageSize", SqlDbType.Int),
* new SqlParameter("@PageIndex", SqlDbType.Int),
* new SqlParameter("@IsReCount", SqlDbType.Bit),
* new SqlParameter("@OrderType", SqlDbType.Bit),
* new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
* };
* parameters[0].Value = "Person_Reward";
* parameters[1].Value = "PerRewardID";
* parameters[2].Value = PageSize;
* parameters[3].Value = PageIndex;
* parameters[4].Value = 0;
* parameters[5].Value = 0;
* parameters[6].Value = strWhere;
* return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
* }*/
#endregion Method
#region MethodEx
/// <summary>
/// 修改悬赏
/// </summary>
/// <param name="reward"></param>
/// <returns></returns>
public bool editPersonReward(ZhongLi.Model.Person_Reward reward)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Person_Reward set Trade=@Trade,CompanySize=@CompanySize,CompanyNature=@CompanyNature,EngagePost=@EngagePost,");
strSql.Append("DemandPay=@DemandPay,JobCity=@JobCity,OtherDemand=@OtherDemand,CompanyMatching=@CompanyMatching,RewardMoney=@RewardMoney,OtherDemandDes=@OtherDemandDes,Education=@Education,WorkLife=@WorkLife");
strSql.Append(" where PerRewardID=@PerRewardID");
SqlParameter[] para = { new SqlParameter("@Trade", reward.Trade),
new SqlParameter("@CompanySize", reward.CompanySize),
new SqlParameter("@CompanyNature", reward.CompanyNature),
new SqlParameter("@EngagePost", reward.EngagePost),
new SqlParameter("@DemandPay", reward.DemandPay),
new SqlParameter("@JobCity", reward.JobCity),
new SqlParameter("@OtherDemand", reward.OtherDemand),
new SqlParameter("@CompanyMatching", reward.CompanyMatching),
new SqlParameter("@RewardMoney", reward.RewardMoney),
new SqlParameter("@OtherDemandDes", reward.OtherDemandDes),
new SqlParameter("@PerRewardID", reward.PerRewardID),
new SqlParameter("@Education", reward.Education),
new SqlParameter("@WorkLife", reward.WorkLife) };
return(DbHelperSQL.ExecuteSql(strSql.ToString(), para) > 0);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ZhongLi.Model.Person_Reward DataRowToModel(DataRow row)
{
ZhongLi.Model.Person_Reward model = new ZhongLi.Model.Person_Reward();
if (row != null)
{
if (row["PerRewardID"] != null && row["PerRewardID"].ToString() != "")
{
model.PerRewardID = int.Parse(row["PerRewardID"].ToString());
}
if (row["PerID"] != null && row["PerID"].ToString() != "")
{
model.PerID = int.Parse(row["PerID"].ToString());
}
if (row["Trade"] != null)
{
model.Trade = row["Trade"].ToString();
}
if (row["CompanySize"] != null)
{
model.CompanySize = row["CompanySize"].ToString();
}
if (row["CompanyNature"] != null)
{
model.CompanyNature = row["CompanyNature"].ToString();
}
if (row["EngagePost"] != null)
{
model.EngagePost = row["EngagePost"].ToString();
}
if (row["DemandPay"] != null)
{
model.DemandPay = row["DemandPay"].ToString();
}
if (row["JobCity"] != null)
{
model.JobCity = row["JobCity"].ToString();
}
if (row["OtherDemand"] != null)
{
model.OtherDemand = row["OtherDemand"].ToString();
}
if (row["CompanyMatching"] != null)
{
model.CompanyMatching = row["CompanyMatching"].ToString();
}
if (row["OtherDemandDes"] != null)
{
model.OtherDemandDes = row["OtherDemandDes"].ToString();
}
if (row["RewardMoney"] != null && row["RewardMoney"].ToString() != "")
{
model.RewardMoney = decimal.Parse(row["RewardMoney"].ToString());
}
if (row["RewardTime"] != null && row["RewardTime"].ToString() != "")
{
model.RewardTime = DateTime.Parse(row["RewardTime"].ToString());
}
if (row["RewardState"] != null && row["RewardState"].ToString() != "")
{
model.RewardState = int.Parse(row["RewardState"].ToString());
}
if (row["IsDelete"] != null && row["IsDelete"].ToString() != "")
{
model.IsDelete = int.Parse(row["IsDelete"].ToString());
}
if (row["Education"] != null)
{
model.Education = row["Education"].ToString();
}
if (row["WorkLife"] != null)
{
model.WorkLife = row["WorkLife"].ToString();
}
}
return(model);
}
