/// <summary> /// 年租扣费规则更新 /// </summary> /// <param name="yearCostRule"></param> /// <returns></returns> public bool YearCostRuleUpdate(YearCostRule yearCostRule) { int result; try { string sql = "YEAR_COST_RULE_UPDATE"; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@CRID", SqlDbType.Int), new SqlParameter("@CRNAME", SqlDbType.VarChar, 50), new SqlParameter("@COSTPH", SqlDbType.Money), new SqlParameter("@COSTTIME", SqlDbType.Time), new SqlParameter("@COSTBEGIN", SqlDbType.Money) }; para[0].Value = yearCostRule.CrId; para[1].Value = yearCostRule.CrName; para[2].Value = yearCostRule.CostPh; para[3].Value = yearCostRule.CostTime; para[4].Value = yearCostRule.CostBegin; result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, para); return(result > 0 ? true : false); } catch (Exception ex) { except.ExceptionInsert("修改年租扣费规则出错:" + ex.Message, "YearCostRuleUpdate", DateTime.Now); return(false); } }
/// <summary> /// 根据CRID获得年租扣费规则 /// </summary> /// <returns></returns> public YearCostRule YearCostRuleSelectById(YearCostRule yearCostRule) { string sql = "YEAR_COST_RULE_SELECT_BY_CRID"; dt = new DataTable(); try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@CRID", SqlDbType.Int) }; para[0].Value = yearCostRule.CrId; using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, para)) { dt.Load(dr); } YearCostRule yearCostRuleInfo = new YearCostRule(); yearCostRuleInfo.CrId = Convert.ToInt32(dt.Rows[0]["CRID"]); yearCostRuleInfo.CrName = Convert.ToString(dt.Rows[0]["CRNAME"]); yearCostRuleInfo.CostPh = Convert.ToDouble(dt.Rows[0]["COSTPH"]); yearCostRuleInfo.CostTime = Convert.ToDateTime(dt.Rows[0]["COSTTIME"]); yearCostRuleInfo.CostBegin = Convert.ToDouble(dt.Rows[0]["COSTBEGIN"]); return(yearCostRuleInfo); } catch (Exception ex) { except.ExceptionInsert("查询年租扣费规则出错:" + ex.Message, "YearCostRuleSelectById", DateTime.Now); return(null); } }
/// <summary> /// 获取所有年租扣费规则 /// </summary> /// <returns></returns> public List <YearCostRule> YearCostRuleSelect() { string sql = "YEAR_COST_RULE_SELECT"; List <YearCostRule> listYearCostRule = new List <YearCostRule>(); dt = new DataTable(); try { using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, null)) { dt.Load(dr); } YearCostRule yearCostRuleTemp; for (int i = 0; i < dt.Rows.Count; i++) { yearCostRuleTemp = new YearCostRule(); yearCostRuleTemp.CrId = Convert.ToInt32(dt.Rows[i]["CRID"]); yearCostRuleTemp.CrName = Convert.ToString(dt.Rows[i]["CRNAME"]); yearCostRuleTemp.CostPh = Convert.ToDouble(dt.Rows[i]["COSTPH"]); yearCostRuleTemp.CostTime = Convert.ToDateTime(dt.Rows[i]["COSTTIME"]); yearCostRuleTemp.CostBegin = Convert.ToDouble(dt.Rows[i]["COSTbEGIN"]); listYearCostRule.Add(yearCostRuleTemp); } return(listYearCostRule); } catch (Exception ex) { except.ExceptionInsert("查询年租扣费规则出错:" + ex.Message, "YearCostRuleSelect", DateTime.Now); return(null); } }
/// <summary> /// 删除年租扣费规则 /// </summary> /// <param name="yearCostRule"></param> /// <returns></returns> public bool YearCostRuleDelete(YearCostRule yearCostRule) { string sql = "YEAR_COST_RULE_DELETE"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@CRID", SqlDbType.Int) }; para[0].Value = yearCostRule.CrId; int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, para); return(result > 0 ? true : false); } catch (Exception ex) { except.ExceptionInsert("删除年租扣费规则出错:" + ex.Message, "YearCostRuleDelete", DateTime.Now); return(false); } }