public int LoginCheck(string uid, string pwd) { string sql = "select COUNT(*) from SYS_USER where USER_CODE=@uid and PASSWORD=@pwd"; SqlParameter[] pms = new SqlParameter[] { new SqlParameter("@uid", uid), new SqlParameter("@pwd", pwd) }; return((int)SqlHelper_cory.ExecuteScalar(sql, CommandType.Text, pms)); }
public SYS_MENU GetMenuByCode(string code) { string sql = "select *from sys_menu where Menu_code=@code and Menu_unit is not null"; SqlDataReader reader = SqlHelper_cory.ExecuteReader(sql, CommandType.Text, new SqlParameter("@code", code)); SYS_MENU model = new SYS_MENU(); if (reader.HasRows) { if (reader.Read()) { model.MENU_CODE = reader.GetString(reader.GetOrdinal("MENU_CODE")); model.MENU_NAME = reader.GetString(reader.GetOrdinal("MENU_NAME")); model.MENU_UNIT = reader.GetString(reader.GetOrdinal("MENU_UNIT")); model.PARENT_MENU_CODE = reader.GetString(reader.GetOrdinal("PARENT_MENU_CODE")); } } return(model); }
/// <summary> /// 根据ID返回实体 /// </summary> /// <param name="uid"></param> /// <returns></returns> public SYS_USER CheckUid(string uid) { string sql = "select * from SYS_USER where USER_CODE=@uid"; using (SqlDataReader reader = SqlHelper_cory.ExecuteReader(sql, CommandType.Text, new SqlParameter("@uid", uid))) { SYS_USER model = new SYS_USER(); if (reader.HasRows) { if (reader.Read()) { model.USER_CODE = reader.GetString(reader.GetOrdinal("USER_CODE")); model.PASSWORD = reader.GetString(reader.GetOrdinal("PASSWORD")); model.USER_NAME = reader.GetString(reader.GetOrdinal("USER_NAME")); model.STOCK_CODE = reader.GetString(reader.GetOrdinal("STOCK_CODE")); model.STOCK_NAME = reader.GetString(reader.GetOrdinal("STOCK_NAME")); model.PPRICE_SHOW = reader.GetBoolean(reader.GetOrdinal("PPRICE_SHOW")); model.DEPARTMENT_CODE = reader.GetString(reader.GetOrdinal("DEPARTMENT_CODE")); model.DEPARTMENT_NAME = reader.GetString(reader.GetOrdinal("DEPARTMENT_NAME")); } } return(model); } }
/// <summary> /// 显示所有用列表 /// </summary> /// <returns></returns> public DataTable ListAllUsers() { string sql = "select *from SYS_USer"; return(SqlHelper_cory.ExceuteDataTable(sql, CommandType.Text)); }
public DataTable LoadNavMenu(string pid) { string sql = "select Menu_code,Menu_name,menu_unit,parent_menu_code from sys_menu where parent_menu_code=@pid"; return(SqlHelper_cory.ExceuteDataTable(sql, CommandType.Text, new SqlParameter("@pid", pid))); }