コード例 #1
0
        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);
        }
コード例 #2
0
        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);
        }
コード例 #3
0
        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);
        }