public decimal GetMonitorUseVal(int co_id, int module_id, string moduleAddr, int fun_id) { StringBuilder strSql = new StringBuilder(); strSql.Clear(); strSql.Append("select a.LastVal-a.FirstVal"); strSql.Append(" from v2_info as a"); strSql.Append(" where a.Ledger=@Ledger and a.Co_id=@Co_id and a.Module_id=@Module_id and a.ModuleAddr=@ModuleAddr and a.Fun_id=@Fun_id"); object obj = SQLHelper.ExecuteScalar(strSql.ToString(), new { Ledger = this.Ledger, Co_id = co_id, Module_id = module_id, ModuleAddr = moduleAddr, Fun_id = fun_id }); return(CommFunc.ConvertDBNullToDecimal(obj)); }
/// <summary> /// 历史数据 /// </summary> /// <param name="module_id">回路ID号</param> /// <param name="funType">采集项目</param> /// <param name="dataType">查询类型</param> /// <param name="startTime">开始日期</param> /// <returns></returns> public APIRst GetHisData(int module_id, string funType, string dataType, DateTime startTime) { APIRst rst = new APIRst(); try { DateTime start = startTime, end = startTime; if (dataType.Equals("hour")) { start = new DateTime(start.Year, start.Month, start.Day, start.Hour, 0, 0); end = new DateTime(start.Year, start.Month, start.Day, 23, 0, 0); } if (dataType.Equals("day")) { start = new DateTime(start.Year, start.Month, 1); end = start.AddMonths(1).AddDays(-1); } if (dataType.Equals("month")) { start = new DateTime(start.Year, 1, 1); end = start.AddYears(1).AddDays(-1); } DataTable dtSource = bll.GetHisData(module_id, funType, dataType, start, end); int total = dtSource.Rows.Count; var res1 = from s1 in dtSource.AsEnumerable() select new { RowId = CommFunc.ConvertDBNullToInt32(s1["RowId"]), TagTime = CommFunc.ConvertDBNullToDateTime(s1["TagTime"]).ToString("yyyy-MM-dd HH:mm:ss"), Module_id = CommFunc.ConvertDBNullToInt32(s1["Module_id"]), Fun_id = CommFunc.ConvertDBNullToInt32(s1["Fun_id"]), FunName = CommFunc.ConvertDBNullToString(s1["FunName"]), ModuleAddr = CommFunc.ConvertDBNullToString(s1["ModuleAddr"]), ModuleName = CommFunc.ConvertDBNullToString(s1["ModuleName"]), CoStrcName = CommFunc.ConvertDBNullToString(s1["CoStrcName"]), CoName = CommFunc.ConvertDBNullToString(s1["CoName"]), TagTimeS = CommFunc.ConvertDBNullToString(s1["TagTimeS"]), Cnt = CommFunc.ConvertDBNullToInt32(s1["Cnt"]), NewValue = s1["NewValue"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["NewValue"]).ToString(), Value = s1["Value"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["Value"]).ToString(), }; rst.data = res1.ToList(); } 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="time"></param> /// <returns></returns> public APIRst GetMonthAnalysis(DateTime time) { APIRst rst = new APIRst(); try { DataTable dtSource = bll.GetMonthAnalysis(user.Attach.mid, time); foreach (DataRow dr in dtSource.Rows) { if (CommFunc.ConvertDBNullToInt32(dr["Step"]) == 0) { continue; /*不存在月份*/ } decimal useVal = CommFunc.ConvertDBNullToDecimal(dr["UseVal"]); decimal pri1 = 0; if (useVal <= user.Attach.step.s1) { pri1 = user.Attach.step.p1; dr["Step"] = 1; } else if (useVal <= user.Attach.step.s2) { pri1 = user.Attach.step.p2; dr["Step"] = 2; } else { pri1 = user.Attach.step.p3; dr["Step"] = 3; } //dr["UseAmt"] = Math.Round(useVal * pri1, 2, MidpointRounding.AwayFromZero); } var res1 = from s1 in dtSource.AsEnumerable() select new { Month = CommFunc.ConvertDBNullToInt32(s1["Month"]), UseVal = CommFunc.ConvertDBNullToDecimal(s1["UseVal"]), UseAmt = CommFunc.ConvertDBNullToDecimal(s1["UseAmt"]), Step = CommFunc.ConvertDBNullToInt32(s1["Step"]), }; rst.data = new { row = res1.ToList(), total = dtSource.Rows.Count }; rst.rst = true; } 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); }
private void GetYdModuleCollectValData(string periods, string splitMdQuery, DateTime start, DateTime end, ref DataTable dtRst, ref DataTable dtSource) { DataTable dtUse = null; if (periods.ToLower().Equals("FirstVal".ToLower())) { dtUse = WholeBLL.GetCoreQueryData(this.Ledger, splitMdQuery, start, start, "day"); } else { dtUse = WholeBLL.GetCoreQueryData(this.Ledger, splitMdQuery, end, end, "day"); } foreach (DataRow dr in dtUse.Rows) { DataRow curDr = dtSource.Rows.Find(new object[] { dr["Module_id"], dr["Fun_id"] }); if (curDr == null) { continue; } int scale = CommFunc.ConvertDBNullToInt32(curDr["Scale"]); scale = scale == 0 ? 2 : scale; decimal multiply = CommFunc.ConvertDBNullToDecimal(curDr["Multiply"]); DateTime tagtime = CommFunc.ConvertDBNullToDateTime(dr["TagTime"]); decimal firstVal = CommFunc.ConvertDBNullToDecimal(dr["FirstVal"]) * multiply; decimal lastVal = CommFunc.ConvertDBNullToDecimal(dr["LastVal"]) * multiply; firstVal = Math.Round(firstVal, scale, MidpointRounding.AwayFromZero); lastVal = Math.Round(lastVal, scale, MidpointRounding.AwayFromZero); // DataRow addDr = dtRst.Rows.Find(new object[] { dr["Module_id"], dr["ModuleAddr"] }); if (addDr == null) { addDr = dtRst.NewRow(); addDr["Module_id"] = dr["Module_id"]; addDr["ModuleAddr"] = dr["ModuleAddr"]; addDr["Start"] = start; addDr["End"] = end; addDr["ModuleName"] = curDr["ModuleName"]; addDr["RoomName"] = curDr["CoName"]; addDr["StrcName"] = curDr["CoStrcName"]; dtRst.Rows.Add(addDr); } if (periods.ToLower().Equals("FirstVal".ToLower())) { addDr["FirstVal"] = firstVal; } else { addDr["LastVal"] = lastVal; } } }
private object GetYdMontionOnList(string CoStrcName, string CoName, string DateType, DateTime Start, DateTime End, out int total) { DataTable dtSource = bll.GetYdMonitorOnList(CoStrcName, CoName, DateType, Start, End); total = dtSource.Rows.Count; var res1 = from s1 in dtSource.AsEnumerable() select new { RowId = CommFunc.ConvertDBNullToInt32(s1["RowId"]), TagTime = CommFunc.ConvertDBNullToDateTime(s1["TagTime"]).ToString("yyyy-MM-dd HH:mm:ss"), Module_id = CommFunc.ConvertDBNullToInt32(s1["Module_id"]), ModuleAddr = CommFunc.ConvertDBNullToString(s1["ModuleAddr"]), ModuleName = CommFunc.ConvertDBNullToString(s1["ModuleName"]), CoStrcName = CommFunc.ConvertDBNullToString(s1["CoStrcName"]), CoName = CommFunc.ConvertDBNullToString(s1["CoName"]), TagTimeS = CommFunc.ConvertDBNullToString(s1["TagTimeS"]), Cnt = CommFunc.ConvertDBNullToInt32(s1["Cnt"]), h00 = s1["h00"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["h00"]).ToString(), h01 = s1["h01"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["h01"]).ToString(), h02 = s1["h02"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["h02"]).ToString(), h03 = s1["h03"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["h03"]).ToString(), h04 = s1["h04"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["h04"]).ToString(), h05 = s1["h05"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["h05"]).ToString(), h06 = s1["h06"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["h06"]).ToString(), h07 = s1["h07"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["h07"]).ToString(), h08 = s1["h08"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["h08"]).ToString(), h09 = s1["h09"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["h09"]).ToString(), h10 = s1["h10"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["h10"]).ToString(), h11 = s1["h11"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["h11"]).ToString(), h12 = s1["h12"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["h12"]).ToString(), h13 = s1["h13"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["h13"]).ToString(), h14 = s1["h14"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["h14"]).ToString(), h15 = s1["h15"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["h15"]).ToString(), h16 = s1["h16"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["h16"]).ToString(), h17 = s1["h17"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["h17"]).ToString(), h18 = s1["h18"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["h18"]).ToString(), h19 = s1["h19"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["h19"]).ToString(), h20 = s1["h20"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["h20"]).ToString(), h21 = s1["h21"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["h21"]).ToString(), h22 = s1["h22"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["h22"]).ToString(), h23 = s1["h23"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["h23"]).ToString(), h24 = s1["h24"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["h24"]).ToString(), h25 = s1["h25"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["h25"]).ToString(), h26 = s1["h26"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["h26"]).ToString(), h27 = s1["h27"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["h27"]).ToString(), h28 = s1["h28"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["h28"]).ToString(), h29 = s1["h29"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["h29"]).ToString(), h30 = s1["h30"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["h30"]).ToString() }; return(res1.ToList()); }
private void GetRealVal(DataTable dt, out decimal pTotal, out decimal eTotal, out DateTime UTime) { pTotal = 0; eTotal = 0; UTime = DateTime.MinValue; CacheUser user = WebConfig.GetSession(); string key = (user == null || user.Uid == 0) ? "" : user.CacheKey; if (string.IsNullOrEmpty(key)) { key = WebConfig.MemcachKey; } string ccKey = ""; foreach (DataRow dr in dt.Rows) { ccKey = key + CommFunc.ConvertDBNullToString(dr["P_Tag"]); int i = 0; RstVar var = null; while (++i <= 2) { var = MemcachedMgr.GetVal <RstVar>(ccKey); if (var != null) { break; } System.Threading.Thread.Sleep(50); } if (var != null) { pTotal += CommFunc.ConvertDBNullToDecimal(var.lpszVal); if (var.lpszdateTime > UTime) { UTime = var.lpszdateTime; } } //ccKey = key + CommFunc.ConvertDBNullToString(dr["E_Tag"]); //i = 0; //var = null; //while (++i <= 2) //{ // var = MemcachedMgr.GetVal<RstVar>(ccKey); // if (var != null) break; // System.Threading.Thread.Sleep(50); //} //if (var != null) //{ // eTotal += CommFunc.ConvertDBNullToDecimal(var.lpszVal); // if (var.lpszdateTime > UTime) UTime = var.lpszdateTime; //} } }
/// <summary> /// 保存采集项数据 /// </summary> /// <param name="lpszDbVarName"></param> /// <param name="lpszVal"></param> /// <param name="lpszdateTime"></param> internal static void SaveCollectCache(string lpszDbVarName, string lpszVal, DateTime lpszdateTime) { string mkey = Helper.ProjectKey + lpszDbVarName; CollectVModel collect = null; if (NCSys.Result.TryGetValue(mkey, out collect) == false) { try { collect = new CollectVModel(); System.Data.DataTable dtSource = processBll.GetMapInfo(lpszDbVarName); if (dtSource.Rows.Count != 1) { FileLog.Debug("KEY:" + lpszDbVarName + "值信息不存在数据库中"); return; } collect.RstVar = new RstVar() { dwUserData = 0 }; foreach (DataRow dr in dtSource.Rows) { collect.Module_id = CommFunc.ConvertDBNullToInt32(dr["Module_id"]); collect.ModuleAddr = CommFunc.ConvertDBNullToString(dr["ModuleAddr"]); collect.Fun_id = CommFunc.ConvertDBNullToInt32(dr["Fun_id"]); collect.UpTime = CommFunc.ConvertDBNullToDateTime(dr["LastTime"]); collect.RstVar.lpszVal = dr["LastVal"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(dr["LastVal"]).ToString(); collect.RstVar.lpszdateTime = collect.UpTime; } NCSys.Result.TryAdd(mkey, collect); } catch (Exception ex) { FileLog.Debug("获取DB数据错误:" + ex.Message + ex.StackTrace); return;/*采集值反转*/ } } if (CommFunc.ConvertDBNullToDateTime(collect.RstVar.lpszdateTime) > lpszdateTime) { FileLog.Debug("KEY:" + lpszDbVarName + "值采集时间反转"); return;/*时间反转*/ } if (CommFunc.ConvertDBNullToDecimal(collect.RstVar.lpszVal) > CommFunc.ConvertDBNullToDecimal(lpszVal)) { FileLog.Debug("KEY:" + lpszDbVarName + "值采集数据反转"); return;/*采集值反转*/ } collect.RstVar.lpszVal = lpszVal; collect.RstVar.lpszdateTime = lpszdateTime; collect.RstVar.dwUserData = 0; }
/// <summary> /// 新增物业列表 /// </summary> /// <returns></returns> public int AddCharg(int co_id, decimal firstVal, decimal lastVal, DateTime firstTime, DateTime lastTime, decimal price, decimal chargAmt) { StringBuilder strSql = new StringBuilder(); strSql.Clear(); strSql.Append("select RdAmt from v1_custinfo where Ledger=@Ledger and Co_id=@Co_id"); object obj = SQLHelper.ExecuteScalar(strSql.ToString(), new { Ledger = this.Ledger, Co_id = co_id }); decimal syAmt = CommFunc.ConvertDBNullToDecimal(obj); strSql.Clear(); strSql.Append("insert into v4_pay_charg(CDate,Ledger,Co_id,FirstVal,LastVal,FirstTime,LastTime,Price,ChargVal,Cretae_by,Create_dt,Update_by,Update_dt,SyAmt)"); strSql.Append("values(@LastTime,@Ledger,@Co_id,@FirstVal,@LastVal,@FirstTime,@LastTime,@Price,@ChargVal,@SysUid,now(),@SysUid,now(),@SyAmt)"); return(SQLHelper.Execute(strSql.ToString(), new { Ledger = this.Ledger, Co_id = co_id, FirstVal = firstVal, LastVal = lastVal, FirstTime = firstTime, LastTime = lastTime, Price = price, ChargVal = chargAmt, SysUid = this.SysUid, SyAmt = syAmt })); }
/// <summary> /// 电气火灾列表 /// </summary> /// <returns></returns> public APIRst GetDqhzList() { APIRst rst = new APIRst(); try { List<object> list = new List<object>(); DataTable dtSource = bll.GetDqhzList(); var res1 = from s1 in dtSource.AsEnumerable() group s1 by new { Module_id = CommFunc.ConvertDBNullToInt32(s1["Module_id"]) } into g1 select new { Module_id = g1.Key.Module_id, ModuleName = CommFunc.ConvertDBNullToString(g1.First()["ModuleName"]), MeterName = CommFunc.ConvertDBNullToString(g1.First()["MeterName"]), }; foreach (var o1 in res1) { List<object> rv = new List<object>(); foreach (DataRow dr in dtSource.Select("Module_id=" + o1.Module_id)) { string lpszDbVarName = CommFunc.ConvertDBNullToString(dr["LpszDbVarName"]); string funType = CommFunc.ConvertDBNullToString(dr["FunType"]); string funName = CommFunc.ConvertDBNullToString(dr["FunName"]); int scale = CommFunc.ConvertDBNullToInt32(dr["Scale"]); RstVar vv = MemcachedMgr.GetVal<RstVar>(user.CacheKey + lpszDbVarName); if (vv != null) { vv.lpszVal = CommFunc.ConvertDBNullToDecimal(vv.lpszVal).ToString("f" + scale); rv.Add(new { FunType = funType, FunName = funName, Data = new { lpszVal = vv.lpszVal, lpszdateTime = vv.lpszdateTime } }); } else { rv.Add(new { FunType = funType, FunName = funName, Data = "" }); } } list.Add(new { Module_id = o1.Module_id, MouleName = o1.ModuleName, MeterName = o1.MeterName, List = rv }); } rst.data = list; } 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> /// <returns></returns> public Decimal GetRatio() { object params01 = new { Ledger = this.Ledger, }; StringBuilder strSql = new StringBuilder(); strSql.Append("select Price from syscont"); strSql.Append(" where Ledger=@Ledger"); //strSql.Append("select ratio from syscont where ledger=@ledger"); object obj = SQLHelper.ExecuteScalar(strSql.ToString(), params01); return(CommFunc.ConvertDBNullToDecimal(obj)); }
/// <summary> /// 月用电量 /// </summary> /// <param name="Co_id"></param> /// <param name="Module_id"></param> /// <param name="ModuleAddr"></param> /// <returns></returns> public decimal GetYdMonitorOnMthUseVal(int Co_id, int Module_id, string ModuleAddr) { DateTime TagTime = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); decimal useVal = 0; DataTable dtUse = WHoleDAL.GetCoreQueryData(this.Ledger, Module_id.ToString(), TagTime, TagTime, "month", "E"); foreach (DataRow dr in dtUse.Rows) { if (CommFunc.ConvertDBNullToInt32(dr["Co_id"]) == Co_id) { useVal = useVal + ((CommFunc.ConvertDBNullToDecimal(dr["LastVal"]) - CommFunc.ConvertDBNullToDecimal(dr["FirstVal"])) * CommFunc.ConvertDBNullToDecimal(dr["Multiply"])); } } return(useVal); }
/// <summary> /// 获取用户的用能列表 /// </summary> /// <param name="Co_id"></param> /// <returns></returns> public APIRst GetYdCustOnMdList(int Co_id) { APIRst rst = new APIRst(); try { Co_id = Co_id == 0 ? -9999 : Co_id; DataTable dtSource = bll.GetYdCustOnMdList(Co_id); var res1 = from s1 in dtSource.AsEnumerable() select new { id = CommFunc.ConvertDBNullToInt32(s1["Module_id"]), _parentId = CommFunc.ConvertDBNullToInt32(s1["pid"]), Module_id = CommFunc.ConvertDBNullToInt32(s1["Module_id"]), ModuleName = CommFunc.ConvertDBNullToString(s1["ModuleName"]), ModuleAddr = CommFunc.ConvertDBNullToString(s1["ModuleAddr"]), ModuleType = CommFunc.ConvertDBNullToString(s1["ModuleType"]), Parent_id = CommFunc.ConvertDBNullToString(s1["Parent_id"]), Inst_loc = CommFunc.ConvertDBNullToString(s1["Inst_loc"]), Multiply = CommFunc.ConvertDBNullToDecimal(s1["Multiply"]).ToString("f2"), Co_id = CommFunc.ConvertDBNullToInt32(s1["Co_id"]), CoName = CommFunc.ConvertDBNullToString(s1["CoName"]), Struc = CommFunc.ConvertDBNullToString(s1["GwName"]) + "->" + CommFunc.ConvertDBNullToString(s1["EspName"]), //Waste = CommFunc.ConvertDBNullToDecimal(s1["Waste"]), //Fees = CommFunc.ConvertDBNullToDecimal(s1["Fees"]), MinPay = CommFunc.ConvertDBNullToDecimal(s1["MinPay"]), Price = CommFunc.ConvertDBNullToDecimal(s1["Price"]), //IsPSum = CommFunc.ConvertDBNullToInt32(s1["IsPSum"]), //Format = CommFunc.ConvertDBNullToInt32(s1["Format"]), //DataCfg = CommFunc.ConvertDBNullToString(s1["DataCfg"]), Rate_id = CommFunc.ConvertDBNullToInt32(s1["Rate_id"]), IsAlarm = CommFunc.ConvertDBNullToInt32(s1["IsAlarm"]), AlarmVal = CommFunc.ConvertDBNullToDecimal(s1["AlarmVal"]), EnergyItemCode = CommFunc.ConvertDBNullToString(s1["EnergyItemCode"]), EnergyItemName = CommFunc.ConvertDBNullToString(s1["EnergyItemName"]), }; object obj = new { total = dtSource.Rows.Count, rows = res1.ToList() }; 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); }
public APIRst GetYdSmsContent(int co_id, int module_id, string moduleAddr) { APIRst rst = new APIRst(); try { DataTable dtSource = bll.GetYdSmsContent(co_id, module_id, moduleAddr); string content = ""; string crmName = "", coName = "", mPhone = "", email = ""; decimal syVal = 0, syAmt = 0, price = 0; DateTime lastTime = new DateTime(); if (dtSource.Rows.Count > 0) { mPhone = CommFunc.ConvertDBNullToString(dtSource.Rows[0]["MPhone"]); email = CommFunc.ConvertDBNullToString(dtSource.Rows[0]["Email"]); crmName = CommFunc.ConvertDBNullToString(dtSource.Rows[0]["CrmName"]); coName = CommFunc.ConvertDBNullToString(dtSource.Rows[0]["CoName"]); syVal = CommFunc.ConvertDBNullToDecimal(dtSource.Rows[0]["RdVal"]); price = CommFunc.ConvertDBNullToDecimal(dtSource.Rows[0]["Price"]); lastTime = CommFunc.ConvertDBNullToDateTime(dtSource.Rows[0]["LastTime"]); syAmt = Math.Round(syVal * price, 2, MidpointRounding.AwayFromZero); //尊敬的${CrmName}用户,截止到${DateTime},您所属的${CoName}号房间剩余金额是${SyAmt}元,剩余电量是${SyVal},为了不影响您正常的用电使用,请及时到物管中心缴费!谢谢您的合作! content = "尊敬的{0}用户,截止到{1},您所属的{2}号房间剩余金额是{3}元,剩余电量是{4},为了不影响您正常的用电使用,请及时到物管中心缴费!谢谢您的合作!"; content = string.Format(content, crmName, (lastTime.Year != 1900 ? lastTime.ToString("yyyy-MM-dd") : ""), coName, syAmt, syVal.ToString("f2") + "kWh"); } object obj = new { Content = content, MPhone = mPhone, Email = email, CrmName = crmName, LastTime = (lastTime.Year == 1900 || lastTime.Year == 0) ? "" : lastTime.ToString("yyyy-MM-dd"), CoName = coName, SyAmt = syAmt, SyVal = syVal.ToString("f2") + "kWh" }; rst.data = obj; } catch (Exception ex) { rst.rst = false; rst.err.code = (int)ResultCodeDefine.Error; rst.err.msg = ex.Message; FileLog.WriteLog("获取发送信息错误 (GetYdSmsContent)", ex.Message + ex.StackTrace); } return(rst); }
public DataTable GetYdPayLogOnList(string StrcName, string CoName, int d_ways, string Create_by, DateTime StartTime, DateTime EndTime) { DataTable dtSource = dal.GetYdPayLogOnList(StrcName, CoName, d_ways, Create_by, StartTime, EndTime); dtSource.Columns.Add("RowId", typeof(System.Int32)); dtSource.Columns.Add("PayTypeS", typeof(System.String)); dtSource.Columns.Add("IsPayS", typeof(System.String)); int RowId = 0; foreach (DataRow dr in dtSource.Rows) { dr["RowId"] = ++RowId; int payType = CommFunc.ConvertDBNullToInt32(dr["PayType"]); int ispay = CommFunc.ConvertDBNullToInt32(dr["IsPay"]); if (payType == (int)PayType.pay) { dr["PayTypeS"] = "充值"; } if (payType == (int)PayType.refund) { dr["PayAmt"] = -CommFunc.ConvertDBNullToDecimal(dr["PayAmt"]); dr["PayVal"] = -CommFunc.ConvertDBNullToDecimal(dr["PayVal"]); dr["PayTypeS"] = "退费"; } if (payType == (int)PayType.present) { dr["PayTypeS"] = "赠电"; } if (payType == (int)PayType.reback) { dr["PayAmt"] = -CommFunc.ConvertDBNullToDecimal(dr["PayAmt"]); dr["PayVal"] = -CommFunc.ConvertDBNullToDecimal(dr["PayVal"]); dr["PayTypeS"] = "退赠电"; } if (ispay == 0) { dr["IsPayS"] = "现金支付"; } if ((ispay >= 10 && ispay < 20) || ispay == 1) { dr["IsPayS"] = "微信支付"; } } return(dtSource); }
// 采集器数据集合 private object GetYdModuleOnDetail(int Gw_id, int Esp_id, int Meter_id, int Module_id, out int total) { DataTable dtSource = bll.GetYdModuleOnDetail(Gw_id, Esp_id, Meter_id, Module_id); total = dtSource.Rows.Count; var res1 = from s1 in dtSource.AsEnumerable() orderby CommFunc.ConvertDBNullToInt32(s1["Id"]) select new { id = CommFunc.ConvertDBNullToInt32(s1["Id"]), _parentId = CommFunc.ConvertDBNullToInt32(s1["Pid"]), Gw_id = CommFunc.ConvertDBNullToInt32(s1["Gw_id"]), Esp_id = CommFunc.ConvertDBNullToInt32(s1["Esp_id"]), Meter_id = CommFunc.ConvertDBNullToInt32(s1["Meter_id"]), Module_id = CommFunc.ConvertDBNullToInt32(s1["Module_id"]), EmName = CommFunc.ConvertDBNullToString(s1["EmName"]), EmAddr = CommFunc.ConvertDBNullToString(s1["EmAddr"]), EmNo = CommFunc.ConvertDBNullToString(s1["EmNo"]), TransferType = CommFunc.ConvertDBNullToInt32(s1["TransferType"]), EspIp = CommFunc.ConvertDBNullToString(s1["EspIp"]), EspPort = CommFunc.ConvertDBNullToInt32(s1["EspPort"]), Timeout = CommFunc.ConvertDBNullToInt32(s1["Timeout"]), ComPort = CommFunc.ConvertDBNullToString(s1["ComPort"]), ComPortNum = CommFunc.ConvertDBNullToString(s1["ComPort"]).Replace("COM", ""), Baud = CommFunc.ConvertDBNullToInt32(s1["Baud"]), DataBit = CommFunc.ConvertDBNullToInt32(s1["DataBit"]), StopBit = CommFunc.ConvertDBNullToInt32(s1["StopBit"]), Parity = CommFunc.ConvertDBNullToInt32(s1["Parity"]), Mm_id = CommFunc.ConvertDBNullToInt32(s1["Mm_id"]), EmType = CommFunc.ConvertDBNullToString(s1["EmType"]), Inst_loc = CommFunc.ConvertDBNullToString(s1["Inst_loc"]), Disabled = CommFunc.ConvertDBNullToInt32(s1["Disabled"]), Remark = CommFunc.ConvertDBNullToString(s1["Remark"]), Multiply = CommFunc.ConvertDBNullToDecimal(s1["Multiply"]), EnergyItemCode = CommFunc.ConvertDBNullToString(s1["EnergyItemCode"]), Co_id = CommFunc.ConvertDBNullToInt32(s1["Co_id"]), CoName = CommFunc.ConvertDBNullToInt32(s1["CoName"]), IsAlarm = CommFunc.ConvertDBNullToInt32(s1["IsAlarm"]), MinPay = CommFunc.ConvertDBNullToInt32(s1["MinPay"]), Price = CommFunc.ConvertDBNullToDecimal(s1["Price"]), Rate_id = CommFunc.ConvertDBNullToInt32(s1["Rate_id"]), }; return(res1.ToList()); }
private object GetYdRateNewList(int rate_id, string descr) { DataTable dtSource = bll.GetYdRateNewList(rate_id, descr); var res1 = from s1 in dtSource.AsEnumerable() select new { Rate_id = CommFunc.ConvertDBNullToInt32(s1["Rate_id"]), Descr = CommFunc.ConvertDBNullToString(s1["Descr"]), Unit = CommFunc.ConvertDBNullToString(s1["Unit"]), UnitBase = CommFunc.ConvertDBNullToDecimal(s1["UnitBase"]).ToString("f2"), Rule = CommFunc.ConvertDBNullToInt32(s1["Rule"]), UnitName = CommFunc.GetEnumDisplay(typeof(RateUnit), CommFunc.ConvertDBNullToString(s1["Unit"])), RuleName = CommFunc.GetEnumDisplay(typeof(RateRule), CommFunc.ConvertDBNullToInt32(s1["Rule"])), }; object obj = new { total = dtSource.Rows.Count, rows = res1.ToList() }; return(obj); }
/// <summary> /// 导出充值表 /// </summary> /// <param name="Room_id"></param> /// <returns></returns> public DataTable GetYdPayBill(long Log_id) { DataTable dtSource = dal.GetPayList(Log_id); dtSource.Columns.Add("payTypeS", typeof(System.String)); //充值类型 payType=1充值=2退电=3赠送电 dtSource.Columns.Add("strAmt", typeof(System.String)); //金额(大写) dtSource.Columns.Add("IsPayS", typeof(System.String)); //支付方式 foreach (DataRow dr in dtSource.Rows) { dr["Multiply"] = CommFunc.ConvertDBNullToDecimal(dr["Multiply"]).ToString("f2"); dr["PayVal"] = CommFunc.ConvertDBNullToDecimal(dr["PayVal"]).ToString("f2"); dr["PayAmt"] = CommFunc.ConvertDBNullToDecimal(dr["PayAmt"]).ToString("f2"); dr["strAmt"] = CommFunc.convertMoneytoRMB(CommFunc.ConvertDBNullToDecimal(dr["PayAmt"])); if (CommFunc.ConvertDBNullToInt32(dr["PayType"]) == 1) { dr["payTypeS"] = "充值"; } if (CommFunc.ConvertDBNullToInt32(dr["PayType"]) == 2) { dr["payTypeS"] = "退电"; dr["PayVal"] = "-" + CommFunc.ConvertDBNullToDecimal(dr["PayVal"]).ToString("f2"); dr["PayAmt"] = "-" + CommFunc.ConvertDBNullToDecimal(dr["PayAmt"]).ToString("f2"); } if (CommFunc.ConvertDBNullToInt32(dr["PayType"]) == 3) { dr["payTypeS"] = "赠送电"; } dr["Create_dt"] = CommFunc.ConvertDBNullToDateTime(dr["Create_dt"]).ToString("yyyy-MM-dd HH:mm:ss"); int isPay = CommFunc.ConvertDBNullToInt32(dr["IsPay"]); if (isPay == 0) { dr["IsPayS"] = "现金支付"; } else if (isPay == 1) { dr["IsPayS"] = "PC端微信支付"; } else if (isPay == 10) { dr["IsPayS"] = "手机微信支付"; } } return(dtSource); }
public int UpV4_pay_charg(long log_id, int co_id, decimal useAmt) { StringBuilder strSql = new StringBuilder(); using (var conn1 = SQLHelper.GetDBConnection()) {//更新数据库 try { conn1.Open(); using (var trans = conn1.BeginTransaction()) { DataTable dtSource = this.GetCoEleAmt(conn1, trans, co_id); decimal eleAmt = CommFunc.ConvertDBNullToDecimal(dtSource.Compute("sum(RdAmt)", "true")); eleAmt = Math.Abs(eleAmt); decimal RdCoAmt = this.GetCoRdAmt(conn1, trans, co_id); if (RdCoAmt < eleAmt + useAmt) { return(0); } foreach (DataRow dr in dtSource.Rows) { int module_id = CommFunc.ConvertDBNullToInt32(dr["Module_id"]); string moduleAddr = CommFunc.ConvertDBNullToString(dr["ModuleAddr"]); int fun_id = CommFunc.ConvertDBNullToInt32(dr["Fun_id"]); decimal rdVal = Math.Abs(CommFunc.ConvertDBNullToDecimal(dr["RdVal"])); decimal rdAmt = Math.Abs(CommFunc.ConvertDBNullToDecimal(dr["RdAmt"])); this.UpV2Info(conn1, trans, co_id, module_id, moduleAddr, fun_id, rdVal, rdAmt); } this.UpV4_pay_charg(conn1, trans, log_id, co_id, useAmt); trans.Commit(); } conn1.Close(); } catch (Exception ex) { throw ex; } finally { conn1.Close(); } } return(1); }
public object GetMgrStatus(string pk) { DataTable dtSource = dal.GetMgrStatus(); List <object> dd = new List <object>(); int sc = 0; int oc = 0; int ec = 0; foreach (DataRow drp in dtSource.Rows) { string key = pk + CommFunc.ConvertDBNullToString(drp["LpszDbVarName"]); int i = 0; RstVar var = null; while (++i <= 2) { var = MemcachedMgr.GetVal <RstVar>(key); if (var != null) { break; } System.Threading.Thread.Sleep(50); } decimal?status = null; if (var != null) { status = CommFunc.ConvertDBNullToDecimal(var.lpszVal); //sc = sc + (CommFunc.ConvertDBNullToDecimal(var.lpszVal) == 0 ? 1 : 0); if (status == 0) { sc++; } else { oc++; } } else { ec++; } dd.Add(new { moduleName = CommFunc.ConvertDBNullToString(drp["CoName"]), status = status }); } return(new { status = new { count = dtSource.Rows.Count, online = sc, offline = oc, errCnt = ec }, list = dd }); }
/// <summary> /// 回来能耗统计分析(区间粒度) /// </summary> /// <param name="selKey">选择的对象</param> /// <param name="start">开始时间</param> /// <param name="end">结束时间</param> /// <returns></returns> public APIResult GetYdModuleCollectValList(string selKey, DateTime start, DateTime end) { APIResult rst = new APIResult(); try { string[] kk = selKey.Split(new char[] { '-' }, StringSplitOptions.RemoveEmptyEntries); int id = kk.Count() != 2 ? 0 : CommFunc.ConvertDBNullToInt32(kk[1]); int co_id = 0, meter_id = 0; if (selKey.Contains("M-")) { meter_id = id; } else { co_id = id; } DataTable dtSource = bll.GetYdModuleCollectValList(co_id, meter_id, start, end); var res1 = from s1 in dtSource.AsEnumerable() select new { RowId = dtSource.Rows.IndexOf(s1) + 1, Module_id = CommFunc.ConvertDBNullToInt32(s1["Module_id"]), ModuleAddr = CommFunc.ConvertDBNullToString(s1["ModuleAddr"]), Start = CommFunc.ConvertDBNullToDateTime(s1["Start"]).ToString("yyyy-MM-dd"), End = CommFunc.ConvertDBNullToDateTime(s1["End"]).ToString("yyyy-MM-dd"), FirstVal = s1["FirstVal"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["FirstVal"]).ToString("f2"), LastVal = s1["LastVal"] == DBNull.Value ? "" : CommFunc.ConvertDBNullToDecimal(s1["LastVal"]).ToString("f2"), ModuleName = CommFunc.ConvertDBNullToString(s1["ModuleName"]), RoomName = CommFunc.ConvertDBNullToString(s1["RoomName"]), StrcName = CommFunc.ConvertDBNullToString(s1["StrcName"]), }; rst.Code = 0; rst.Msg = ""; rst.Data = new { total = dtSource.Rows.Count, rows = res1.ToList() }; } catch (Exception ex) { rst.Code = -1; rst.Msg = ex.Message; FileLog.WriteLog("获取按区间粒度列表错误(GetYdModuleCollectValList):" + ex.Message + ex.StackTrace); } return(rst); }
/// <summary> /// 获取设备信息 /// </summary> /// <param name="meter_id">设备信息ID号</param> /// <param name="meterName">设备名称</param> /// <returns></returns> public APIResult GetMeterList(int meter_id, string meterName) { APIResult rst = new APIResult(); try { DataTable dtSource = bll.GetMeterList(meter_id, meterName); var res1 = from s1 in dtSource.AsEnumerable() select new { RowId = dtSource.Rows.IndexOf(s1) + 1, Meter_id = CommFunc.ConvertDBNullToInt32(s1["Meter_id"]), Esp_id = CommFunc.ConvertDBNullToString(s1["Esp_id"]), MeterAddr = CommFunc.ConvertDBNullToString(s1["MeterAddr"]), MeterName = CommFunc.ConvertDBNullToString(s1["MeterName"]), Inst_loc = CommFunc.ConvertDBNullToString(s1["Inst_loc"]), Supplier = CommFunc.ConvertDBNullToString(s1["Supplier"]), //Switch = CommFunc.ConvertDBNullToString(s1["Switch"]), //ChrgType = CommFunc.ConvertDBNullToInt32(s1["ChrgType"]), Remark = CommFunc.ConvertDBNullToString(s1["Remark"]), Disabled = CommFunc.ConvertDBNullToInt32(s1["Disabled"]), Multiply = CommFunc.ConvertDBNullToDecimal(s1["Multiply"]), RoomId = CommFunc.ConvertDBNullToInt32(s1["RoomId"]), MeterTypeId = CommFunc.ConvertDBNullToInt32(s1["MeterTypeId"]), MeterType = CommFunc.ConvertDBNullToString(s1["MeterType"]), MeterTypeName = CommFunc.ConvertDBNullToString(s1["MeterTypeName"]), RoomName = CommFunc.ConvertDBNullToString(s1["RoomName"]), //ChrgTypeName = CommFunc.GetEnumDisplay(typeof(ChargAttrib), CommFunc.ConvertDBNullToInt32(s1["ChrgType"])), EspName = CommFunc.ConvertDBNullToString(s1["EspName"]), }; object obj = new { total = dtSource.Rows.Count, rows = res1.ToList() }; rst.Code = 0; rst.Msg = ""; rst.Data = obj; } catch (Exception ex) { rst.Code = -1; rst.Msg = ex.Message; FileLog.WriteLog("获取设备信息信息错误(GetMeterList):" + ex.Message + ex.StackTrace); } return(rst); }
/// <summary> /// 站点场景类型统计分析 /// </summary> /// <param name="areaId">区域ID号</param> /// <param name="start">开始时间</param> /// <param name="end">结束时间</param> /// <param name="roomSightId">场景ID号</param> /// <returns></returns> public APIResult GetRptRoomSightList(int areaId, DateTime start, DateTime end, int roomSightId) { APIResult rst = new APIResult(); try { DataTable dtSource = bll.GetRptRoomSightList(areaId, start, end, roomSightId); var res1 = from s1 in dtSource.AsEnumerable() select new { RowId = dtSource.Rows.IndexOf(s1) + 1, RoomId = CommFunc.ConvertDBNullToInt32(s1["RoomId"]), RoomSightId = CommFunc.ConvertDBNullToInt32(s1["RoomSightId"]), RoomNo = CommFunc.ConvertDBNullToString(s1["RoomNo"]), RoomName = CommFunc.ConvertDBNullToString(s1["RoomName"]), Address = CommFunc.ConvertDBNullToString(s1["Address"]), RoomSightName = CommFunc.ConvertDBNullToString(s1["RoomSightName"]), StrcName = CommFunc.ConvertDBNullToString(s1["StrcName"]), UseVal = CommFunc.ConvertDBNullToDecimal(s1["UseVal"]).ToString("f2"), LastTime = CommFunc.ConvertDBNullToDateTime(s1["LastTime"]).ToString("yyyy-MM-dd HH:mm:ss"), }; var res2 = from s1 in dtSource.AsEnumerable() group s1 by new { RoomSightId = CommFunc.ConvertDBNullToInt32(s1["RoomSightId"]) } into g1 select new { RoomSightId = g1.Key.RoomSightId, RoomSightName = CommFunc.ConvertDBNullToString(g1.First()["RoomSightName"]), UseVal = g1.Sum(p => CommFunc.ConvertDBNullToDecimal(p["UseVal"])), Cnt = g1.Count() }; rst.Code = 0; rst.Msg = ""; rst.Data = new { total = dtSource.Rows.Count, rows = res1.ToList(), charts = res2.ToList() }; } catch (Exception ex) { rst.Code = -1; rst.Msg = ex.Message; FileLog.WriteLog("站点场景类型统计分析(GetRptRoomSightList):" + ex.Message + ex.StackTrace); } return(rst); }
private int GetStatus(string tag, string dataValue, DateTime update_dt) { string key = user.CacheKey + tag; int i = 0; RstVar var = null; while (++i <= 2) { var = MemcachedMgr.GetVal <RstVar>(key); if (var != null) { break; } System.Threading.Thread.Sleep(50); } decimal?value = null;// "未知"; int realStatus = 1; if (var != null) { value = CommFunc.ConvertDBNullToDecimal(var.lpszVal); // 值 } if (!string.IsNullOrEmpty(dataValue)) { decimal realVal = value == null ? -1 : value.Value; if (realVal == CommFunc.ConvertDBNullToDecimal(dataValue)) {/*值相等设置成功*/ realStatus = 1; } else { if (update_dt.AddMinutes(1) > DateTime.Now) {/*正在设置*/ realStatus = 0; } else {/*超过两分钟设置全部按缓存值*/ realStatus = -1; } } } return(realStatus); }
/// <summary> /// 保存修改错误数据 /// </summary> /// <returns></returns> public APIRst SaveVal(int RowId, int Co_id, int Log_id, int Module_id, int Fun_id, string ModuleAddr, decimal LastValOld, decimal LastVal, decimal FirstVal) { decimal charge = LastValOld - FirstVal; FirstVal = LastVal - charge; APIRst rst = new APIRst(); try { int total = 0; bll.SetV2_infoInVal(Log_id, Co_id, Module_id, ModuleAddr, Fun_id, FirstVal, LastVal); DataTable dtSource = bll.GetTabVal(Co_id, ModuleAddr); total = dtSource.Rows.Count; var res1 = from s1 in dtSource.AsEnumerable() select new { RowId = RowId, Co_id = CommFunc.ConvertDBNullToInt32(s1["Co_id"]), Log_id = CommFunc.ConvertDBNullToInt32(s1["Log_id"]), CoStrcName = CommFunc.ConvertDBNullToString(s1["CoStrcName"]), CoName = CommFunc.ConvertDBNullToString(s1["CoName"]), ModuleAddr = CommFunc.ConvertDBNullToString(s1["ModuleAddr"]), AType = CommFunc.ConvertDBNullToString(s1["AType"]), Content = CommFunc.ConvertDBNullToString(s1["Content"]), ErrCode = CommFunc.ConvertDBNullToString(s1["ErrCode"]), CollectTime = CommFunc.ConvertDBNullToDateTime(s1["CollectTime"]).ToString("yyyy-MM-dd HH:mm:ss"), FirstVal = CommFunc.ConvertDBNullToDecimal(s1["FirstVal"]), LastVal = CommFunc.ConvertDBNullToDecimal(s1["LastVal"]), LastValOld = CommFunc.ConvertDBNullToDecimal(s1["LastVal"]), LastTime = CommFunc.ConvertDBNullToDateTime(s1["LastTime"]).ToString("yyyy-MM-dd HH:mm:ss"), }; rst.data = res1.ToList(); } 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); }
private bool AddType(ref SortedList <string, Data> source, ref List <Data> ld, int type) { if (source.Count == 0) { return(true); } Data de = new Data(); decimal useValE0 = 0, useValEa = 0; foreach (var dd in source) { de.FunType = type == 0 ? "E" : "E4"; de.Type = 0; de.Time = dd.Value.Time; if (!string.IsNullOrEmpty(de.DataValue)) { de.DataValue = de.DataValue + ","; } if (dd.Key.Equals("E0")) { de.DataValue = "E0:{0}"; useValE0 = CommFunc.ConvertDBNullToDecimal(dd.Value.DataValue); } else { useValEa = useValEa + CommFunc.ConvertDBNullToDecimal(dd.Value.DataValue); de.DataValue = de.DataValue + dd.Key + ":" + dd.Value.DataValue; } } bool rst = true; if (Math.Abs(useValE0 - useValEa) > (decimal)0.01) { FileLog.WriteLog((type == 0 ? "非" : "") + "冻结数据E0不等于4个费率之和:" + de.DataValue); rst = false; } else { de.DataValue = string.Format(de.DataValue, useValEa.ToString()); ld.Add(de); } return(rst); }
/// <summary> /// 采集异常告警列表 /// </summary> /// <returns></returns> public APIRst GetYdAlarmOfUnusualList(string strcName, string coName, string startTime, string endTime) { APIRst rst = new APIRst(); try { DataTable dtSource = bll.GetYdAlarmOfUnusualList(strcName, coName, CommFunc.ConvertDBNullToDateTime(startTime), CommFunc.ConvertDBNullToDateTime(endTime)); int total = dtSource.Rows.Count; var res1 = from s1 in dtSource.AsEnumerable() select new { RowId = CommFunc.ConvertDBNullToInt32(s1["RowId"]), Co_id = CommFunc.ConvertDBNullToInt32(s1["Co_id"]), Log_id = CommFunc.ConvertDBNullToInt32(s1["Log_id"]), Module_id = CommFunc.ConvertDBNullToInt32(s1["Module_id"]), ModuleName = CommFunc.ConvertDBNullToString(s1["ModuleName"]), Fun_id = CommFunc.ConvertDBNullToInt32(s1["Fun_id"]), CoStrcName = CommFunc.ConvertDBNullToString(s1["CoStrcName"]), CoName = CommFunc.ConvertDBNullToString(s1["CoName"]), ModuleAddr = CommFunc.ConvertDBNullToString(s1["ModuleAddr"]), ModuleAddrS = CommFunc.ConvertDBNullToString(s1["ModuleAddr"]), AType = CommFunc.ConvertDBNullToString(s1["AType"]), Content = CommFunc.ConvertDBNullToString(s1["Content"]), ErrCode = CommFunc.ConvertDBNullToString(s1["ErrCode"]), CollectTime = CommFunc.ConvertDBNullToDateTime(s1["CollectTime"]).ToString("yyyy-MM-dd HH:mm:ss"), FirstVal = CommFunc.ConvertDBNullToDecimal(s1["FirstVal"]), LastVal = CommFunc.ConvertDBNullToDecimal(s1["LastVal"]), LastValOld = CommFunc.ConvertDBNullToDecimal(s1["LastVal"]), LastTime = CommFunc.ConvertDBNullToDateTime(s1["LastTime"]).ToString("yyyy-MM-dd HH:mm:ss"), }; object obj = new { total = total, rows = res1.ToList() }; rst.data = obj; } catch (Exception ex) { rst.rst = false; rst.err.code = (int)ResultCodeDefine.Error; rst.err.msg = ex.Message; FileLog.WriteLog("获取告警内容错误(GetYdAlarmOfUnusualList)", ex.Message + ex.StackTrace); } return(rst); }
private int MeterInfo(DataRow dr, int esp_id) { v1_gateway_esp_meterVModel vm = new v1_gateway_esp_meterVModel() { Esp_id = esp_id, MeterAddr = CommFunc.ConvertDBNullToString(dr["MeterAddr"]), Multiply = CommFunc.ConvertDBNullToDecimal(dr["Multiply"]) }; string moduleType = CommFunc.ConvertDBNullToString(dr["ModuleType"]); string msg = ""; bool isUp = false; //更新 DataTable dtMdInfo = dal.GetMeterInfo(esp_id, vm.MeterAddr); DataRow[] arr = dtMdInfo.Select(); if (arr.Count() > 0) { vm.Meter_id = CommFunc.ConvertDBNullToInt32(arr[0]["Meter_id"]); if (!moduleType.Equals(CommFunc.ConvertDBNullToString(arr[0]["ModuleType"]))) { isUp = true; } else if (vm.Multiply != CommFunc.ConvertDBNullToDecimal(arr[0]["Multiply"])) { isUp = true; } } else { isUp = true; } if (isUp == true) { int meter_id = dal.UpdateMeterInfo(vm, moduleType, out msg); if (meter_id == 0) { dr["ErrCode"] = -1; dr["ErrTxt"] = msg; } } return(vm.Meter_id); }
public APIRst GetYdAlarmOfChargeList(string strcName, string coName, string isPay, string startTime, string endTime) { APIRst rst = new APIRst(); try { DataTable dtSource = bll.GetYdAlarmOfChargeList(strcName, coName, isPay, CommFunc.ConvertDBNullToDateTime(startTime), CommFunc.ConvertDBNullToDateTime(endTime)); int total = dtSource.Rows.Count; var res1 = from s1 in dtSource.AsEnumerable() select new { RowId = CommFunc.ConvertDBNullToInt32(s1["RowId"]), Co_id = CommFunc.ConvertDBNullToInt32(s1["Co_id"]), CoStrcName = CommFunc.ConvertDBNullToString(s1["CoStrcName"]), CoName = CommFunc.ConvertDBNullToString(s1["CoName"]), Module_id = CommFunc.ConvertDBNullToInt32(s1["Module_id"]), ModuleName = CommFunc.ConvertDBNullToString(s1["ModuleName"]), ModuleAddr = CommFunc.ConvertDBNullToString(s1["ModuleAddr"]), IsPay = CommFunc.ConvertDBNullToInt32(s1["IsPay"]), IsPayS = CommFunc.ConvertDBNullToString(s1["IsPayS"]), Trade_no = CommFunc.ConvertDBNullToString(s1["Trade_no"]), PayAmt = CommFunc.ConvertDBNullToDecimal(s1["PayAmt"]).ToString("f2"), PayVal = CommFunc.ConvertDBNullToDecimal(s1["PayVal"]).ToString("f2"), ErrCode = CommFunc.ConvertDBNullToInt32(s1["ErrCode"]), ErrTxt = ((CommFunc.ConvertDBNullToInt32(s1["IsPay"]) == 1 && CommFunc.ConvertDBNullToInt32(s1["ErrCode"]) == -2) || (CommFunc.ConvertDBNullToInt32(s1["IsPay"]) == 10 && CommFunc.ConvertDBNullToInt32(s1["ErrCode"]) == 0)) ? "用户取消" : CommFunc.ConvertDBNullToString(s1["ErrTxt"]), Create_by = CommFunc.ConvertDBNullToString(s1["Create_by"]), Create_dt = CommFunc.ConvertDBNullToDateTime(s1["Create_dt"]).ToString("yyyy-MM-dd HH:mm:ss"), PayType = CommFunc.ConvertDBNullToInt32(s1["PayType"]), PayTypeS = CommFunc.ConvertDBNullToString(s1["PayTypeS"]), }; object obj = new { total = total, rows = res1.ToList() }; rst.data = obj; } catch (Exception ex) { rst.rst = false; rst.err.code = (int)ResultCodeDefine.Error; rst.err.msg = ex.Message; FileLog.WriteLog("获取充值用电告警错误(YdAlarmOnList)", ex.Message + ex.StackTrace); } return(rst); }
//缴费总列表 public APIRst GetYdPrePayInMdOnList(string strcName, string coName, int co_id) { APIRst rst = new APIRst(); try { DataTable dtSource = bll.GetYdPrePayInMdOnList(strcName, coName, co_id); int total = dtSource.Rows.Count; int RowId = 0; var res1 = from s1 in dtSource.AsEnumerable() select new { RowId = ++RowId, Co_id = CommFunc.ConvertDBNullToInt32(s1["Co_id"]), CoStrcName = CommFunc.ConvertDBNullToString(s1["CoStrcName"]), CoName = CommFunc.ConvertDBNullToString(s1["CoName"]), Module_id = CommFunc.ConvertDBNullToInt32(s1["Module_id"]), MeterName = CommFunc.ConvertDBNullToString(s1["MeterName"]), Fun_id = CommFunc.ConvertDBNullToInt32(s1["Fun_id"]), ModuleAddr = CommFunc.ConvertDBNullToString(s1["ModuleAddr"]), ChrgVal = CommFunc.ConvertDBNullToDecimal(s1["ChrgVal"]).ToString("f2"), UseVal = CommFunc.ConvertDBNullToDecimal(s1["UseVal"]).ToString("f2"), RdVal = CommFunc.ConvertDBNullToDecimal(s1["RdVal"]).ToString("f2"), RdAmt = (CommFunc.ConvertDBNullToDecimal(s1["RdVal"]) * CommFunc.ConvertDBNullToDecimal(s1["Price"])).ToString("f2"), Price = CommFunc.ConvertDBNullToDecimal(s1["Price"]).ToString("f3"), ZsVal = CommFunc.ConvertDBNullToDecimal(s1["ZsVal"]).ToString("f2"), SyZsVal = CommFunc.ConvertDBNullToDecimal(s1["SyZsVal"]).ToString("f2"), SyVal = (CommFunc.ConvertDBNullToDecimal(s1["RdVal"]) - CommFunc.ConvertDBNullToDecimal(s1["SyZsVal"])).ToString("f2") }; object obj = new { total = total, rows = res1.ToList() }; rst.data = obj; } catch (Exception ex) { rst.rst = false; rst.err.code = (int)ResultCodeDefine.Error; rst.err.msg = ex.Message; FileLog.WriteLog("获取预付费页面错误:(GetYdPrePayInMdOnList)", ex.Message + ex.StackTrace); } return(rst); }
/// <summary> /// 汇出Excel(充值缴费--打印小票) /// </summary> /// <returns></returns> public APIRst GetYdPrePayInMdExcel(int Co_id, string PayAmt, int IsPay) { long Room_id = CommFunc.ConvertDBNullToLong(Co_id); //房间id PayAmt = CommFunc.ConvertDBNullToDecimal(PayAmt).ToString("f2"); //缴费金额 //int IsPay = CommFunc.ConvertDBNullToInt32(Request["IsPay"]);//缴费方式:=0现金充值,=10微信充值 APIRst rst = new APIRst(); try { DataTable dtSource = bll.GetPayList(Room_id, PayAmt, IsPay); //string path = GetYdPayLogOnExport(dtSource); //return Json(new { rst = true, msg = "", data = path }, JsonRequestBehavior.DenyGet); int total = dtSource.Rows.Count; var res1 = from s1 in dtSource.AsEnumerable() select new { CoStrcName = CommFunc.ConvertDBNullToString(s1["CoStrcName"]), CoName = CommFunc.ConvertDBNullToString(s1["CoName"]), Multiply = CommFunc.ConvertDBNullToDecimal(s1["Multiply"]), IsPayS = CommFunc.ConvertDBNullToString(s1["IsPayS"]), payTypeS = CommFunc.ConvertDBNullToString(s1["payTypeS"]), PayVal = CommFunc.ConvertDBNullToDecimal(s1["PayVal"]).ToString("f2"), PayAmt = CommFunc.ConvertDBNullToDecimal(s1["PayAmt"]).ToString("f2"), Price = CommFunc.ConvertDBNullToDecimal(s1["Price"]).ToString("f3"), strAmt = CommFunc.ConvertDBNullToString(s1["strAmt"]), Create_by = CommFunc.ConvertDBNullToString(s1["Create_by"]), Create_dt = CommFunc.ConvertDBNullToString(s1["Create_dt"]), }; rst.data = res1.ToList(); //return Json(new { rst = true, msg = "", data = new { total = total, rows = res1.ToList() } }, JsonRequestBehavior.DenyGet); } catch (Exception ex) { rst.rst = false; rst.err.code = (int)ResultCodeDefine.Error; rst.err.msg = ex.Message; FileLog.WriteLog("GetYdPrePayInMdExcel:" + ex.Message + ex.StackTrace); } return(rst); }