private void SetAttParams(MySqlCommand cmd, OnLineUserLogPo obj) { cmd.Parameters.AddWithValue(OnLineUserLogDbo.CmdParam.USERNAME, 253).Value = obj.USERNAME; cmd.Parameters.AddWithValue(OnLineUserLogDbo.CmdParam.WS_IP, 253).Value = obj.WS_IP; cmd.Parameters.AddWithValue(OnLineUserLogDbo.CmdParam.WS_MAC, 253).Value = obj.WS_MAC; cmd.Parameters.AddWithValue(OnLineUserLogDbo.CmdParam.CREATED, 12).Value = obj.CREATED; }
public bool Insert(MySqlConnection conn, MySqlTransaction trans, OnLineUserLogPo obj) { string text = string.Concat(new string[] { "INSERT INTO ", this.TABLE_NAME, " (", this.SQL_INSERT_COLUMNS, ") VALUES (", this.SQL_INSERT_VALUES, ")" }); MySqlCommand mySqlCommand = new MySqlCommand(text, conn, trans); this.SetKeyParams(mySqlCommand, obj); this.SetAttParams(mySqlCommand, obj); bool result; try { result = (mySqlCommand.ExecuteNonQuery() > 0); } catch (MySqlException ex) { throw new Exception(ex.Message); } catch (Exception ex2) { throw new Exception(ex2.Message); } return(result); }
public bool Delete(OnLineUserLogPo obj) { string text = " DELETE FROM " + this.TABLE_NAME + this.SQL_WHERE_KEYS; MySqlConnection connection = DBOHelper.GetConnection(); DBOHelper.OpenConnection(connection); MySqlCommand mySqlCommand = new MySqlCommand(text, connection); this.SetKeyParams(mySqlCommand, obj); bool result; try { result = (mySqlCommand.ExecuteNonQuery() > 0); } catch (MySqlException ex) { throw new Exception(ex.Message); } catch (Exception ex2) { throw new Exception(ex2.Message); } finally { DBOHelper.CloseConnection(connection); } return(result); }
public bool Update(MySqlConnection conn, MySqlTransaction trans, OnLineUserLogPo obj) { string text = string.Concat(new string[] { "UPDATE ", this.TABLE_NAME, " SET ", this.SQL_UPDATE_FIELD, this.SQL_WHERE_KEYS }); MySqlCommand mySqlCommand = new MySqlCommand(text, conn, trans); this.SetKeyParams(mySqlCommand, obj); this.SetAttParams(mySqlCommand, obj); bool result; try { result = (mySqlCommand.ExecuteNonQuery() > 0); } catch (MySqlException ex) { throw new Exception(ex.Message); } catch (Exception ex2) { throw new Exception(ex2.Message); } return(result); }
public static bool DeleteObj(OnLineUserLog ou) { OnLineUserLogDbo dbo = new OnLineUserLogDbo(); OnLineUserLogPo po = new OnLineUserLogPo(); po.USERID = ou.UserId; po.USERNAME = ou.UserName; po.WS_IP = ou.WS_IP; po.WS_MAC = ou.WS_MAC; po.CREATED = ou.Created; return(dbo.Delete(po)); }
public static bool UpdateObj(OnLineUserLog ou) { OnLineUserLogDbo dbo = new OnLineUserLogDbo(); OnLineUserLogPo po = new OnLineUserLogPo(); po.USERID = ou.UserId; po.USERNAME = ou.UserName; po.WS_IP = ou.WS_IP; po.WS_MAC = ou.WS_MAC; po.CREATED = DateTime.Now; return(dbo.Update(po)); }
public bool Insert(OnLineUserLogPo obj) { MySqlConnection connection = DBOHelper.GetConnection(); DBOHelper.OpenConnection(connection); string text = string.Concat(new string[] { "INSERT INTO ", this.TABLE_NAME, " (", this.SQL_INSERT_COLUMNS, ") VALUES (", this.SQL_INSERT_VALUES, ")" }); MySqlCommand mySqlCommand = new MySqlCommand(text, connection); this.SetKeyParams(mySqlCommand, obj); this.SetAttParams(mySqlCommand, obj); bool result; try { result = (mySqlCommand.ExecuteNonQuery() > 0); } catch (MySqlException ex) { throw new Exception(ex.Message); } catch (Exception ex2) { throw new Exception(ex2.Message); } finally { DBOHelper.CloseConnection(connection); } return(result); }
public bool Delete(MySqlConnection conn, MySqlTransaction trans, OnLineUserLogPo obj) { string text = " DELETE FROM " + this.TABLE_NAME + this.SQL_WHERE_KEYS; MySqlCommand mySqlCommand = new MySqlCommand(text, conn, trans); this.SetKeyParams(mySqlCommand, obj); bool result; try { result = (mySqlCommand.ExecuteNonQuery() > 0); } catch (MySqlException ex) { throw new Exception(ex.Message); } catch (Exception ex2) { throw new Exception(ex2.Message); } return(result); }
public bool Update(OnLineUserLogPo obj) { MySqlConnection connection = DBOHelper.GetConnection(); DBOHelper.OpenConnection(connection); string text = string.Concat(new string[] { "UPDATE ", this.TABLE_NAME, " SET ", this.SQL_UPDATE_FIELD, this.SQL_WHERE_KEYS }); MySqlCommand mySqlCommand = new MySqlCommand(text, connection); this.SetKeyParams(mySqlCommand, obj); this.SetAttParams(mySqlCommand, obj); bool result; try { result = (mySqlCommand.ExecuteNonQuery() > 0); } catch (MySqlException ex) { throw new Exception(ex.Message); } catch (Exception ex2) { throw new Exception(ex2.Message); } finally { DBOHelper.CloseConnection(connection); } return(result); }
private void SetKeyParams(MySqlCommand cmd, OnLineUserLogPo obj) { cmd.Parameters.AddWithValue(OnLineUserLogDbo.CmdParam.USERID, 3).Value = obj.USERID; }