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