/// <summary>
/// 设置参数
/// </summary>
/// <param name="sAddr"></param>
/// <param name="ChrAllowUsed"></param>
/// <param name="ChrFreezeDay"></param>
/// <param name="ChrValveMaint"></param>
/// <param name="ChrUpTiming"></param>
/// <param name="ChrUpTimingUnit"></param>
/// <param name="ChrUpAmount"></param>
/// <returns></returns>
public ActionResult SettingMeterInfo_Server(String sAddr, String sMeterInfoTypeNo)
{
CommonResult result = new CommonResult();
var meterSettingtypeno = sMeterInfoTypeNo.ToIntOrZero();
try
{
var rs = new ServiceDbClient().Terminal_SetMeterConfig(endcode, sAddr, meterSettingtypeno);
if (rs == "0")
{
result.IsSuccess = true;
}
else
{
result.IsSuccess = false;
result.ErrorMsg = rs;
}
}
catch (Exception ex)
{
var err = ex.ToString();
result.IsSuccess = false;
}
return(ToJsonContent(result));
}
public ActionResult IntReplaceType_Server()
{
ServiceDbClient DbServer = new ServiceDbClient();
var list = DbServer.GetDictMeterReplaceType();
return(ToJsonContentDate(list));
}
public ActionResult InsOrUpd_Server(SmsTemplate info)
{
CommonResult result = new CommonResult();
var endcode = Session["EndCode"].ToString() ?? "0";
info.IntEndCode = endcode.ToIntOrZero();
try
{
ServiceDbClient DbServer = new ServiceDbClient();
var flag = DbServer.SMS_Template_InsOrUpd(info);
info.DtLstUpd = DateTime.Now;
if (flag == "0")
{
result.IsSuccess = true;
}
else
{
result.ErrorMsg = flag;
}
}
catch (Exception ex)
{
result.ErrorMsg = ex.Message;
}
return(ToJsonContent(result));
}
public ActionResult TreeJson()
{
// var listAll = BLLFactory<Core.BLL.ArcConcentratorInfo>.Instance.GetAll();
var endcode = Session["EndCode"] ?? "0";
//调用后台服务获取集中器信息
ServiceDbClient DbServer = new ServiceDbClient();
var listAll = DbServer.ArcConcentrator_GetTree_Level(endcode.ToString().ToInt32()).ToList();
var children = new List <EasyTreeData>();
var listFirst = listAll.Where(n => n.IntUpID == 0);
foreach (var item in listFirst)
{
var dd = new EasyTreeData();
//if (item.IntOnline == 1) d.iconCls = "icon-online";
dd.iconCls = "icon-online";
dd.id = item.IntID.ToString();
dd.text = item.NvcName;
dd.children = getSubItem(item.IntID, listAll);
children.Add(dd);
}
var treeList = new List <EasyTreeData>();
//ROOT
var d = new EasyTreeData();
d.iconCls = "icon-house";
d.id = "0";
d.text = "根";
d.children = children;
treeList.Add(d);
return(ToJsonContentDate(treeList));
}
public ActionResult GetInfoByIntPropertyNo_Server()
{
var IntPropertyNo = Request["IntPropertyNo"].ToIntOrZero();
var dt = new ServiceDbClient().PriceProperty_GetByNo(IntPropertyNo);
return(ToJsonContentDate(dt));
}
public ActionResult TemplateList_Server()
{
var Status = Request["WHC_IntStatus"] ?? "-1";
var id = Request["WHC_IntID"] ?? "0";
var SmsTemplate_info = new SmsTemplate
{
NvcName = Request["WHC_TempName"] ?? "",
IntID = id == "" ? 0 : Convert.ToInt32(id),
IntStatus = Status == "" ? 0 : Convert.ToInt32(Status)
};
ServiceDbClient DbServer = new ServiceDbClient();
var dts = DbServer.SMS_Template_Qry(endcode, SmsTemplate_info);
int rows = Request["rows"] == null ? 10 : int.Parse(Request["rows"]);
int page = Request["page"] == null ? 1 : int.Parse(Request["page"]);
DataTable dat = new DataTable();
//复制源的架构和约束
dat = dts.Clone();
// 清除目标的所有数据
dat.Clear();
//对数据进行分页
for (int i = (page - 1) * rows; i < page * rows && i < dts.Rows.Count; i++)
{
dat.ImportRow(dts.Rows[i]);
}
//最重要的是在后台取数据放在json中要添加个参数total来存放数据的总行数，如果没有这个参数则不能分页
int total = dts.Rows.Count;
var result = new { total, rows = dat };
return(ToJsonContentDate(result));
}
public ActionResult IntAutoSwitch_Server()
{
ServiceDbClient DbServer = new ServiceDbClient();
var list = DbServer.GetDictValveAuto();
return(ToJsonContentDate(list));
}
public ActionResult ChangeTBL_Server(MeterReplaceInfo MeterReplace)
{
CommonResult result = new CommonResult();
MeterReplace.VcUserID = Session["UserID"].ToString();
MeterReplace.IntEndCode = 0;
try
{
var flg = new ServiceDbClient().ArcMeter_Replace(MeterReplace);
if (flg == "0")
{
result.Success = true;
}
else
{
result.ErrorMessage = flg;
result.Success = false;
}
}
catch (Exception ex)
{
result.ErrorMessage = ex.Message;
}
return(ToJsonContent(result));
}
/// <summary>
/// 查询参数信息
/// </summary>
/// <returns></returns>
public ActionResult Param_MeterConfig_Qry()
{
var endcoed = Session["EndCode"] ?? "";
var dts = new ServiceDbClient().Param_MeterConfig_Qry(endcoed.ToString().ToInt());
int rows = Request["rows"] == null ? 10 : int.Parse(Request["rows"]);
int page = Request["page"] == null ? 1 : int.Parse(Request["page"]);
DataTable dat = new DataTable();
//复制源的架构和约束
dat = dts.Clone();
// 清除目标的所有数据
dat.Clear();
//对数据进行分页
for (int i = (page - 1) * rows; i < page * rows && i < dts.Rows.Count; i++)
{
dat.ImportRow(dts.Rows[i]);
}
//最重要的是在后台取数据放在json中要添加个参数total来存放数据的总行数，如果没有这个参数则不能分页
int total = dts.Rows.Count;
var result = new { total = total, rows = dat };
return(ToJsonContentDate(result));
}
public ActionResult AddOrUpdate_Server(PriceProperty info)
{
Framework.Commons.CommonResult result = new Framework.Commons.CommonResult();
//价格明细
var lstPrice = new List <PriceDetail>();
var stepCount = RRequest("IntStepCount").ToInt32();
//阶梯,如果是则是页面的阶梯数,不是则为1
stepCount = info.IntStep == 1 ? stepCount : 1;
for (int i = 1; i <= stepCount; i++)
{
PriceDetail price_detail_info = new PriceDetail
{
//阶梯数
IntStepOrder = (uint)i,
//阶梯起始量
IntStepStart = (uint)RRequest("IntStepStart" + i).ToIntOrZero(),
// 阶梯增量
IntStepInc = (uint)RRequest("IntStepInc" + i).ToIntOrZero(),
// 总价格
TotalPrice = (double)RRequest("NumTotalPrice" + i).ToDecimalOrZero()
};
//价格分项
Dictionary <int, double> price_info = new Dictionary <int, double>();
var arrTypeNo = Request["ArrTypeNo"].Split(',');
foreach (var intTypeNo in arrTypeNo)
{
price_info.Add(intTypeNo.ToInt32(), (double)RRequest("NumPrice" + i + "_" + intTypeNo).ToDecimalOrZero());
}
price_detail_info.Price = price_info;
lstPrice.Add(price_detail_info);
}
//厂家编码
var endcode = Session["EndCode"] ?? "0";
info.IntEndCode = endcode.ToString().ToInt32();
//操作员
info.IntUserNo = CurrentUser.ID;
try
{
ServiceDbClient DbServer = new ServiceDbClient();
var flag = DbServer.PriceProperty_AddOrUpdate(info, lstPrice.ToArray());
if (flag == "0")
{
result.Success = true;
}
else
{
result.ErrorMessage = flag;
result.Success = false;
}
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(ToJsonContent(result));
}
public ActionResult Insert_server(Concentrator info)
{
//检查用户是否有权限，否则抛出MyDenyAccessException异常
base.CheckAuthorized(AuthorizeKey.InsertKey);
CommonResult result = new CommonResult();
//厂家编码
var endcode = Session["EndCode"] ?? "0";
info.IntEndCode = endcode.ToString().ToInt32();
try
{
//调用后台服务获取集中器信息
ServiceDbClient DbServer = new ServiceDbClient();
var flg = DbServer.ArcConcentrator_Ins(info);
if (flg == "0")
{
result.Success = true;
}
else
{
result.ErrorMessage = flg;
result.Success = false;
}
}
catch (Exception ex)
{
result.ErrorMessage = ex.Message;
}
return(ToJsonContent(result));
}
public ActionResult CurrentDateList_Server()
{
var date = RRequest("WHC_DteAccount");
var UserId = Session["UserID"].ToString().ToInt();
ServiceDbClient DbServer = new ServiceDbClient();
var dts = DbServer.Account_GetDepositDetail(UserId, date.ToDateTime(), date.ToDateTime());
//分页参数
int rows = Request["rows"] == null ? 10 : int.Parse(Request["rows"]);
int page = Request["page"] == null ? 1 : int.Parse(Request["page"]);
DataTable dat = new DataTable();
//复制源的架构和约束
dat = dts.Clone();
// 清除目标的所有数据
dat.Clear();
//对数据进行分页
for (int i = (page - 1) * rows; i < page * rows && i < dts.Rows.Count; i++)
{
dat.ImportRow(dts.Rows[i]);
}
//最重要的是在后台取数据放在json中要添加个参数total来存放数据的总行数，如果没有这个参数则不能分页
int total = dts.Rows.Count;
var result = new { total, rows = dat };
return(ToJsonContentDate(result));
}
public ActionResult GetDetailByCustomerNo_Server()
{
var endcode = Session["EndCode"] ?? "0";
var custno = Request["WHC_IntCustNo"] ?? "0";
ServiceDbClient DbServer = new ServiceDbClient();
var dts = DbServer.Account_GetDepositDetailByCustNo(endcode.ToString().ToInt32(), custno.ToInt32());
//分页参数
int rows = Request["rows"] == null ? 10 : int.Parse(Request["rows"]);
int page = Request["page"] == null ? 1 : int.Parse(Request["page"]);
DataTable dat = new DataTable();
//复制源的架构和约束
dat = dts.Clone();
// 清除目标的所有数据
dat.Clear();
//对数据进行分页
for (int i = (page - 1) * rows; i < page * rows && i < dts.Rows.Count; i++)
{
dat.ImportRow(dts.Rows[i]);
}
//最重要的是在后台取数据放在json中要添加个参数total来存放数据的总行数，如果没有这个参数则不能分页
int total = dts.Rows.Count;
var result = new { total, rows = dat };
return(ToJsonContentDate(result));
}
public ActionResult CollectStatJson_Server()
{
var WHC_StartDteFreeze = Request["WHC_StratDteFreeze"].ToDateTime();
var WHC_EndDteFreeze = Request["WHC_EndDteFreeze"].ToDateTime();
var fuji = Request["WHC_Fuji"];
var Text = Request["WHC_Text"];
var Strlevel = Request["WHC_Treelevel"];
var ParentText = Request["WHC_TreePrentText"];
var customerinfo = new Customer()
{
NvcName = Request["WHC_NvcName"] ?? "",
VcMobile = Request["WHC_VcMobile"] ?? "",
};
var custno = Request["WHC_IntCustNo"] ?? "0";
customerinfo.IntNo = custno.ToIntOrZero();
if (Strlevel == "1")
{
customerinfo.NvcVillage = "所有小区";
}
;
if (Strlevel == "2")
{
customerinfo.NvcVillage = Text;
}
if (Strlevel == "3")
{
customerinfo.NvcVillage = fuji;
customerinfo.VcBuilding = Text;
}
if (Strlevel == "4")
{
customerinfo.NvcVillage = ParentText;
customerinfo.VcBuilding = fuji;
customerinfo.VcUnitNum = Text;
}
//调用后台服务获取集中器信息
var dts = new ServiceDbClient().CollectStatus_Qry(endcode, customerinfo, WHC_StartDteFreeze, WHC_EndDteFreeze);
int rows = Request["rows"] == null ? 10 : int.Parse(Request["rows"]);
int page = Request["page"] == null ? 1 : int.Parse(Request["page"]);
DataTable dat = new DataTable();
//复制源的架构和约束
dat = dts.Clone();
// 清除目标的所有数据
dat.Clear();
//对数据进行分页
for (int i = (page - 1) * rows; i < page * rows && i < dts.Rows.Count; i++)
{
dat.ImportRow(dts.Rows[i]);
}
//最重要的是在后台取数据放在json中要添加个参数total来存放数据的总行数，如果没有这个参数则不能分页
int total = dts.Rows.Count;
var result = new { total = total, rows = dat };
return(ToJsonContentDate(result));
}
public ActionResult DictAccountWay_Server()
{
ServiceDbClient DbServer = new ServiceDbClient();
var dt = DbServer.GetDictAccountWay();
return(ToJsonContentDate(dt));
}
/// <summary>
/// 打印扣费信息
/// </summary>
/// <param name="IntFeeID">客户编号</param>
/// <returns></returns>
public ActionResult PrintTicketDetail(int IntFeeID)
{
var DtStart = Request["WHC_DtStart"] ?? DateTime.Now.ToString();
var Dtend = Request["WHC_DtEnd"] ?? DateTime.Now.ToString();;
var custinfo = new Customer();
var dt = new ServiceDbClient().Account_GetPaymentDetail(endcode, IntFeeID, DtStart.ToDateTime(), Dtend.ToDateTime(), custinfo);
if (dt.Rows.Count > 0)
{
ViewBag.IntCustNo = dt.Rows[0]["IntCustNo"].ToString();
ViewBag.NvcName = dt.Rows[0]["NvcName"].ToString();
ViewBag.VcRoomNum = dt.Rows[0]["VcRoomNum"].ToString();
ViewBag.NvcVillage = dt.Rows[0]["NvcVillage"].ToString();
ViewBag.NvcAddr = dt.Rows[0]["NvcAddr"].ToString();
ViewBag.IntYearMon = dt.Rows[0]["IntYearMon"].ToString();
ViewBag.DteFee = dt.Rows[0]["DteFee"].ToString();
var MonFee = dt.Rows[0]["MonFee"].ToString().ToDouble();
ViewBag.MonFee = MonFee.ToString("#0.00");
var MonPenalty = dt.Rows[0]["MonPenalty"].ToString().ToDouble();
ViewBag.MonPenalty = MonPenalty.ToString("#0.00");;
ViewBag.IntDays = dt.Rows[0]["IntDays"].ToString();
ViewBag.VcFlowNo = dt.Rows[0]["VcFlowNo"].ToString();
ViewBag.IntPayUnit = dt.Rows[0]["IntPayUnit"].ToString();
ViewBag.VcChargeNo = dt.Rows[0]["VcChargeNo"].ToString();
}
return(View());
}
public ActionResult CloseAccount_Query_Server(string custNo)
{
CommonResult result = new CommonResult();
var intcustno = custNo ?? "0";
try
{
var rs = new ServiceDbClient().Account_GetBillByCustNo(endcode, intcustno.ToIntOrZero());
if (rs.IsSuccess)
{
if (rs.Tbl1.Rows.Count > 0)
{
result.StrData1 = Newtonsoft.Json.JsonConvert.SerializeObject(rs.Tbl1);
var dt = new { total = rs.Tbl2.Rows.Count, rows = rs.Tbl2 };
result.IsSuccess = true;
// result.LstObj = dt;
result.StrData2 = rs.Tbl2.Rows.Count.ToString();
//result.Data2 = "2";
}
else
{
result.ErrorMsg = "未查询到用户号为：【" + custNo + "】 的用户档案";
}
}
else
{
result.ErrorMsg = "查询欠费失败!错误如下:" + rs.ErrorMsg;
}
}
catch (Exception ex)
{
result.ErrorMsg = "查询欠费失败!错误如下:" + ex.Message;
}
return(ToJsonContent(result));
}
public ActionResult ListJson_Server()
{
var Strlevel = Request["WHC_Treelevel"];
var fuji = Request["WHC_Fuji"];
var Text = Request["WHC_Text"];
var ParentText = Request["WHC_TreePrentText"];
var QryCondi = new MeterReplaceQryCondition()
{
NvcName = Request["WHC_NvcName"] ?? "",
NvcAddr = Request["WHC_NvcAddr"] ?? "",
IntCustNo = (Request["IntCustNO"] ?? "0").ToString().ToIntOrZero(),
VcMeterAddr = Request["WHC_VcAddr"] ?? ""
};
if (Strlevel == "1")
{
QryCondi.NvcVillage = "所有小区";
}
;
if (Strlevel == "2")
{
QryCondi.NvcVillage = Text;
}
if (Strlevel == "3")
{
QryCondi.NvcVillage = fuji;
QryCondi.VcBuilding = Text;
}
if (Strlevel == "4")
{
QryCondi.NvcVillage = ParentText;
QryCondi.VcBuilding = fuji;
QryCondi.VcUnitNum = Text;
}
QryCondi.IntEndNo = endcode;
var dts = new ServiceDbClient().GetMeterReplaceList(QryCondi);
int rows = Request["rows"] == null ? 10 : int.Parse(Request["rows"]);
int page = Request["page"] == null ? 1 : int.Parse(Request["page"]);
DataTable dat = new DataTable();
//复制源的架构和约束
dat = dts.Clone();
// 清除目标的所有数据
dat.Clear();
//对数据进行分页
for (int i = (page - 1) * rows; i < page * rows && i < dts.Rows.Count; i++)
{
dat.ImportRow(dts.Rows[i]);
}
//最重要的是在后台取数据放在json中要添加个参数total来存放数据的总行数，如果没有这个参数则不能分页
int total = dts.Rows.Count;
var result = new { total = total, rows = dat };
return(ToJsonContentDate(result));
}
/// <summary>
/// 查询参数信息 用于前端下拉框
/// </summary>
/// <returns></returns>
public ActionResult GetParam_MeterConfigTreeJson_Server()
{
var endcode = Session["EndCode"] ?? "0";
ServiceDbClient DbServer = new ServiceDbClient();
var tree = new ServiceDbClient().Param_MeterConfig_GetTree(endcode.ToString().ToInt());
return(ToJsonContentDate(tree));
}
public ActionResult TreeCommunity_Server()
{
var endcode = Session["EndCode"] ?? "0";
var treelist = new ServiceDbClient().ArcCustomer_TreeCommunity(endcode.ToString().ToInt32());
return(ToJsonContentDate(treelist));
}
public ActionResult GetTreeJson_Server()
{
var endcode = Session["EndCode"] ?? "0";
ServiceDbClient DbServer = new ServiceDbClient();
var tree = DbServer.PriceProperty_GetTreeJson(endcode.ToString().ToInt32());
return(ToJsonContentDate(tree));
}
public ActionResult GetInfoByIntPropertyNo_Server()
{
var IntPropertyNo = RRequest("IntPropertyNo").ToInt32();
//var IntPropertyNo = 1003;
ServiceDbClient DbServer = new ServiceDbClient();
var dt = DbServer.PriceProperty_GetByNo(IntPropertyNo);
return(ToJsonContentDate(dt));
}
public ActionResult Update_Server(string id, Concentrator info)
{
//检查用户是否有权限，否则抛出MyDenyAccessException异常
base.CheckAuthorized(AuthorizeKey.UpdateKey);
//赋值
info.IntID = Convert.ToInt32(id);
CommonResult result = new CommonResult();
if (info.IntUpID == info.IntID)
{
result.ErrorMessage = "不能选择自己作为父级设备";
return(ToJsonContent(result));
}
//判断当前 选择的父级 是否为当前设备下的子级
var listChilden = new List <int>();
GetChilden(info.IntID.ToString(), ref listChilden);
if (listChilden.Contains(info.IntUpID))
{
result.ErrorMessage = "父级设备不能是当前设备下的子级设备!请重新选择!";
return(ToJsonContent(result));
}
//厂家编码
var endcode = Session["EndCode"] ?? "0";
info.IntEndCode = endcode.ToString().ToInt32();
try
{
//调用后台服务获取集中器信息
ServiceDbClient DbServer = new ServiceDbClient();
var flg = DbServer.ArcConcentrator_Upd(info);
if (flg == "0")
{
result.Success = true;
}
else
{
result.ErrorMessage = flg;
result.Success = false;
}
}
catch (Exception ex)
{
result.ErrorMessage = ex.Message;
}
return(ToJsonContent(result));
}
public ActionResult Update_Server(Customer CustomerInfo, Meter MeterInfo)
{
//检查用户是否有权限，否则抛出MyDenyAccessException异常
base.CheckAuthorized(AuthorizeKey.InsertKey);
CommonResult result = new CommonResult();
try
{
var cInfo = Request["CustomerInfo"];
var mInfo = Request["MeterInfo"];
var setting = new Newtonsoft.Json.JsonSerializerSettings
{
NullValueHandling = Newtonsoft.Json.NullValueHandling.Ignore
};
CustomerInfo = Newtonsoft.Json.JsonConvert.DeserializeObject <Customer>(cInfo, setting);
MeterInfo = Newtonsoft.Json.JsonConvert.DeserializeObject <Meter>(mInfo, setting);
CustomerInfo = ReflectionHelper.ReplacePropertyValue(CustomerInfo, typeof(string), null, string.Empty);
MeterInfo = ReflectionHelper.ReplacePropertyValue(MeterInfo, typeof(string), null, string.Empty);
CustomerInfo.IntUserID = CurrentUser.ID;
CustomerInfo.IntStatus = 1;
CustomerInfo.DteCancel = DateTime.Now;
CustomerInfo.DteOpen = DateTime.Now;
MeterInfo.DtCreate = DateTime.Now;
MeterInfo.DtOnline = DateTime.Now;
MeterInfo.IntCustNO = CustomerInfo.IntNo;
CustomerInfo.VcAddrCode = DBLib.PinYinHelper.GetInitials(CustomerInfo.NvcAddr);
CustomerInfo.VcNameCode = DBLib.PinYinHelper.GetInitials(CustomerInfo.NvcName);
var endcode = Session["EndCode"] ?? "0";
CustomerInfo.IntEndCode = endcode.ToString().ToInt32();
MeterInfo.IntEndCode = endcode.ToString().ToInt32();
//调用后台服务获取集中器信息
ServiceDbClient DbServer = new ServiceDbClient();
var flg = DbServer.ArcCustMeter_Upd(CustomerInfo, MeterInfo);
if (flg == "0")
{
result.Success = true;
}
else
{
result.ErrorMessage = flg;
result.Success = false;
}
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(ToJsonContent(result));
}
public ActionResult FindByIntCustNo_Server(string IntCustNo)
{
DbServiceReference.CommonResult result = new DbServiceReference.CommonResult();
try
{
result = new ServiceDbClient().FindByIntCustNo(IntCustNo);
}
catch (Exception ex)
{
LogTextHelper.Error(ex);//错误记录
result.ErrorMsg = ex.Message;
}
return(ToJsonContent(result));
}
public ActionResult CollectStatJsonTotal_Server()
{
CommonResult result = new CommonResult();
var WHC_StartDteFreeze = Request["WHC_StratDteFreeze"].ToDateTime();
var WHC_EndDteFreeze = Request["WHC_EndDteFreeze"].ToDateTime();
var fuji = Request["WHC_Fuji"];
var Text = Request["WHC_Text"];
var Strlevel = Request["WHC_Treelevel"];
var ParentText = Request["WHC_TreePrentText"];
var customerinfo = new Customer()
{
NvcName = Request["WHC_NvcName"] ?? "",
VcMobile = Request["WHC_VcMobile"] ?? "",
};
var custno = Request["WHC_IntCustNo"] ?? "0";
customerinfo.IntNo = custno.ToIntOrZero();
if (Strlevel == "1")
{
customerinfo.NvcVillage = "所有小区";
}
;
if (Strlevel == "2")
{
customerinfo.NvcVillage = Text;
}
if (Strlevel == "3")
{
customerinfo.NvcVillage = fuji;
customerinfo.VcBuilding = Text;
}
if (Strlevel == "4")
{
customerinfo.NvcVillage = ParentText;
customerinfo.VcBuilding = fuji;
customerinfo.VcUnitNum = Text;
}
//调用后台服务获取集中器信息
var dts = new ServiceDbClient().CollectStatus_Qry(endcode, customerinfo, WHC_StartDteFreeze, WHC_EndDteFreeze);
var m = new CollectStatModel();
foreach (DataRow item in dts.Rows)
{
m.Used += item["Reading"].ToString().ToDecimalOrZero();
}
result.StrData1 = dts.Rows.Count.ToString();
result.StrData2 = m.Used.ToString();
return(ToJsonContentDate(result));
}
public ActionResult Update_Server(Customer CustomerInfo, Meter MeterInfo)
{
CommonResult result = new CommonResult();
try
{
var cInfo = Request["CustomerInfo"];
var mInfo = Request["MeterInfo"];
var setting = new Newtonsoft.Json.JsonSerializerSettings
{
NullValueHandling = Newtonsoft.Json.NullValueHandling.Ignore
};
CustomerInfo = Newtonsoft.Json.JsonConvert.DeserializeObject <Customer>(cInfo, setting);
MeterInfo = Newtonsoft.Json.JsonConvert.DeserializeObject <Meter>(mInfo, setting);
//CustomerInfo = ReflectionHelper.ReplacePropertyValue(CustomerInfo, typeof(string), null, string.Empty);
//MeterInfo = ReflectionHelper.ReplacePropertyValue(MeterInfo, typeof(string), null, string.Empty);
CustomerInfo.IntUserID = userid;
CustomerInfo.IntStatus = 1;
CustomerInfo.DteCancel = DateTime.Now;
CustomerInfo.DteOpen = DateTime.Now;
MeterInfo.DtCreate = DateTime.Now;
MeterInfo.DtOnline = DateTime.Now;
MeterInfo.IntCustNO = CustomerInfo.IntNo;
CustomerInfo.VcAddrCode = "";
CustomerInfo.VcNameCode = "";
CustomerInfo.IntEndCode = endcode;
MeterInfo.IntEndCode = endcode;
CustomerInfo.VcWechatNo = "";
var flg = new ServiceDbClient().ArcCustMeter_Upd(CustomerInfo, MeterInfo);
if (flg == "0")
{
result.IsSuccess = true;
}
else
{
result.ErrorMsg = flg;
result.IsSuccess = false;
}
}
catch (Exception ex)
{
result.IsSuccess = false;
result.ErrorMsg = ex.Message;
}
return(ToJsonContent(result));
}
public ActionResult Param_EndUser_Qry_Server()
{
CommonResult result = new CommonResult();
try
{
result = new ServiceDbClient().Param_EndUser_Qry(endcode);
}
catch (Exception ex)
{
result.ErrorMsg = "保存失败!错误如下:" + ex.Message;
}
return(ToJsonContent(result));
}
public ActionResult GetListJson_Server()
{
var list = new ServiceDbClient().PriceProperty_GetList(endcode);
var tree = new List <TreeData>();
foreach (var item in list)
{
tree.Add(new TreeData()
{
id = item.IntNo.ToString(),
text = item.NvcDesc,
data = item
});
}
return(ToJsonContentDate(tree));
}
public ActionResult GetListJson_Server()
{
ServiceDbClient DbServer = new ServiceDbClient();
var endcode = Session["EndCode"] ?? "0";
var list = DbServer.PriceProperty_GetList(endcode.ToString().ToInt32());
var tree = new List <TreeData>();
foreach (var item in list)
{
tree.Add(new TreeData()
{
id = item.IntNo.ToString(),
text = item.NvcDesc,
data = item
});
}
return(ToJsonContentDate(tree));
}
