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