public IList GetAllPartGroupForReport() { m_cmd.CommandText = PartGroup.GetAllSQLStatic(); MySql.Data.MySqlClient.MySqlDataReader rdr = m_cmd.ExecuteReader(); IList result = PartGroup.GetAllStaticForReport(rdr); rdr.Close(); return(result); }
public static PartGroup GetPartGroupByID(MySql.Data.MySqlClient.MySqlCommand cmd, int unitID) { cmd.CommandText = PartGroup.GetByIDSQLstatic(unitID); MySql.Data.MySqlClient.MySqlDataReader aReader = cmd.ExecuteReader(); PartGroup a = PartGroup.GetPartGroup(aReader); aReader.Close(); return(a); }
public static PartGroup GetPartGroup(MySql.Data.MySqlClient.MySqlDataReader aReader) { PartGroup partgroup = null; while (aReader.Read()) { partgroup = new PartGroup(); partgroup.ID = Convert.ToInt32(aReader[0]); partgroup.CODE = aReader[1].ToString(); partgroup.NAME = aReader[2].ToString(); partgroup.MODIFIED_BY = aReader["modified_by"].ToString(); partgroup.MODIFIED_DATE = Convert.ToDateTime(aReader["modified_date"].ToString()); partgroup.MODIFIED_COMPUTER_NAME = aReader["modified_computer"].ToString(); } return(partgroup); }
public static IList GetAllStaticForReport(MySql.Data.MySqlClient.MySqlDataReader aReader) { IList result = new ArrayList(); while (aReader.Read()) { PartGroup partgroup = new PartGroup(); partgroup.ID = Convert.ToInt32(aReader[0]); //partgroup.CODE = aReader[1].ToString(); partgroup.CODE = aReader[2].ToString(); //partgroup.MODIFIED_BY = aReader["modified_by"].ToString(); //partgroup.MODIFIED_DATE = Convert.ToDateTime(aReader["modified_date"].ToString()); //partgroup.MODIFIED_COMPUTER_NAME = aReader["modified_computer"].ToString(); result.Add(partgroup); } 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 PartGroup GetPartGroup(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 = PartGroup.GetByCodeSQLStatic(code.Trim()); MySql.Data.MySqlClient.MySqlDataReader r = aCommand.ExecuteReader(); PartGroup u = PartGroup.GetPartGroup(r); r.Close(); if (u == null) { u = new PartGroup(); u.CODE = code; u.NAME = name; aCommand.CommandText = u.GetInsertSQL(); aCommand.ExecuteNonQuery(); aCommand.CommandText = u.GetMaximumIDSQL(); u.ID = Convert.ToInt32(aCommand.ExecuteScalar()); } return(u); }