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