/// <summary> /// 得到一个对象实体 /// </summary> public Base_Site_Limit DataRowToModel(DataRow dr) { Base_Site_Limit model = new Base_Site_Limit(); if (dr != null) { model.strSiteGUID = ObjectConvertClass.static_ext_string(dr["strSiteGUID"]); model.nJobID = ObjectConvertClass.static_ext_int(dr["nJobID"]); model.nJobLimit = ObjectConvertClass.static_ext_int(dr["nJobLimit"]); } return(model); }
public ShortTrain GetTrainTypes_DRToModel(DataRow dr) { ShortTrain model = new ShortTrain(); if (dr != null) { model.nID = ObjectConvertClass.static_ext_int(dr["nID"]); model.strLongName = ObjectConvertClass.static_ext_string(dr["strLongName"]); model.strShortName = ObjectConvertClass.static_ext_string(dr["strShortName"]); } return(model); }
/// <summary> /// 获得记录总数 /// </summary> public int GetDataCount(DDML_ConfirmQueryCondition QueryCondition) { SqlParameter[] sqlParams; StringBuilder strSqlOption = new StringBuilder(); QueryCondition.OutPut(out strSqlOption, out sqlParams); StringBuilder strSql = new StringBuilder(); strSql.Append("select count(*) "); strSql.Append(" FROM TAB_DDML_Confirm where 1=1" + strSqlOption.ToString()); return(ObjectConvertClass.static_ext_int(SqlHelper.ExecuteScalar(ConnectionString, CommandType.Text, strSql.ToString(), sqlParams))); }
/// <summary> /// 得到一个对象实体 /// </summary> public Org_Area DataRowToModel(DataRow dr) { Org_Area model = new Org_Area(); if (dr != null) { model.nid = ObjectConvertClass.static_ext_int(dr["nid"]); model.strGUID = ObjectConvertClass.static_ext_string(dr["strGUID"]); model.strAreaName = ObjectConvertClass.static_ext_string(dr["strAreaName"]); model.strJWDNumber = ObjectConvertClass.static_ext_string(dr["strJWDNumber"]); } return(model); }
public SystemDict.DrinkImageInfo GetDrinkImageList(string strTrainmanGUID, string strTrainPlanGUID, int WorkTypeID) { DataSet set = this.GetList(strTrainmanGUID, strTrainPlanGUID, WorkTypeID); SystemDict.DrinkImageInfo dii = new SystemDict.DrinkImageInfo(); if (set.Tables[0].Rows.Count > 0) { dii.dtCreateTime = ObjectConvertClass.static_ext_Date(set.Tables[0].Rows[0]["dtCreateTime"]); dii.nDrinkResult = ObjectConvertClass.static_ext_int(set.Tables[0].Rows[0]["nDrinkResult"]); dii.strPictureURL = ObjectConvertClass.static_ext_string(set.Tables[0].Rows[0]["strImagePath"]); } return(dii); }
public int getMainCount(string strTrainPlanGUID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(*) "); strSql.Append(" FROM Tab_EndWork_RunRecrod_Main where strPlanGUID=@strPlanGUID"); SqlParameter[] sqlParams = { new SqlParameter("@strPlanGUID", strTrainPlanGUID) }; return(ObjectConvertClass.static_ext_int(SqlHelper.ExecuteScalar(ConnectionString, CommandType.Text, strSql.ToString(), sqlParams))); }
public LendingType GetGoodType_DRToModelDTToList(DataRow dr) { LendingType model = new LendingType(); if (dr != null) { model.nID = ObjectConvertClass.static_ext_int(dr["nID"]); model.nLendingTypeID = ObjectConvertClass.static_ext_int(dr["nLendingTypeID"]); model.strLendingTypeName = ObjectConvertClass.static_ext_string(dr["strLendingTypeName"]); model.strAlias = ObjectConvertClass.static_ext_string(dr["strAlias"]); } return(model); }
/// <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"]); }
public LendingTjInfo GetTongJiInfo_DRToModelDTToList(DataRow dr) { LendingTjInfo model = new LendingTjInfo(); if (dr != null) { model.nLendingType = ObjectConvertClass.static_ext_int(dr["nLendingType"]); model.nTotalCount = ObjectConvertClass.static_ext_int(dr["nTotalCount"]); model.nNoReturnCount = ObjectConvertClass.static_ext_int(dr["nNoReturnCount"]); model.strLendingTypeName = ObjectConvertClass.static_ext_string(dr["strLendingTypeName"]); model.strTypeAlias = ObjectConvertClass.static_ext_string(dr["strAlias"]); } return(model); }
/// <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 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 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"]); }
//数据行信息填充到实体 private void DataRowToCfg(DataRow dr, WorkFlowCfg cfg) { cfg.id = ObjectConvertClass.static_ext_int(dr["nID"]); cfg.flowType = ObjectConvertClass.static_ext_string(dr["strFlowType"]); cfg.flowIdentify = ObjectConvertClass.static_ext_string(dr["strFlowIdentify"]); cfg.flowName = ObjectConvertClass.static_ext_string(dr["strFlowName"]); cfg.timeBoundary_left = ObjectConvertClass.static_ext_int(dr["nTimeBoundary_left"]); cfg.timeBoundary_right = ObjectConvertClass.static_ext_int(dr["nTimeBoundary_right"]); cfg.withPlanID = ObjectConvertClass.static_ext_int(dr["nWithPlanID"]); cfg.workShop = ObjectConvertClass.static_ext_string(dr["strWorkShop"]); cfg.workShopName = ObjectConvertClass.static_ext_string(dr["strWorkShopName"]); cfg.necessary = ObjectConvertClass.static_ext_int(dr["nNecessary"]); cfg.lackFlowHint = ObjectConvertClass.static_ext_string(dr["strLackFlowHint"]); }
/// <summary> /// 得到一个对象实体 /// </summary> public Org_WorkShop DataRowToModel(DataRow dr) { Org_WorkShop model = new Org_WorkShop(); if (dr != null) { model.nid = ObjectConvertClass.static_ext_int(dr["nid"]); model.strWorkShopGUID = ObjectConvertClass.static_ext_string(dr["strWorkShopGUID"]); model.strAreaGUID = ObjectConvertClass.static_ext_string(dr["strAreaGUID"]); model.strWorkShopName = ObjectConvertClass.static_ext_string(dr["strWorkShopName"]); model.strWorkShopNumber = ObjectConvertClass.static_ext_string(dr["strWorkShopNumber"]); } return(model); }
public DayPlanItemGroup GetGroup_DRToModel(DataRow dr) { DayPlanItemGroup model = new DayPlanItemGroup(); if (dr != null) { model.ID = ObjectConvertClass.static_ext_int(dr["nID"]); model.Name = ObjectConvertClass.static_ext_string(dr["strName"]); model.ExcelSide = ObjectConvertClass.static_ext_int(dr["nExcelSide"]); model.ExcelPos = ObjectConvertClass.static_ext_int(dr["nExcelPos"]); model.DayPlanID = ObjectConvertClass.static_ext_string(dr["nDayPlanID"]); model.IsDaWen = ObjectConvertClass.static_ext_int(dr["bIsDawen"]); } return(model); }
/// <summary> /// 读取DataRow数据到Model中 /// </summary> private void DataRowToStepModel(Plan_Beginwork_StepDef model, DataRow dr) { model.nID = ObjectConvertClass.static_ext_int(dr["nID"]); 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.strStepID = ObjectConvertClass.static_ext_string(dr["strStepID"]); model.nIsNecessary = ObjectConvertClass.static_ext_int(dr["nIsNecessary"]); //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"]); }
public LCDayPlan.PlanItemGroup QueryLeftGroupListByID_DRToModel(DataRow dr, DateTime BeginDate, DateTime EndDate) { LCDayPlan.PlanItemGroup model = new LCDayPlan.PlanItemGroup(); if (dr != null) { model.nID = ObjectConvertClass.static_ext_int(dr["nID"]); model.strName = ObjectConvertClass.static_ext_string(dr["strName"]); model.nExcelSide = ObjectConvertClass.static_ext_int(dr["nExcelSide"]); model.nExcelPos = ObjectConvertClass.static_ext_int(dr["nExcelPos"]); model.nDayPlanID = ObjectConvertClass.static_ext_int(dr["nDayPlanID"]); model.bIsDawen = ObjectConvertClass.static_ext_int(dr["bIsDawen"]); //model.DayPlanInfoList = QueryDayPlanInfoListByGroupID(BeginDate, EndDate, model.nID); } return(model); }
/// <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> /// 得到一个对象实体 /// </summary> public Base_Station DataRowToModel(DataRow dr) { Base_Station model = new Base_Station(); if (dr != null) { model.nid = ObjectConvertClass.static_ext_int(dr["nid"]); model.strStationGUID = ObjectConvertClass.static_ext_string(dr["strStationGUID"]); model.strStationNumber = ObjectConvertClass.static_ext_int(dr["strStationNumber"]); model.strStationName = ObjectConvertClass.static_ext_string(dr["strStationName"]); model.strWorkShopGUID = ObjectConvertClass.static_ext_string(dr["strWorkShopGUID"]); model.strStationPY = ObjectConvertClass.static_ext_string(dr["strStationPY"]); } return(model); }
/// <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"]); }
/// <summary> /// 读取DataRow数据到Model中 /// </summary> private void DataRowToModel(ZXYJInfo model, DataRow dr) { model.nid = ObjectConvertClass.static_ext_int(dr["nid"]); model.strTrainPlanGUID = ObjectConvertClass.static_ext_string(dr["strTrainPlanGUID"]); model.strTrainmanNumber1 = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber1"]); model.strTrainmanNumber2 = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber2"]); model.dtEventTime = ObjectConvertClass.static_ext_Date(dr["dtEventTime"]); model.strXDMC = ObjectConvertClass.static_ext_string(dr["strXDMC"]); 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.strDWH = ObjectConvertClass.static_ext_string(dr["strDWH"]); model.dtCreateTime = ObjectConvertClass.static_ext_Date(dr["dtCreateTime"]); model.nTMIS = ObjectConvertClass.static_ext_string(dr["nTMIS"]); model.strTMISName = ObjectConvertClass.static_ext_string(dr["strTMISName"]); }
public Dictionary <string, TmJl> GetJlDict() { string strSql = @"select * from TAB_Base_TrainmanJiaolu"; DataTable dtTrainmanJiaolu = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql).Tables[0]; Dictionary <string, TmJl> d = new Dictionary <string, TmJl>(); for (int i = 0; i < dtTrainmanJiaolu.Rows.Count; i++) { TmJl tmjl = new TmJl(); tmjl.ID = ObjectConvertClass.static_ext_string(dtTrainmanJiaolu.Rows[i]["strTrainmanJiaoluGUID"]); tmjl.JlType = ObjectConvertClass.static_ext_int(dtTrainmanJiaolu.Rows[i]["nJiaoluType"]); tmjl.Name = ObjectConvertClass.static_ext_string(dtTrainmanJiaolu.Rows[i]["strTrainmanJiaoluName"]); d.Add(tmjl.ID, tmjl); } return(d); }
/// <summary> /// 得到一个对象实体 /// </summary> public Base_ZFQJ DataRowToModel(DataRow dr) { Base_ZFQJ model = new Base_ZFQJ(); if (dr != null) { model.nid = ObjectConvertClass.static_ext_int(dr["nid"]); model.strZFQJGUID = ObjectConvertClass.static_ext_string(dr["strZFQJGUID"]); model.strTrainJiaoluGUID = ObjectConvertClass.static_ext_string(dr["strTrainJiaoluGUID"]); model.nQuJianIndex = ObjectConvertClass.static_ext_int(dr["nQuJianIndex"]); model.strBeginStationGUID = ObjectConvertClass.static_ext_string(dr["strBeginStationGUID"]); model.strEndStationGUID = ObjectConvertClass.static_ext_string(dr["strEndStationGUID"]); model.nSortid = ObjectConvertClass.static_ext_int(dr["nSortid"]); } return(model); }
public LendingManager GetGoodsCodeRange_DRToModelDTToList(DataRow dr) { LendingManager model = new LendingManager(); if (dr != null) { model.nID = ObjectConvertClass.static_ext_int(dr["nID"]); model.strGUID = ObjectConvertClass.static_ext_string(dr["strGUID"]); model.nLendingTypeID = ObjectConvertClass.static_ext_int(dr["nLendingTypeID"]); model.nStartCode = ObjectConvertClass.static_ext_int(dr["nStartCode"]); model.nStopCode = ObjectConvertClass.static_ext_int(dr["nStopCode"]); model.strExceptCodes = ObjectConvertClass.static_ext_string(dr["strExceptCodes"]); model.strWorkShopGUID = ObjectConvertClass.static_ext_string(dr["strWorkShopGUID"]); } return(model); }
/// <summary> /// 检查数据是否存在 /// <summary> public bool Exists(Dic_UnitInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(*) from TAB_Dic_UnitInfo where UnitNumber=@UnitNumber"); if (model.nID != 0) { strSql.Append(" and nID<>@nID"); } SqlParameter[] parameters = { new SqlParameter("nID", model.nID), new SqlParameter("UnitNumber", model.UnitNumber) }; return(ObjectConvertClass.static_ext_int(SqlHelper.ExecuteScalar(ConnectionString, CommandType.Text, strSql.ToString(), parameters)) > 0); }
public TmInfo GetTmInfo(string Number) { string strSql = "select top 1 strTrainmanName,strTrainmanNumber,strTrainmanGUID,nTrainmanState,strTrainmanJiaoluGUID from TAB_Org_Trainman where strTrainmanNumber = '" + Number + "'"; DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql).Tables[0]; if (dt.Rows.Count > 0) { TmInfo Ti = new TmInfo(); Ti.Number = ObjectConvertClass.static_ext_string(dt.Rows[0]["strTrainmanNumber"]); Ti.State = ObjectConvertClass.static_ext_int(dt.Rows[0]["nTrainmanState"]); Ti.Name = ObjectConvertClass.static_ext_string(dt.Rows[0]["strTrainmanName"]); Ti.TMID = ObjectConvertClass.static_ext_string(dt.Rows[0]["strTrainmanGUID"]); Ti.TMJLID = ObjectConvertClass.static_ext_string(dt.Rows[0]["strTrainmanJiaoluGUID"]); return(Ti); } return(null); }
/// <summary> /// 得到一个对象实体 /// </summary> public Base_TrainJiaolu DataRowToModel(DataRow dr) { Base_TrainJiaolu model = new Base_TrainJiaolu(); if (dr != null) { model.nid = ObjectConvertClass.static_ext_int(dr["nid"]); model.strTrainJiaoluGUID = ObjectConvertClass.static_ext_string(dr["strTrainJiaoluGUID"]); model.strTrainJiaoluName = ObjectConvertClass.static_ext_string(dr["strTrainJiaoluName"]); model.strStartStation = ObjectConvertClass.static_ext_string(dr["strStartStation"]); model.strEndStation = ObjectConvertClass.static_ext_string(dr["strEndStation"]); model.strWorkShopGUID = ObjectConvertClass.static_ext_string(dr["strWorkShopGUID"]); model.bIsBeginWorkFP = ObjectConvertClass.static_ext_int(dr["bIsBeginWorkFP"]); model.bIsDir = ObjectConvertClass.static_ext_int(dr["bIsDir"]); model.nWorkTimeTypeID = ObjectConvertClass.static_ext_int(dr["nWorkTimeTypeID"]); } return(model); }
public MDstepDef TostepDefList(DataRow dr) { MDstepDef model = new MDstepDef(); if (dr != null) { model.nID = ObjectConvertClass.static_ext_int(dr["nID"]); 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.nIsNecessary = ObjectConvertClass.static_ext_int(dr["nIsNecessary"]); model.strStepID = ObjectConvertClass.static_ext_string(dr["strStepID"]); model.nWorkTypeID = ObjectConvertClass.static_ext_int(dr["nWorkTypeID"]); } return(model); }
/// <summary> /// 设置属性 /// </summary> /// <param name="model"></param> /// <param name="dr"></param> /// <returns></returns> public Dic_StaffInfo SetValue(Dic_StaffInfo model, DataRow dr) { if (dr != null) { model.nID = ObjectConvertClass.static_ext_int(dr["nID"].ToString()); model.strID = dr["strID"].ToString(); model.strNumber = dr["strNumber"].ToString(); model.strName = dr["strName"].ToString(); model.strDuty = dr["strDuty"].ToString(); model.strPassword = dr["strPassword"].ToString(); model.strPictureFileName = dr["strPictureFileName"].ToString(); model.dtTokenTime = ObjectConvertClass.static_ext_Date(dr["dtTokenTime"]); model.dtLoginTime = ObjectConvertClass.static_ext_Date(dr["dtLoginTime"]); model.strTokenID = ObjectConvertClass.static_ext_string(dr["strTokenID"]); model.nRoleID = ObjectConvertClass.static_ext_int(dr["nRoleID"]); } return(model); }
public NamePlate GetNamePlate(string TmId) { string strSql = @" SELECT * FROM TAB_Nameplate_Group where strTrainmanGUID1=@strTrainmanGUID or strTrainmanGUID2=@strTrainmanGUID or strTrainmanGUID3=@strTrainmanGUID or strTrainmanGUID4=@strTrainmanGUID"; SqlParameter[] sqlparams = new SqlParameter[] { new SqlParameter("strTrainmanGUID", TmId) }; DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlparams).Tables[0]; if (dt.Rows.Count > 0) { NamePlate np = new NamePlate(); np.strGroupGUID = ObjectConvertClass.static_ext_string(dt.Rows[0]["strGroupGUID"]); np.nTXState = ObjectConvertClass.static_ext_int(dt.Rows[0]["nTXState"]); return(np); } return(null); }