public EditSold(DBProvider db, string tableName, string code, bool exh)
{
InitializeComponent();
this.db = db;
this.Exhibition = exh;
if (!Exhibition)
txtExhibition.Enabled = false;
else
{
txtSellDate.Enabled = false;
txtSellPrice.Enabled = false;
}
if (code == null)
{
MessageBox.Show(this, "Code is missing!", "Edit sold", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
string sExh = string.Empty;
if (Exhibition)
sExh = ", EXHIBITIONNAME";
else
sExh = ", A.SELLDATE, A.SELLPRICE";
var ds = db.ExecuteQuery(string.Format("select B.CODE, B.ITEMNAME, B.COUNTRY, B.SUPPLIER, B.LENGTH, B.WIDTH, B.VK_NETTO, B.DATE {3} from {0} A join {1} B on A.CODE = B.CODE where A.code = {2}", tableName, DBProvider.TableNames[(int)TABS.MAIN], code, sExh));
if (ds != null && ds.Tables.Count > 0)
{
var vals = ds.Tables[0].Rows[0].ItemArray;
txtCode.Text = vals[0].ToString();
txtName.Text = vals[1].ToString();
txtCountry.Text = vals[2].ToString();
txtSupplier.Text = vals[3].ToString();
txtLegnth.Text = vals[4].ToString();
txtWidth.Text = vals[5].ToString();
txtItemPrice.Text = vals[6].ToString();
txtDate.Text = vals[7].ToString();
if (Exhibition)
txtExhibition.Text = vals[8].ToString();
else
{
txtSellDate.Text = vals[8].ToString();
txtSellPrice.Text = vals[9].ToString();
}
}
}
}
public InventoryResult(DBProvider db, List<string> missingMain, List<string> missingInv)
{
InitializeComponent();
var table = new DataTable("inventory");
table.Columns.Add("Code");
missingMain.ForEach(s => table.Rows.Add(s));
gridMissingMain.DataSource = table;
var table2 = db.ExecuteQuery(DBProvider.TableNames[0], string.Format(" where code in ({0})", string.Join(",", missingInv.ToArray())), " order by code desc ").Tables[0];
gridMissingInv.DataSource = table2;
lblMissingMain.Text = lblMissingMain.Text.Replace("XXX", table.Rows.Count.ToString());
lblMissingInv.Text = lblMissingInv.Text.Replace("XXX", table2.Rows.Count.ToString());
}
public AddEditMain(DBProvider db, string tableName, string code, EditMode mode)
{
InitializeComponent();
this.mode = mode;
this.db = db;
if (code == null)
{
txtCode.Text = (db.LoadMaxCode(false) + 1).ToString();
}
else
{
var ds = db.ExecuteQuery(tableName, " where code = " + code, "");
if (ds != null && ds.Tables.Count > 0)
{
var vals = ds.Tables[0].Rows[0].ItemArray;
txtCode.Text = vals[0].ToString();
txtName.Text = vals[1].ToString();
txtCountry.Text = vals[2].ToString();
txtSupplier.Text = vals[3].ToString();
txtSupplierNr.Text = vals[4].ToString();
txtLength.Text = vals[5].ToString();
txtWidth.Text = vals[6].ToString();
txtEKNetto.Text = vals[7].ToString();
txtVKNetto.Text = vals[8].ToString();
txtQuantity.Text = vals[9].ToString();
txtQMPrice.Text = vals[10].ToString();
txtDate.Text = vals[11].ToString();
txtMVDate.Text = vals[12].ToString();
txtInvoice.Text = vals[13].ToString();
txtColor.Text = vals[14].ToString();
txtMaterial.Text = vals[15].ToString();
txtComment.Text = vals[16].ToString();
txtInfo.Text = vals[17].ToString();
txtEuroStuck.Text = vals[18].ToString();
txtPaid.Text = vals[19].ToString();
}
}
}
private string CreateDBSoldTXT()
{
DBProvider dbp = new DBProvider(Properties.Settings.Default.PtcommDir + @"\arena.db");
var data = dbp.ExecuteQuery(DBProvider.TableNames[1], " where VALID = 1 ", "");
if (data.Tables != null && data.Tables.Count == 1)
{
var res = new List<string>();
foreach (DataRow r in data.Tables[0].Rows)
{
res.Add(r[0].ToString());
res.Add(r[1].ToString());
res.Add(r[2].ToString());
}
var ret = Properties.Settings.Default.PtcommDir + @"\DBSOLD.TXT";
File.WriteAllLines(ret, res.ToArray());
return ret;
}
return null;
}