/// <summary>
/// 修改操作日志
/// </summary>
/// <param name="Log"></param>
/// <returns></returns>
public static int UpdateLog(Am_AmmeterOperateLog Log)
{
using (var conn = GetOpenConnection())
{
var sql = "update Am_AmmeterOperateLog set Result=@Result where Number=@Number ";
return(conn.Execute(sql, Log));
}
}
/// <summary>
/// 电表操作记录
/// </summary>
/// <param name="userNumber"></param>
/// <param name="cid"></param>
/// <param name="address"></param>
/// <param name="type">1电表删除 2总电量查询 3余额查询 4充值金额查询 5电价设置 6拉闸 7合闸 8开户 9充值 10清零</param>
/// <param name="typeStr"></param>
/// <param name="taskNumber"></param>
/// <param name="result"></param>
/// <param name="remark"></param>
public static void InserOperateLog(string userNumber, string cid, string address, int type, string typeStr, string taskNumber, bool state, string remark)
{
IDatabase database = DataFactory.Database();
WebData wbll = new WebData();
string result = "";
if (state)
{
result = "队列中";
}
else
{
result = "提交失败";
}
List <DbParameter> parameter = new List <DbParameter>();
parameter.Add(DbFactory.CreateDbParameter("@AM_Code", address));
var ammeter = database.FindEntityByWhere <Am_Ammeter>(" and AM_Code=@AM_Code ", parameter.ToArray());
if (ammeter != null && ammeter.Number != null)
{
List <DbParameter> par1 = new List <DbParameter>();
par1.Add(DbFactory.CreateDbParameter("@CollectorCode", cid));
var collector = database.FindEntityByWhere <Am_Collector>(" and CollectorCode=@CollectorCode ", par1.ToArray());
List <DbParameter> par2 = new List <DbParameter>();
par2.Add(DbFactory.CreateDbParameter("@Number", userNumber));
var user = database.FindEntityByWhere <Ho_PartnerUser>(" and Number=@Number ", par2.ToArray());
var operateLog = new Am_AmmeterOperateLog
{
AmmeterCode = ammeter.AM_Code,
AmmeterNumber = ammeter.Number,
CollectorCode = collector.CollectorCode,
Number = Utilities.CommonHelper.GetGuid,
CollectorNumber = collector.Number,
CreateTime = DateTime.Now,
OperateType = type,
OperateTypeStr = typeStr,
Remark = remark,
Result = result,
TaskNumber = taskNumber,
UserName = user.Account,
U_Name = user.Name,
U_Number = user.Number
};
database.Insert <Am_AmmeterOperateLog>(operateLog);
}
}
