/// <summary>
/// 修改定时启动记录
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public ReturnValue Update(TiminGstartRecordInfo info)
{
//ReturnValue retVal = GetTimingStartRecord(new TiminGstartRecordInfo() { UserID = info.UserID });
//if (!retVal.IsSuccess) { return new ReturnValue(false, -9, Consts.EXP_Info); } //执行失败
//DataTable dt = retVal.RetDt;
//DataRow[] drs = dt.Select(string.Format(" tsrid={1}", info.UserName, info.TSRID), "tsrid asc");
//if (drs.Length == 0) { return new ReturnValue(false, -2); } //不存在该记录
return(tsrDAL.Update(info));
}
/// <summary>
///
/// </summary>
/// <param name="strparam"></param>
/// <returns></returns>
public string Delete(string strparam)
{
Dictionary <string, string> dic = MyJson.JsonToDictionary(strparam);
TiminGstartRecordInfo info = new TiminGstartRecordInfo()
{
TSRID = dic.ContainsKey("tsrid") ? Tools.GetInt32(dic["tsrid"], -1) : -1
};
ReturnValue retVal = tsrLogic.Delete(info);
return(MyXml.CreateResultXml(retVal.RetCode, retVal.RetMsg, string.Empty).InnerXml);
}
/// <summary>
/// 批量添加（批量关联）
/// </summary>
/// <param name="strparam"></param>
/// <returns></returns>
public string UserEquipmentsGrant(string strparam)
{
Dictionary <string, string> dic = MyJson.JsonToDictionary(strparam);
string[] eiids = (dic.ContainsKey("eiid") ? dic["eiid"] : string.Empty).Split(',');
string[] einames = (dic.ContainsKey("einame") ? dic["einame"] : string.Empty).Split(',');
int errCnt = 0;
for (int i = 0; i < eiids.Length; i++)
{
if (eiids[i].Trim().Length == 0)
{
continue;
}
try
{
TiminGstartRecordInfo info = new TiminGstartRecordInfo()
{
UserID = Tools.GetInt32((dic.ContainsKey("userid") ? dic["userid"] : "-1"), -1),
EIID = Tools.GetInt32(eiids[i], -1),
TSRID = Tools.GetInt32((dic.ContainsKey("tsrid") ? dic["tsrid"] : "-1"), -1),
UserName = dic.ContainsKey("username") ? dic["username"] : string.Empty,
EIName = einames[i],
PackName = dic.ContainsKey("packname") ? dic["packname"] : string.Empty,
StartDate = Tools.GetDateTime(dic.ContainsKey("begintime") ? dic["begintime"] : string.Empty, DateTime.Now),
EndDate = Tools.GetDateTime(dic.ContainsKey("endtime") ? dic["endtime"] : string.Empty, DateTime.Now),
ExpStartDate = Tools.GetDateTime(dic.ContainsKey("expbegintime") ? dic["expbegintime"] : string.Empty, DateTime.Now),
ExpEndDate = Tools.GetDateTime(dic.ContainsKey("expendtime") ? dic["expendtime"] : string.Empty, DateTime.Now),
Release = Tools.GetInt32((dic.ContainsKey("release") ? dic["release"] : "-1"), -1),
Status = 0,
Description = dic.ContainsKey("description") ? dic["description"] : string.Empty
};
info.ExpStartDate = new DateTime(info.ExpStartDate.Year, info.ExpStartDate.Month, info.ExpStartDate.Day, 0, 0, 0);
info.ExpEndDate = new DateTime(info.ExpEndDate.Year, info.ExpEndDate.Month, info.ExpEndDate.Day, 23, 59, 59);
ReturnValue retVal = tsrLogic.Insert(info);
}
catch (Exception ex)
{
errCnt += 1;
MyLog.WriteExceptionLog("UserEquipmentsGrant(定时记录-批量添加)", ex, ex.Source);
}
}
return(MyXml.CreateResultXml(1, string.Empty, (einames.Length - errCnt).ToString()).InnerXml);
}
/// <summary>
///
/// </summary>
/// <param name="strparam"></param>
/// <returns></returns>
public string AddorEdit(string strparam)
{
Dictionary <string, string> dic = MyJson.JsonToDictionary(strparam);
TiminGstartRecordInfo info = new TiminGstartRecordInfo()
{
UserID = Tools.GetInt32((dic.ContainsKey("userid") ? dic["userid"] : "-1"), -1),
EIID = Tools.GetInt32((dic.ContainsKey("eiid") ? dic["eiid"] : "-1"), -1),
TSRID = Tools.GetInt32((dic.ContainsKey("tsrid") ? dic["tsrid"] : "-1"), -1),
UserName = dic.ContainsKey("username") ? dic["username"] : string.Empty,
EIName = dic.ContainsKey("einame") ? dic["einame"] : string.Empty,
PackName = dic.ContainsKey("packname") ? dic["packname"] : string.Empty,
StartDate = Tools.GetDateTime(dic.ContainsKey("begintime") ? dic["begintime"] : string.Empty, DateTime.MinValue),
EndDate = Tools.GetDateTime(dic.ContainsKey("endtime") ? dic["endtime"] : string.Empty, DateTime.MaxValue),
ExpStartDate = Tools.GetDateTime(dic.ContainsKey("expbegintime") ? dic["expbegintime"] : string.Empty, DateTime.MinValue),
ExpEndDate = Tools.GetDateTime(dic.ContainsKey("expendtime") ? dic["expendtime"] : string.Empty, DateTime.MaxValue),
Release = Tools.GetInt32((dic.ContainsKey("release") ? dic["release"] : "-1"), -1),
Status = 0,
Description = dic.ContainsKey("description") ? dic["description"] : string.Empty
};
//tsrid ==-1 添加 否则 修改
ReturnValue retVal = info.TSRID == -1 ? tsrLogic.Insert(info) : tsrLogic.Update(info);
return(MyXml.CreateResultXml(retVal.RetCode, retVal.RetMsg, string.Empty).InnerXml);
}
/// <summary>
/// 删除定时启动记录
/// </summary>
/// <param name="info">UserId/UserName</param>
/// <returns></returns>
public ReturnValue Delete(TiminGstartRecordInfo info)
{
return(tsrDAL.Delete(info));
}
/// <summary>
/// 添加定时启动记录
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public ReturnValue Insert(TiminGstartRecordInfo info)
{
return(tsrDAL.Insert(info));
}
/// <summary>
/// /// 获取定时启动记录
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public ReturnValue GetTimingStartRecord(TiminGstartRecordInfo info)
{
return(tsrDAL.GetTimingStartRecord(info));
}
public string GetTimingList(string strjson)
{
try
{
Dictionary <string, string> dic = MyJson.JsonToDictionary(strjson);
if (dic.Count == 0)
{
return(Json.Write(-1, "参数JSON格式错误"));
}
string equipmentname = string.Empty;
string username = string.Empty;
string expstartdate = string.Empty;
string expenddate = string.Empty;
if (dic.TryGetValue("equipmentname", out equipmentname) == false)
{
return(Json.Write(-1, "设备名称无法识别"));
}
if (equipmentname.Trim().Length == 0)
{
return(Json.Write(-1, "设备名称为空"));
}
//以下参数为可选，先判断是否存在
if (dic.ContainsKey("username") && dic.TryGetValue("username", out username) == false)
{
return(Json.Write(-1, "用户账号无法识别"));
}
if (dic.ContainsKey("expstartdate") && dic.TryGetValue("expstartdate", out expstartdate) == false)
{
return(Json.Write(-1, "有效期开始时间无法识别"));
}
if (dic.ContainsKey("expenddate") && dic.TryGetValue("expenddate", out expenddate) == false)
{
return(Json.Write(-1, "有效期结束时间无法识别"));
}
//获取设备信息
TiminGstartRecordInfo info = new TiminGstartRecordInfo()
{
EIName = equipmentname
};
if (dic.ContainsKey("username"))
{
info.UserName = username;
}
if (dic.ContainsKey("expstartdate"))
{
DateTime starttime = Tools.GetDateTime(expstartdate, DateTime.MinValue);
if (starttime == DateTime.MinValue)
{
return(Json.Write(-1, "有效期开始时间格式输入不正确"));
}
info.ExpStartDate = starttime;
}
if (dic.ContainsKey("expenddate"))
{
DateTime endtime = Tools.GetDateTime(expenddate, DateTime.MaxValue);
if (endtime == DateTime.MaxValue)
{
return(Json.Write(-1, "有效期结束时间格式输入不正确"));
}
info.ExpEndDate = endtime;
}
ReturnValue retVal = tsrLogic.GetTimingStartRecord(info);
return(Json.Write(retVal.RetCode, retVal.RetMsg, retVal.RetDt));
}
catch (Exception ex)
{
return(Json.Write(-1, Consts.EXP_Info));
}
}
