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