//从数据行中读取数据到TrainmanNamePlate对象中 public static void TrainmanNamePlateFromDB(TrainmanNamePlate tm, DataRow row) { tm.trainmanID = row["strTrainmanGUID"].ToString(); tm.trainmanNumber = row["strTrainmanNumber"].ToString(); tm.trainmanName = row["strTrainmanName"].ToString(); if (!TF.RunSafty.Utils.Parse.TFParse.DBToInt(row["nPostID"], ref tm.postID)) { tm.postID = 0; } if (!TF.RunSafty.Utils.Parse.TFParse.DBToInt(row["nDriverLevel"], ref tm.driverTypeID)) { tm.driverTypeID = 0; } if (!TF.RunSafty.Utils.Parse.TFParse.DBToInt(row["bIsKey"], ref tm.isKey)) { tm.isKey = 0; } if (!TF.RunSafty.Utils.Parse.TFParse.DBToInt(row["nTrainmanState"], ref tm.trainmanState)) { tm.trainmanState = 0; } tm.lastEndworkTime = TF.RunSafty.Utils.Parse.TFParse.DBToDateTime(row["dtLastEndWorkTime"], DateTime.MinValue); tm.ABCD = row["strABCD"].ToString(); tm.telNumber = row["strTelNumber"].ToString(); }
/// <summary> /// 获取指定车间指定人员交路未在牌人员的人员列表 /// </summary> public InterfaceOutPut GetTMNotInNameGroup(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; try { JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); InGetPrepareTrainmans InParams = javaScriptSerializer.Deserialize <InGetPrepareTrainmans>(Data); OutGetPrepareTrainmans OutParams = new OutGetPrepareTrainmans(); string str = ""; if (!string.IsNullOrEmpty(InParams.WorkShopGUID)) { str += " and strWorkShopGUID = @strWorkShopGUID"; } if (!string.IsNullOrEmpty(InParams.TrainmanJiaoluGUID)) { str += " and strTrainmanJiaoluGUID = @strTrainmanJiaoluGUID"; } string strSql = string.Format(@"SELECT * FROM TAB_Org_Trainman where ( nTrainmanState=7 or len(nTrainmanState)=0 or ( nTrainmanState=1 and (len(strTrainmanJiaoluGUID)=0 or strTrainmanJiaoluGUID not in(select strTrainmanJiaoluGUID from TAB_Base_TrainmanJiaolu)) ) ) {0} order by strTrainmanNumber ", str); SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("strWorkShopGUID", InParams.WorkShopGUID), new SqlParameter("strTrainmanJiaoluGUID", InParams.TrainmanJiaoluGUID) }; DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams).Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { TrainmanNamePlate trainman = new TrainmanNamePlate(); PSNameBoard.TrainmanNamePlateFromDB(trainman, dt.Rows[i]); OutParams.Trainmans.Add(trainman); } output.data = OutParams; output.result = 0; } catch (Exception ex) { output.resultStr = ex.Message; LogClass.log("Interface.GetPrepareTrainmans:" + ex.Message); throw ex; } return(output); }
/// <summary> /// 获取指定车间的指定人员交路下的预备人员列表 /// </summary> public InterfaceOutPut GetPrepareTrainmans(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; try { JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); InGetPrepareTrainmans InParams = javaScriptSerializer.Deserialize <InGetPrepareTrainmans>(Data); OutGetPrepareTrainmans OutParams = new OutGetPrepareTrainmans(); string strSql = @"select * from VIEW_Nameplate_TrainmanJiaolu_Prepare where nTrainmanState <> 7 and strWorkShopGUID = @strWorkShopGUID and strTrainmanJiaoluGUID = @strTrainmanJiaoluGUID order by dtLastEndworkTime,strTrainmanNumber"; SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("strWorkShopGUID", InParams.WorkShopGUID), new SqlParameter("strTrainmanJiaoluGUID", InParams.TrainmanJiaoluGUID) }; DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams).Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { TrainmanNamePlate trainman = new TrainmanNamePlate(); PSNameBoard.TrainmanNamePlateFromDB(trainman, dt.Rows[i]); OutParams.Trainmans.Add(trainman); } output.data = OutParams; output.result = 0; } catch (Exception ex) { output.resultStr = ex.Message; LogClass.log("Interface.GetPrepareTrainmans:" + ex.Message); throw ex; } return(output); }