public int InsertSYS_CCU(SYS_CCU sys_ccu) { 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_TIME, sys_ccu.Time, false)); para.Add(_DbHelper.CreateParameter(FIELD_TOTALREQUEST, sys_ccu.TotalRequest, false)); para.Add(_DbHelper.CreateParameter(FIELD_TOTALONLINE, sys_ccu.TotalOnline, false)); para.Add(_DbHelper.CreateParameter(FIELD_ONLINE, sys_ccu.Online, false)); para.Add(ouput); _DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[SYS_CCU_Insert]", para.ToArray()); return((int)ouput.Value); } catch (Exception ex) { throw new Exception(String.Format("SYS_CCUDataAccess.Insert: {0}", ex.Message)); } finally { conn.Close(); } }
public SYS_CCU SelectSYS_CCU(int ID) { SYS_CCU sys_ccu = new SYS_CCU(); 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_CCU_SelectById]", para.ToArray()); if (reader.HasRows && reader.Read()) { SYS_CCUDataAccess.SetSYS_CCUInfo(reader, ref sys_ccu); } return(sys_ccu); } catch (Exception ex) { throw new Exception(String.Format("SYS_CCUDataAccess.SelectById: {0}", ex.Message)); } finally { if (reader != null) { reader.Close(); } conn.Close(); } }
public void UpdateSYS_CCU(SYS_CCU sys_ccu) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_ccu.ID, false)); para.Add(_DbHelper.CreateParameter(FIELD_TIME, sys_ccu.Time, false)); para.Add(_DbHelper.CreateParameter(FIELD_TOTALREQUEST, sys_ccu.TotalRequest, false)); para.Add(_DbHelper.CreateParameter(FIELD_TOTALONLINE, sys_ccu.TotalOnline, false)); para.Add(_DbHelper.CreateParameter(FIELD_ONLINE, sys_ccu.Online, false)); _DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[SYS_CCU_Update]", para.ToArray()); } catch (Exception ex) { throw new Exception(String.Format("SYS_CCUDataAccess.Update: {0}", ex.Message)); } finally { conn.Close(); } }
private static void SetSYS_CCUInfo(DbDataReader reader, ref SYS_CCU sys_ccu) { sys_ccu.ID = int.Parse("0" + reader[FIELD_ID]); DateTime Time = (DateTime)reader[FIELD_TIME]; sys_ccu.Time = Time != null ? (DateTime)Time : DateTime.Now; sys_ccu.TotalRequest = int.Parse("0" + reader[FIELD_TOTALREQUEST]); sys_ccu.TotalOnline = int.Parse("0" + reader[FIELD_TOTALONLINE]); sys_ccu.Online = int.Parse("0" + reader[FIELD_ONLINE]); }
private static void SetBindingListSYS_CCUInfo(ref DbDataReader reader, ref BindingList <SYS_CCU> sys_ccus) { SYS_CCU sys_ccu = null; while (reader.Read()) { sys_ccu = new SYS_CCU(); SYS_CCUDataAccess.SetSYS_CCUInfo(reader, ref sys_ccu); sys_ccus.Add(sys_ccu); } }
public void UpdateSYS_CCU(DbTransaction transaction, SYS_CCU sys_ccu) { try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_ccu.ID, false)); para.Add(_DbHelper.CreateParameter(FIELD_TIME, sys_ccu.Time, false)); para.Add(_DbHelper.CreateParameter(FIELD_TOTALREQUEST, sys_ccu.TotalRequest, false)); para.Add(_DbHelper.CreateParameter(FIELD_TOTALONLINE, sys_ccu.TotalOnline, false)); para.Add(_DbHelper.CreateParameter(FIELD_ONLINE, sys_ccu.Online, false)); _DbHelper.ExecuteNonQuery(transaction, Common.DatabaseSchema + "[SYS_CCU_Update]", para.ToArray()); } catch (Exception ex) { throw new Exception(String.Format("SYS_CCUDataAccess.Update: {0}", ex.Message)); } }
public void DeleteSYS_CCU(SYS_CCU sys_ccus) { _sys_ccuDataAccess.DeleteSYS_CCU(sys_ccus); }
public void UpdateSYS_CCU(SYS_CCU sys_ccu) { _sys_ccuDataAccess.UpdateSYS_CCU(sys_ccu); }
public int InsertSYS_CCU(SYS_CCU sys_ccu) { return(_sys_ccuDataAccess.InsertSYS_CCU(sys_ccu)); }