/// <summary> /// 读取DataRow数据到Model中 /// </summary> private void DutyUserDataRowToModel(RsDutyUser model, DataRow dr) { model.strDutyGUID = ObjectConvertClass.static_ext_string(dr["strDutyGUID"]); model.strDutyNumber = ObjectConvertClass.static_ext_string(dr["strDutyNumber"]); model.strDutyName = ObjectConvertClass.static_ext_string(dr["strDutyName"]); model.strPassword = ObjectConvertClass.static_ext_string(dr["strPassword"]); }
/// <summary> /// 根据用户名获取登录人员信息 /// </summary> /// <param name="strDutyNumber">工号</param> /// <param name="bExist">返回参数,是否存在</param> /// <returns></returns> public RsDutyUser GetDutyUserByNumber(string strDutyNumber, out Boolean bExist) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from TAB_Org_DutyUser where strDutyNumber = @strDutyNumber"); SqlParameter[] sqlParams = { new SqlParameter("strDutyNumber", strDutyNumber) }; DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0]; RsDutyUser _Org_DutyUser = null; if (dt.Rows.Count > 0) { bExist = true; _Org_DutyUser = new RsDutyUser(); DutyUserDataRowToModel(_Org_DutyUser, dt.Rows[0]); } else { bExist = false; } return(_Org_DutyUser); }