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