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