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