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);
}
