/// <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);
}