public int AddDayPlanInfo(DayPlan model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TAB_DayPlan_TrainRelation"); strSql.Append("(strDayPlanGUID,dtBeginTime,dtEndTime,dtCreateTime,strTrainNo,strTrainTypeName,strTrainNumber,strRemark,strTrainNo1,strTrainInfo,strTrainNo2,nQuDuanID,nPlanID,bIsTomorrow,nDayPlanID,nPlanState,strDaWenCheXing,strDaWenCheHao1,strDaWenCheHao2,strDaWenCheHao3,bIsSend,strTrainPlanGUID)"); strSql.Append("values(@strDayPlanGUID,@dtBeginTime,@dtEndTime,@dtCreateTime,@strTrainNo,@strTrainTypeName,@strTrainNumber,@strRemark,@strTrainNo1,@strTrainInfo,@strTrainNo2,@nQuDuanID,@nPlanID,@bIsTomorrow,@nDayPlanID,@nPlanState,@strDaWenCheXing,@strDaWenCheHao1,@strDaWenCheHao2,@strDaWenCheHao3,@bIsSend,@strTrainPlanGUID)"); SqlParameter[] parameters = { new SqlParameter("@strDayPlanGUID", model.strDayPlanGUID), new SqlParameter("@dtBeginTime", model.dtBeginTime), new SqlParameter("@dtEndTime", model.dtEndTime), new SqlParameter("@dtCreateTime", model.dtCreateTime), new SqlParameter("@strTrainNo", model.strTrainNo), new SqlParameter("@strTrainTypeName", model.strTrainTypeName), new SqlParameter("@strTrainNumber", model.strTrainNumber), new SqlParameter("@strRemark", model.strRemark), new SqlParameter("@strTrainNo1", model.strTrainNo1), new SqlParameter("@strTrainInfo", model.strTrainInfo), new SqlParameter("@strTrainNo2", model.strTrainNo2), new SqlParameter("@nQuDuanID", model.nQuDuanID), new SqlParameter("@nPlanID", model.nPlanID), new SqlParameter("@bIsTomorrow", model.bIsTomorrow), new SqlParameter("@nDayPlanID", model.nDayPlanID), new SqlParameter("@nPlanState", model.nPlanState), new SqlParameter("@strDaWenCheXing", model.strDaWenCheXing), new SqlParameter("@strDaWenCheHao1", model.strDaWenCheHao1), new SqlParameter("@strDaWenCheHao2", model.strDaWenCheHao2), new SqlParameter("@strDaWenCheHao3", model.strDaWenCheHao3), new SqlParameter("@bIsSend", model.bIsSend), new SqlParameter("@strTrainPlanGUID", model.strTrainPlanGUID) }; return(SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters)); }
public Get_OutGetPlan GetPlan(string data) { Get_OutGetPlan json = new Get_OutGetPlan(); try { Get_InGetPlan input = Newtonsoft.Json.JsonConvert.DeserializeObject <Get_InGetPlan>(data); DBDayPlan db = new DBDayPlan(); resultGetPlan r = new resultGetPlan(); r.bExist = false; DayPlan Plan = new DayPlan(); if (db.GetPlan(input.PlanGUID, Plan)) { r.bExist = true; r.Plan = Plan; } json.data = r; json.result = "0"; json.resultStr = "返回成功"; } catch (Exception ex) { json.result = "1"; json.resultStr = "提交失败:" + ex.Message; } return(json); }
public DayPlan QueryPlans_DRToModel(DataRow dr, DayPlan Plan) { if (dr != null) { Plan.strDayPlanGUID = ObjectConvertClass.static_ext_string(dr["strDayPlanGUID"]); Plan.dtBeginTime = ObjectConvertClass.static_ext_date(dr["dtBeginTime"]); Plan.dtEndTime = ObjectConvertClass.static_ext_date(dr["dtEndTime"]); Plan.dtCreateTime = ObjectConvertClass.static_ext_date(dr["dtCreateTime"]); Plan.strTrainNo = ObjectConvertClass.static_ext_string(dr["strTrainNo"]); Plan.strTrainTypeName = ObjectConvertClass.static_ext_string(dr["strTrainTypeName"]); Plan.strTrainNumber = ObjectConvertClass.static_ext_string(dr["strTrainNumber"]); Plan.nid = ObjectConvertClass.static_ext_int(dr["nid"]); Plan.strRemark = ObjectConvertClass.static_ext_string(dr["strRemark"]); Plan.strTrainNo1 = ObjectConvertClass.static_ext_string(dr["strTrainNo1"]); Plan.strTrainInfo = ObjectConvertClass.static_ext_string(dr["strTrainInfo"]); Plan.strTrainNo2 = ObjectConvertClass.static_ext_string(dr["strTrainNo2"]); Plan.nQuDuanID = ObjectConvertClass.static_ext_int(dr["nQuDuanID"]); Plan.nPlanID = ObjectConvertClass.static_ext_int(dr["nPlanID"]); Plan.bIsTomorrow = ObjectConvertClass.static_ext_int(dr["bIsTomorrow"]); Plan.nDayPlanID = ObjectConvertClass.static_ext_int(dr["nDayPlanID"]); Plan.nPlanState = ObjectConvertClass.static_ext_int(dr["nPlanState"]); Plan.strDaWenCheXing = ObjectConvertClass.static_ext_string(dr["strDaWenCheXing"]); Plan.strDaWenCheHao1 = ObjectConvertClass.static_ext_string(dr["strDaWenCheHao1"]); Plan.strDaWenCheHao2 = ObjectConvertClass.static_ext_string(dr["strDaWenCheHao2"]); Plan.strDaWenCheHao3 = ObjectConvertClass.static_ext_string(dr["strDaWenCheHao3"]); Plan.bIsSend = ObjectConvertClass.static_ext_int(dr["bIsSend"]); Plan.strTrainPlanGUID = ObjectConvertClass.static_ext_string(dr["strTrainPlanGUID"]); } return(Plan); }
public int LoadDayPlanInfo(DateTime DayPlanDate, DateTime dtNow, int DayPlanTypeID, int DayPlanID, int GroupID, DataTable dt) { DateTime dtBeginTime, dtEndTime; DayPlan dp = new DayPlan(); int k = 0; for (int i = 0; i < dt.Rows.Count; i++) { dp.strDayPlanGUID = Guid.NewGuid().ToString(); dp.nPlanState = 1; DateTime DayPlanDate_Day = Convert.ToDateTime(DayPlanDate.ToShortDateString()); if (DayPlanTypeID == 0) //白班 { dtBeginTime = DayPlanDate_Day.AddHours(8); dtEndTime = DayPlanDate_Day.AddHours(18).AddSeconds(-1); } else if (DayPlanTypeID == 1) //夜班 { dtBeginTime = DayPlanDate_Day.AddHours(18); dtEndTime = DayPlanDate_Day.AddDays(1).AddHours(8).AddSeconds(-1); } else //全天 { dtBeginTime = DayPlanDate_Day.AddHours(18); dtEndTime = DayPlanDate_Day.AddDays(1).AddHours(18).AddSeconds(-1); } dp.dtBeginTime = dtBeginTime; //开始时间 dp.dtEndTime = dtEndTime; //结束时间 dp.dtCreateTime = dtNow; //产生事件 dp.strTrainNo1 = dt.Rows[i]["strTrainNo1"].ToString(); //车次1 dp.strTrainInfo = dt.Rows[i]["strTrainInfo"].ToString(); //机车信息 dp.strTrainNo2 = dt.Rows[i]["strTrainNo2"].ToString(); //车次 2 dp.strTrainNo = dt.Rows[i]["strTrainNo"].ToString(); //车次 dp.strTrainTypeName = ""; //车型 dp.strTrainNumber = ""; //车号 dp.strRemark = dt.Rows[i]["strRemark"].ToString(); if (Convert.ToInt32(dt.Rows[i]["bIsTomorrow"]) > 0) { dp.strRemark = DayPlanDate_Day.AddDays(1).ToString() + "日"; } dp.bIsTomorrow = Convert.ToInt32(dt.Rows[i]["bIsTomorrow"]); dp.nDayPlanID = DayPlanID; dp.nQuDuanID = Convert.ToInt32(dt.Rows[i]["nGroupID"]); //区段信息 //打温专用 dp.strDaWenCheXing = dt.Rows[i]["strDaWenCheXing"].ToString(); dp.strDaWenCheHao1 = dt.Rows[i]["strDaWenCheHao1"].ToString(); dp.strDaWenCheHao2 = dt.Rows[i]["strDaWenCheHao2"].ToString(); dp.strDaWenCheHao3 = dt.Rows[i]["strDaWenCheHao3"].ToString(); dp.nPlanID = Convert.ToInt32(dt.Rows[i]["nID"].ToString()); dp.bIsSend = 0; dp.strTrainPlanGUID = ""; k += AddDayPlanInfo(dp); } return(k); }
public int ModifyDayPlanInfo(DayPlan model) { StringBuilder strSql = new StringBuilder(); strSql.Append("Update TAB_DayPlan_TrainRelation set "); strSql.Append(" dtBeginTime = @dtBeginTime, "); strSql.Append(" dtEndTime = @dtEndTime, "); strSql.Append(" dtCreateTime = @dtCreateTime, "); strSql.Append(" strTrainNo = @strTrainNo, "); strSql.Append(" strTrainTypeName = @strTrainTypeName, "); strSql.Append(" strTrainNumber = @strTrainNumber, "); strSql.Append(" strRemark = @strRemark, "); strSql.Append(" strTrainNo1 = @strTrainNo1, "); strSql.Append(" strTrainInfo = @strTrainInfo, "); strSql.Append(" strTrainNo2 = @strTrainNo2, "); strSql.Append(" nQuDuanID = @nQuDuanID, "); strSql.Append(" nPlanID = @nPlanID, "); strSql.Append(" bIsTomorrow = @bIsTomorrow, "); strSql.Append(" nDayPlanID = @nDayPlanID, "); strSql.Append(" nPlanState = @nPlanState, "); strSql.Append(" strDaWenCheXing = @strDaWenCheXing, "); strSql.Append(" strDaWenCheHao1 = @strDaWenCheHao1, "); strSql.Append(" strDaWenCheHao2 = @strDaWenCheHao2, "); strSql.Append(" strDaWenCheHao3 = @strDaWenCheHao3, "); strSql.Append(" bIsSend = @bIsSend, "); strSql.Append(" strTrainPlanGUID = @strTrainPlanGUID "); strSql.Append(" where strDayPlanGUID = @strDayPlanGUID "); SqlParameter[] parameters = { new SqlParameter("@strDayPlanGUID", model.strDayPlanGUID), new SqlParameter("@dtBeginTime", model.dtBeginTime), new SqlParameter("@dtEndTime", model.dtEndTime), new SqlParameter("@dtCreateTime", model.dtCreateTime), new SqlParameter("@strTrainNo", model.strTrainNo), new SqlParameter("@strTrainTypeName", model.strTrainTypeName), new SqlParameter("@strTrainNumber", model.strTrainNumber), new SqlParameter("@strRemark", model.strRemark), new SqlParameter("@strTrainNo1", model.strTrainNo1), new SqlParameter("@strTrainInfo", model.strTrainInfo), new SqlParameter("@strTrainNo2", model.strTrainNo2), new SqlParameter("@nQuDuanID", model.nQuDuanID), new SqlParameter("@nPlanID", model.nPlanID), new SqlParameter("@bIsTomorrow", model.bIsTomorrow), new SqlParameter("@nDayPlanID", model.nDayPlanID), new SqlParameter("@nPlanState", model.nPlanState), new SqlParameter("@strDaWenCheXing", model.strDaWenCheXing), new SqlParameter("@strDaWenCheHao1", model.strDaWenCheHao1), new SqlParameter("@strDaWenCheHao2", model.strDaWenCheHao2), new SqlParameter("@strDaWenCheHao3", model.strDaWenCheHao3), new SqlParameter("@bIsSend", model.bIsSend), new SqlParameter("@strTrainPlanGUID", model.strTrainPlanGUID) }; return(SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters)); }
public bool GetPlan(string PlanGUID, DayPlan Plan) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from TAB_DayPlan_TrainRelation where strDayPlanGUID ='" + PlanGUID + "'"); DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString()).Tables[0]; if (dt.Rows.Count <= 0) { return(false); } QueryPlans_DRToModel(dt.Rows[0], Plan); return(true); }
public List <DayPlan> QueryPlans_DTToList(DataTable dt) { List <DayPlan> modelList = new List <DayPlan>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { for (int n = 0; n < rowsCount; n++) { DayPlan model = new DayPlan(); QueryPlans_DRToModel(dt.Rows[n], model); if (model != null) { modelList.Add(model); } } } return(modelList); }