/// <summary>
/// 读取DataRow数据到Model中
/// </summary>
private void AskLeaveDetailDataRowToModel(AskLeaveDetailEntity model, DataRow dr)
{
model.strAskLeaveDetailGUID = ObjectConvertClass.static_ext_string(dr["strAskLeaveDetailGUID"]);
model.strAskLeaveGUID = ObjectConvertClass.static_ext_string(dr["strAskLeaveGUID"]);
model.strMemo = ObjectConvertClass.static_ext_string(dr["strMemo"]);
model.dtBeginTime = ObjectConvertClass.static_ext_date(dr["dBeginTime"]);
model.dtEndTime = ObjectConvertClass.static_ext_date(dr["dEndTime"]);
model.strProverID = ObjectConvertClass.static_ext_string(dr["strProverID"]);
model.strProverName = ObjectConvertClass.static_ext_string(dr["strProverName"]);
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>
/// 获得数据List
/// </summary>
public AskLeaveDetailEntity GetAskLeaveDetailDataList(string strAskLeaveGUID, out Boolean bExist)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from TAB_LeaveMgr_AskLeaveDetail where strAskLeaveGUID=@strAskLeaveGUID");
SqlParameter[] parameters =
{
new SqlParameter("strAskLeaveGUID", strAskLeaveGUID)
};
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters).Tables[0];
AskLeaveDetailEntity _AskLeaveDetailEntity = null;
if (dt.Rows.Count > 0)
{
bExist = true;
_AskLeaveDetailEntity = new AskLeaveDetailEntity();
AskLeaveDetailDataRowToModel(_AskLeaveDetailEntity, dt.Rows[0]);
}
else
{
bExist = false;
}
return(_AskLeaveDetailEntity);
}
