bool DoUpdateSupplier(string sql, OleDbConnection con) { progressPanel1.Visible = true; try { var ds = new DataSet(); var ta = new OleDbDataAdapter(sql, con); ta.Fill(ds); var dsMaster = new DsMaster(); dsMaster.Merge(new DataManager().GetSupplierList()); int cnt = 0; foreach (DataRow dr in ds.Tables[0].Rows) { cnt++; var row = dsMaster.SUPPLIER.FindBySUPPLIERNO(dr["ACCNO"].ToString()); if (row == null) { Application.DoEvents(); var newrow = dsMaster.SUPPLIER.NewRow(); newrow["SUPPLIERNO"] = dr["ACCNO"].ToString(); newrow["SUPPLIERNAME"] = dr["ACCNAME"].ToString(); // newrow["ALTERNATENAME"] = dr["ALTERNATENAME"].ToString(); newrow["CONTACT"] = dr["CONTACT"].ToString(); newrow["ADDRESS"] = dr["ADDRESS"].ToString(); newrow["PHONE"] = dr["TEL1"].ToString(); // newrow["FAX"] = dr["FAX"].ToString(); newrow["CREDITLIMIT"] = dr["CRLMT"] ?? 0; newrow["DUEDAYS"] = dr["DDAY"] ?? 0; dsMaster.SUPPLIER.Rows.Add(newrow); } } label1.Text = cnt.ToString(); return new DataManager().UpdateSupplier(dsMaster.SUPPLIER); } catch (Exception ex) { XtraMessageBox.Show(ex.ToString(), "POS", MessageBoxButtons.OK, MessageBoxIcon.Error); } return false; }
bool DoCreateItemMast(string sql,OleDbConnection con) { progressPanel1.Visible = true; try { var ds = new DataSet(); var ta = new OleDbDataAdapter(sql, con); ta.Fill(ds); var dsMaster = new DsMaster(); dsMaster.Merge(new ItemMaster().GetItemMastList()); int cnt = 0; foreach (DataRow dr in ds.Tables[0].Rows) { cnt++; var nrow = dsMaster.ITEMMAST.FindByITEMNO(dr["DCODE"].ToString()); if (nrow == null) { Application.DoEvents(); var row = dsMaster.ITEMMAST.NewRow(); row["Itemno"] = dr["DCODE"]; row["ITEMTYPE"]=1; row["SUPPLIERNO"] = dr["ACCNO"]; row["BARCODE"] = dr["BARCD"]; row["ITEMNAME"] = dr["DNAME"]; row["GROUPID"] = int.Parse(dr["ITYPE"].ToString()); row["DISCOUNT"] = dr["STAX"] ?? 0; row["EXPDATEREQ"] = dr["EXPIRY"]; row["sPRICE"] = dr["SPRICE"]; row["CPRICE"] = dr["CPRICE"]; row["MINQTY"] = dr["MINQTY"]; row["REORDER"] = dr["MINQTY"]; row["SEL"] = 0; row["DISCONSALE"] = 0; dsMaster.ITEMMAST.Rows.Add(row); } else { nrow["SUPPLIERNO"] = dr["ACCNO"]; nrow["ITEMTYPE"] = 1; nrow["DISCOUNT"] = dr["STAX"] ?? 0; } } label1.Text = cnt.ToString(); return new ItemMaster().UpdateItems(dsMaster.ITEMMAST); } catch (Exception ex) { XtraMessageBox.Show(ex.ToString(), "POS", MessageBoxButtons.OK, MessageBoxIcon.Error); } return false; }