public static List <PrepareTMOrder> GetCJPrepareOrders(string WorkShopGUID) { string strSql = @"select * from VIEW_Nameplate_TrainmanJiaolu_PrepareOrder where TrainmanjiaoluGUID in (select strTrainmanJiaoluGUID from VIEW_Base_JiaoluRelation where strWorkShopGUID=@strWorkShopGUID and nJiaoluType=3) order by TrainmanjiaoluGUID,PostID,TrainmanOrder"; SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("strWorkShopGUID", WorkShopGUID), }; List <PrepareTMOrder> result = new List <PrepareTMOrder>(); DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams).Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { PrepareTMOrder tmOrder = new PrepareTMOrder(); tmOrder.TrainmanJiaoluGUID = TF.Utils.TFConvert.DBToString(dt.Rows[i]["TrainmanJiaoluGUID"], ""); tmOrder.TrainmanJiaoluName = TF.Utils.TFConvert.DBToString(dt.Rows[i]["TrainmanJiaoluName"], ""); tmOrder.TrainmanNumber = TF.Utils.TFConvert.DBToString(dt.Rows[i]["TrainmanNumber"], ""); tmOrder.TrainmanOrder = TF.Utils.TFConvert.DBToInt(dt.Rows[i]["TrainmanOrder"], 0); tmOrder.PostID = TF.Utils.TFConvert.DBToInt(dt.Rows[i]["PostID"], 0); tmOrder.TrainmanName = TF.Utils.TFConvert.DBToString(dt.Rows[i]["TrainmanName"], ""); tmOrder.nTrainmanState = TF.Utils.TFConvert.DBToInt(dt.Rows[i]["nTrainmanState"], 1); tmOrder.dtLastEndWorkTime = TF.Utils.TFConvert.DBToDateTimeD(dt.Rows[i]["dtLastEndWorkTime"]); tmOrder.strTelNumber = TF.Utils.TFConvert.DBToString(dt.Rows[i]["strTelNumber"], ""); tmOrder.nPostID = TF.Utils.TFConvert.DBToInt(dt.Rows[i]["nPostID"], 1); tmOrder.nid = TF.Utils.TFConvert.DBToInt(dt.Rows[i]["nid"], 0); result.Add(tmOrder); } return(result); }
public static List <PrepareTMOrder> GetTrainmanSubOrders(string TrainmanJiaoluGUID, string TrainmanNumber, int PostID, int TMOrder, bool HasSelf) { List <PrepareTMOrder> result = new List <PrepareTMOrder>(); string strSql = @"select * from Tab_Nameplate_TrainmanJiaolu_PrepareOrder where TrainmanjiaoluGUID = @TrainmanJiaoluGUID and PostID=@PostID and TrainmanOrder >= @TrainmanOrder order by TrainmanOrder"; if (!HasSelf) { strSql = @"select * from Tab_Nameplate_TrainmanJiaolu_PrepareOrder where TrainmanjiaoluGUID = @TrainmanJiaoluGUID and PostID=@PostID and TrainmanOrder > @TrainmanOrder order by TrainmanOrder"; } SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("TrainmanJiaoluGUID", TrainmanJiaoluGUID), new SqlParameter("TrainmanOrder", TMOrder), new SqlParameter("PostID", PostID) }; DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams).Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { PrepareTMOrder tmOrder = new PrepareTMOrder(); tmOrder.TrainmanJiaoluGUID = TF.Utils.TFConvert.DBToString(dt.Rows[i]["TrainmanJiaoluGUID"], ""); tmOrder.TrainmanJiaoluName = TF.Utils.TFConvert.DBToString(dt.Rows[i]["TrainmanJiaoluName"], ""); tmOrder.TrainmanNumber = TF.Utils.TFConvert.DBToString(dt.Rows[i]["TrainmanNumber"], ""); tmOrder.TrainmanOrder = TF.Utils.TFConvert.DBToInt(dt.Rows[i]["TrainmanOrder"], 0); tmOrder.PostID = TF.Utils.TFConvert.DBToInt(dt.Rows[i]["PostID"], 0); tmOrder.nid = TF.Utils.TFConvert.DBToInt(dt.Rows[i]["nid"], 0); result.Add(tmOrder); } return(result); }
public static void AddPrepareTMOrder(PrepareTMOrder TMOrder) { //当前位置以后的所有人向后移动一位 List <PrepareTMOrder> orders = DBPrepareTMOrder.GetTrainmanSubOrders(TMOrder.TrainmanJiaoluGUID, TMOrder.TrainmanNumber, TMOrder.PostID, TMOrder.TrainmanOrder, true); for (int i = 0; i < orders.Count; i++) { DBPrepareTMOrder.ReorderTrainmanOrder(orders[i].nid, TMOrder.TrainmanOrder + i + 1); } ///添加 DBPrepareTMOrder.AddTrainmanOrder(TMOrder); }
/// <summary> /// 删除预备人员序号 /// </summary> /// <param name="TMOrder"></param> public static bool DeleteTrainmanOrder(PrepareTMOrder TMOrder) { string strSql = @"delete from Tab_Nameplate_TrainmanJiaolu_PrepareOrder where TrainmanJiaoluGUID=@TrainmanJiaoluGUID and TrainmanNumber=@TrainmanNumber and PostID=@PostID and TrainmanOrder=@TrainmanOrder "; SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("TrainmanJiaoluGUID", TMOrder.TrainmanJiaoluGUID), new SqlParameter("PostID", TMOrder.PostID), new SqlParameter("TrainmanNumber", TMOrder.TrainmanNumber), new SqlParameter("TrainmanOrder", TMOrder.TrainmanOrder) }; return(SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams) > 0); }
public static void DeletePrepareTrainmanOrder(PrepareTMOrder TMOrder) { ///已经存在则修改 if (DBPrepareTMOrder.DeleteTrainmanOrder(TMOrder)) { //所有位置向前移动一位 List <PrepareTMOrder> orders = DBPrepareTMOrder.GetTrainmanSubOrders(TMOrder.TrainmanJiaoluGUID, TMOrder.TrainmanNumber, TMOrder.PostID, TMOrder.TrainmanOrder, false); for (int i = 0; i < orders.Count; i++) { DBPrepareTMOrder.ReorderTrainmanOrder(orders[i].nid, TMOrder.TrainmanOrder + i); } } }
/// <summary> /// 修改预备人员序号 /// </summary> /// <param name="TMOrder"></param> public static void UpdateTrainmanOrder(PrepareTMOrder TMOrder) { string strSql = @"update Tab_Nameplate_TrainmanJiaolu_PrepareOrder set TrainmanNumber=@TrainmanNumber,TrainmanName=@TrainmanName,TrainmanJiaoluName = @TrainmanJiaoluName where TrainmanJiaoluGUID=@TrainmanJiaoluGUID and PostID=@PostID and TrainmanOrder = @TrainmanOrder "; SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("TrainmanJiaoluGUID", TMOrder.TrainmanJiaoluGUID), new SqlParameter("TrainmanJiaoluName", TMOrder.TrainmanJiaoluName), new SqlParameter("PostID", TMOrder.PostID), new SqlParameter("TrainmanNumber", TMOrder.TrainmanNumber), new SqlParameter("TrainmanName", TMOrder.TrainmanName), new SqlParameter("TrainmanOrder", TMOrder.TrainmanOrder) }; SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams); }
/// <summary> /// 添加预备人员编号 /// </summary> /// <param name="TMOrder"></param> public static void AddTrainmanOrder(PrepareTMOrder TMOrder) { string strSql = @"insert into Tab_Nameplate_TrainmanJiaolu_PrepareOrder (TrainmanJiaoluGUID,TrainmanJiaoluName,PostID,TrainmanNumber,TrainmanName,TrainmanOrder) values (@TrainmanJiaoluGUID,@TrainmanJiaoluName,@PostID,@TrainmanNumber,@TrainmanName,@TrainmanOrder) "; SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("TrainmanJiaoluGUID", TMOrder.TrainmanJiaoluGUID), new SqlParameter("TrainmanJiaoluName", TMOrder.TrainmanJiaoluName), new SqlParameter("PostID", TMOrder.PostID), new SqlParameter("TrainmanNumber", TMOrder.TrainmanNumber), new SqlParameter("TrainmanName", TMOrder.TrainmanName), new SqlParameter("TrainmanOrder", TMOrder.TrainmanOrder) }; SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams); }
public static void SetToPrepareOrder(string TMJiaoluGUID, string TMJiaouName, string GroupGUID) { //将所有机组打散,并将司机和副司机安排到备班表中 NamePlate.MD.Group g = new NamePlate.MD.Group(); if (NamePlate.LCGroup.GetGroup(GroupGUID, g)) { int tempOrder; PrepareTMOrder TMOrder; if (g.trainman1.trainmanID != "") { tempOrder = LCPrepareTMOrder.GetMaxTMOrder(TMJiaoluGUID, 1); TMOrder = new PrepareTMOrder(); TMOrder.TrainmanJiaoluGUID = TMJiaoluGUID; TMOrder.TrainmanJiaoluName = TMJiaouName; TMOrder.TrainmanName = g.trainman1.trainmanName; TMOrder.TrainmanNumber = g.trainman1.trainmanNumber; TMOrder.TrainmanOrder = tempOrder + 1; TMOrder.PostID = 1; LCPrepareTMOrder.AddPrepareTMOrder(TMOrder); } if (g.trainman2.trainmanID != "") { tempOrder = LCPrepareTMOrder.GetMaxTMOrder(TMJiaoluGUID, 2); TMOrder = new PrepareTMOrder(); TMOrder.TrainmanJiaoluGUID = TMJiaoluGUID; TMOrder.TrainmanJiaoluName = TMJiaouName; TMOrder.TrainmanName = g.trainman2.trainmanName; TMOrder.TrainmanNumber = g.trainman2.trainmanNumber; TMOrder.TrainmanOrder = tempOrder + 1; TMOrder.PostID = 2; LCPrepareTMOrder.AddPrepareTMOrder(TMOrder); } } else { TF.CommonUtility.LogClass.log(string.Format("未获取到机组信息{0}", GroupGUID)); } }
public static bool GetTrainmanOrder(string TrainmanNumber, PrepareTMOrder TMOrder) { string strSql = "select * from Tab_Nameplate_TrainmanJiaolu_PrepareOrder where TrainmanNumber=@TrainmanNumber"; SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("TrainmanNumber", TrainmanNumber) }; DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams).Tables[0]; if (dt.Rows.Count > 0) { TMOrder.TrainmanJiaoluGUID = TF.Utils.TFConvert.DBToString(dt.Rows[0]["TrainmanJiaoluGUID"], ""); TMOrder.TrainmanJiaoluName = TF.Utils.TFConvert.DBToString(dt.Rows[0]["TrainmanJiaoluName"], ""); TMOrder.TrainmanNumber = TF.Utils.TFConvert.DBToString(dt.Rows[0]["TrainmanNumber"], ""); TMOrder.TrainmanOrder = TF.Utils.TFConvert.DBToInt(dt.Rows[0]["TrainmanOrder"], 0); TMOrder.PostID = TF.Utils.TFConvert.DBToInt(dt.Rows[0]["PostID"], 0); return(true); } return(false); }
public static void UpdateTrainmanOrder(PrepareTMOrder TMOrder) { DBPrepareTMOrder.UpdateTrainmanOrder(TMOrder); }
public static bool GetTrainmanOrder(string TrainmanNumber, PrepareTMOrder TMOrder) { return(DBPrepareTMOrder.GetTrainmanOrder(TrainmanNumber, TMOrder)); }
public InterfaceOutPut UpdatePerpareTrainmanOrder(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; try { JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); InUpdatePerpareTrainman InParams = javaScriptSerializer.Deserialize <InUpdatePerpareTrainman>(Data); InterfaceOutPut OutParams = new InterfaceOutPut(); DB.DBNameBoard dbNameBoard = new DB.DBNameBoard(); int sourceOrder = InParams.Source.TrainmanOrder; int destOrder = InParams.Dest.TrainmanOrder; PrepareTMOrder TMOrder = new PrepareTMOrder(); //目标位置有效 if (destOrder > 0) { bool hasSource = false; if (sourceOrder > 0) { TMOrder.TrainmanOrder = InParams.Source.TrainmanOrder; TMOrder.PostID = InParams.Source.PostID; TMOrder.TrainmanJiaoluGUID = InParams.Source.TrainmanJiaoluGUID; TMOrder.TrainmanJiaoluName = InParams.Source.TrainmanJiaoluName; TMOrder.TrainmanNumber = InParams.Dest.TrainmanNumber; TMOrder.TrainmanName = InParams.Dest.TrainmanName; hasSource = true; } else { PrepareTMOrder tempOrder = new PrepareTMOrder(); if (LCPrepareTMOrder.GetTrainmanOrder(InParams.Source.TrainmanNumber, tempOrder)) { TMOrder.TrainmanOrder = tempOrder.TrainmanOrder; TMOrder.PostID = tempOrder.PostID; TMOrder.TrainmanJiaoluGUID = tempOrder.TrainmanJiaoluGUID; TMOrder.TrainmanJiaoluName = tempOrder.TrainmanJiaoluName; TMOrder.TrainmanNumber = InParams.Dest.TrainmanNumber; TMOrder.TrainmanName = InParams.Dest.TrainmanName; hasSource = true; } } if (hasSource) { LCPrepareTMOrder.UpdateTrainmanOrder(TMOrder); } TMOrder.TrainmanOrder = InParams.Dest.TrainmanOrder; TMOrder.PostID = InParams.Dest.PostID; TMOrder.TrainmanJiaoluGUID = InParams.Dest.TrainmanJiaoluGUID; TMOrder.TrainmanJiaoluName = InParams.Dest.TrainmanJiaoluName; TMOrder.TrainmanNumber = InParams.Source.TrainmanNumber; TMOrder.TrainmanName = InParams.Source.TrainmanName; LCPrepareTMOrder.UpdateTrainmanOrder(TMOrder); } output.result = 0; } catch (Exception ex) { output.resultStr = ex.Message; LogClass.log("Interface.UpdatePerpareTrainman:" + ex.Message); throw ex; } return(output); }