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 CallNotify GetByStateSecDRToModelDTToList(DataRow dr)
{
CallNotify model = new CallNotify();
if (dr != null)
{
model.nId = ObjectConvertClass.static_ext_int(dr["nId"]);
model.strTrainPlanGUID = ObjectConvertClass.static_ext_string(dr["strTrainPlanGUID"]);
model.strMsgGUID = ObjectConvertClass.static_ext_string(dr["strMsgGUID"]);
model.strTrainmanGUID = ObjectConvertClass.static_ext_string(dr["strTrainmanGUID"]);
model.strSendMsgContent = ObjectConvertClass.static_ext_string(dr["strSendMsgContent"]);
model.strRecvMsgContent = ObjectConvertClass.static_ext_string(dr["strRecvMsgContent"]);
model.dtSendTime = ObjectConvertClass.static_ext_date(dr["dtSendTime"]);
model.strSendUser = ObjectConvertClass.static_ext_string(dr["strSendUser"]);
model.dtRecvTime = ObjectConvertClass.static_ext_date(dr["dtRecvTime"]);
model.strRecvUser = ObjectConvertClass.static_ext_string(dr["strRecvUser"]);
model.eCallState = ObjectConvertClass.static_ext_int(dr["eCallState"]);
model.eCallType = ObjectConvertClass.static_ext_int(dr["eCallType"]);
model.nCancel = ObjectConvertClass.static_ext_int(dr["nCancel"]);
model.strCancelReason = ObjectConvertClass.static_ext_string(dr["strCancelReason"]);
model.strCancelUser = ObjectConvertClass.static_ext_string(dr["strCancelUser"]);
model.dtCancelTime = ObjectConvertClass.static_ext_date(dr["dtCancelTime"]);
model.strTrainmanNumber = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber"]);
model.strTrainmanName = ObjectConvertClass.static_ext_string(dr["strTrainmanName"]);
model.strTrainNo = ObjectConvertClass.static_ext_string(dr["strTrainNo"]);
model.dtStartTime = ObjectConvertClass.static_ext_date(dr["dtStartTime"]);
model.strMobileNumber = ObjectConvertClass.static_ext_string(dr["strMobileNumber"]);
model.dtChuQinTime = ObjectConvertClass.static_ext_date(dr["dtChuQinTime"]);
model.dtCallTime = ObjectConvertClass.static_ext_date(dr["dtCallTime"]);
}
return(model);
}
public LendingInfo QueryRecord_DRToModelDTToList(DataRow dr)
{
LendingInfo model = new LendingInfo();
if (dr != null)
{
model.strStateName = ObjectConvertClass.static_ext_string(dr["strStateName"]);
model.strGiveBackLoginName = ObjectConvertClass.static_ext_string(dr["strGiveBackLoginTypeName"]);
model.strRemark = ObjectConvertClass.static_ext_string(dr["strRemark"]);
model.strBorrowLoginName = ObjectConvertClass.static_ext_string(dr["strBorrowLoginTypeName"]);
model.strGiveBackTrainmanNumber = ObjectConvertClass.static_ext_string(dr["strGiveBackTrainmanNumber"]);
model.strLenderName = ObjectConvertClass.static_ext_string(dr["strLenderName"]);
model.strGiveBackTrainmanName = ObjectConvertClass.static_ext_string(dr["strGiveBackTrainmanName"]);
model.strLenderNumber = ObjectConvertClass.static_ext_string(dr["strLenderNumber"]);
model.strBorrowTrainmanName = ObjectConvertClass.static_ext_string(dr["strBorrowTrainmanName"]);
model.strBorrowTrainmanNumber = ObjectConvertClass.static_ext_string(dr["strBorrowTrainmanNumber"]);
model.strGiveBackTrainmanGUID = ObjectConvertClass.static_ext_string(dr["strGiveBackTrainmanGUID"]);
model.strBorrowTrainmanGUID = ObjectConvertClass.static_ext_string(dr["strBorrowTrainmanGUID"]);
model.strLenderGUID = ObjectConvertClass.static_ext_string(dr["strLenderGUID"]);
model.strGUID = ObjectConvertClass.static_ext_string(dr["strGUID"]);
model.nReturnState = ObjectConvertClass.static_ext_int(dr["nReturnState"]);
model.strDetails = ObjectConvertClass.static_ext_string(dr["strLendingDetail"]);
model.strLendingInfoGUID = ObjectConvertClass.static_ext_string(dr["strLendingInfoGUID"]);
model.dtModifyTime = ObjectConvertClass.static_ext_date(dr["dtModifyTime"]);
model.dtGiveBackTime = ObjectConvertClass.static_ext_date(dr["dtGiveBackTime"]);
model.nBorrowLoginType = ObjectConvertClass.static_ext_int(dr["nBorrowLoginType"]);
model.dtBorrowTime = ObjectConvertClass.static_ext_date(dr["dtBorrowTime"]);
model.nGiveBackLoginType = ObjectConvertClass.static_ext_int(dr["nGiveBackLoginType"]);
model.strWorkShopGUID = ObjectConvertClass.static_ext_string(dr["strWorkShopGUID"]);
}
return(model);
}
public AskLeaveWithType GetLastLeaveInfo(string strTrainmanID)
{
AskLeaveWithType ret = new AskLeaveWithType();
string sql = "select top 1 * from VIEW_LeaveMgr_AskLeaveWithTypeName where strTrainmanID = @strTrainmanID order by dBeginTime desc";
DbParamDict dbParamDict = new DbParamDict();
dbParamDict.Add("strTrainmanID", strTrainmanID, ParamDataType.dtString);
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, sql, dbParamDict.GetParams()).Tables[0];
if (dt.Rows.Count > 0)
{
DataRow dr;
dr = dt.Rows[0];
ret.strTypeName = ObjectConvertClass.static_ext_string(dr["strTypeName"]);
AskLeaveEntity AskLeave = new AskLeaveEntity();
AskLeave.strAskLeaveGUID = ObjectConvertClass.static_ext_string(dr["strAskLeaveGUID"]);
AskLeave.strTrainManID = ObjectConvertClass.static_ext_string(dr["strTrainManID"]);
AskLeave.dtBeginTime = ObjectConvertClass.static_ext_date(dr["dBeginTime"]);
AskLeave.dtEndTime = ObjectConvertClass.static_ext_date(dr["dEndTime"]);
AskLeave.nStatus = ObjectConvertClass.static_ext_int(dr["nStatus"]);
ret.AskLeave = AskLeave;
return(ret);
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Base_TrainNo DataRowToModel(DataRow dr)
{
Base_TrainNo model = new Base_TrainNo();
if (dr != null)
{
model.strGUID = ObjectConvertClass.static_ext_string(dr["strGUID"]);
model.strTrainTypeName = ObjectConvertClass.static_ext_string(dr["strTrainTypeName"]);
model.strTrainNumber = ObjectConvertClass.static_ext_string(dr["strTrainNumber"]);
model.strTrainNo = ObjectConvertClass.static_ext_string(dr["strTrainNo"]);
model.dtStartTime = ObjectConvertClass.static_ext_date(dr["dtStartTime"]);
model.dtRealStartTime = ObjectConvertClass.static_ext_date(dr["dtRealStartTime"]);
model.strTrainJiaoluGUID = ObjectConvertClass.static_ext_string(dr["strTrainJiaoluGUID"]);
model.strStartStation = ObjectConvertClass.static_ext_string(dr["strStartStation"]);
model.strEndStation = ObjectConvertClass.static_ext_string(dr["strEndStation"]);
model.nTrainmanTypeID = ObjectConvertClass.static_ext_int(dr["nTrainmanTypeID"]);
model.nPlanType = ObjectConvertClass.static_ext_int(dr["nPlanType"]);
model.nDragType = ObjectConvertClass.static_ext_int(dr["nDragType"]);
model.nKehuoID = ObjectConvertClass.static_ext_int(dr["nKehuoID"]);
model.nRemarkType = ObjectConvertClass.static_ext_int(dr["nRemarkType"]);
model.strRemark = ObjectConvertClass.static_ext_string(dr["strRemark"]);
model.dtCreateTime = ObjectConvertClass.static_ext_date(dr["dtCreateTime"]);
model.strCreateSiteGUID = ObjectConvertClass.static_ext_string(dr["strCreateSiteGUID"]);
model.strCreateUserGUID = ObjectConvertClass.static_ext_string(dr["strCreateUserGUID"]);
model.strPlaceID = ObjectConvertClass.static_ext_string(dr["strPlaceID"]);
model.dtPlanStartTime = ObjectConvertClass.static_ext_date(dr["dtPlanStartTime"]);
model.nNeedRest = ObjectConvertClass.static_ext_int(dr["nNeedRest"]);
model.dtArriveTime = ObjectConvertClass.static_ext_date(dr["dtArriveTime"]);
model.dtCallTime = ObjectConvertClass.static_ext_date(dr["dtCallTime"]);
model.strWorkDay = ObjectConvertClass.static_ext_string(dr["strWorkDay"]);
}
return(model);
}
public DrinkInfoArray GetTrainNoDrinkInfo(DateTime dtStartTime, string strTrainNo, string strPlaceID, int ncount)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top " + ncount + " strTrainmanNumber,strTrainmanName,strTrainmanGUID, dwAlcoholicity,nDrinkResult,dtCreateTime ");
strSql.Append(" from TAB_Drink_Information WHERE dtCreateTime in (select max(dtCreateTime) from TAB_Drink_Information");
strSql.Append(" where dtcreatetime >= @dtStartTime and strTrainNo = @strTrainNo ");
if (!string.IsNullOrEmpty(strPlaceID))
{
strSql.Append(" and strPlaceID=@strPlaceID");
}
strSql.Append(" group by strTrainmanNumber)");
SqlParameter[] sqlParams =
{
new SqlParameter("dtStartTime", dtStartTime),
new SqlParameter("strTrainNo", strTrainNo),
new SqlParameter("strPlaceID", strPlaceID)
};
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0];
DrinkInfoArray list = new DrinkInfoArray();
foreach (DataRow dr in dt.Rows)
{
DrinkInfo _Drink_Query = new DrinkInfo();
_Drink_Query.strTrainmanGUID = ObjectConvertClass.static_ext_string(dr["strTrainmanGUID"]);
_Drink_Query.strTrainmanNumber = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber"]);
_Drink_Query.strTrainmanName = ObjectConvertClass.static_ext_string(dr["strTrainmanName"]);
_Drink_Query.dwAlcoholicity = ObjectConvertClass.static_ext_int(dr["dwAlcoholicity"]);
_Drink_Query.nDrinkResult = ObjectConvertClass.static_ext_int(dr["nDrinkResult"]);
_Drink_Query.dtCreateTime = ObjectConvertClass.static_ext_date(dr["dtCreateTime"]);
list.Add(_Drink_Query);
}
return(list);
}
public DrinkInfo GetTMLastDrinkInfo(string strSiteNumber, string strTrainmanNumber, DateTime dtStartTime, out Boolean bExist)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 strTrainmanGUID, strTrainmanNumber,strTrainmanName,dwAlcoholicity,nDrinkResult,dtCreateTime");
strSql.Append(" from TAB_Drink_Information where dtcreatetime >= @dtStartTime and strTrainmanNumber = @strTrainmanNumber and strSiteNumber = @strSiteNumber");
strSql.Append(" order by dtcreateTime desc");
SqlParameter[] sqlParams =
{
new SqlParameter("dtStartTime", dtStartTime),
new SqlParameter("strTrainmanNumber", strTrainmanNumber),
new SqlParameter("strSiteNumber", strSiteNumber),
};
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0];
DrinkInfo _Drink_Query = null;
if (dt.Rows.Count > 0)
{
bExist = true;
_Drink_Query = new DrinkInfo();
_Drink_Query.strTrainmanGUID = ObjectConvertClass.static_ext_string(dt.Rows[0]["strTrainmanGUID"]);
_Drink_Query.strTrainmanNumber = ObjectConvertClass.static_ext_string(dt.Rows[0]["strTrainmanNumber"]);
_Drink_Query.strTrainmanName = ObjectConvertClass.static_ext_string(dt.Rows[0]["strTrainmanName"]);
_Drink_Query.dwAlcoholicity = ObjectConvertClass.static_ext_int(dt.Rows[0]["dwAlcoholicity"]);
_Drink_Query.nDrinkResult = ObjectConvertClass.static_ext_int(dt.Rows[0]["nDrinkResult"]);
_Drink_Query.dtCreateTime = ObjectConvertClass.static_ext_date(dt.Rows[0]["dtCreateTime"]);
}
else
{
bExist = false;
}
return(_Drink_Query);
}
public CallNotify FindUnCancelforNone_dtToModel(DataTable dt)
{
CallNotify model = new CallNotify();
if (dt.Rows.Count > 0)
{
model.nId = ObjectConvertClass.static_ext_int(dt.Rows[0]["nId"]);
model.strTrainPlanGUID = ObjectConvertClass.static_ext_string(dt.Rows[0]["strTrainPlanGUID"]);
model.strMsgGUID = ObjectConvertClass.static_ext_string(dt.Rows[0]["strMsgGUID"]);
model.strTrainmanGUID = ObjectConvertClass.static_ext_string(dt.Rows[0]["strTrainmanGUID"]);
model.strSendMsgContent = ObjectConvertClass.static_ext_string(dt.Rows[0]["strSendMsgContent"]);
model.strRecvMsgContent = ObjectConvertClass.static_ext_string(dt.Rows[0]["strRecvMsgContent"]);
model.dtSendTime = ObjectConvertClass.static_ext_date(dt.Rows[0]["dtSendTime"]);
model.strSendUser = ObjectConvertClass.static_ext_string(dt.Rows[0]["strSendUser"]);
model.dtRecvTime = ObjectConvertClass.static_ext_date(dt.Rows[0]["dtRecvTime"]);
model.strRecvUser = ObjectConvertClass.static_ext_string(dt.Rows[0]["strRecvUser"]);
model.eCallState = ObjectConvertClass.static_ext_int(dt.Rows[0]["eCallState"]);
model.eCallType = ObjectConvertClass.static_ext_int(dt.Rows[0]["eCallType"]);
model.nCancel = ObjectConvertClass.static_ext_int(dt.Rows[0]["nCancel"]);
model.strCancelReason = ObjectConvertClass.static_ext_string(dt.Rows[0]["strCancelReason"]);
model.strCancelUser = ObjectConvertClass.static_ext_string(dt.Rows[0]["strCancelUser"]);
model.dtCancelTime = ObjectConvertClass.static_ext_date(dt.Rows[0]["dtCancelTime"]);
model.strTrainmanNumber = ObjectConvertClass.static_ext_string(dt.Rows[0]["strTrainmanNumber"]);
model.strTrainmanName = ObjectConvertClass.static_ext_string(dt.Rows[0]["strTrainmanName"]);
model.strTrainNo = ObjectConvertClass.static_ext_string(dt.Rows[0]["strTrainNo"]);
model.dtStartTime = ObjectConvertClass.static_ext_date(dt.Rows[0]["dtStartTime"]);
model.strMobileNumber = ObjectConvertClass.static_ext_string(dt.Rows[0]["strMobileNumber"]);
model.dtChuQinTime = ObjectConvertClass.static_ext_date(dt.Rows[0]["dtChuQinTime"]);
model.dtCallTime = ObjectConvertClass.static_ext_date(dt.Rows[0]["dtCallTime"]);
}
return(model);
}
public RunEvent GetPlanRunEventsDRToModelDTToList(DataRow dr)
{
RunEvent model = new RunEvent();
if (dr != null)
{
model.strRunEventGUID = ObjectConvertClass.static_ext_string(dr["strRunEventGUID"]);
model.strTrainPlanGUID = ObjectConvertClass.static_ext_string(dr["strTrainPlanGUID"]);
model.nEventID = ObjectConvertClass.static_ext_int(dr["nEventID"]);
model.strEventName = GetRunEventTypeName.GetRunEventTypeNamebyID(model.nEventID);
model.dtEventTime = ObjectConvertClass.static_ext_date(dr["dtEventTime"]);
model.strTrainNo = ObjectConvertClass.static_ext_string(dr["strTrainNo"]);
model.strTrainTypeName = ObjectConvertClass.static_ext_string(dr["strTrainTypeName"]);
model.strTrainNumber = ObjectConvertClass.static_ext_string(dr["strTrainNumber"]);
model.nTMIS = ObjectConvertClass.static_ext_string(dr["nTMIS"]);
model.strGroupGUID = ObjectConvertClass.static_ext_string(dr["strGroupGUID"]);
model.strTrainmanNumber1 = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber1"]);
model.strTrainmanNumber2 = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber2"]);
model.dtCreateTime = ObjectConvertClass.static_ext_date(dr["dtCreateTime"]);
model.nID = ObjectConvertClass.static_ext_int(dr["nID"]);
model.nResultID = ObjectConvertClass.static_ext_int(dr["nResult"]);
model.strResult = ObjectConvertClass.static_ext_string(dr["strResult"]);
model.strFlowID = ObjectConvertClass.static_ext_string(dr["strFlowID"]);
model.strStationName = ObjectConvertClass.static_ext_string(dr["strStationName"]);
model.strWorkShopGUID1 = ObjectConvertClass.static_ext_string(dr["strWorkShopGUID1"]);
model.strWorkShopGUID2 = ObjectConvertClass.static_ext_string(dr["strWorkShopGUID2"]);
model.nKehuoID = ObjectConvertClass.static_ext_int(dr["nKehuoID"]);
model.nKehuo = ObjectConvertClass.static_ext_int(dr["nKeHuo"]);
}
return(model);
}
/// <summary>
/// 读取DataRow数据到Model中
/// </summary>
private void DataRowToModel(Plan_Beginwork_StepData model, DataRow dr)
{
model.nID = ObjectConvertClass.static_ext_int(dr["nID"]);
model.strTrainPlanGUID = ObjectConvertClass.static_ext_string(dr["strTrainPlanGUID"]);
model.strFieldName = ObjectConvertClass.static_ext_string(dr["strFieldName"]);
model.nStepData = ObjectConvertClass.static_ext_int(dr["nStepData"]);
model.dtStepData = ObjectConvertClass.static_ext_date(dr["dtStepData"]);
model.strStepData = ObjectConvertClass.static_ext_string(dr["strStepData"]);
}
/// <summary>
/// 读取DataRow数据到Model中
/// </summary>
private void LeavesByIDDataRowToModel(AskLeaveEntity model, DataRow dr)
{
model.strAskLeaveGUID = ObjectConvertClass.static_ext_string(dr["strAskLeaveGUID"]);
model.strTrainManID = ObjectConvertClass.static_ext_string(dr["strTrainManID"]);
model.dtBeginTime = ObjectConvertClass.static_ext_date(dr["dBeginTime"]);
model.dtEndTime = ObjectConvertClass.static_ext_date(dr["dEndTime"]);
model.strLeaveTypeGUID = ObjectConvertClass.static_ext_string(dr["strLeaveTypeGUID"]);
model.nStatus = ObjectConvertClass.static_ext_int(dr["nStatus"]);
}
/// <summary>
/// 读取DataRow数据到Model中
/// </summary>
private void DataRowToModel(DDML_Confirm model, DataRow dr)
{
model.nID = ObjectConvertClass.static_ext_int(dr["nID"]);
model.strWorkShopGUID = ObjectConvertClass.static_ext_string(dr["strWorkShopGUID"]);
model.strWorkShopNumber = ObjectConvertClass.static_ext_string(dr["strWorkShopNumber"]);
model.strWorkShopName = ObjectConvertClass.static_ext_string(dr["strWorkShopName"]);
model.dtConfirmTime = ObjectConvertClass.static_ext_date(dr["dtConfirmTime"]);
model.strDutyUserNumber = ObjectConvertClass.static_ext_string(dr["strDutyUserNumber"]);
model.strDutyUserName = ObjectConvertClass.static_ext_string(dr["strDutyUserName"]);
}
/// <summary>
/// 读取DataRow数据到Model中
/// </summary>
private void DataRowToModel(Dat_WebLog model,DataRow dr)
{
model.nID = ObjectConvertClass.static_ext_int(dr["nID"]);
model.strID = ObjectConvertClass.static_ext_string(dr["strID"]);
model.strTrianManNumber = ObjectConvertClass.static_ext_string(dr["strTrianManNumber"]);
model.nType = ObjectConvertClass.static_ext_int(dr["nType"]);
model.dtPostTime = ObjectConvertClass.static_ext_date(dr["dtPostTime"]);
model.strPageUrl = ObjectConvertClass.static_ext_string(dr["strPageUrl"]);
model.strPageName = ObjectConvertClass.static_ext_string(dr["strPageName"]);
model.strClientIP = ObjectConvertClass.static_ext_string(dr["strClientIP"]);
}
/// <summary>
/// 读取DataRow数据到Model中
/// </summary>
private void DataRowToModel(RunRecordFileDetail model, DataRow dr)
{
model.nID = ObjectConvertClass.static_ext_int(dr["nID"]);
model.strPlanGUID = ObjectConvertClass.static_ext_string(dr["strPlanGUID"]);
model.strFileName = ObjectConvertClass.static_ext_string(dr["strFileName"]);
model.strTrainNum = ObjectConvertClass.static_ext_string(dr["strTrainNum"]);
model.strTrainmanNumber = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber"]);
model.strTrainNo = ObjectConvertClass.static_ext_string(dr["strTrainNo"]);
model.nFileSize = ObjectConvertClass.static_ext_int(dr["nFileSize"]);
model.dtFileTime = ObjectConvertClass.static_ext_date(dr["dtFileTime"]);
}
private DateTime?DBFieldToTime(DataRow dr, string FieldName)
{
if (dr.Table.Columns.Contains(FieldName))
{
return(ObjectConvertClass.static_ext_date(dr[FieldName]));
}
else
{
return(null);
}
}
public override void GetResult(object data, int nWorkTypeID)
{
InFlows_SpecificOnDutyPrint input = Newtonsoft.Json.JsonConvert.DeserializeObject <InFlows_SpecificOnDutyPrint>(data.ToString());
DBStep db = new DBStep();
foreach (trainmanList t in input.trainmanList)
{
#region 出勤步骤结果的实体信息
StepResult StepResult = new StepResult();
StepResult.dtBeginTime = ObjectConvertClass.static_ext_date(input.dtBeginTime);
StepResult.dtCreateTime = ObjectConvertClass.static_ext_date(input.dtCreateTime);
StepResult.dtEndTime = ObjectConvertClass.static_ext_date(input.dtEndTime);
int nStepIndex = db.getIndexOfStep(input.strWorkShopGUID, "RS.STEP.PRINT.GXHCQ", nWorkTypeID);
if (nStepIndex == 0)
{
break;
}
StepResult.nStepIndex = nStepIndex;
StepResult.strStepBrief = "个性化出勤打印";
StepResult.strStepName = "RS.STEP.PRINT.GXHCQ";
StepResult.strTrainPlanGUID = input.strTrainPlanGUID;
StepResult.strTrainmanGUID = t.strTrainmanGUID;
StepResult.nStepResult = input.nStepResult;
StepResult.strTrainmanName = t.strTrainmanName;
StepResult.strTrainmanNumber = t.strTrainmanNumber;
StepResult.nWorkTypeID = nWorkTypeID;
#endregion
db.AddStep(null, null, StepResult);
//向旧的接口提交数据
MDPlan_Beginwork_Step md = new MDPlan_Beginwork_Step();
md.dtCreateTime = input.dtCreateTime;
md.dtEventEndTime = input.dtEndTime;
md.dtEventTime = input.dtCreateTime;
md.nStepID = 1013;
md.nStepResultID = 1;
md.strStepResultText = "";
md.strTrainmanGUID = t.strTrainmanGUID;
md.strTrainmanName = t.strTrainmanName;
md.strTrainmanNumber = t.strTrainmanName;
md.strTrainPlanGUID = input.strTrainPlanGUID;
db.AddPlan_Beginwork_Step(md);
//向旧的接口提交数据结束
//检测是否是特殊步骤
if (db.CheckIsSpecialStep("RS.STEP.PRINT.GXHCQ", input.strWorkShopGUID, nWorkTypeID))
{
db.UpdateToYiChuQin(input.strTrainPlanGUID, DateTime.Now, "", "", "", nWorkTypeID);
}
}
db.creatMsg("RS.STEP.PRINT.GXHCQ", input.strTrainPlanGUID, input.cid, nWorkTypeID, input.strWorkShopGUID);
}
/// <summary>
/// 读取DataRow数据到Model中
/// </summary>
private void GuideSignDataRowToModel(GuideSignEntity model, DataRow dr)
{
model.strGuideSignGUID = ObjectConvertClass.static_ext_string(dr["strGuideSignGUID"]);
model.strTrainmanNumber = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber"]);
model.strTrainmanName = ObjectConvertClass.static_ext_string(dr["strTrainmanName"]);
model.strWorkShopGUID = ObjectConvertClass.static_ext_string(dr["strWorkShopGUID"]);
model.strWorkShopName = ObjectConvertClass.static_ext_string(dr["strWorkShopName"]);
model.strGuideGroupGUID = ObjectConvertClass.static_ext_string(dr["strGuideGroupGUID"]);
model.strGuideGroupName = ObjectConvertClass.static_ext_string(dr["strGuideGroupName"]);
model.dtSignInTime = ObjectConvertClass.static_ext_date(dr["dtSignInTime"]);
model.nSignInFlag = ObjectConvertClass.static_ext_int(dr["nSignInFlag"]);
model.dtSignOutTime = ObjectConvertClass.static_ext_date(dr["dtSignOutTime"]);
model.nSignOutFlag = ObjectConvertClass.static_ext_int(dr["nSignOutFlag"]);
}
/// <summary>
/// 读取DataRow数据到Model中
/// </summary>
private void DataRowToModel(Plan_Beginwork_StepResult model, DataRow dr)
{
model.nID = ObjectConvertClass.static_ext_int(dr["nID"]);
model.strTrainPlanGUID = ObjectConvertClass.static_ext_string(dr["strTrainPlanGUID"]);
model.strStepName = ObjectConvertClass.static_ext_string(dr["strStepName"]);
model.nStepResult = ObjectConvertClass.static_ext_int(dr["nStepResult"]);
model.dtBeginTime = ObjectConvertClass.static_ext_date(dr["dtBeginTime"]);
model.dtEndTime = ObjectConvertClass.static_ext_date(dr["dtEndTime"]);
model.strStepBrief = ObjectConvertClass.static_ext_string(dr["strStepBrief"]);
model.dtCreateTime = ObjectConvertClass.static_ext_date(dr["dtCreateTime"]);
model.nStepIndex = ObjectConvertClass.static_ext_int(dr["nStepIndex"]);
model.strTrainmanName = ObjectConvertClass.static_ext_string(dr["strTrainmanName"]);
model.strTrainmanNumber = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber"]);
}
/// <summary>
/// 读取DataRow数据到Model中
/// </summary>
private void OperateLogDataRowToModel(XyOperateLog model, DataRow dr)
{
model.RelationOP = ObjectConvertClass.static_ext_int(dr["nRelationOP"]);
model.strTeacherGUID = ObjectConvertClass.static_ext_string(dr["strTeacherGUID"]);
model.strTeacherNumber = ObjectConvertClass.static_ext_string(dr["strTeacherNumber"]);
model.strTeacherName = ObjectConvertClass.static_ext_string(dr["strTeacherName"]);
model.strStudentGUID = ObjectConvertClass.static_ext_string(dr["strStudentGUID"]);
model.strStudentNumber = ObjectConvertClass.static_ext_string(dr["strStudentNumber"]);
model.strStudentName = ObjectConvertClass.static_ext_string(dr["strStudentName"]);
model.strDutyUserGUID = ObjectConvertClass.static_ext_string(dr["strDutyUserGUID"]);
model.strDutyUserNumber = ObjectConvertClass.static_ext_string(dr["strDutyNumber"]);
model.strDutyUserName = ObjectConvertClass.static_ext_string(dr["strDutyName"]);
model.dtCreateTime = ObjectConvertClass.static_ext_date(dr["dtCreateTime"]);
}
/// <summary>
/// 读取DataRow数据到Model中
/// </summary>
private void CancelLeaveDetailDataRowToModel(CancelLeaveDetailEntity model, DataRow dr)
{
model.strCancelLeaveGUID = ObjectConvertClass.static_ext_string(dr["strCancelLeaveGUID"]);
model.strAskLeaveGUID = ObjectConvertClass.static_ext_string(dr["strAskLeaveGUID"]);
model.strProverID = ObjectConvertClass.static_ext_string(dr["strProverID"]);
model.strProverName = ObjectConvertClass.static_ext_string(dr["strProverName"]);
model.dtCancelTime = ObjectConvertClass.static_ext_date(dr["dtCancelTime"]);
model.dtCreateTime = ObjectConvertClass.static_ext_date(dr["dCreateTime"]);
model.strDutyUserID = ObjectConvertClass.static_ext_string(dr["strDutyUserID"]);
model.strDutyUserName = ObjectConvertClass.static_ext_string(dr["strDutyUserName"]);
model.strSiteID = ObjectConvertClass.static_ext_string(dr["strSiteID"]);
model.strSiteName = ObjectConvertClass.static_ext_string(dr["strSiteName"]);
model.Verify = ObjectConvertClass.static_ext_int(dr["nValidWay"]);
}
/// <summary>
/// 读取DataRow数据到Model中
/// </summary>
private void DataRowToModel(Plan_Beginwork_Flow model, DataRow dr)
{
model.nID = ObjectConvertClass.static_ext_int(dr["nID"]);
model.strTrainPlanGUID = ObjectConvertClass.static_ext_string(dr["strTrainPlanGUID"]);
model.strUserName = ObjectConvertClass.static_ext_string(dr["strUserName"]);
model.strUserNumber = ObjectConvertClass.static_ext_string(dr["strUserNumber"]);
model.dtConfirmTime = ObjectConvertClass.static_ext_date(dr["dtConfirmTime"]);
model.nConfirmType = ObjectConvertClass.static_ext_int(dr["nConfirmType"]);
model.strConfirmBrief = ObjectConvertClass.static_ext_string(dr["strConfirmBrief"]);
model.nFlowState = ObjectConvertClass.static_ext_int(dr["nFlowState"]);
model.dtCreateTime = ObjectConvertClass.static_ext_date(dr["dtCreateTime"]);
model.dtBeginTime = ObjectConvertClass.static_ext_date(dr["dtBeginTime"]);
model.dtEndTime = ObjectConvertClass.static_ext_date(dr["dtEndTime"]);
model.nExecLength = ObjectConvertClass.static_ext_int(dr["nExecLength"]);
}
/// <summary>
/// 读取DataRow数据到Model中
/// </summary>
private void DrinkDataRowToModel(DrinkInfo model, DataRow dr)
{
model.strGUID = ObjectConvertClass.static_ext_string(dr["strGUID"]);
model.nDrinkResult = ObjectConvertClass.static_ext_int(dr["nDrinkResult"]);
model.dtCreateTime = ObjectConvertClass.static_ext_date(dr["dtCreateTime"]);
model.nVerifyID = ObjectConvertClass.static_ext_int(dr["nVerifyID"]);
model.nWorkTypeID = ObjectConvertClass.static_ext_int(dr["nWorkTypeID"]);
model.strWorkTypeName = ObjectConvertClass.static_ext_string(dr["strWorkTypeName"]);
model.strDrinkResultName = ObjectConvertClass.static_ext_string(dr["strDrinkResultName"]);
model.strVerifyName = ObjectConvertClass.static_ext_string(dr["strVerifyName"]);
model.strImagePath = ObjectConvertClass.static_ext_string(dr["strImagePath"]);
model.nid = ObjectConvertClass.static_ext_int(dr["nid"]);
//人员
model.strTrainmanGUID = ObjectConvertClass.static_ext_string(dr["strTrainmanGUID"]);
model.strTrainmanNumber = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber"]);
model.strTrainmanName = ObjectConvertClass.static_ext_string(dr["strTrainmanName"]);
//车次
model.strTrainNo = ObjectConvertClass.static_ext_string(dr["strTrainNo"]);
model.strTrainNumber = ObjectConvertClass.static_ext_string(dr["strTrainNumber"]);
model.strTrainTypeName = ObjectConvertClass.static_ext_string(dr["strTrainTypeName"]);
//出勤点
model.strPlaceID = ObjectConvertClass.static_ext_string(dr["strPlaceID"]);
model.strPlaceName = ObjectConvertClass.static_ext_string(dr["strPlaceName"]);
model.strSiteGUID = ObjectConvertClass.static_ext_string(dr["strSiteGUID"]);
model.strSiteName = ObjectConvertClass.static_ext_string(dr["strSiteName"]);
//车间
model.strWorkShopGUID = ObjectConvertClass.static_ext_string(dr["strWorkShopGUID"]);
model.strWorkShopName = ObjectConvertClass.static_ext_string(dr["strWorkShopName"]);
//酒精度
model.dwAlcoholicity = ObjectConvertClass.static_ext_int(dr["dwAlcoholicity"]);
model.strWorkID = ObjectConvertClass.static_ext_string(dr["strWorkID"]);
model.strAreaGUID = ObjectConvertClass.static_ext_string(dr["strAreaGUID"]);
model.strDutyGUID = ObjectConvertClass.static_ext_string(dr["strDutyGUID"]);
model.strDutyName = ObjectConvertClass.static_ext_string(dr["strDutyName"]);
model.strDutyNumber = ObjectConvertClass.static_ext_string(dr["strDutyNumber"]);
if (!(dr["bLocalAreaTrainman"] is DBNull))
{
model.bLocalAreaTrainman = Convert.ToBoolean(dr["bLocalAreaTrainman"]);
}
model.strSiteNumber = ObjectConvertClass.static_ext_string(dr["strSiteNumber"]);
model.strDepartmentID = ObjectConvertClass.static_ext_string(dr["strDepartmentID"]);
model.strDepartmentName = ObjectConvertClass.static_ext_string(dr["strDepartmentName"]);
model.nCadreTypeID = ObjectConvertClass.static_ext_string(dr["nCadreTypeID"]);
model.strCadreTypeName = ObjectConvertClass.static_ext_string(dr["strCadreTypeName"]);
}
public override void GetResult(object data, int nWorkTypeID)
{
base._nWorkTypeID = nWorkTypeID;
input = Newtonsoft.Json.JsonConvert.DeserializeObject <InFlows_TQZhuanChu>(data.ToString());
//保存转储数据
DBEndWork dal = new DBEndWork();
if (input.runRecordFileMain != null)
{
dal.SubMitRunRecordInfo(input.runRecordFileMain);
}
else
{
LogClass.log("没有转储数据");
}
DBStep db = new DBStep();
StepResult StepResult = null;
int nStepIndex = db.getIndexOfStep(input.strWorkShopGUID, WorkType.TQZhuanChu, nWorkTypeID);
if (nStepIndex != 0)
{
//保存转储步骤执行数据
foreach (trainmanList t in input.trainmanList)
{
#region 退勤步骤结果的实体信息
StepResult = new StepResult();
StepResult.dtBeginTime = ObjectConvertClass.static_ext_date(input.dtBeginTime);
StepResult.dtCreateTime = ObjectConvertClass.static_ext_date(input.dtCreateTime);
StepResult.dtEndTime = ObjectConvertClass.static_ext_date(input.dtEndTime);
StepResult.nStepIndex = nStepIndex;
StepResult.strStepBrief = "运行记录转储";
StepResult.strStepName = WorkType.TQZhuanChu;
StepResult.strTrainPlanGUID = input.strTrainPlanGUID;
StepResult.strTrainmanGUID = t.strTrainmanGUID;
StepResult.nStepResult = input.nStepResult;
StepResult.strTrainmanName = t.strTrainmanName;
StepResult.strTrainmanNumber = t.strTrainmanNumber;
StepResult.nWorkTypeID = 2;
StepResult.strStepName = "RS.STEP.ICCARDRUNRECORD";
#endregion
db.AddStep(null, null, StepResult);
}
db.creatMsg("RS.STEP.ICCARDRUNRECORD", input.strTrainPlanGUID, input.cid, nWorkTypeID, input.strWorkShopGUID);
}
}
private void DrinkInfoDataRowToModel(DrinkInfo model, DataRow dr)
{
model.strGUID = ObjectConvertClass.static_ext_string(dr["strGUID"]);
model.strTrainmanNumber = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber"]);
model.strTrainmanName = ObjectConvertClass.static_ext_string(dr["strTrainmanName"]);
model.strWorkShopName = ObjectConvertClass.static_ext_string(dr["strWorkShopName"]);
model.nDrinkResult = ObjectConvertClass.static_ext_int(dr["nDrinkResult"]);
model.strDrinkResultName = ObjectConvertClass.static_ext_string(dr["strDrinkResultName"]);
model.dtCreateTime = ObjectConvertClass.static_ext_date(dr["dtCreateTime"]);
model.nVerifyID = ObjectConvertClass.static_ext_int(dr["nVerifyID"]);
model.strVerifyName = ObjectConvertClass.static_ext_string(dr["strVerifyName"]);
model.nWorkTypeID = ObjectConvertClass.static_ext_int(dr["nWorkTypeID"]);
model.strWorkTypeName = ObjectConvertClass.static_ext_string(dr["strWorkTypeName"]);
model.strImagePath = ObjectConvertClass.static_ext_string(dr["strImagePath"]);
model.strDepartmentID = ObjectConvertClass.static_ext_string(dr["strDepartmentID"]);
model.strDepartmentName = ObjectConvertClass.static_ext_string(dr["strDepartmentName"]);
model.nCadreTypeID = ObjectConvertClass.static_ext_string(dr["nCadreTypeID"]);
model.strCadreTypeName = ObjectConvertClass.static_ext_string(dr["strCadreTypeName"]);
}
public DrinkInfo GetTrainmanDrinkInfo(string strTrainmanGUID, string strTrainPlanGUID, int WorkType, out Boolean bExist)
{
StringBuilder strSql = new StringBuilder();
switch (WorkType)
{
case 2: //出勤
strSql.Append("select * from TAB_Drink_Information where strWorkID = (");
strSql.Append("select top 1 strBeginWorkGUID from TAB_Plan_BeginWork where ");
strSql.Append(" strTrainPlanGUID = @strTrainPlanGUID and strTrainmanGUID = @strTrainmanGUID) ORDER BY dtCreateTime DESC");
break;
case 3: //退勤
strSql.Append("select * from TAB_Drink_Information where strWorkID = (");
strSql.Append("select top 1 strEndWorkGUID from TAB_Plan_EndWork where ");
strSql.Append(" strTrainPlanGUID = @strTrainPlanGUID and strTrainmanGUID = @strTrainmanGUID) ORDER BY dtCreateTime DESC");
break;
}
SqlParameter[] sqlParams =
{
new SqlParameter("strTrainPlanGUID", strTrainPlanGUID),
new SqlParameter("strTrainmanGUID", strTrainmanGUID),
};
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0];
DrinkInfo _Drink_Query = null;
if (dt.Rows.Count > 0)
{
bExist = true;
_Drink_Query = new DrinkInfo();
_Drink_Query.nDrinkResult = ObjectConvertClass.static_ext_int(dt.Rows[0]["nDrinkResult"]);
_Drink_Query.dtCreateTime = ObjectConvertClass.static_ext_date(dt.Rows[0]["dtCreateTime"]);
_Drink_Query.strImagePath = ObjectConvertClass.static_ext_string(dt.Rows[0]["strImagePath"]);
//DrinkDataRowToModel(_Drink_Query, dt.Rows[0]);
}
else
{
bExist = false;
}
return(_Drink_Query);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Org_DutyUser DataRowToModel(DataRow dr)
{
Org_DutyUser model = new Org_DutyUser();
if (dr != null)
{
model.nid = ObjectConvertClass.static_ext_int(dr["nid"]);
model.strDutyGUID = ObjectConvertClass.static_ext_string(dr["strDutyGUID"]);
model.strDutyNumber = ObjectConvertClass.static_ext_string(dr["strDutyNumber"]);
model.strDutyName = ObjectConvertClass.static_ext_string(dr["strDutyName"]);
model.strPassword = ObjectConvertClass.static_ext_string(dr["strPassword"]);
model.nDeleteState = ObjectConvertClass.static_ext_int(dr["nDeleteState"]);
model.strAreaGUID = ObjectConvertClass.static_ext_string(dr["strAreaGUID"]);
model.nRoleID = ObjectConvertClass.static_ext_int(dr["nRoleID"]);
model.dtCreateTime = ObjectConvertClass.static_ext_date(dr["dtCreateTime"]);
model.strTokenID = ObjectConvertClass.static_ext_string(dr["strTokenID"]);
model.dtTokenTime = ObjectConvertClass.static_ext_date(dr["dtTokenTime"]);
model.dtLoginTime = ObjectConvertClass.static_ext_date(dr["dtLoginTime"]);
}
return(model);
}
/// <summary>
/// 读取DataRow数据到Model中
/// </summary>
private void DataRowToModel(RunRecordFileMain model, DataRow dr)
{
model.nID = ObjectConvertClass.static_ext_int(dr["nID"]);
model.dtUploadTime = ObjectConvertClass.static_ext_date(dr["dtUploadTime"]);
model.strPlanGUID = ObjectConvertClass.static_ext_string(dr["strPlanGUID"]);
model.dtPlanChuQinTime = ObjectConvertClass.static_ext_date(dr["dtPlanChuQinTime"]);
model.strTrainNo = ObjectConvertClass.static_ext_string(dr["strTrainNo"]);
model.strTrainNum = ObjectConvertClass.static_ext_string(dr["strTrainNum"]);
model.strTrainTypeName = ObjectConvertClass.static_ext_string(dr["strTrainTypeName"]);
model.strTrainmanNumber1 = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber1"]);
model.strTrainmanName1 = ObjectConvertClass.static_ext_string(dr["strTrainmanName1"]);
model.strTrainmanNumber2 = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber2"]);
model.strTrainmanName2 = ObjectConvertClass.static_ext_string(dr["strTrainmanName2"]);
model.strTrainmanNumber3 = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber3"]);
model.strTrainmanName3 = ObjectConvertClass.static_ext_string(dr["strTrainmanName3"]);
model.strTrainmanNumber4 = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber4"]);
model.strTrainmanName4 = ObjectConvertClass.static_ext_string(dr["strTrainmanName4"]);
model.strCardNumber = ObjectConvertClass.static_ext_string(dr["strCardNumber"]);
model.strSiteNumber = ObjectConvertClass.static_ext_string(dr["strSiteNumber"]);
model.strSiteName = ObjectConvertClass.static_ext_string(dr["strSiteName"]);
}
/// <summary>
/// 读取DataRow数据到Model中
/// </summary>
private void LeavesDataRowToModel(AskLeaveWithType model, DataRow dr)
{
model.strTypeName = ObjectConvertClass.static_ext_string(dr["strTypeName"]);
AskLeaveEntity AskLeave = new AskLeaveEntity();
AskLeave.strAskLeaveGUID = ObjectConvertClass.static_ext_string(dr["strAskLeaveGUID"]);
AskLeave.strTrainManID = ObjectConvertClass.static_ext_string(dr["strTrainManID"]);
AskLeave.strTrainmanName = ObjectConvertClass.static_ext_string(dr["strTrainmanName"]);
AskLeave.dtBeginTime = ObjectConvertClass.static_ext_date(dr["dBeginTime"]);
AskLeave.dtEndTime = ObjectConvertClass.static_ext_date(dr["dEndTime"]);
AskLeave.strLeaveTypeGUID = ObjectConvertClass.static_ext_string(dr["strLeaveTypeGUID"]);
AskLeave.nStatus = ObjectConvertClass.static_ext_int(dr["nStatus"]);
AskLeave.strAskProverID = ObjectConvertClass.static_ext_string(dr["strAskProverID"]);
AskLeave.strAskProverName = ObjectConvertClass.static_ext_string(dr["strAskProverName"]);
AskLeave.dtAskCreateTime = ObjectConvertClass.static_ext_date(dr["dtAskCreateTime"]);
AskLeave.strAskDutyUserName = ObjectConvertClass.static_ext_string(dr["strAskDutyUserName"]);
AskLeave.strMemo = ObjectConvertClass.static_ext_string(dr["strMemo"]);
AskLeave.nPostID = ObjectConvertClass.static_ext_int(dr["nPostID"]);
AskLeave.strGuideGroupName = ObjectConvertClass.static_ext_string(dr["strGuideGroupName"]);
model.AskLeave = AskLeave;
}
/// <summary>
/// 读取DataRow数据到Model中
/// <summary>
private void DataRowToModel(Base_TrainNo model, DataRow dr)
{
model.strGUID = ObjectConvertClass.static_ext_string(dr["strGUID"]);
model.strTrainTypeName = ObjectConvertClass.static_ext_string(dr["strTrainTypeName"]);
model.strTrainNumber = ObjectConvertClass.static_ext_string(dr["strTrainNumber"]);
model.strTrainNo = ObjectConvertClass.static_ext_string(dr["strTrainNo"]);
model.dtStartTime = ObjectConvertClass.static_ext_date(dr["dtStartTime"]);
model.dtRealStartTime = ObjectConvertClass.static_ext_date(dr["dtRealStartTime"]);
model.strTrainJiaoluGUID = ObjectConvertClass.static_ext_string(dr["strTrainJiaoluGUID"]);
model.strStartStation = ObjectConvertClass.static_ext_string(dr["strStartStation"]);
model.strEndStation = ObjectConvertClass.static_ext_string(dr["strEndStation"]);
model.nTrainmanTypeID = ObjectConvertClass.static_ext_int(dr["nTrainmanTypeID"]);
model.nPlanType = ObjectConvertClass.static_ext_int(dr["nPlanType"]);
model.nDragType = ObjectConvertClass.static_ext_int(dr["nDragType"]);
model.nKehuoID = ObjectConvertClass.static_ext_int(dr["nKehuoID"]);
model.nRemarkType = ObjectConvertClass.static_ext_int(dr["nRemarkType"]);
model.strRemark = ObjectConvertClass.static_ext_string(dr["strRemark"]);
model.dtCreateTime = ObjectConvertClass.static_ext_date(dr["dtCreateTime"]);
model.strCreateSiteGUID = ObjectConvertClass.static_ext_string(dr["strCreateSiteGUID"]);
model.strCreateUserGUID = ObjectConvertClass.static_ext_string(dr["strCreateUserGUID"]);
model.strPlaceID = ObjectConvertClass.static_ext_string(dr["strPlaceID"]);
model.dtPlanStartTime = ObjectConvertClass.static_ext_date(dr["dtPlanStartTime"]);
}
public override void GetResult(object data, int nWorkTypeID)
{
InFlows_Base input = Newtonsoft.Json.JsonConvert.DeserializeObject <InFlows_Base>(data.ToString());
DBStep db = new DBStep();
foreach (trainmanList t in input.trainmanList)
{
StepResult StepResult = new StepResult();
StepResult.dtBeginTime = ObjectConvertClass.static_ext_date(input.dtBeginTime);
StepResult.dtCreateTime = ObjectConvertClass.static_ext_date(input.dtCreateTime);
StepResult.dtEndTime = ObjectConvertClass.static_ext_date(input.dtEndTime);
//int nStepIndex = db.getIndexOfStep(input.strWorkShopGUID, input.stepName, nWorkTypeID);
StepResult.nStepIndex = 1;
StepResult.strStepBrief = input.stepChineseName;
StepResult.strStepName = input.stepName;
StepResult.strTrainPlanGUID = input.strTrainPlanGUID;
//人员没有guid的情况下，从新从人员库中获取
if (t.strTrainmanGUID == null || t.strTrainmanGUID == "")
{
StepResult.strTrainmanGUID = db.getTrainManGUID(t.strTrainmanNumber);
}
else
{
StepResult.strTrainmanGUID = t.strTrainmanGUID;
}
StepResult.nStepResult = input.nStepResult;
StepResult.strTrainmanName = t.strTrainmanName;
StepResult.strTrainmanNumber = t.strTrainmanNumber;
StepResult.nWorkTypeID = nWorkTypeID;
db.AddStep(null, null, StepResult);
}
}