//public override void getDataFromDB() { }
public supplier(connector _cn, string _name, string _ogrn, string _inn, string _tel = "", string _email = "")
{
setName(_name);
setOGRN(_ogrn);
setINN(_inn);
setTel(_tel);
setEmail(_email);
cn = _cn;
SQL = new MySqlDb(cn);
}
public result create()
{
if (id != 0)
{
return(new result(100, "Поставщик уже занесен"));
}
sql = "INSERT INTO suppliers (id,name,ogrn,inn,tel,email) VALUES (null,@name, @ogrn, @inn, @tel ,@email)" + Form1.GET_ID;
SQL = new MySqlDb(cn);
SQL.clearParam();
SQL.addParam("@name", name);
SQL.addParam("@ogrn", ogrn);
SQL.addParam("@inn", inn);
SQL.addParam("@tel", tel);
SQL.addParam("@email", email);
result res = new result();
id = (SQL.ExecuteScalar(sql));
return(new result());
}
public SaleStatistic(connector _cn)
{
cn = _cn;
SQL = new MySqlDb(cn);
}
public result testConnection()
{
MySqlDb mb = new MySqlDb(this);
return(mb.testConnection(this));
}
// Класс для формирования отчетов
public GoodStatistic(connector cn)
{
SQL = new MySqlDb(cn);
}
public ordersList(connector cn)
{
SQL = new MySqlDb(cn);
}
public SupplyStat(connector cnn)
{
SQL = new MySqlDb(cnn);
cn = cnn;
}
public supplier(connector cn)
{
SQL = new MySqlDb(cn);
}
//DataTable dt;
public cat(connector cn)
{
SQL = new MySqlDb(cn);
sql = "SELECT `category_id` 'id',`name_ru-RU`'name' FROM `ishp_jshopping_categories`";
}
public elementSupply(connector cn)
{
SQL = new MySqlDb(cn);
}
public SimpleSQLQuery(connector cn)
{
SQL = new MySqlDb(cn);
}
