public static BurnAddress GetBurnAddressNew(int custId, string burnAddressRef, string tag) { BurnAddress address = new BurnAddress(); MySqlConnection conn = new MySqlConnection(constr); try { conn.Open(); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "update `goraven`.`burn_address` na inner join(select min(`BurnAddressId`) as BurnAddressId from `goraven`.`burn_address` where `CustId` is null) mn on na.`BurnAddressId` = mn.`BurnAddressId` set na.`CustId`= " + custId.ToString() + ", na.`BurnAddressRef`= '" + burnAddressRef + "', na.`Tag`= '" + tag + "', na.`UpdateDateTime` = now()"; cmd.ExecuteNonQuery(); MySqlCommand cmd2 = conn.CreateCommand(); cmd2.CommandText = "select * from `goraven`.`burn_address` where `CustId` = " + custId.ToString() + " order by BurnAddressId desc limit 1;"; MySqlDataReader reader = cmd2.ExecuteReader(); while (reader.Read()) { address.burnAddress = reader.GetString("BurnAddress"); address.custId = Convert.ToInt32(reader.GetString("CustId")); if (!reader.IsDBNull(3)) { address.burnAddressRef = reader.GetString("BurnAddressRef"); } if (!reader.IsDBNull(4)) { address.burnAddressTag = reader.GetString("Tag"); } if (!reader.IsDBNull(5)) { address.updateDateTime = Convert.ToDateTime(reader.GetString("UpdateDateTime")); } if (!reader.IsDBNull(6)) { address.createDateTime = Convert.ToDateTime(reader.GetString("CreateDateTime")); } } reader.Close(); reader.Dispose(); } catch (Exception ex) { return(null); } finally { conn.Close(); conn.Dispose(); } return(address); }
public static List <BurnAddress> GetBurnAddressList(int custId) { List <BurnAddress> burnAddressList = new List <BurnAddress>(); MySqlConnection conn = new MySqlConnection(constr); conn.Open(); try { MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "select * from `goraven`.`burn_address` where `CustId` = " + custId.ToString() + " or `CustId` in (select `parentCustId` from `goraven`.`cust` where `CustId`= " + custId.ToString() + ");"; MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { BurnAddress address = new BurnAddress(); address.burnAddress = reader.GetString("BurnAddress"); address.custId = Convert.ToInt32(reader.GetString("CustId")); if (!reader.IsDBNull(3)) { address.burnAddressRef = reader.GetString("BurnAddressRef"); } if (!reader.IsDBNull(4)) { address.burnAddressTag = reader.GetString("Tag"); } if (!reader.IsDBNull(5)) { address.updateDateTime = Convert.ToDateTime(reader.GetString("UpdateDateTime")); } if (!reader.IsDBNull(6)) { address.createDateTime = Convert.ToDateTime(reader.GetString("CreateDateTime")); } burnAddressList.Add(address); } reader.Close(); reader.Dispose(); } catch (Exception ex) { //burnAddress = ex.ToString(); } finally { conn.Close(); conn.Dispose(); } return(burnAddressList); }
public static BurnAddress GetBurnAddressByRef(int custId, string burnAddressRef) { BurnAddress address = new BurnAddress(); MySqlConnection conn = new MySqlConnection(constr); conn.Open(); try { MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "select * from `goraven`.`burn_address` where `BurnAddressRef` = '" + burnAddressRef + "' and (`CustId` = " + custId.ToString() + " or `CustId` in (select `parentCustId` from `goraven`.`cust` where `CustId`= " + custId.ToString() + ")) limit 1;"; //cmd.CommandText = "select * from `goraven`.`burn_address` where `CustId` = " + custId.ToString() + " and `BurnAddressRef` = '" + burnAddressRef + "' limit 1;"; MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { address.burnAddress = reader.GetString("BurnAddress"); address.custId = Convert.ToInt32(reader.GetString("CustId")); if (!reader.IsDBNull(3)) { address.burnAddressRef = reader.GetString("BurnAddressRef"); } if (!reader.IsDBNull(4)) { address.burnAddressTag = reader.GetString("Tag"); } if (!reader.IsDBNull(5)) { address.updateDateTime = Convert.ToDateTime(reader.GetString("UpdateDateTime")); } if (!reader.IsDBNull(6)) { address.createDateTime = Convert.ToDateTime(reader.GetString("CreateDateTime")); } } reader.Close(); reader.Dispose(); } catch (Exception ex) { } finally { conn.Close(); conn.Dispose(); } return(address); }