public AskLeaveWithType GetLastLeaveInfo(string strTrainmanID) { AskLeaveWithType ret = new AskLeaveWithType(); string sql = "select top 1 * from VIEW_LeaveMgr_AskLeaveWithTypeName where strTrainmanID = @strTrainmanID order by dBeginTime desc"; DbParamDict dbParamDict = new DbParamDict(); dbParamDict.Add("strTrainmanID", strTrainmanID, ParamDataType.dtString); DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, sql, dbParamDict.GetParams()).Tables[0]; if (dt.Rows.Count > 0) { DataRow dr; dr = dt.Rows[0]; ret.strTypeName = ObjectConvertClass.static_ext_string(dr["strTypeName"]); AskLeaveEntity AskLeave = new AskLeaveEntity(); AskLeave.strAskLeaveGUID = ObjectConvertClass.static_ext_string(dr["strAskLeaveGUID"]); AskLeave.strTrainManID = ObjectConvertClass.static_ext_string(dr["strTrainManID"]); AskLeave.dtBeginTime = ObjectConvertClass.static_ext_date(dr["dBeginTime"]); AskLeave.dtEndTime = ObjectConvertClass.static_ext_date(dr["dEndTime"]); AskLeave.nStatus = ObjectConvertClass.static_ext_int(dr["nStatus"]); ret.AskLeave = AskLeave; return(ret); } else { return(null); } }
/// <summary> /// 获得数据List /// </summary> public AskLeaveWithTypeArray GetLeavesDataList(LeaveMgr_AskLeaveQueryCondition QueryCondition) { SqlParameter[] sqlParams; StringBuilder strSqlOption = new StringBuilder(); QueryCondition.OutPut(out strSqlOption, out sqlParams); StringBuilder strSql = new StringBuilder(); strSql.Append(@"select A.*,B.strTrainmanName,B.nPostID,D.strGuideGroupName,C.strProverID strAskProverID, C.strProverName strAskProverName,C.strDutyUserName strAskDutyUserName, C.dCreateTime dtAskCreateTime,C.strMemo strMemo from VIEW_LeaveMgr_AskLeaveWithTypeName A left join TAB_Org_Trainman B on A.strTrainmanID=B.strTrainmanNumber left join TAB_LeaveMgr_AskLeaveDetail C on A.strAskLeaveGUID=C.strAskLeaveGUID left join TAB_Org_GuideGroup D on B.strGuideGroupGUID=D.strGuideGroupGUID"); strSql.Append(" where 1=1 " + strSqlOption.ToString() + " order by A.dBeginTime desc"); DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0]; AskLeaveWithTypeArray list = new AskLeaveWithTypeArray(); foreach (DataRow dr in dt.Rows) { AskLeaveWithType _LeaveMgr_AskLeave = new AskLeaveWithType(); LeavesDataRowToModel(_LeaveMgr_AskLeave, dr); list.Add(_LeaveMgr_AskLeave); } return(list); }
/// <summary> /// 读取DataRow数据到Model中 /// </summary> private void LeavesDataRowToModel(AskLeaveWithType model, DataRow dr) { model.strTypeName = ObjectConvertClass.static_ext_string(dr["strTypeName"]); AskLeaveEntity AskLeave = new AskLeaveEntity(); AskLeave.strAskLeaveGUID = ObjectConvertClass.static_ext_string(dr["strAskLeaveGUID"]); AskLeave.strTrainManID = ObjectConvertClass.static_ext_string(dr["strTrainManID"]); AskLeave.strTrainmanName = ObjectConvertClass.static_ext_string(dr["strTrainmanName"]); AskLeave.dtBeginTime = ObjectConvertClass.static_ext_date(dr["dBeginTime"]); AskLeave.dtEndTime = ObjectConvertClass.static_ext_date(dr["dEndTime"]); AskLeave.strLeaveTypeGUID = ObjectConvertClass.static_ext_string(dr["strLeaveTypeGUID"]); AskLeave.nStatus = ObjectConvertClass.static_ext_int(dr["nStatus"]); AskLeave.strAskProverID = ObjectConvertClass.static_ext_string(dr["strAskProverID"]); AskLeave.strAskProverName = ObjectConvertClass.static_ext_string(dr["strAskProverName"]); AskLeave.dtAskCreateTime = ObjectConvertClass.static_ext_date(dr["dtAskCreateTime"]); AskLeave.strAskDutyUserName = ObjectConvertClass.static_ext_string(dr["strAskDutyUserName"]); AskLeave.strMemo = ObjectConvertClass.static_ext_string(dr["strMemo"]); AskLeave.nPostID = ObjectConvertClass.static_ext_int(dr["nPostID"]); AskLeave.strGuideGroupName = ObjectConvertClass.static_ext_string(dr["strGuideGroupName"]); model.AskLeave = AskLeave; }