private void InsertreadMeterRecordLog(string RecordInfo) { var ur = JsonTool.Deserialize <WUploadUserReq>(RecordInfo); if (string.IsNullOrEmpty(ur.readMeterRecordId)) { return; } WSingleUserItemReq req = new WSingleUserItemReq(); req.readMeterRecordId = ur.readMeterRecordId; WUserItemRes wr = AService.GetSingleUserItemRes(req); if (wr.userItems.Count < 1) { return; } WUserItem wi = wr.userItems[0]; if (ur.chargeState == wi.ChaoBiaoTag && ur.checkState == wi.checkState && ur.chargeID == wi.chargeID && ur.waterMeterEndNumber == wi.CurrentMonthValue) { return; } ordernumber = wi.OrderNumber; waterUserNO = wi.UserNo; waterMeterNo = wi.StealNo; waterUserName = wi.UserFName; waterMeterLastNumber = wi.LastMonthValue; loginid = wi.loginId; UpdataMeterData(ur); }
private void InsertLogDt(string sr) { var ur = JsonTool.Deserialize <WUploadUserReq>(sr); if (string.IsNullOrEmpty(ur.readMeterRecordId)) { return; } WSingleUserItemReq req = new WSingleUserItemReq(); req.readMeterRecordId = ur.readMeterRecordId; WUserItemRes wr = AService.GetSingleUserItemRes(req); if (wr.userItems.Count < 1) { return; } WUserItem wi = wr.userItems[0]; try { if (wi.loginId == loginid) { if (ur.chargeState == wi.ChaoBiaoTag && ur.checkState == wi.checkState && ur.chargeID == wi.chargeID && ur.waterMeterEndNumber == wi.CurrentMonthValue) { return; } DataRow dr = LogDt.NewRow(); dr[0] = ur.readMeterRecordId; dr[1] = wi.UserNo; dr[2] = wi.UserFName; dr[3] = wi.LastMonthValue; dr[4] = ur.waterMeterEndNumber; dr[5] = FileCreateTime; dr[6] = wi.NoteNo; dr[7] = wi.StealNo; dr[8] = ur.chargeState; dr[9] = ur.chargeID; dr[10] = ur.readMeterRecordDate; dr[11] = wi.loginId; dr[12] = wi.USERNAME; dr[13] = ur.checkState; dr[14] = ur.checkDateTime; dr[15] = wi.OrderNumber; LogDt.Rows.Add(dr); } } catch (Exception) { } }
/// <summary> /// 获取 /// </summary> /// <param name="visitorid"></param> /// <returns></returns> public WUserItem GetWUserItem(string uin) { WUserItem item = null; if (string.IsNullOrEmpty(this._ConnectionString)) { LogHelper.Log("WUserData-GetWUserItem:" + "File ERROR"); return(item); } try { _LockSlim.EnterReadLock(); string sqlSelect = "SELECT * FROM WUserItem WHERE uin=@uin"; DapperHelper db = new DapperHelper(this._ConnectionString); try { item = db.QueryFirstOrDefault <WUserItem>(sqlSelect, new { uin }); } catch (Exception ex) { LogHelper.Log("WUserData-GetWUserItem:" + ex.ToString()); } finally { db.Close(); } } catch (Exception ex) { LogHelper.Log("WUserData-GetWUserItem:" + ex.ToString()); } finally { _LockSlim.ExitReadLock(); } return(item); }
/// <summary> /// 添加 /// </summary> /// <param name="item"></param> /// <returns></returns> public bool AddWUserItem(WUserItem item) { bool ret = false; if (item == null) { return(ret); } if (string.IsNullOrEmpty(this._ConnectionString)) { LogHelper.Log("WUserData-AddWUserItem:" + "File ERROR"); return(ret); } try { _LockSlim.EnterWriteLock(); DapperHelper db = new DapperHelper(this._ConnectionString); string sqlSelect = ""; Dictionary <string, object> parms = new Dictionary <string, object>(); //parms.Add("uin", item.uin); //parms.Add("createtime", item.createtime); //parms.Add("alias", item.alias); //parms.Add("nickname", item.nickname); //parms.Add("username", item.username); //parms.Add("city", item.city); //parms.Add("province", item.province); //parms.Add("pyquanpin", item.pyquanpin); //parms.Add("remarkname", item.remarkname); //parms.Add("remarkpyquanpin", item.remarkpyquanpin); //parms.Add("sex", item.sex); //parms.Add("signature", item.signature); //parms.Add("headimg", item.headimg); //parms.Add("isdel", item.isdel); //parms.Add("status", item.status); //parms.Add("lastlogintime", item.lastlogintime); //parms.Add("devicename", item.devicename); //parms.Add("uuid", item.uuid); //parms.Add("mac", item.mac); try { sqlSelect = "SELECT COUNT(uin) FROM WUserItem WHERE uin=@uin"; if (db.ExecuteScalar(sqlSelect, parms).ToString().ToInt() > 0) { sqlSelect = "UPDATE WUserItem SET nickname=@nickname,username=@username,status=@status,headimg=@headimg,lastlogintime=@lastlogintime,isdel=@isdel,devicename=@devicename,uuid=@uuid,mac=@mac WHERE uin=@uin"; } else { sqlSelect = "INSERT INTO WUserItem(uin,createtime,alias,nickname,username,city,province,pyquanpin,remarkname,remarkpyquanpin,sex,signature,headimg,isdel,status,lastlogintime,devicename,uuid,mac) VALUES(@uin,@createtime,@alias,@nickname,@username,@city,@province,@pyquanpin,@remarkname,@remarkpyquanpin,@sex,@signature,@headimg,@isdel,@status,@lastlogintime,@devicename,@uuid,@mac)"; } db.Execute(sqlSelect, parms); ret = true; } catch (Exception ex) { LogHelper.Log("WUserData-AddWUserItem:" + ex.ToString()); } finally { db.Close(); } } catch (Exception ex) { LogHelper.Log("WUserData-AddWUserItem:" + ex.ToString()); } finally { _LockSlim.ExitWriteLock(); } return(ret); }