public string GetCardUserById(string loginIdentifer, string cardUserID) { JavaScriptObject obj2 = new JavaScriptObject(); obj2.Add("Result", false); obj2.Add("Message", ""); obj2.Add("CardUser", new JavaScriptObject()); try { ResMsg msg = CommonUtil.CheckLoginState(loginIdentifer, true); if (!msg.Result) { obj2["Message"] = msg.Message; return(JavaScriptConvert.SerializeObject(obj2)); } if ((cardUserID == null) || (cardUserID.Trim() == "")) { obj2["Message"] = "用水户卡ID不能为空"; return(JavaScriptConvert.SerializeObject(obj2)); } CardUser cardUser = CardUserModule.GetCardUserById(long.Parse(cardUserID)); if (cardUser == null) { obj2["Message"] = "ID为" + cardUserID + "用水户卡不存在"; return(JavaScriptConvert.SerializeObject(obj2)); } obj2["Result"] = true; obj2["CardUser"] = CardUserModule.CardUserToJson(cardUser); } catch (Exception exception) { obj2["Message"] = exception.Message; } return(JavaScriptConvert.SerializeObject(obj2)); }
private JavaScriptObject CardUserWaterLog(HttpRequest request) { string SerialNumber = request["SerialNumber"] ?? ""; string UserNo = request["UserNo"] ?? ""; string DeviceNo = request["DeviceNo"] ?? ""; string StartTime = request["StartTime"] ?? ""; string StartResidualWater = request["StartResidualWater"] ?? ""; string StartResidualElectric = request["StartResidualElectric"] ?? ""; string EndTime = request["EndTime"] ?? ""; string EndResidualWater = request["EndResidualWater"] ?? ""; string EndResidualElectric = request["EndResidualElectric"] ?? ""; JavaScriptObject result = new JavaScriptObject(); result.Add("Result", false); result.Add("Message", ""); try { CardUser cu = CardUserModule.GetCardUserBySerialNumber(SerialNumber); if (cu == null) { result["Message"] = "卡序列号" + SerialNumber + "的用水户不存在!"; return(result); } Device device = DeviceModule.GetDeviceByFullDeviceNo(DeviceNo); if (device == null) { result["Message"] = "设备长编号" + DeviceNo + "不存在!"; return(result); } CardUserWaterLog cuwLog = new CardUserWaterLog(); cuwLog.SerialNumber = SerialNumber; cuwLog.WateUserId = cu.WaterUserId; cuwLog.UserNo = UserNo; cuwLog.DeviceId = device.Id; cuwLog.DeviceNo = DeviceNo; cuwLog.StartTime = DateTime.Parse(StartTime); cuwLog.StartResidualWater = decimal.Parse(StartResidualWater); cuwLog.StartResidualElectric = decimal.Parse(StartResidualElectric); cuwLog.EndTime = DateTime.Parse(EndTime); cuwLog.EndResidualWater = decimal.Parse(EndResidualWater); cuwLog.EndResidualElectric = decimal.Parse(EndResidualElectric); cuwLog.WaterUsed = decimal.Parse(EndResidualWater) - decimal.Parse(StartResidualWater); cuwLog.ElectricUsed = decimal.Parse(EndResidualElectric) - decimal.Parse(StartResidualElectric); cuwLog.Duration = Convert.ToDecimal((DateTime.Parse(EndTime) - DateTime.Parse(StartTime)).TotalSeconds); CardUserWaterLogModule.AddCardUserWaterLog(cuwLog); result["Result"] = true; } catch (Exception ex) { result["Message"] = "用户用水保存出错!"; myLogger.Error(ex.Message); } return(result); }
public string GetCardUsersByVillageId(string loginIdentifer, string villageId, bool isExport) { JavaScriptObject obj2 = new JavaScriptObject(); JavaScriptArray array = new JavaScriptArray(); obj2.Add("Result", false); obj2.Add("Message", ""); obj2.Add("CardUsers", array); try { ResMsg msg = CommonUtil.CheckLoginState(loginIdentifer, true); if (!msg.Result) { obj2["Message"] = msg.Message; return(JavaScriptConvert.SerializeObject(obj2)); } if ((villageId == null) || (villageId.Trim() == "")) { obj2["Message"] = "参数villageId不能为空"; return(JavaScriptConvert.SerializeObject(obj2)); } if (DistrictModule.ReturnDistrictInfo(long.Parse(villageId)) == null) { obj2["Message"] = "ID为" + villageId + "的村庄不存在"; return(JavaScriptConvert.SerializeObject(obj2)); } //List<CardUser> liCardUsers = CardUserModule.GetCardUsersByDistrictId(long.Parse(villageId), true); //foreach (CardUser info in liCardUsers) //{ // array.Add(CardUserModule.CardUserToJson(info)); //} List <WaterUser> liWaterUser = WaterUserModule.GetWaterUsersByDistrictId(long.Parse(villageId), true); foreach (WaterUser wui in liWaterUser) { List <CardUser> liCardUsers = CardUserModule.GetCardUsersByWaterUserId(wui.id, true); foreach (CardUser info in liCardUsers) { array.Add(CardUserModule.CardUserToJson(info)); } } obj2["Result"] = true; } catch (Exception exception) { obj2["Message"] = exception.Message; } return(JavaScriptConvert.SerializeObject(obj2)); }
private void button1_Click(object sender, EventArgs e) { this.label7.Text = ""; try { CardUserModule.LoadCardUsers(); this.label4.Text = CardUserModule.GetAllCardUser(true).Count.ToString(); this.label7.ForeColor = Color.Green; this.label7.Text = "更新成功"; } catch { this.label7.ForeColor = Color.Red; this.label7.Text = "更新失败"; } }
//启动时,设备全部显示离线 #region 2015-8-7 每次启动时,将登陆状态置为0 void installDeviceState() { try { BaseModule.LoadBaseInfo(); CardUserModule.LoadCardUsers(); DistrictModule.UpdateLevelInfo(); DistrictModule.UpdateDistrictInfo(); //将在线状态置为0 DeviceModule.SetOnline0(); DeviceModule.LoadDevices(); /* * IList<Device> deviceList = DeviceModule.GetAllDevice(); * * foreach (Device d in deviceList) * { * if (d.Online == 1) * { * d.Online = 0; * DeviceModule.ModifyDevice(d); * } * } * */ AlarmService.Init(); int alarmCount = AlarmService.GetCount(); //logHelper.Info("程序启动报警数量为:" + alarmCount); ShowLogData.add("程序启动报警数量为:" + alarmCount); } catch (Exception e) { if (showErrorLog) { string error = string.Format("在将设备登陆状态置为0时,读取数据库时出错,错误信息{0}", e.Message); logHelper.Error(error); } } finally { } }
public string GetCardUsersByWaterUserIds(string loginIdentifer, string waterUserIds) { JavaScriptObject obj2 = new JavaScriptObject(); JavaScriptArray array = new JavaScriptArray(); obj2.Add("Result", false); obj2.Add("Message", ""); obj2.Add("CardUsers", array); try { ResMsg msg = CommonUtil.CheckLoginState(loginIdentifer, true); if (!msg.Result) { obj2["Message"] = msg.Message; return(JavaScriptConvert.SerializeObject(obj2)); } if ((waterUserIds == null) || (waterUserIds.Trim() == "")) { obj2["Message"] = "用水户ID不能为空"; return(JavaScriptConvert.SerializeObject(obj2)); } foreach (string str in waterUserIds.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries)) { WaterUser wui = WaterUserModule.GetWaterUserById(long.Parse(str)); if (wui == null) { obj2["Message"] = "ID为" + str + "的用水户不存在"; return(JavaScriptConvert.SerializeObject(obj2)); } List <CardUser> liCardUsers = CardUserModule.GetCardUsersByWaterUserId(wui.id, true); foreach (CardUser info in liCardUsers) { array.Add(CardUserModule.CardUserToJson(info)); } } obj2["Result"] = true; } catch (Exception exception) { obj2["Message"] = exception.Message; } return(JavaScriptConvert.SerializeObject(obj2)); }
private void Refresh() { int i = 0; while (!isClose) { i++; if (i == 2 * 10) { WaterUserModule.LoadWaterUsers(); CardUserModule.LoadCardUsers(); i = 0; } DeviceModule.LoadDevices(); //间隔30秒 Thread.Sleep(30 * 1000); } }
//根据信息的种类 ,进行处理:1.数据信息,发送给DTU 2.控制命令,发送给WEB 3.设备列表,更新显示表格 private void proxyProcess(DataTransfer transfer) { switch (transfer.TransferType) { case DataTransferType.DataTransferDataInfo: { DataTransferInfo info = transfer.TransferDataInfo; DeviceInfo di = new DeviceInfo(); di.Parse(info.DeviceNo); string DeviceFullNo = DeviceModule.DeviceNo_Hex2Normal(di.SerialString); string DeviceFullNoMain = DeviceModule.GetDeviceNoMain(DeviceFullNo); bridge.sendToDtu(DeviceFullNo, DeviceFullNoMain, info.Data, info.Offset, info.Length); break; } case DataTransferType.DataTransferCommand: { DTU.GateWay.Protocol.Command command = transfer.TransferCommand; bridge.sendToWeb(command.DeviceInfo.SerialLong, command); break; } case DataTransferType.DataTransferDeviceList: { Device deviceList = transfer.DeviceList; DeviceEvent deviceEvent = transfer.DeviceEvent; updateDeviceListInGridView(deviceList, deviceEvent); break; } case DataTransferType.DataTransferLog: { break; } case DataTransferType.DataTransferUpdateDevice: { string kt = transfer.KeyType; string key = transfer.Key; if (SysCache.ShowInfoLog) { ShowLogData.add("更新设备缓存:" + kt + "," + key); logHelper.Info("更新设备缓存:" + kt + "," + key); } if (kt == "01") { Device device = DeviceModule.GetDeviceByFullDeviceNo_DB(key); if (device != null) { DeviceModule.UpdateDeviceInfo(device); if (dtuServer != null) { dtuServer.updateDevice(device); } updateDeviceListInGridView(device, null); } else { if (SysCache.ShowInfoLog) { ShowLogData.add("更新设备缓存:" + kt + "," + key + " 无法更新设备不存在"); logHelper.Info("更新设备缓存:" + kt + "," + key + " 无法更新设备不存在"); } } } else if (kt == "02") { DeviceModule.RemoveDeviceInfo(key); lock (this.deviceListsDataGridView) { int rows = this.deviceListsDataGridView.Rows.Count; for (int i = 0; i < rows; i++) { object obj = this.deviceListsDataGridView.Rows[i].Cells[1].Value; if (obj != null) { string val = obj.ToString(); if (val.Equals(key)) { this.deviceListsDataGridView.Rows.Remove(this.deviceListsDataGridView.Rows[i]); return; } } } } } break; } case DataTransferType.DataTransferUpdateCardUser: { string kt = transfer.KeyType; string key = transfer.Key; ShowLogData.add("更新用户卡缓存:" + kt + "," + key); if (kt == "01") { CardUser cardUser = CardUserModule.GetCardUserBySerialNumber_DB(key); if (cardUser != null) { CardUserModule.UpdateCardUserInfo(cardUser); } } else if (kt == "02") { CardUserModule.RemoveCardUserInfo(key); } break; } case DataTransferType.DataTransferUpdateDistrict: { ShowLogData.add("更新地区缓存"); initDistrictTree(); break; } } }
public string RefreshCache(string loginIdentifer, string CacheName) { JavaScriptObject obj2 = new JavaScriptObject(); obj2["Result"] = false; obj2["Message"] = ""; LoginUser loginUser = GlobalAppModule.GetLoginUser(loginIdentifer); if (loginUser == null) { obj2["Message"] = "未登录"; return(JavaScriptConvert.SerializeObject(obj2)); } if (loginUser.LoginTimeout) { obj2["Message"] = "登录超时"; return(JavaScriptConvert.SerializeObject(obj2)); } loginUser.LastOperateTime = DateTime.Now; CommonUtil.WaitMainLibInit(); GlobalAppModule.IsInitMainLib = true; try { if (CacheName == "基础信息") { BaseModule.LoadBaseInfo(); MenuModule.MenuInit(); RoleModule.UpdateRoleInfo(); SysUserModule.UpdateUserInfo(); DeviceTypeCodeModule.LoadDeviceTypeCodeInfos(); PriceModule.LoadPriceTypes(); PriceModule.LoadPriceInfos(); CropModule.LoadUnitQuotaInfos(); obj2["Result"] = true; } else if (CacheName == "用水户") { WaterUserModule.LoadWaterUsers(); obj2["Result"] = true; } else if (CacheName == "用户卡") { CardUserModule.LoadCardUsers(); obj2["Result"] = true; } else if (CacheName == "设备") { DeviceModule.LoadDevices(); obj2["Result"] = true; } else if (CacheName == "区域") { DistrictModule.UpdateLevelInfo(); DistrictModule.UpdateDistrictInfo(); obj2["Result"] = true; } else { obj2["Message"] = "参数错误!【" + CacheName + "】"; } } catch (Exception ex) { obj2["Message"] = "刷新缓存【" + CacheName + "】出错!" + ex.Message; } GlobalAppModule.IsInitMainLib = false; return(JavaScriptConvert.SerializeObject(obj2)); }
public string WriteOffWaterUserByUserSerialNumber(string loginIdentifer, string userSerialNumber) { JavaScriptObject obj2 = new JavaScriptObject(); obj2.Add("Result", false); obj2.Add("Message", ""); try { ResMsg msg = CommonUtil.CheckLoginState(loginIdentifer, true); if (!msg.Result) { obj2["Message"] = msg.Message; return(JavaScriptConvert.SerializeObject(obj2)); } LoginUser loginUser = GlobalAppModule.GetLoginUser(loginIdentifer); if ((userSerialNumber == null) || (userSerialNumber.Trim() == "")) { obj2["Message"] = "用户卡号不能为空"; return(JavaScriptConvert.SerializeObject(obj2)); } CardUser cu = CardUserModule.GetCardUserBySerialNumber(userSerialNumber); if (cu == null) { obj2["Message"] = "卡号为" + userSerialNumber + "的用户卡不存在"; return(JavaScriptConvert.SerializeObject(obj2)); } WaterUser wui = WaterUserModule.GetWaterUserById(cu.WaterUserId); if (wui == null) { obj2["Message"] = "卡号为" + userSerialNumber + "的用水户不存在"; return(JavaScriptConvert.SerializeObject(obj2)); } ResMsg msg1 = WaterUserModule.WriteOffWaterUserById(cu.WaterUserId); if (msg1.Result)//msg.Result { obj2["Result"] = true; } else { obj2["Message"] = msg.Message; } try { //添加日志 WaterUserLog log = new WaterUserLog(); log.WaterUserId = wui.id; log.LogUserId = loginUser.UserId; log.LogUserName = loginUser.LoginName; log.LogAddress = ToolsWeb.GetIP(context.Request); log.LogTime = loginUser.LastOperateTime; log.LogType = "注销"; log.LogContent = msg.Message; log.UserName = wui.UserName; log.Password = wui.Password; log.DistrictId = wui.DistrictId; log.TrueName = wui.TrueName; log.IdentityNumber = wui.IdentityNumber; log.Telephone = wui.Telephone; log.Address = wui.Address; log.WaterQuota = wui.WaterQuota; log.ElectricQuota = wui.ElectricQuota; log.Remark = wui.Remark; log.水价ID = wui.水价ID; log.电价ID = wui.电价ID; log.State = wui.State; WaterUserLogModule.Add(log); } catch { } } catch (Exception exception) { obj2["Message"] = exception.Message; } return(JavaScriptConvert.SerializeObject(obj2)); }
protected void Application_Start(object sender, EventArgs e) { string path = Server.MapPath("~/"); SysInfo.IsReg = false; SysInfo.DRegStr = "jssl160721"; SysInfo.RegStr = SysInfo.DRegStr; if (SysInfo.IsReg) { myLogger.Info("判断注册!"); SysInfo.SetFilePath(path); SysInfo.IsRegSuccess = false; string regStr = ""; if (FileHelper.IsExists(SysInfo.fileName)) { regStr = FileHelper.ReadFile(SysInfo.fileName); } else { regStr = "00000000000000000000000000000000"; FileHelper.writeFile(SysInfo.fileName, regStr); } if (regStr != SysInfo.GetRegStr2()) { myLogger.Info("注册码不对!序列号为:" + SysInfo.GetRegStr1()); } else { myLogger.Info("注册码正确"); SysInfo.IsRegSuccess = true; } } isClose = false; myLogger.Info("网站启动"); DbHelperSQL.SetConnectionString(ConfigurationManager.AppSettings["ConnectionString"]); GlobalAppModule.IsInitMainLib = true; BaseModule.LoadBaseInfo(); MenuModule.MenuInit(); RoleModule.UpdateRoleInfo(); SysUserModule.UpdateUserInfo(); //SysUserConfigModule.LoadSysUserConfig(); DeviceTypeCodeModule.LoadDeviceTypeCodeInfos(); PriceModule.LoadPriceTypes(); PriceModule.LoadPriceInfos(); CropModule.LoadUnitQuotaInfos(); DistrictModule.UpdateLevelInfo(); DistrictModule.UpdateDistrictInfo(); WaterUserModule.LoadWaterUsers(); DeviceModule.LoadDevices(); //Device_GroundWaterModule.LoadDevices(); CardUserModule.LoadCardUsers(); GlobalAppModule.IsInitMainLib = false; Thread thread = new Thread(new ThreadStart(testConnect)); thread.Start(); Thread threadDeleteXLS = new Thread(new ThreadStart(DeleteXLS)); threadDeleteXLS.Start(); Thread threadRefresh = new Thread(new ThreadStart(Refresh)); threadRefresh.Start(); myLogger.Info("网站启动完成!"); }