//从数据行中读取数据到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);
}
