public ActionResult System()
{
var Rate = new Rates();
var Quota = new Quotas();
var rate = Rate.GetLast();
if (rate == null)
{
rate = new Entity.T_Rate()
{
Rate_note = "暂未设置费率",
};
}
var quota = Quota.GetLast();
if (quota == null)
{
quota = new Entity.T_Quota()
{
Quota_note = "暂未设置基础配额"
};
}
ViewBag.rate = rate;
ViewBag.quota = quota;
return(View());
}
public bool Update(Entity.T_Rate rate)
{
if (rate.Rate_id < 1)
{
return(Add(rate));
}
return(Db.Updateable(rate).ExecuteCommand() > 0 ? true : false);
}
public void Rate(FormCollection collection)
{
var msg = new Msg();
var Rate = new Rates();
var rate = new Entity.T_Rate();
try
{
rate.Rate_cold_water_value = Convert.ToSingle(collection["cold_water_value"]);
rate.Rate_hot_water_value = Convert.ToSingle(collection["hot_water_value"]);
rate.Rate_electric_value = Convert.ToSingle(collection["electric_value"]);
//rate.Is_active = Convert.ToBoolean(collection["is_active"]);
/// 检查输入
if (rate.Rate_cold_water_value < 0 || rate.Rate_cold_water_value > 99999.99)
{
throw new Exception("冷水费率应在0.0~99999.99之间");
}
if (rate.Rate_hot_water_value < 0 || rate.Rate_hot_water_value > 99999.99)
{
throw new Exception("热水费率应在0.0~99999.99之间");
}
if (rate.Rate_electric_value < 0 || rate.Rate_electric_value > 99999.99)
{
throw new Exception("电力费率应在0.0~99999.99之间");
}
/// 保存数据
rate.Rate_note = collection["note"];
if (Rate.Update(rate))
{
msg.Message = "保存成功";
}
else
{
throw new Exception("发生未知错误，保存失败");
}
}
catch (Exception ex)
{
msg.Code = -1;
msg.Message = ex.Message;
}
Response.Write(msg.ToJson());
Response.End();
}
public bool Add(Entity.T_Rate rate)
{
return(Db.Insertable(rate).ExecuteCommand() > 0 ? true : false);
}
