/// <summary> /// 设置保存费率信息 /// </summary> /// <param name="T1st">尖单价-对应的开始时间</param> /// <param name="T2nd">峰单价-对应的开始时间</param> /// <param name="T3rd">平单价-对应的开始时间</param> /// <param name="T4th">谷单价-对应的开始时间</param> /// <param name="Rate_id">费率ID号</param> /// <param name="Descr">费率描述</param> /// <param name="Pri1st">尖单价</param> /// <param name="Pri2nd">峰单价</param> /// <param name="Pri3rd">平单价</param> /// <param name="Pri4th">谷单价</param> /// <returns></returns> public APIRst SetSaveYdRate(string T1st, string T2nd, string T3rd, string T4th, int Rate_id, string Descr, decimal Pri1st, decimal Pri2nd, decimal Pri3rd, decimal Pri4th) { APIRst rst = new APIRst(); try { v1_rateVModel rv = new v1_rateVModel(); v1_rateCfg cfg = new v1_rateCfg(); cfg.T1st = T1st; cfg.T2nd = T2nd; cfg.T3rd = T3rd; cfg.T4th = T4th; rv.Rate_id = Rate_id; rv.Descr = Descr; rv.Pri1st = Pri1st; rv.Pri2nd = Pri2nd; rv.Pri3rd = Pri3rd; rv.Pri4th = Pri4th; rv.DataCfg = JsonHelper.Serialize(cfg); int cnt = bll.SaveYdRate(rv); object obj = GetYdRateList(rv.Rate_id, ""); rst.data = obj; } catch (Exception ex) { rst.rst = false; rst.err.code = (int)ResultCodeDefine.Error; rst.err.msg = ex.Message; FileLog.WriteLog("获取费率列表错误:" + ex.Message + ex.StackTrace); } return(rst); }
/// <summary> /// 设置保存物业收费 /// </summary> /// <param name="Rate_id">费率ID号</param> /// <param name="Descr">描述</param> /// <param name="Rule">计算规则: 0=正常,1=时间范围,2=数量范围</param> /// <param name="Unit">单位: Area=平方米,Bank=户数</param> /// <param name="UnitBase">单位基数</param> /// <param name="Disabled">是否弃用:0=否,1=是</param> /// <returns></returns> public APIRst SetSaveYdRateNew(int Rate_id, string Descr, int Rule, string Unit, decimal UnitBase, int Disabled) { APIRst rst = new APIRst(); try { v1_rateVModel rv = new v1_rateVModel(); rv.Rate_id = Rate_id; rv.Descr = Descr; rv.Attrib = 1; rv.Rule = Rule; rv.Unit = Unit; rv.UnitBase = UnitBase; rv.Disabled = Disabled; int cnt = bll.SaveYdRateNew(rv); object obj = GetYdRateNewList(rv.Rate_id, ""); rst.data = obj; } catch (Exception ex) { rst.rst = false; rst.err.code = (int)ResultCodeDefine.Error; rst.err.msg = ex.Message; FileLog.WriteLog("获取费率列表错误:" + ex.Message + ex.StackTrace); } return(rst); }
/// <summary> /// 设置保存费率信息 /// </summary> /// <param name="T1st">尖单价-对应的开始时间</param> /// <param name="T2nd">峰单价-对应的开始时间</param> /// <param name="T3rd">平单价-对应的开始时间</param> /// <param name="T4th">谷单价-对应的开始时间</param> /// <param name="Rate_id">费率ID号</param> /// <param name="Descr">费率描述</param> /// <param name="Pri1st">尖单价</param> /// <param name="Pri2nd">峰单价</param> /// <param name="Pri3rd">平单价</param> /// <param name="Pri4th">谷单价</param> /// <returns></returns> public int SaveYdRate(v1_rateVModel rv) { StringBuilder strSql = new StringBuilder(); strSql.Clear(); DataTable obj = null; if (rv.Rate_id == 0) { strSql.Clear(); strSql.Append("select max(Rate_id) as id from v1_rate where Ledger=@Ledger"); obj = SQLHelper.Query(strSql.ToString(), new { Ledger = this.Ledger }); rv.Rate_id = CommFunc.ConvertDBNullToInt32(obj.Rows[0]["id"]) + 1; } strSql.Clear(); strSql.Append("insert into v1_rate(Ledger,Rate_id,Descr,Pri1st,Pri2nd,Pri3rd,Pri4th,Disabled,DataCfg,Create_by,Create_dt,Update_by,Update_dt)values"); strSql.Append("(@Ledger,@Rate_id,@Descr,@Pri1st,@Pri2nd,@Pri3rd,@Pri4th,0,@DataCfg,@SysUid,now(),@SysUid,now())"); strSql.Append("ON DUPLICATE KEY UPDATE Descr=@Descr,Pri1st=@Pri1st,Pri2nd=@Pri2nd,Pri3rd=@Pri3rd,Pri4th=@Pri4th,DataCfg=@DataCfg,Update_by=@SysUid,Update_dt=now()"); return(SQLHelper.Execute(strSql.ToString(), new { Ledger = this.Ledger, Rate_id = rv.Rate_id, Descr = rv.Descr, Pri1st = rv.Pri1st, Pri2nd = rv.Pri2nd, Pri3rd = rv.Pri3rd, Pri4th = rv.Pri4th, DataCfg = rv.DataCfg, SysUid = this.SysUid })); }
/// <summary> /// 设置保存物业收费 /// </summary> /// <param name="Rate_id">费率ID号</param> /// <param name="Descr">描述</param> /// <param name="Rule">计算规则: 0=正常,1=时间范围,2=数量范围</param> /// <param name="Unit">单位: Area=平方米,Bank=户数</param> /// <param name="UnitBase">单位基数</param> /// <param name="Disabled">是否弃用:0=否,1=是</param> /// <returns></returns> public int SaveYdRateNew(v1_rateVModel rv) { StringBuilder strSql = new StringBuilder(); strSql.Clear(); DataTable obj = null; if (rv.Rate_id == 0) { strSql.Clear(); strSql.Append("select max(Rate_id) as id from v1_rate where Ledger=@Ledger"); obj = SQLHelper.Query(strSql.ToString(), new { Ledger = this.Ledger }); rv.Rate_id = obj.Rows.Count > 0 ? CommFunc.ConvertDBNullToInt32(obj.Rows[0]["id"]) + 1 : 1; //rv.Rate_id = CommFunc.ConvertDBNullToInt32(obj.Rows[0]["id"]) + 1; } strSql.Clear(); strSql.Append("insert into v1_rate(Ledger,Rate_id,Descr,Attrib,Rule,Unit,UnitBase,Disabled,Create_by,Create_dt,Update_by,Update_dt)values"); strSql.Append("(@Ledger,@Rate_id,@Descr,@Attrib,@Rule,@Unit,@UnitBase,@Disabled,@SysUid,now(),@SysUid,now())"); strSql.Append("ON DUPLICATE KEY UPDATE Descr=@Descr,Rule=@Rule,Unit=@Unit,UnitBase=@UnitBase,Disabled=@Disabled,Update_by=@SysUid,Update_dt=now()"); return(SQLHelper.Execute(strSql.ToString(), new { Ledger = this.Ledger, Rate_id = rv.Rate_id, Descr = rv.Descr, Attrib = rv.Attrib, Rule = rv.Rule, Unit = rv.Unit, UnitBase = rv.UnitBase, Disabled = rv.Disabled, SysUid = this.SysUid })); }
/// <summary> /// 设置保存费率信息 /// </summary> /// <param name="T1st">尖单价-对应的开始时间</param> /// <param name="T2nd">峰单价-对应的开始时间</param> /// <param name="T3rd">平单价-对应的开始时间</param> /// <param name="T4th">谷单价-对应的开始时间</param> /// <param name="Rate_id">费率ID号</param> /// <param name="Descr">费率描述</param> /// <param name="Pri1st">尖单价</param> /// <param name="Pri2nd">峰单价</param> /// <param name="Pri3rd">平单价</param> /// <param name="Pri4th">谷单价</param> /// <returns></returns> public int SaveYdRate(v1_rateVModel rv) { return(dal.SaveYdRate(rv)); }