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);
}
