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 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); }
//从数据行中读取数据到TrainPlanChangeLog中 public static void TrainPlanChangeLogFromDB(TrainPlanChangeLog Log, DataRow dr) { Log.nid = ObjectConvertClass.static_ext_int(dr["nid"]); Log.strLogGUID = ObjectConvertClass.static_ext_string(dr["strLogGUID"]); Log.strTrainPlanGUID = ObjectConvertClass.static_ext_string(dr["strTrainPlanGUID"]); Log.strTrainTypeName = ObjectConvertClass.static_ext_string(dr["strTrainTypeName"]); Log.strTrainNumber = ObjectConvertClass.static_ext_string(dr["strTrainNumber"]); Log.strTrainNo = ObjectConvertClass.static_ext_string(dr["strTrainNo"]); Log.dtStartTime = ObjectConvertClass.static_ext_Date(dr["dtStartTime"]); Log.strTrainJiaoluGUID = ObjectConvertClass.static_ext_string(dr["strTrainJiaoluGUID"]); Log.strTrainJiaoluName = ObjectConvertClass.static_ext_string(dr["strTrainJiaoluName"]); Log.strStartStation = ObjectConvertClass.static_ext_string(dr["strStartStation"]); Log.strStartStationName = ObjectConvertClass.static_ext_string(dr["strStartStationName"]); Log.strEndStation = ObjectConvertClass.static_ext_string(dr["strEndStation"]); Log.strEndStationName = ObjectConvertClass.static_ext_string(dr["strEndStationName"]); Log.nTrainmanTypeID = ObjectConvertClass.static_ext_int(dr["nTrainmanTypeID"]); Log.nPlanType = ObjectConvertClass.static_ext_int(dr["nPlanType"]); Log.nDragType = ObjectConvertClass.static_ext_int(dr["nDragType"]); Log.nKehuoID = ObjectConvertClass.static_ext_int(dr["nKehuoID"]); Log.nRemarkType = ObjectConvertClass.static_ext_int(dr["nRemarkType"]); Log.strRemark = ObjectConvertClass.static_ext_string(dr["strRemark"]); Log.nPlanState = ObjectConvertClass.static_ext_int(dr["nPlanState"]); Log.dtCreateTime = ObjectConvertClass.static_ext_Date(dr["dtCreateTime"]); Log.strOperateSiteGUID = ObjectConvertClass.static_ext_string(dr["strOperateSiteGUID"]); Log.strOperateSiteName = ObjectConvertClass.static_ext_string(dr["strOperateSiteName"]); Log.strOperateUserGUID = ObjectConvertClass.static_ext_string(dr["strOperateUserGUID"]); Log.strOperateUserName = ObjectConvertClass.static_ext_string(dr["strOperateUserName"]); Log.strOperateUserID = ObjectConvertClass.static_ext_string(dr["strOperateUserID"]); Log.dtChangeTime = ObjectConvertClass.static_ext_Date(dr["dtChangeTime"]); }
/// <summary> /// 读取DataRow数据到Model中 /// </summary> private void StudentsDataRowToModel(XYStudent model, DataRow dr) { model.strTeacherGUID = ObjectConvertClass.static_ext_string(dr["strTeacherGUID"]); model.strStudentGUID = ObjectConvertClass.static_ext_string(dr["strStudentGUID"]); model.strStudentNumber = ObjectConvertClass.static_ext_string(dr["strStudentNumber"]); model.strStudentName = ObjectConvertClass.static_ext_string(dr["strStudentName"]); }
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); }
/// <summary> /// 读取DataRow数据到Model中 /// </summary> private void DutyUserDataRowToModel(RsDutyUser model, DataRow dr) { 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"]); }
/// <summary> /// 获得对象信息 /// <summary> public InterfaceOutPut GetEntry(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 0; try { CommonJsonModel cjm = new CommonJsonModel(Data); Base_TrainNoQueryCondition _Base_TrainNoQueryCondition = new Base_TrainNoQueryCondition(); _Base_TrainNoQueryCondition.strGUID = ObjectConvertClass.static_ext_string(cjm.GetValue("strGUID")); DBBase_TrainNo dbBase_TrainNo = new DBBase_TrainNo(ThinkFreely.DBUtility.SqlHelper.ConnString); Base_TrainNo _Base_TrainNo = dbBase_TrainNo.GetModel(_Base_TrainNoQueryCondition); if (_Base_TrainNo == null) { output.resultStr = "没有对应数据"; } else { output.result = 1; List <Base_TrainNo> Base_TrainNoList = new List <Base_TrainNo>(); Base_TrainNoList.Add(_Base_TrainNo); output.data = Base_TrainNoList; } } catch (Exception ex) { output.resultStr = ex.Message; LogClass.log("InterfaceBase_TrainNo.GetEntry:" + ex.Message); } return(output); }
//查询流程列表 public void Query(string flowType, string tmid, string planID, List <WorkFlow> flows) { flows.Clear(); string sql = "select * from TAB_Plan_WorkFlow where strTmID = @tmid and strPlanID = @planID and strFlowType = @flowType order by dtEventTime"; SqlParameter[] sqlParams = { new SqlParameter("tmid", tmid), new SqlParameter("planID", planID), new SqlParameter("flowType", flowType) }; DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, sql, sqlParams).Tables[0]; WorkFlow workFlow; foreach (DataRow dr in dt.Rows) { workFlow = new WorkFlow(); workFlow.planID = ObjectConvertClass.static_ext_string(dr["strPlanID"]); workFlow.description = ObjectConvertClass.static_ext_string(dr["strDescription"]); workFlow.eventTime = ObjectConvertClass.static_ext_Date(dr["dtEventTime"]); workFlow.flowIdentify = ObjectConvertClass.static_ext_string(dr["strFlowIdentify"]); workFlow.flowType = ObjectConvertClass.static_ext_string(dr["strFlowType"]); workFlow.success = ObjectConvertClass.static_ext_int(dr["nSuccess"]); workFlow.tmid = ObjectConvertClass.static_ext_string(dr["strTmid"]); workFlow.tmName = ObjectConvertClass.static_ext_string(dr["strTmName"]); flows.Add(workFlow); } }
/// <summary> /// 读取DataRow数据到Model中 /// <summary> private void DataRowToModel(Dic_UnitInfo model, DataRow dr) { model.nID = ObjectConvertClass.static_ext_int(dr["nID"]); model.strID = ObjectConvertClass.static_ext_string(dr["strID"]); model.UnitNumber = ObjectConvertClass.static_ext_string(dr["UnitNumber"]); model.UnitName = ObjectConvertClass.static_ext_string(dr["UnitName"]); }
public GuideSignArray GetNotSignDataList(GuideSignQryParam QueryCondition) { StringBuilder strSql = new StringBuilder(); StringBuilder sqlCondition = new StringBuilder(); sqlCondition.Append("select strTrainmanNumber From VIEW_Sign_GuideGroup where 1=1"); sqlCondition.Append(QueryCondition.dtSignTimeBegin >= DateTimeMinValue.dtMinValue && QueryCondition.dtSignTimeEnd >= DateTimeMinValue.dtMinValue ? " and (dtSignInTime >= @dtSignTimeBegin and dtSignInTime <= @dtSignTimeEnd)" : ""); strSql.Append("select strTrainmanNumber,strTrainmanName from TAB_Org_Trainman "); strSql.Append(" where strGuideGroupGUID=@strGuideGroupGUID and strTrainmanNumber not in (" + sqlCondition + ") order by strTrainmanNumber"); SqlParameter[] sqlParams = { new SqlParameter("strGuideGroupGUID", QueryCondition.strGuideGroupGUID), new SqlParameter("dtSignTimeBegin", QueryCondition.dtSignTimeBegin), new SqlParameter("dtSignTimeEnd", QueryCondition.dtSignTimeEnd) }; DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0]; GuideSignArray list = new GuideSignArray(); foreach (DataRow dr in dt.Rows) { GuideSignEntity _Sign_GuideGroup = new GuideSignEntity(); _Sign_GuideGroup.strTrainmanNumber = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber"]); _Sign_GuideGroup.strTrainmanName = ObjectConvertClass.static_ext_string(dr["strTrainmanName"]); list.Add(_Sign_GuideGroup); } return(list); }
public MDJDPlan GetJDPlan(DataRow dr) { MDJDPlan model = new MDJDPlan(); if (dr != null) { model.Day = ObjectConvertClass.static_ext_string(dr["day"]); model.Shift = ObjectConvertClass.static_ext_int(dr["shift"]); model.Typ = ObjectConvertClass.static_ext_int(dr["typ"]); model.Section_id = ObjectConvertClass.static_ext_string(dr["section_id"]); model.Trainkind = ObjectConvertClass.static_ext_int(dr["trainkind"]); model.Train_id = ObjectConvertClass.static_ext_string(dr["train_id"]); model.Train_code = ObjectConvertClass.static_ext_string(dr["train_code"]); model.Time_deptart = ObjectConvertClass.static_ext_Date(dr["time_deptart"]); model.Time_arrived = ObjectConvertClass.static_ext_Date(dr["time_arrived"]); model.Station_deptart = ObjectConvertClass.static_ext_string(dr["station_deptart"]); model.Station_arrived = ObjectConvertClass.static_ext_string(dr["station_arrived"]); model.Loco_num = ObjectConvertClass.static_ext_int(dr["loco_num"]); model.Weight = (float)ObjectConvertClass.static_ext_double(dr["weight"]); model.Car_count = ObjectConvertClass.static_ext_int(dr["car_count"]); model.C_length = (float)ObjectConvertClass.static_ext_double(dr["c_length"]); model.PlanGUID = ObjectConvertClass.static_ext_string(dr["strTrainPlanGUID"]); model.Section_name = ObjectConvertClass.static_ext_string(dr["strSectionName"]); model.Station_deptart_id = ObjectConvertClass.static_ext_string(dr["strDeptartStationID"]); model.Station_arrived_id = ObjectConvertClass.static_ext_string(dr["strArrivedStationID"]); model.IsUpdate = ObjectConvertClass.static_ext_int(dr["nIsUpdate"]); } return(model); }
//通过计划GUID和当前人员的额工号 判断是司机副司机还是学员 public string getTmPost(string tpGUID, string tn) { StringBuilder strSql = new StringBuilder(); strSql.Append("select strTrainmanNumber1,strTrainmanNumber2,strTrainmanNumber3,strTrainmanNumber4 "); strSql.Append(" FROM VIEW_Plan_Trainman where strTrainPlanGUID= '" + tpGUID + "' "); DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString()).Tables[0]; if (dt.Rows.Count > 0) { if (ObjectConvertClass.static_ext_string(dt.Rows[0]["strTrainmanNumber1"].ToString()) == tn) { return("1"); } else if (ObjectConvertClass.static_ext_string(dt.Rows[0]["strTrainmanNumber2"].ToString()) == tn) { return("2"); } else if (ObjectConvertClass.static_ext_string(dt.Rows[0]["strTrainmanNumber3"].ToString()) == tn) { return("3"); } else { return("4"); } } else { return("0"); } }
/// <summary> /// 清除乘务员的指纹信息 /// <summary> public InterfaceOutPut ClearFingerPrint(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; try { CommonJsonModel cjm = new CommonJsonModel(Data); string strTrainmanGUID = ObjectConvertClass.static_ext_string(cjm.GetValue("strTrainmanGUID")); string strSql = @"update TAB_Org_Trainman set Fingerprint1=null,Fingerprint2=null Where strTrainmanGUID =@strTrainmanGUID"; SqlParameter[] sqlParameters = new SqlParameter[] { new SqlParameter("strTrainmanGUID", strTrainmanGUID), }; int count = SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql, sqlParameters); if (count > 0) { output.result = 0; output.resultStr = "指纹信息清除成功"; } } catch (Exception ex) { output.resultStr = ex.Message; LogClass.log("Interface.ClearFingerPrint:" + ex.Message); throw ex; } return(output); }
/// <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); }
/// <summary> /// 获取运安系统时间定义信息 /// </summary> public InterfaceOutPut GetKernelTimeConfig(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; try { OutGetKernelTimeConfig OutParams = new OutGetKernelTimeConfig(); output.data = OutParams; string strSql = "select top 1 * from tab_Base_KernelTime"; DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql).Tables[0]; if (dt.Rows.Count > 0) { OutParams.Config.nMinCallBeforeChuQing = ObjectConvertClass.static_ext_int(dt.Rows[0]["nMinCallBeforeChuQing"]); OutParams.Config.nMinChuQingBeforeStartTrain_K = ObjectConvertClass.static_ext_int(dt.Rows[0]["nMinChuQingBeforeStartTrain_K"]); OutParams.Config.nMinChuQingBeforeStartTrain_Z = ObjectConvertClass.static_ext_int(dt.Rows[0]["nMinChuQingBeforeStartTrain_Z"]); OutParams.Config.nMinDayWorkStart = ObjectConvertClass.static_ext_int(dt.Rows[0]["nMinDayWorkStart"]); OutParams.Config.nMinNightWokrStart = ObjectConvertClass.static_ext_int(dt.Rows[0]["nMinNightWokrStart"]); OutParams.Exist = 1; } output.result = 0; } catch (Exception ex) { output.resultStr = ex.Message; LogClass.log("Interface.GetKernelTimeConfig:" + ex.Message); throw ex; } return(output); }
private VTrainman DrToVTrainmanBrief(DataRow dr, int Option) { VTrainman model = new VTrainman(); 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.nID = ObjectConvertClass.static_ext_int(dr["nID"]); model.strJP = ObjectConvertClass.static_ext_string(dr["strJP"]); if ((Option & 1) != 0) { if (dr.Table.Columns.Contains("FingerPrint1")) { model.FingerPrint1 = ToBase64String(dr["FingerPrint1"]); } if (dr.Table.Columns.Contains("FingerPrint2")) { model.FingerPrint2 = ToBase64String(dr["FingerPrint2"]); } } if ((Option & 2) != 0) { if (dr.Table.Columns.Contains("Picture")) { model.Picture = ToBase64String(dr["Picture"]); } } return(model); }
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 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); }
/// <summary> /// 获取各交路下人员数量 /// </summary> public InterfaceOutPut GetTrainmanJiaoLuCount(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; try { JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); InGetTrainmanJiaoLuCount InParams = javaScriptSerializer.Deserialize <InGetTrainmanJiaoLuCount>(Data); OutGetTrainmanJiaoLuCount OutParams = new OutGetTrainmanJiaoLuCount(); string strSql = @"select count(*) as nCount,strTrainmanJiaoluGUID,strTrainmanJiaoluName from VIEW_Nameplate_TrainmanInJiaolu_All where strTrainmanJiaoluGUID in (select strTrainmanJiaoluGUID from VIEW_Base_JiaoluRelation where strWorkShopGUID = @strWorkShopGUID) group by strTrainmanJiaoluGUID,strTrainmanJiaoluName "; SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("strWorkShopGUID", InParams.WorkShopGUID) }; DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams).Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { TrainmanJiaoluCount c = new TrainmanJiaoluCount(); c.nCount = ObjectConvertClass.static_ext_int(dt.Rows[i]["nCount"]); c.strJiaoLuName = dt.Rows[i]["strTrainmanJiaoluName"].ToString(); OutParams.SumCount.Add(c); } output.data = OutParams; output.result = 0; } catch (Exception ex) { output.resultStr = ex.Message; LogClass.log("Interface.GetTrainmanJiaoLuCount:" + ex.Message); throw ex; } return(output); }
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); } }
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 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); }
private bool ISTXState(string strTrainmanGUID) { //获取目标人员所在机组信息 string strSql = @"select nTXState from TAB_Nameplate_Group where strTrainmanGUID1= @strTrainmanGUID or strTrainmanGUID2=@strTrainmanGUID or strTrainmanGUID3=@strTrainmanGUID or strTrainmanGUID4= @strTrainmanGUID"; SqlParameter[] sqlParamsGroup = new SqlParameter[] { new SqlParameter("strTrainmanGUID", strTrainmanGUID) }; DataTable dtGroup = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParamsGroup).Tables[0]; //判断目标人员所在机组是否处于调休状态 if (dtGroup.Rows.Count > 0) { string nTXState = ObjectConvertClass.static_ext_string(dtGroup.Rows[0]["nTXState"]); if (nTXState == "1") { return(true); } else { return(false); } } else { return(false); } }
/// <summary> /// 读取DataRow数据到Model中 /// </summary> private void LeaveTypeDataRowToModel(LeaveType model, DataRow dr) { model.strTypeGUID = ObjectConvertClass.static_ext_string(dr["strTypeGUID"]); model.strTypeName = ObjectConvertClass.static_ext_string(dr["strTypeName"]); model.nClassID = ObjectConvertClass.static_ext_int(dr["nClassID"]); model.strClassName = ObjectConvertClass.static_ext_string(dr["strClassName"]); }
public string getTrainPlanGUID(string strTrainNumber) { string strTrainmanGUID = ""; StringBuilder strSql = new StringBuilder(); strSql.Append(" select strTrainmanGUID from TAB_Org_Trainman where strTrainmanNumber='" + strTrainNumber + "'"); DataTable dt = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, strSql.ToString()).Tables[0]; if (dt.Rows.Count > 0) { strTrainmanGUID = ObjectConvertClass.static_ext_string(dt.Rows[0]["strTrainmanGUID"]); } else { return(""); } StringBuilder strSql2 = new StringBuilder(); strSql2.Append(@"select top 1 strTrainPlanGUID from TAB_Plan_Trainman where dtCreateTime<'" + DateTime.Now.ToString() + "' and (strTrainmanGUID1= '" + strTrainmanGUID + "' or strTrainmanGUID2= '" + strTrainmanGUID + "' or strTrainmanGUID3= '" + strTrainmanGUID + "' or strTrainmanGUID4= '" + strTrainmanGUID + "')"); DataTable dt2 = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, strSql2.ToString()).Tables[0]; if (dt2.Rows.Count <= 0) { return(""); } else { return(ObjectConvertClass.static_ext_string(dt2.Rows[0]["strTrainPlanGUID"])); } }
/// <summary> /// 读取DataRow数据到Model中 /// </summary> private void DataRowToModel(PlanWriteCardSection model, DataRow dr) { model.nID = ObjectConvertClass.static_ext_int(dr["niD"]); model.strTrainPlanGUID = ObjectConvertClass.static_ext_string(dr["strTrainPlanGUID"]); model.strSectionID = ObjectConvertClass.static_ext_string(dr["strSectionID"]); model.strSectionName = ObjectConvertClass.static_ext_string(dr["strSectionName"]); model.strJWDNumber = ObjectConvertClass.static_ext_string(dr["strJWDNumber"]); }
/// <summary> /// 读取DataRow数据到Model中 /// </summary> private void DataRowToModel(Plan_Beginwork_Rule model, DataRow dr) { model.strWorkShopGUID = ObjectConvertClass.static_ext_string(dr["strWorkShopGUID"]); model.strWorkShopName = ObjectConvertClass.static_ext_string(dr["strWorkShopName"]); model.strKeyStepName = ObjectConvertClass.static_ext_string(dr["strKeyStepName"]); model.nExecByStepIndex = ObjectConvertClass.static_ext_int(dr["nExecByStepIndex"]); model.nID = ObjectConvertClass.static_ext_int(dr["nID"]); }
/// <summary> /// 读取DataRow数据到Model中 /// </summary> private void DataRowToModel(Plan_Beginwork_StepDef model, DataRow dr) { model.strWorkShopGUID = ObjectConvertClass.static_ext_string(dr["strWorkShopGUID"]); model.strWorkShopName = ObjectConvertClass.static_ext_string(dr["strWorkShopName"]); model.strStepName = ObjectConvertClass.static_ext_string(dr["strStepName"]); model.strStepBrief = ObjectConvertClass.static_ext_string(dr["strStepBrief"]); model.nStepIndex = ObjectConvertClass.static_ext_int(dr["nStepIndex"]); model.nID = ObjectConvertClass.static_ext_int(dr["nID"]); }
/// <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(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"]); }