public DsMaster.PAYTYPEMASTDataTable GetPaymentTypes()
{
var ta = new PAYTYPEMASTTableAdapter { Connection = { ConnectionString = _constr } };
var ds = new DsMaster().PAYTYPEMAST;
ta.Fill(ds);
return ds;
}
// public DsMaster.STOREMASTRow StoremastRow;
public string DoSave()
{
string retval="0";
SqlTransaction tran = null;
var isnew = false;
try
{
var cn = new SqlConnection {ConnectionString = _constr};
cn.Open();
tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted);
var dt = new DsMaster().STOREMAST;
var ta = new DsMasterTableAdapters.STOREMASTTableAdapter();
ta.Connection.ConnectionString = _constr;
ta.Fill(dt);
ta.AssignConnection(cn, tran);
var dr = dt.FindBySTORECODE(storecode);
if (dr != null)
{
dr.BeginEdit();
dr.EditedBy = Utils.Userid;
}
else
{
dr = (DsMaster.STOREMASTRow) dt.NewRow();
isnew = true;
var autoid = new DataManager().GetAutoId(9);
autoid++;
storecode = String.Format("{0,-2:D2}", autoid);
dr.CREATEDBY = Utils.Userid;
dr.CREATEDATE = System.DateTime.Now.Date;
}
dr.STORECODE = storecode;
dr.STORETYPE = storetype;
dr.STORENAME = storename;
dr.ADDRESSS = address;
dr.PHONENO = phono;
dr.FAXNO = fax;
dr.COMM = communicationtype;
dr.COMPANY = COMPANY;
if (isnew)
{
dt.Rows.Add(dr);
ta.Update(dt);
}
else
{
dr.EndEdit();
ta.Update(dt);
}
new DataManager().UpdateAutoNum(9);
tran.Commit();
retval = "1";
}
catch (Exception ex)
{
retval = ex.ToString();
if (tran != null) tran.Rollback();
}
return retval;
}
public DsMaster GetBom()
{
var ta = new BOMMASTTableAdapter {Connection = {ConnectionString = _constr}};
var catds = new DsMaster();
ta.Fill(catds.BOMMAST);
return catds;
}
public DsMaster GetItemType()
{
var ta = new ITEMTYPETableAdapter {Connection = {ConnectionString = _constr}};
var catds = new DsMaster();
ta.Fill(catds.ITEMTYPE);
return catds;
}
public DsMaster.STOREMASTDataTable GetStores()
{
var ta = new STOREMASTTableAdapter {Connection = {ConnectionString = _constr}};
var storeds = new DsMaster();
ta.Fill(storeds.STOREMAST);
return storeds.STOREMAST;
}
public DsMaster.WAREHOUSEMASTDataTable GetWareHouse()
{
var ta = new WAREHOUSEMASTTableAdapter {Connection = {ConnectionString = _constr}};
var ds = new DsMaster();
ta.Fill(ds.WAREHOUSEMAST);
return ds.WAREHOUSEMAST;
}
public DsMaster.TEMPBCODEPRINTDataTable CreateBarCodeTable(string purno)
{
var dt = new DsMaster().TEMPBCODEPRINT;
var dm = new PurInvDataManager();
Purinvdetail = dm.GetPurInvDetailsById(purno);
foreach (DataRow dr in Purinvdetail.Rows)
{
var dnew = dt.NewRow();
dnew["ITEMCODE"] = dr["itemno"];
dnew["ITEMNAME"] = new BlItemMaster().GetItemname(dr["itemno"].ToString());
var _qty = int.Parse(dr["qty"].ToString()) + (string.IsNullOrEmpty(dr["BONUSQTY"].ToString()) ? 0 : int.Parse(dr["BONUSQTY"].ToString()));
dnew["QTY"] = _qty;
dnew["PRICE"] = dr["SPRICE"];
dt.Rows.Add(dnew);
}
return dt;
}
public DsMaster.ITEMMASTDataTable GetItemMastList()
{
var ta = new DsMasterTableAdapters.ITEMMASTTableAdapter {Connection = {ConnectionString = _constr}};
var ds = new DsMaster().ITEMMAST;
ta.Fill(ds);
return ds;
}
public bool SaveItemGenric(DsMaster genric)
{
bool saved = false;
if (genric.HasChanges() && !genric.CATEGORY.HasErrors)
{
var manager = new DsMasterTableAdapters.TableAdapterManager
{
Connection = {ConnectionString = _constr},
GENERICMASTTableAdapter = new GENERICMASTTableAdapter(),
BackupDataSetBeforeUpdate = true
};
saved = manager.UpdateAll(genric) > 0;
}
return saved;
}
public string DoSave()
{
string retval=string.Empty;
SqlTransaction tran = null;
var isnew = false;
try
{
var cn = new SqlConnection {ConnectionString = _constr};
cn.Open();
tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted);
var dt = new DsMaster().CUSTOMER;
var ta = new DsMasterTableAdapters.CUSTOMERTableAdapter {Connection = {ConnectionString = _constr}};
ta.Fill(dt);
ta.AssignConnection(cn, tran);
var tains = new DsMasterTableAdapters.INSURANCEDISCTableAdapter
{Connection = {ConnectionString = _constr}};
tains.AssignConnection(cn, tran);
var dr = dt.FindByCUSTNO(customerRow.CUSTNO);
if (dr != null)
{
dr.BeginEdit();
Utils.CustomerNo = customerRow.CUSTNO;
dr.EUSERID = Utils.Userid;
dr.EDATE = DateTime.Now.Date;
}
else
{
dr = (DsMaster.CUSTOMERRow) dt.NewRow();
isnew = true;
var autoid = new DataManager().GetAutoId(13);
autoid++;
Utils.CustomerNo = new DataManager().CreateFormatedAutoNo(autoid);
dr.CUSTNO = Utils.CustomerNo;
dr.CUSERID = Utils.Userid;
dr.CDATE = DateTime.Now.Date;
}
dr.CUSTOMERTYPE = customerRow.CUSTOMERTYPE;
dr.CUSTOMERNAME = customerRow.CUSTOMERNAME;
dr.CUSTCOMP = customerRow.CUSTCOMP;
dr.CUSTOMERID = customerRow.CUSTOMERID;
dr.PHONE = customerRow.PHONE;
dr.Mobile = customerRow.Mobile;
dr.EMAIL = customerRow.EMAIL;
dr.NOTE = customerRow.NOTE;
dr.FIXDISC = customerRow.FIXDISC;
dr.FIXDISCAMTPER = customerRow.FIXDISCAMTPER;
dr.CREDITLIMIT = customerRow.CREDITLIMIT;
dr.COMPANY = Utils.Company;
dr.PAYTYPE = customerRow.PAYTYPE;
dr.MEMBERNO = customerRow.MEMBERNO;
if (isnew)
{
dt.Rows.Add(dr);
ta.Update(dt);
}
else
{
dr.EndEdit();
ta.Update(dt);
}
if (insurancediscDataTable != null)
{
foreach (DsMaster.INSURANCEDISCRow di in insurancediscDataTable.Rows)
{
di.CUSTNO = Utils.CustomerNo;
}
tains.Update(insurancediscDataTable);
}
tran.Commit();
new DataManager().UpdateAutoNum(13);
retval = "1";
}
catch (Exception ex)
{
retval = ex.ToString();
if (tran != null) tran.Rollback();
}
return retval;
}
public DsMaster.STOREMASTDataTable GetMyWareHouses()
{
var dt = new DsMaster().STOREMAST;
var ta = new DsMasterTableAdapters.STOREMASTTableAdapter { Connection = { ConnectionString = _constr } };
ta.FillByMyWareHouse(dt,Utils.Company);
return dt;
}
public DsMaster.ITEMMASTDataTable FindItemByBarCode(string barcode)
{
var ta = new DsMasterTableAdapters.ITEMMASTTableAdapter {Connection = {ConnectionString = _constr}};
var ds = new DsMaster().ITEMMAST;
ta.FillByBarCode(ds, barcode);
return ds;
}
public DsMaster.DISCOUNTNAMESDataTable GetDiscountNames()
{
var ta = new DISCOUNTNAMESTableAdapter { Connection = { ConnectionString = _constr } };
var ds = new DsMaster().DISCOUNTNAMES;
ta.Fill(ds);
return ds;
}
private void simpleButton3_Click(object sender, EventArgs e)
{
bool isvalid = false;
if (txtfno.EditValue== null)
{
txtfno.ErrorText = "Enter File No";
isvalid = true;
}
if (txtmemno.EditValue == null)
{
txtmemno.ErrorText = "Enter Member No";
isvalid = true;
}
if (txtcompname.EditValue == null)
{
txtcompname.ErrorText = "Enter Company name";
isvalid = true;
}
if (txtname.EditValue == null)
{
txtname.ErrorText = "Enter Patient name";
isvalid = true;
}
if (!isvalid )
{
var bl = new BlInsuranceCustomer();
var tb = new DsMaster().INSCUSTOMERS;
var dr = (DsMaster.INSCUSTOMERSRow) tb.NewRow();
dr.TID = Tid;
dr.FILENO = txtfno.Text;
dr.POLICYNO =int.Parse(txtmemno.EditValue.ToString());
dr.CUSTNO = txtcompname.Text;
dr.PATNAME = txtname.Text;
bl.dr = dr;
var msg = bl.DoSave();
if (msg == "1")
{
if (
XtraMessageBox.Show("Saved do you want to add more", "Patient Details", MessageBoxButtons.YesNo) ==
DialogResult.Yes)
{
Tid = 0;
txtfno.Text = string.Empty;
txtfno.Text = string.Empty;
txtmemno.Text = string.Empty;
txtcompname.Text = string.Empty;
txtname.Text = string.Empty;
}
else
{
Custno = txtname.Text;
Custpayment = cutomerpayment.EditValue.ToString();
Close();
}
}
else
{
XtraMessageBox.Show(msg, "Patient Details", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
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;
}
public bool SaveCategory(DsMaster itemCat)
{
bool saved = false;
if (itemCat.HasChanges() && !itemCat.CATEGORY.HasErrors)
{
var manager = new DsMasterTableAdapters.TableAdapterManager
{
Connection = {ConnectionString = _constr},
BackupDataSetBeforeUpdate = true,
CATEGORYTableAdapter = new CATEGORYTableAdapter()
};
saved = manager.UpdateAll(itemCat) > 0;
}
return saved;
}
public string DoUpLoadItems(string purid,bool ispurchase)
{
string retval = "1";
var taItem = new DsMasterTableAdapters.ITEMMASTTableAdapter();
var ds = new DsMaster().ITEMMAST;
taItem.Connection.ConnectionString = _constr;
// taItem.FillByBarCode()
DataTable dtitems = null;
dtitems = ispurchase ? new PurInvDataManager().GetItemMasterInPurchase(purid) : new PurInvDataManager().GetITEMsInTransfer(purid);
string itemnos = dtitems.Rows.Cast<DataRow>().Aggregate("", (current, dr) => current + (dr["ITEMNO"].ToString() + ","));
// taItem.FillByItemnos(ds, itemnos);
bool isnew = false;
foreach (DataRow dr in dtitems.Rows)
{
bool update = true;
taItem.FillByITEMNO(ds, dr["ITEMNO"].ToString());
var dsup = ds.FindByITEMNO(dr["ITEMNO"].ToString());
if (dsup != null)
{
isnew = false;
dsup.BeginEdit();
update = Equals(dr, dsup);
}
else
{
dsup = (DsMaster.ITEMMASTRow)ds.NewRow();
isnew = true;
}
if (!update)
{
foreach (DataColumn dc in dtitems.Columns)
{
if (!dc.ReadOnly)
dsup[dc.ColumnName] = dr[dc.ColumnName];
}
}
if (isnew)
{
ds.Rows.Add(dr.ItemArray);
var t = taItem.Update(ds);
if (t == 0)
retval += "item mast not created";
}
else
{
dsup.EndEdit();
taItem.Update(dsup);
}
isnew = false;
}
return retval;
}
public DsMaster GetGeneric()
{
var ta = new GENERICMASTTableAdapter {Connection = {ConnectionString = _constr}};
var catds = new DsMaster();
ta.Fill(catds.GENERICMAST);
return catds;
}
public bool SaveItemGroup(DsMaster itemgrp)
{
bool saved = false;
if (itemgrp.HasChanges() && !itemgrp.CATEGORY.HasErrors)
{
var manager = new DsMasterTableAdapters.TableAdapterManager
{ Connection = {ConnectionString = _constr},
ITEMGROUPTableAdapter = new ITEMGROUPTableAdapter(),
BackupDataSetBeforeUpdate = true
};
saved = manager.UpdateAll(itemgrp) > 0;
}
return saved;
}
public DsMaster GetItemGroup()
{
var ta = new ITEMGROUPTableAdapter {Connection = {ConnectionString = _constr}};
var catds = new DsMaster();
ta.Fill(catds.ITEMGROUP);
return catds;
}
public DsMaster GetCategory()
{
var ta = new CATEGORYTableAdapter {Connection = {ConnectionString = _constr}};
var catds = new DsMaster();
ta.Fill(catds.CATEGORY);
return catds;
}
public DsMaster.STOREMASTDataTable GetAllSalesStore()
{
var dt = new DsMaster().STOREMAST;
var ta = new DsMasterTableAdapters.STOREMASTTableAdapter { Connection = { ConnectionString = _constr } };
ta.FillByALLSalesStore(dt);
return dt;
}
public string DoDownLoadCustomer()
{
string retval = "1";
var _remotecustomer = new Customer().GetCustomerMembersDataTable(true, _syncConstr);
var ds = new DsMaster().CUSTOMER;
var taCustomer = new DsMasterTableAdapters.CUSTOMERTableAdapter{Connection = { ConnectionString = Utils.Connectionstring } };
taCustomer.Fill(ds);
foreach (DataRow dr in _remotecustomer.Rows)
{
var isnew = false;
var dsup = ds.FindByCUSTNO(dr["CUSTNO"].ToString());
if (dsup != null)
{
dsup.BeginEdit();
}
else
{
dsup = (DsMaster.CUSTOMERRow)ds.NewRow();
isnew = true;
foreach (DataColumn dc in _remotecustomer.Columns)
{
if (dc.ColumnName == "CUSTOMERPOINT")
{
dsup[dc.ColumnName] = 0;
}
else
{
dsup[dc.ColumnName] = dr[dc.ColumnName];
}
}
}
bool update = true;
if (!isnew)
{
update = Equals(dr, dsup);
}
if (!update)
{
foreach (DataColumn dc in _remotecustomer.Columns)
{
if (dc.ColumnName == "CUSTOMERPOINT")
{
dsup[dc.ColumnName] = 0;
}
else
{
dsup[dc.ColumnName] = dr[dc.ColumnName];
}
}
}
if (isnew)
{
ds.Rows.Add(dsup);
var t = taCustomer.Update(ds);
if (t == 0)
retval += "Customer master not created";
}
else
{
dsup.EndEdit();
taCustomer.Update(dsup);
}
}
return retval;
}
public bool SaveUom(DsMaster uom)
{
bool saved = false;
if (uom.HasChanges() && !uom.CATEGORY.HasErrors)
{
var manager = new DsMasterTableAdapters.TableAdapterManager
{ Connection = {ConnectionString = _constr},
UOMMASTTableAdapter = new UOMMASTTableAdapter(), BackupDataSetBeforeUpdate = true
};
saved = manager.UpdateAll(uom) > 0;
}
return saved;
}
public string DoUpLoadSuppliers()
{
string retval = "1";
var dtsupplier = new DataManager().GetSupplier();
var ds = new DsMaster().SUPPLIER;
var taSupplier = new DsMasterTableAdapters.SUPPLIERTableAdapter {Connection = {ConnectionString = _constr}};
taSupplier.Fill(ds);
foreach (DataRow dr in dtsupplier.Rows)
{
var isnew = false;
var dsup = ds.FindBySUPPLIERNO(dr["SUPPLIERNO"].ToString());
if (dsup != null)
{
dsup.BeginEdit();
}
else
{
dsup = (DsMaster.SUPPLIERRow)ds.NewRow();
isnew = true;
foreach (DataColumn dc in dtsupplier.Columns)
{
dsup[dc.ColumnName] = dr[dc.ColumnName];
}
}
bool update = true;
if (!isnew)
{
update = Equals(dr, dsup);
}
if (!update)
{
foreach (DataColumn dc in dtsupplier.Columns)
{
if (!dc.ReadOnly)
dsup[dc.ColumnName] = dr[dc.ColumnName];
}
}
if (isnew)
{
ds.Rows.Add(dr.ItemArray);
var t = taSupplier.Update(ds);
if (t == 0)
retval += " Supplier master not created";
}
else
{
dsup.EndEdit();
taSupplier.Update(dsup);
}
}
return retval;
}
//public DsInventory.NOTESMASTDataTable GetNotes(string supid,string docno)
//{
// var ta = new NOTESMASTTableAdapter();
// var ds = new DsInventory().NOTESMAST;
// ta.FillByID(ds, supid, docno);
// //ta.Fill(ds,supid,docno);
// return ds;
//}
public DsMaster.MastMoveTypesDataTable GetMoveTypes()
{
var ta = new MastMoveTypesTableAdapter {Connection = {ConnectionString = _constr}};
var ds = new DsMaster().MastMoveTypes;
ta.Fill(ds);
return ds;
}
public DsMaster.INSCUSTOMERSRow GetInscustomersRowByFileNo(string fileno)
{
var tam = new DsMasterTableAdapters.INSCUSTOMERSTableAdapter { Connection = { ConnectionString = _constr } };
var dt = new DsMaster().INSCUSTOMERS;
tam.FillByFILENO(dt,fileno);
DsMaster.INSCUSTOMERSRow dr = null;
if (dt.Rows.Count > 0)
dr = dt[0];
return dr;
}
public DsMaster.SUPPLIERDataTable GetSupplierList()
{
var ta = new DsMasterTableAdapters.SUPPLIERTableAdapter();
ta.Connection.ConnectionString = _constr;
var ds = new DsMaster().SUPPLIER;
ta.Fill(ds);
return ds;
}
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;
}
public string DoSave()
{
string retval;
SqlTransaction tran = null;
var isnew = false;
try
{
var cn = new SqlConnection {ConnectionString = _constr};
cn.Open();
tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted);
var dt = new DsMaster().ITEMMAST;
var ta = new DsMasterTableAdapters.ITEMMASTTableAdapter();
ta.Connection.ConnectionString = _constr;
ta.Fill(dt);
ta.AssignConnection(cn, tran);
var dr = dt.FindByITEMNO(Itemno);
if (dr != null)
{
dr.BeginEdit();
dr.editedby = Utils.Userid;
dr.editeddate = DateTime.Now.Date;
}
else
{
dr = (DsMaster.ITEMMASTRow) dt.NewRow();
isnew = true;
var autoid = new DataManager().GetAutoId(12);
autoid++;
Utils.Itemno = Utils.Company + autoid.ToString("D5");
dr.ITEMNO = Utils.Itemno;
dr.CREATEDBY = Utils.Userid;
dr.CDATE = DateTime.Now.Date;
if (ItemmastRow.OWNBARCODE && string.IsNullOrEmpty(ItemmastRow.BARCODE))
dr.BARCODE = Utils.Itemno;
else
{
dr.BARCODE = ItemmastRow.BARCODE;
}
}
dr.ITEMTYPE = ItemmastRow.ITEMTYPE;
dr.OWNBARCODE = ItemmastRow.OWNBARCODE;
dr.ITEMNAME = ItemmastRow.ITEMNAME;
dr.ARITEMNAME = ItemmastRow.ARITEMNAME;
dr.BASEUOM = ItemmastRow.BASEUOM;
dr.SUPPLIERNO = ItemmastRow.SUPPLIERNO;
dr.MANFNAME = ItemmastRow.MANFNAME;
dr.REORDER = ItemmastRow.REORDER;
dr.UOM = ItemmastRow.UOM;
dr.PRINTBARCODE = ItemmastRow.PRINTBARCODE;
dr.EXPDATEREQ = ItemmastRow.EXPDATEREQ;
dr.ACTIVE = ItemmastRow.ACTIVE;
dr.CATEGORY = ItemmastRow.CATEGORY;
dr.GROUPID = ItemmastRow.GROUPID;
dr.GENERICID = ItemmastRow.GENERICID;
dr.MARGIN = ItemmastRow.MARGIN;
dr.MARKUP = ItemmastRow.MARKUP;
dr.DISCOUNT = ItemmastRow.DISCOUNT;
dr.FASTMOVING = ItemmastRow.FASTMOVING;
dr.LOCATION = ItemmastRow.LOCATION;
dr.TEMPRATURE = ItemmastRow.TEMPRATURE;
dr.MINQTY = ItemmastRow.MINQTY;
dr.MAXQTY = ItemmastRow.MAXQTY;
dr.COMPANY = Utils.Company;
dr.SEL = false;
dr.DISCONSALE = ItemmastRow.DISCONSALE;
dr.CPRICE = ItemmastRow.CPRICE;
dr.SPRICE = ItemmastRow.SPRICE;
dr.ITEMDEM = ItemmastRow.ITEMDEM;
dr.COLOR=ItemmastRow.COLOR;
dr.WEIGHT=ItemmastRow.WEIGHT;
dr.POMINQTY =ItemmastRow.POMINQTY;
dr.POMAXQTY =ItemmastRow.POMAXQTY;
dr.DISCONSALE = ItemmastRow.DISCONSALE;
dr.SALEDISCOUNTPER = ItemmastRow.SALEDISCOUNTPER;
if (isnew)
{
dt.Rows.Add(dr);
ta.Update(dt);
}
else
{
dr.EndEdit();
ta.Update(dt);
}
new DataManager().UpdateAutoNum(12);
tran.Commit();
retval = "1";
}
catch (Exception ex)
{
retval = ex.ToString();
if (tran != null) tran.Rollback();
}
return retval;
}
