public static PartCategory GetPartCategory(MySql.Data.MySqlClient.MySqlDataReader aReader) { PartCategory prtCat = null; while (aReader.Read()) { prtCat = new PartCategory(); prtCat.ID = Convert.ToInt32(aReader[0]); prtCat.CODE = aReader[1].ToString(); prtCat.NAME = aReader[2].ToString(); prtCat.MODIFIED_BY = aReader["modified_by"].ToString(); prtCat.MODIFIED_DATE = Convert.ToDateTime(aReader["modified_date"].ToString()); prtCat.MODIFIED_COMPUTER_NAME = aReader["modified_computer"].ToString(); } return(prtCat); }
public IList GetAll(MySql.Data.MySqlClient.MySqlDataReader aReader) { IList result = new ArrayList(); while (aReader.Read()) { PartCategory prtCat = new PartCategory(); prtCat.ID = Convert.ToInt32(aReader[0]); prtCat.CODE = aReader[1].ToString(); prtCat.NAME = aReader[2].ToString(); prtCat.MODIFIED_BY = aReader["modified_by"].ToString(); prtCat.MODIFIED_DATE = Convert.ToDateTime(aReader["modified_date"].ToString()); prtCat.MODIFIED_COMPUTER_NAME = aReader["modified_computer"].ToString(); result.Add(prtCat); } return(result); }
public void Import(string s) { OpenConnection(); MySql.Data.MySqlClient.MySqlCommand aCommand = new MySql.Data.MySqlClient.MySqlCommand(); aCommand.Connection = m_connection; MySql.Data.MySqlClient.MySqlTransaction trc = m_connection.BeginTransaction(); aCommand.Transaction = trc; try { string[] p = s.Split(','); aCommand.CommandText = Part.GetByCodeSQLStatic(p[0]); MySql.Data.MySqlClient.MySqlDataReader re = aCommand.ExecuteReader(); Part fpart = Part.GetPart(re); re.Close(); if (fpart != null) { trc.Rollback(); return; } Unit u = GetUnit(aCommand, p[3], p[4]); PartGroup pg = GetPartGroup(aCommand, p[5], p[6]); Currency ccy = GetCurrency(aCommand, p[7], p[8]); PartCategory pc = GetPartCategory(aCommand, p[9], "KECIL"); Part part = new Part(); part.CODE = p[0]; part.NAME = p[1]; part.BARCODE = p[2]; part.UNIT = u; part.PART_GROUP = pg; part.CURRENCY = ccy; part.PART_CATEGORY = pc; aCommand.CommandText = part.GetInsertSQL(); aCommand.ExecuteNonQuery(); trc.Commit(); } catch (Exception x) { trc.Rollback(); throw x; } }
private PartCategory GetPartCategory(MySql.Data.MySqlClient.MySqlCommand aCommand, string code, string name) { //MySql.Data.MySqlClient.MySqlCommand aCommand = new MySql.Data.MySqlClient.MySqlCommand(); aCommand.Connection = m_connection; aCommand.CommandText = PartCategory.GetByCodeSQLStatic(code.Trim()); MySql.Data.MySqlClient.MySqlDataReader r = aCommand.ExecuteReader(); PartCategory u = PartCategory.GetPartCategory(r); r.Close(); if (u == null) { u = new PartCategory(); u.CODE = code; u.NAME = name; aCommand.CommandText = u.GetInsertSQL(); aCommand.ExecuteNonQuery(); aCommand.CommandText = u.GetMaximumIDSQL(); u.ID = Convert.ToInt32(aCommand.ExecuteScalar()); } return(u); }