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> /// 读取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> /// 获得数据List /// </summary> public AskLeaveEntity GetLeavesDataListByID(string strTrainManID, out string strTypeName, out Boolean bExist) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"select * from VIEW_LeaveMgr_AskLeaveWithTypeName where strTrainManID = '" + strTrainManID + "' and nStatus < 3"); DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString()).Tables[0]; AskLeaveEntity _LeaveMgr_AskLeave = null; if (dt.Rows.Count > 0) { bExist = true; strTypeName = ObjectConvertClass.static_ext_string(dt.Rows[0]["strTypeName"]); _LeaveMgr_AskLeave = new AskLeaveEntity(); LeavesByIDDataRowToModel(_LeaveMgr_AskLeave, dt.Rows[0]); } else { strTypeName = ""; bExist = false; } return(_LeaveMgr_AskLeave); }
/// <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; }