public int InsertSYS_ColumnCategory(SYS_ColumnCategory sys_columncategory) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true); para.Add(_DbHelper.CreateParameter(FIELD_COLUMNNAME, sys_columncategory.ColumnName, false)); para.Add(_DbHelper.CreateParameter(FIELD_DISPLAYNAME, sys_columncategory.DisplayName, false)); para.Add(_DbHelper.CreateParameter(FIELD_IDCATEGORYMANAGER, sys_columncategory.IDCategoryManager, false)); para.Add(_DbHelper.CreateParameter(FIELD_ALLOWNULL, sys_columncategory.AllowNull, false)); para.Add(_DbHelper.CreateParameter(FIELD_DATATYPE, sys_columncategory.DataType, false)); para.Add(ouput); _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_ColumnCategory_Insert]", para.ToArray()); return((int)ouput.Value); } catch (Exception ex) { throw new Exception(String.Format("SYS_ColumnCategoryDataAccess.Insert: {0}", ex.Message)); } finally { conn.Close(); } }
public SYS_ColumnCategory SelectSYS_ColumnCategory(int ID) { SYS_ColumnCategory sys_columncategory = new SYS_ColumnCategory(); DbDataReader reader = null; DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_ID, ID, false)); reader = _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_ColumnCategory_SelectById]", para.ToArray()); if (reader.HasRows && reader.Read()) { SYS_ColumnCategoryDataAccess.SetSYS_ColumnCategoryInfo(reader, ref sys_columncategory); } return(sys_columncategory); } catch (Exception ex) { throw new Exception(String.Format("SYS_ColumnCategoryDataAccess.SelectById: {0}", ex.Message)); } finally { if (reader != null) { reader.Close(); } conn.Close(); } }
private static void SetSYS_ColumnCategoryInfo(DbDataReader reader, ref SYS_ColumnCategory sys_columncategory) { sys_columncategory.ID = int.Parse("0" + reader[FIELD_ID]); sys_columncategory.ColumnName = "" + reader[FIELD_COLUMNNAME]; sys_columncategory.DisplayName = "" + reader[FIELD_DISPLAYNAME]; sys_columncategory.IDCategoryManager = int.Parse("0" + reader[FIELD_IDCATEGORYMANAGER]); sys_columncategory.DataType = "" + reader[FIELD_DATATYPE]; sys_columncategory.AllowNull = Boolean.Parse("" + reader[FIELD_ALLOWNULL]); }
private static void SetListSYS_ColumnCategoryInfo(ref DbDataReader reader, ref List <SYS_ColumnCategory> sys_columncategorys) { SYS_ColumnCategory sys_columncategory = null; while (reader.Read()) { sys_columncategory = new SYS_ColumnCategory(); SYS_ColumnCategoryDataAccess.SetSYS_ColumnCategoryInfo(reader, ref sys_columncategory); sys_columncategorys.Add(sys_columncategory); } }
public void UpdateSYS_ColumnCategory(DbTransaction transaction, SYS_ColumnCategory sys_columncategory) { try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_columncategory.ID, false)); para.Add(_DbHelper.CreateParameter(FIELD_COLUMNNAME, sys_columncategory.ColumnName, false)); para.Add(_DbHelper.CreateParameter(FIELD_DISPLAYNAME, sys_columncategory.DisplayName, false)); para.Add(_DbHelper.CreateParameter(FIELD_IDCATEGORYMANAGER, sys_columncategory.IDCategoryManager, false)); para.Add(_DbHelper.CreateParameter(FIELD_ALLOWNULL, sys_columncategory.AllowNull, false)); para.Add(_DbHelper.CreateParameter(FIELD_DATATYPE, sys_columncategory.DataType, false)); _DbHelper.ExecuteNonQuery(transaction, Common.DatabaseSchema + "[SYS_ColumnCategory_Update]", para.ToArray()); } catch (Exception ex) { throw new Exception(String.Format("SYS_ColumnCategoryDataAccess.Update: {0}", ex.Message)); } }
public void DeleteSYS_ColumnCategory(SYS_ColumnCategory sys_columncategory) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_columncategory.ID, false)); _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_ColumnCategory_Delete]", para.ToArray()); } catch (Exception) { throw; } finally { conn.Close(); } }
public void DeleteSYS_ColumnCategory(SYS_ColumnCategory sys_columncategorys) { _sys_columncategoryDataAccess.DeleteSYS_ColumnCategory(sys_columncategorys); }
public void UpdateSYS_ColumnCategory(SYS_ColumnCategory sys_columncategory) { _sys_columncategoryDataAccess.UpdateSYS_ColumnCategory(sys_columncategory); }
public int InsertSYS_ColumnCategory(SYS_ColumnCategory sys_columncategory) { return(_sys_columncategoryDataAccess.InsertSYS_ColumnCategory(sys_columncategory)); }