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