public List <SYS_Catagory> SelectListCombo(string tableName, int ID, string Connection) { SYS_ConfigConnectionDataAccess connect = new SYS_ConfigConnectionDataAccess(); DbConnection connection = _DbHelper.CreateConnection(connect.DecryptSYS_ConfigConnection(Connection)); connection.Open(); List <SYS_Catagory> SYS_Catagory = new List <SYS_Catagory>(); DbDataReader reader = null; try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_TABLENAME, tableName, false)); para.Add(_DbHelper.CreateParameter(FIELD_ID, ID, false)); reader = _DbHelper.ExecuteReader(connection, Common.DatabaseSchema + "[SYS_Catagory_SelectListCombo]", (DbParameter[])para.ToArray()); if (reader.HasRows) { SYS_CatagoryDataAccess.SetListSYS_CatagoryInfo(ref reader, ref SYS_Catagory); } } catch (Exception ex) { throw new Exception(String.Format(" SYS_CatagoryDataAccess.SelectListCombo: {0}", ex.Message)); } finally { if (reader != null) { reader.Close(); } connection.Close(); } return(SYS_Catagory); }
public List <SYS_Catagory> SelectSYS_CatagoryByIdNhanSuXa(int ID, DbConnection connection) { SYS_ConfigConnectionDataAccess connect = new SYS_ConfigConnectionDataAccess(); List <SYS_Catagory> SYS_Catagory = new List <SYS_Catagory>(); //DbConnection connection = _DbHelper.CreateConnection(Common.ConnectionString); DbDataReader reader = null; try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter("IDNhanSu", ID, false)); reader = _DbHelper.ExecuteReader(connection, Common.DatabaseSchema + "[SYS_Catagory_SelectByIdNhanSuXa]", para.ToArray()); if (reader.HasRows) { SYS_CatagoryDataAccess.SetListSYS_CatagoryInfo(ref reader, ref SYS_Catagory); } } catch (Exception ex) { throw new Exception(String.Format("SYS_CatagoryDataAccess.SelectSYS_CatagoryByIdNhanSuXáS: {0}", ex.Message)); } //finally //{ // if (reader != null) // reader.Close(); // connection.Close(); //} return(SYS_Catagory); }
public List <SYS_Organization> SelectAllSYS_Organization(string connect) { SYS_ConfigConnectionDataAccess connectionDataAccess = new SYS_ConfigConnectionDataAccess(); connect = connectionDataAccess.DecryptSYS_ConfigConnection(connect); DbConnection conn = _DbHelper.CreateConnection(connect); conn.Open(); List <SYS_Organization> sys_organization = new List <SYS_Organization>(); DbDataReader reader = null; try { reader = _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Organization_SelectAll]", (DbParameter[])null); if (reader.HasRows) { SYS_OrganizationDataAccess.SetListSYS_OrganizationInfo(ref reader, ref sys_organization); } return(sys_organization); } catch (Exception ex) { throw new Exception(String.Format(" SYS_OrganizationDataAccess.SelectAll: {0}", ex.Message)); } finally { if (reader != null) { reader.Close(); } conn.Close(); } }
public SYS_Language SelectSYS_Language(int sys_LanguageId, string connect) { SYS_ConfigConnectionDataAccess connectionDataAccess = new SYS_ConfigConnectionDataAccess(); connect = connectionDataAccess.DecryptSYS_ConfigConnection(connect); SYS_Language sys_language = new SYS_Language(); DbDataReader reader = null; DbConnection connection = _DbHelper.CreateConnection(connect); connection.Open(); try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_LanguageId, false)); reader = _DbHelper.ExecuteReader(connection, Common.DatabaseSchema + "[SYS_Language_SelectById]", para.ToArray()); if (reader.HasRows && reader.Read()) { SYS_LanguageDataAccess.SetSYS_LanguageInfo(reader, ref sys_language); } } catch (Exception ex) { throw new Exception(String.Format("SYS_LanguageDataAccess.SelectById: {0}", ex.Message)); } finally { if (reader != null) { reader.Close(); } connection.Close(); } return(sys_language); }
public List <SYS_Right> GetAllRightsByUser(SYS_User user, string connect) { List <SYS_Right> result = new List <SYS_Right>(); DbDataReader reader = null; SYS_ConfigConnectionDataAccess connectionDataAccess = new SYS_ConfigConnectionDataAccess(); connect = connectionDataAccess.DecryptSYS_ConfigConnection(connect); DbConnection dbConnection = Common.CreateConnection(connect); dbConnection.Open(); try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter("UserName", user.UserName, false)); reader = _DbHelper.ExecuteReader(dbConnection, Common.DatabaseSchema + "[SYS_ALLRight_GetByUser]", para.ToArray()); if (reader.HasRows) { while (reader.Read()) { SYS_Right temp = new SYS_Right(); SetSYS_RightInfo(reader, ref temp); temp.IsApprove = Boolean.Parse(reader[FIELD_APPROVE].ToString()); temp.IsDelete = Boolean.Parse(reader[FIELD_DELETE].ToString()); temp.IsCreate = Boolean.Parse(reader[FIELD_CREATE].ToString()); temp.IsUpdate = Boolean.Parse(reader[FIELD_UPDATE].ToString()); temp.ModuleID = int.Parse(reader[FIELD_MODULEID] + ""); result.Add(temp); } } return(result); } catch (Exception ex) { throw new Exception(String.Format("SYS_RightDataAccess.GetRightsByUser: {0}", ex.Message)); } finally { if (reader != null) { reader.Close(); } dbConnection.Close(); } }
/// <summary> /// Sử dụng cho các bảng về VTHCPD /// </summary> /// <param name="TableNotIn"></param> /// <param name="IDDonVi"></param> /// <param name="Year"></param> /// <param name="ParentID"></param> /// <param name="tableName"></param> /// <param name="Connection"></param> /// <returns></returns> public List <SYS_Catagory> SelectSYS_CatagoryByParentIDNotInTable(string TableNotIn, int IDDonVi, int IDChungLoai, int Year, string ParentID, string tableName, string Connection) { SYS_ConfigConnectionDataAccess connect = new SYS_ConfigConnectionDataAccess(); Connection = connect.DecryptSYS_ConfigConnection(Connection); DbConnection connection = _DbHelper.CreateConnection(Connection); connection.Open(); List <SYS_Catagory> SYS_Catagory = new List <SYS_Catagory>(); DbDataReader reader = null; try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_PARENTID, ParentID, false)); para.Add(_DbHelper.CreateParameter(FIELD_TABLENAME, tableName, false)); para.Add(_DbHelper.CreateParameter("TableNotIn", TableNotIn, false)); para.Add(_DbHelper.CreateParameter("IDDonVi", IDDonVi, false)); para.Add(_DbHelper.CreateParameter("DBYear", Year, false)); para.Add(_DbHelper.CreateParameter("IDChungLoai", IDChungLoai, false)); reader = _DbHelper.ExecuteReader(connection, Common.DatabaseSchema + "[SYS_Catagory_SelectByParentIdNotInTable]", para.ToArray()); if (reader.HasRows) { SYS_CatagoryDataAccess.SetListSYS_CatagoryInfo(ref reader, ref SYS_Catagory); } } catch (Exception ex) { throw new Exception(String.Format("SYS_CatagoryDataAccess.SelectByIdNotInTable: {0}", ex.Message)); } finally { if (reader != null) { reader.Close(); } connection.Close(); } return(SYS_Catagory); }
public List <SYS_Organization> SelectByCodeType(string Code) { SYS_ConfigConnectionDataAccess connectionDataAccess = new SYS_ConfigConnectionDataAccess(); DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); List <SYS_Organization> sys_organization = new List <SYS_Organization>(); DbDataReader reader = null; try { if (!string.IsNullOrEmpty(Code)) { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter("Code", Code, false)); reader = _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Organization_SelectByCodeType]", para.ToArray()); } else { reader = _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Organization_SelectByCodeType]", (DbParameter[])null); } if (reader.HasRows) { SYS_OrganizationDataAccess.SetListSYS_OrganizationInfo(ref reader, ref sys_organization); } return(sys_organization); } catch (Exception ex) { throw new Exception(String.Format(" SYS_OrganizationDataAccess.SelectByCodeType: {0}", ex.Message)); } finally { if (reader != null) { reader.Close(); } conn.Close(); } }
public SYS_UserConfig SelectByUserID_UserConfigByStrCn(string connect, int UserId) { SYS_ConfigConnectionDataAccess connectionDataAccess = new SYS_ConfigConnectionDataAccess(); connect = connectionDataAccess.DecryptSYS_ConfigConnection(connect); DbConnection conn = _DbHelper.CreateConnection(connect); conn.Open(); SYS_UserConfig userConfig = new SYS_UserConfig(); DbDataReader reader = null; List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_USERID, UserId, false)); try { reader = _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_UserConfig_SelectByUserId]", para.ToArray()); if (reader.HasRows) { while (reader.Read()) { SetSYS_UserConfigInfo(reader, ref userConfig); } } return(userConfig); } catch (Exception ex) { throw new Exception(String.Format(" SYS_UserConfigDataAccess.SYS_UserConfig_SelectByUserId: {0}", ex.Message)); } finally { if (reader != null) { reader.Close(); } conn.Close(); } }
public void DeleteSYS_Catagory(SYS_Catagory SYS_Catagory, string tableName, string Connection) { SYS_ConfigConnectionDataAccess connectionDataAccess = new SYS_ConfigConnectionDataAccess(); DbConnection connection = Common.CreateConnection(connectionDataAccess.DecryptSYS_ConfigConnection(Connection)); connection.Open(); try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_ID, SYS_Catagory.ID, false)); para.Add(_DbHelper.CreateParameter(FIELD_TABLENAME, tableName, false)); _DbHelper.ExecuteNonQuery(connection, Common.DatabaseSchema + "[SYS_Catagory_Delete]", para.ToArray()); } catch (Exception ex) { throw new Exception(String.Format("SYS_CatagoryDataAccess.DeleteSYS_Catagory: {0}", ex.Message)); } finally { connection.Close(); } }
public SYS_Catagory SelectSYS_CatagoryByName(string Name, string tableName) { SYS_ConfigConnectionDataAccess connect = new SYS_ConfigConnectionDataAccess(); DbConnection connection = _DbHelper.CreateConnection(Common.ConnectionString); connection.Open(); SYS_Catagory SYS_Catagory = new SYS_Catagory(); DbDataReader reader = null; try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_NAME, Name, false)); para.Add(_DbHelper.CreateParameter(FIELD_TABLENAME, tableName, false)); reader = _DbHelper.ExecuteReader(connection, Common.DatabaseSchema + "[SYS_Catagory_SelectByName]", para.ToArray()); if (reader.HasRows && reader.Read()) { SYS_CatagoryDataAccess.SetSYS_CatagoryInfo(reader, ref SYS_Catagory); } } catch (Exception ex) { throw new Exception(String.Format("SYS_CatagoryDataAccess.SelectById: {0}", ex.Message)); } finally { if (reader != null) { reader.Close(); } connection.Close(); } return(SYS_Catagory); }
public List <SYS_Organization> SelectAllSYS_Organization_GetByUserID(int ID, string connect) { SYS_ConfigConnectionDataAccess connectionDataAccess = new SYS_ConfigConnectionDataAccess(); connect = connectionDataAccess.DecryptSYS_ConfigConnection(connect); DbConnection conn = _DbHelper.CreateConnection(connect); conn.Open(); List <SYS_Organization> sys_organization = new List <SYS_Organization>(); DbDataReader reader = null; try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_ID, ID, false)); reader = _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Organization_GetByUserID]", para.ToArray()); if (reader.HasRows) { SYS_OrganizationDataAccess.SetListSYS_OrganizationInfo(ref reader, ref sys_organization); } return(sys_organization); } catch (Exception ex) { throw new Exception(String.Format("SYS_OrganizationDataAccess.SelectByUserId: {0}", ex.Message)); } finally { if (reader != null) { reader.Close(); } conn.Close(); } }