public Core.Business.Department GetDepartByName(string Name) { string SqlSelectDepartmentByName = "SELECT [Id], [DepartCode],[DepartName] FROM [Department] WHERE [DepartName]=@DepartName"; SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@DepartName", SqlDbType.NVarChar, Name); SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectDepartment); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.Department department = new Core.Business.Department(); if (!reader.IsDBNull(0)) department.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) department.DepartCode = reader.GetString(1); if (!reader.IsDBNull(2)) department.DepartName = reader.GetString(2); reader.Close(); department.MarkOld(); return department; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }
public IList<Core.Business.Department> GetAllDepartment() { IList<Core.Business.Department> departmentlist = new List<Core.Business.Department>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllDepartment); if (reader != null) { while (reader.Read()) { Core.Business.Department department = new Core.Business.Department(); if (!reader.IsDBNull(0)) department.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) department.DepartCode = reader.GetString(1); if (!reader.IsDBNull(2)) department.DepartName = reader.GetString(2); department.MarkOld(); departmentlist.Add(department); } reader.Close(); } return departmentlist; }
public Core.Business.Department GetDepartmentByCode(string dcode) { Core.Business.Department department = new Core.Business.Department(); SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@DepartCode", SqlDbType.NVarChar, dcode); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetDepartmentByCode); if (reader != null) { while (reader.Read()) { if (!reader.IsDBNull(0)) department.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) department.DepartCode = reader.GetString(1); if (!reader.IsDBNull(2)) department.DepartName = reader.GetString(2); department.MarkOld(); } reader.Close(); } return department; }
public Core.Business.Department Select(string DepartCode) { if (String.IsNullOrEmpty(DepartCode)) { return null; } SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@DepartCode", SqlDbType.NVarChar, DepartCode, 30); SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectDepartmentByCode); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.Department department = new Core.Business.Department(); if (!reader.IsDBNull(0)) department.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) department.DepartCode = reader.GetString(1); if (!reader.IsDBNull(2)) department.DepartName = reader.GetString(2); reader.Close(); department.MarkOld(); return department; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }
public Core.Business.Department Select(int id) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Id", SqlDbType.Int, id); SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectDepartment); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.Department department = new Core.Business.Department(); if (!reader.IsDBNull(0)) department.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) department.DepartCode = reader.GetString(1); if (!reader.IsDBNull(2)) department.DepartName = reader.GetString(2); reader.Close(); return department; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }