public Get_OutAddDayPlan AddDayPlan(string data) { Get_OutAddDayPlan json = new Get_OutAddDayPlan(); try { Get_InAddDayPlan input = Newtonsoft.Json.JsonConvert.DeserializeObject <Get_InAddDayPlan>(data); DBDayPlan db = new DBDayPlan(); int d = db.AddDayPlan(input.Plan); int l = 0; if (d > 0) { l = db.AddModifyPlanLog(input.Log); } if (d == 1 && l == 1) { json.result = "0"; json.resultStr = "成功插入一条数据"; } else { json.result = "0"; json.resultStr = "返回失败!插入" + d + "条机车计划数据;插入" + l + "条日志信息!"; } } catch (Exception ex) { json.result = "1"; json.resultStr = "提交失败:" + ex.Message; } return(json); }
public Get_OutAddDayPlan UpdateDayPlan(string data) { Get_OutAddDayPlan json = new Get_OutAddDayPlan(); try { Get_InUpdateDayPlan input = Newtonsoft.Json.JsonConvert.DeserializeObject <Get_InUpdateDayPlan>(data); DBDayPlan db = new DBDayPlan(); int d = db.ModifyDayPlanInfo(input.Plan); int l = 0; if (d > 0) { l = db.AddModifyPlanLog(input.Log); } int upp = db.UpdatePaiPlan(input.Plan.strTrainPlanGUID, input.Plan.strTrainTypeName, input.Plan.strTrainNumber, input.Plan.strRemark, input.strSiteGUID, input.strDutyGUID); if (d == 1 && l == 1 && upp == 1) { json.result = "0"; json.resultStr = "成功修改一条机车计划数据,并插入一条日志,更新一条TAB_Plan_Train信息"; } else { json.result = "0"; json.resultStr = "返回失败!修改" + d + "条机车计划数据;插入" + l + "条日志信息!"; } } catch (Exception ex) { json.result = "1"; json.resultStr = "提交失败:" + ex.Message; } return(json); }
public Get_OutDelete DeleteDayPlan(string data) { Get_OutDelete json = new Get_OutDelete(); try { Get_InDeleteDayPlan input = Newtonsoft.Json.JsonConvert.DeserializeObject <Get_InDeleteDayPlan>(data); DBDayPlan db = new DBDayPlan(); resultDelete rd = new resultDelete(); int d = db.DeleteDayPlan(input.DayPlanGUID); int l = 0; if (d > 0) { l = db.AddModifyPlanLog(input.Log); } if (d >= 1 && l == 1) { rd.result = true; json.result = "0"; json.resultStr = "成功删除一条机车计划数据,并插入一条日志"; } else { rd.result = false; json.result = "0"; json.resultStr = "返回失败!删除" + d + "条机车计划数据;插入" + l + "条日志信息!"; } json.data = rd; } catch (Exception ex) { json.result = "1"; json.resultStr = "提交失败:" + ex.Message; } return(json); }