public string save()
{
using (Connection cn = new Connection())
{
try
{
string sql = string.Format("select * from " + tbname + " where oid='{0}'", this.oid);
using (MysqlDataTable dt = new MysqlDataTable(sql, cn.getConnection()))
{
var tb = dt.data;
var dr = tb.NewRow();
if (tb.Rows.Count > 0)
{
dr = tb.Rows[0];
}
else
{
dr["oid"] = 0;
}
dr["countryCode"] = this.countryCode;
dr["countryName"] = this.countryName;
if (dr.RowState.Equals(System.Data.DataRowState.Detached))
{
tb.Rows.Add(dr);
}
dt.update();
}
return("Save Successfully");
}
catch (Exception e)
{
return(e.Message);
}
}
}
public string save()
{
using (Connection cn = new Connection())
{
try
{
string sql = string.Format("select * from " + tbname + " where oid='{0}'", this.oid);
using (MysqlDataTable dt = new MysqlDataTable(sql, cn.getConnection()))
{
var tb = dt.data;
var dr = tb.NewRow();
if (tb.Rows.Count > 0)
{
dr = tb.Rows[0];
}
else
{
dr["oid"] = 0;
}
dr["TRFCLS"] = this.TRFCLS;
dr["CEPCDE"] = this.CEPCDE;
dr["TRFSEQ"] = this.TRFSEQ;
dr["DSCTRS1"] = this.DSCTRS1;
dr["DSCTRS2"] = this.DSCTRS2;
dr["DSCTRS3"] = this.DSCTRS3;
dr["DSCTRS4"] = this.DSCTRS4;
dr["DSCTRS5"] = this.DSCTRS5;
dr["BNAGM"] = this.BNAGM;
dr["IDAGM"] = this.IDAGM;
dr["LAAGM"] = this.LAAGM;
dr["MYAGM"] = this.MYAGM;
dr["MMAGM"] = this.MMAGM;
dr["PHAGM"] = this.PHAGM;
dr["SGAGM"] = this.SGAGM;
dr["VNAGM"] = this.VNAGM;
dr["KHAGM"] = this.KHAGM;
dr["UIDCTEAMN"] = this.UIDCTEAMN;
dr["DTYRTE1"] = this.DTYRTE1;
dr["DTYRTE2"] = this.DTYRTE2;
dr["DTYSPE1"] = this.DTYSPE1;
dr["DTYSPE2"] = this.DTYSPE2;
dr["DTESTR"] = this.DTESTR;
dr["DTEFIN"] = this.DTEFIN;
dr["DTECTEAMN"] = this.DTECTEAMN;
dr["TMECTEAMN"] = this.TMECTEAMN;
if (dr.RowState.Equals(System.Data.DataRowState.Detached))
{
tb.Rows.Add(dr);
}
dt.update();
}
return("Save Successfully");
}
catch (Exception e)
{
return(e.Message);
}
}
}
public string save()
{
using (Connection cn = new Connection())
{
try
{
string sql = string.Format("select * from " + tbname + " where oid='{0}'", this.oid);
using (MysqlDataTable dt = new MysqlDataTable(sql, cn.getConnection()))
{
var tb = dt.data;
var dr = tb.NewRow();
if (tb.Rows.Count > 0)
{
dr = tb.Rows[0];
}
else
{
dr["oid"] = 0;
}
dr["TaxNumber"] = this.TaxNumber;
dr["Code"] = this.Code;
dr["NameEng"] = this.NameEng;
dr["Address1"] = this.Address1;
dr["Address2"] = this.Address2;
dr["CityName"] = this.CityName;
dr["ZipCode"] = this.ZipCode;
dr["CountryCode"] = this.CountryCode;
dr["DestinationPort"] = this.DestinationPort;
dr["Phone"] = this.Phone;
dr["FaxNumber"] = this.FaxNumber;
dr["CommFormName"] = this.CommFormName;
dr["PackFormName"] = this.PackFormName;
dr["CustFormName"] = this.CustFormName;
dr["CommStyle"] = this.CommStyle;
dr["CustStyle"] = this.CustStyle;
dr["PackStyle"] = this.PackStyle;
dr["TAddress"] = this.TAddress;
dr["TDistrict"] = this.TDistrict;
dr["TSubProvince"] = this.TSubProvince;
dr["TProvince"] = this.TProvince;
dr["TPostCode"] = this.TPostCode;
dr["DMailAddress"] = this.DMailAddress;
dr["TProvinceName"] = this.TProvinceName;
if (dr.RowState.Equals(System.Data.DataRowState.Detached))
{
tb.Rows.Add(dr);
}
dt.update();
}
return("Save Successfully");
}
catch (Exception e)
{
return(e.Message);
}
}
}
public string save()
{
using (Connection cn = new Connection())
{
try
{
string sql = string.Format("select * from " + tbname + " where oid='{0}'", this.oid);
using (MysqlDataTable dt = new MysqlDataTable(sql, cn.getConnection()))
{
var tb = dt.data;
var dr = tb.NewRow();
if (tb.Rows.Count > 0)
{
dr = tb.Rows[0];
}
else
{
dr["oid"] = 0;
}
dr["BranchCode"] = this.BranchCode;
dr["RefNO"] = this.RefNO;
dr["DutyType"] = this.DutyType;
dr["SpecCalcBy"] = this.SpecCalcBy;
dr["ArgumentSpecUnit"] = this.ArgumentSpecUnit;
dr["ValueRate"] = this.ValueRate;
dr["SpecRate"] = this.SpecRate;
dr["ValueRateP"] = this.ValueRateP;
dr["SpecRateP"] = this.SpecRateP;
dr["ExeRate"] = this.ExeRate;
dr["DutyAmt"] = this.DutyAmt;
dr["DutyAmtP"] = this.DutyAmtP;
dr["DepositAmt"] = this.DepositAmt;
dr["IntRate"] = this.IntRate;
dr["Interest"] = this.Interest;
dr["ArgumentValueRate"] = this.ArgumentValueRate;
dr["ArgumentSpecRate"] = this.ArgumentSpecRate;
dr["DecItemNo"] = this.DecItemNo;
dr["ItemNo"] = this.ItemNo;
dr["IntMonth"] = this.IntMonth;
dr["Revised"] = this.Revised;
if (dr.RowState.Equals(System.Data.DataRowState.Detached))
{
tb.Rows.Add(dr);
}
dt.update();
}
return("Save Successfully");
}
catch (Exception e)
{
return(e.Message);
}
}
}
public string save()
{
using (Connection cn = new Connection())
{
try
{
string sql = string.Format("select * from " + tbname + " where oid='{0}'", this.oid);
using (MysqlDataTable dt = new MysqlDataTable(sql, cn.getConnection()))
{
var tb = dt.data;
var dr = tb.NewRow();
if (tb.Rows.Count > 0)
{
dr = tb.Rows[0];
}
else
{
dr["oid"] = 0;
}
dr["UserID"] = this.UserID;
dr["UPassword"] = this.UPassword;
dr["TName"] = this.TName;
dr["EName"] = this.EName;
dr["TPosition"] = this.TPosition;
dr["JobAuthorize"] = this.JobAuthorize;
dr["EMail"] = this.EMail;
dr["MobilePhone"] = this.MobilePhone;
dr["UserUpline"] = this.UserUpline;
dr["GLAccountCode"] = this.GLAccountCode;
dr["UsedLanguage"] = this.UsedLanguage;
dr["DMailAccount"] = this.DMailAccount;
dr["DMailPassword"] = this.DMailPassword;
dr["MaxRateDisc"] = this.MaxRateDisc;
dr["MaxAdvance"] = this.MaxAdvance;
dr["UPosition"] = this.UPosition;
dr["IsAlertByAgent"] = this.IsAlertByAgent;
dr["IsAlertByEMail"] = this.IsAlertByEMail;
dr["IsAlertBySMS"] = this.IsAlertBySMS;
dr["LoginDate"] = this.LoginDate;
dr["LoginTime"] = this.LoginTime;
dr["LogoutDate"] = this.LogoutDate;
dr["LogoutTime"] = this.LogoutTime;
if (dr.RowState.Equals(System.Data.DataRowState.Detached))
{
tb.Rows.Add(dr);
}
dt.update();
}
return("Save Successfully");
}
catch (Exception e)
{
return(e.Message);
}
}
}
public string save()
{
using (Connection cn = new Connection())
{
try
{
string sql = string.Format("select * from " + tbname + " where oid='{0}'", this.oid);
using (MysqlDataTable dt = new MysqlDataTable(sql, cn.getConnection()))
{
var tb = dt.data;
var dr = tb.NewRow();
if (tb.Rows.Count > 0)
{
dr = tb.Rows[0];
}
else
{
dr["oid"] = 0;
}
dr["BranchCode"] = this.BranchCode;
dr["RefNO"] = this.RefNO;
dr["ContainerNo"] = this.ContainerNo;
dr["DecNO"] = this.DecNO;
dr["PdtDescription"] = this.PdtDescription;
dr["LodgePort"] = this.LodgePort;
dr["DCmpTaxNo"] = this.DCmpTaxNo;
dr["DCmpCode"] = this.DCmpCode;
dr["DCmpBranch"] = this.DCmpBranch;
dr["PackageUnit"] = this.PackageUnit;
dr["DGrossWeightUnit"] = this.DGrossWeightUnit;
dr["DecRefNo"] = this.DecRefNo;
dr["AdditionDesc"] = this.AdditionDesc;
dr["HouseBL"] = this.HouseBL;
dr["MasterBL"] = this.MasterBL;
dr["PackageAmount"] = this.PackageAmount;
dr["DGrossWeight"] = this.DGrossWeight;
dr["ItemNo"] = this.ItemNo;
dr["DecItemNo"] = this.DecItemNo;
dr["DecRevised"] = this.DecRevised;
dr["Revised"] = this.Revised;
if (dr.RowState.Equals(System.Data.DataRowState.Detached))
{
tb.Rows.Add(dr);
}
dt.update();
}
return("Save Successfully");
}
catch (Exception e)
{
return(e.Message);
}
}
}
public string save()
{
using (Connection cn = new Connection())
{
try
{
string sql = string.Format("select * from " + tbname + " where oid='{0}'", this.oid);
using (MysqlDataTable dt = new MysqlDataTable(sql, cn.getConnection()))
{
var tb = dt.data;
var dr = tb.NewRow();
if (tb.Rows.Count > 0)
{
dr = tb.Rows[0];
}
else
{
dr["oid"] = 0;
}
dr["MailID"] = this.MailID;
dr["RefNO"] = this.RefNO;
dr["ResponseDate"] = this.ResponseDate;
dr["ResponseTime"] = this.ResponseTime;
dr["SendFrom"] = this.SendFrom;
dr["SendTo"] = this.SendTo;
dr["SubJect"] = this.SubJect;
dr["BodyText"] = this.BodyText;
dr["MailType"] = this.MailType;
dr["DocType"] = this.DocType;
dr["RefID"] = this.RefID;
dr["CounterTaxID"] = this.CounterTaxID;
dr["MailStatus"] = this.MailStatus;
dr["UploadStatus"] = this.UploadStatus;
dr["FileSendSize"] = this.FileSendSize;
dr["BillingStatus"] = this.BillingStatus;
dr["LineItem"] = this.LineItem;
dr["LastSendBillingDate"] = this.LastSendBillingDate;
dr["LastResponseBillingDate"] = this.LastResponseBillingDate;
dr["DeleteDate"] = this.DeleteDate;
if (dr.RowState.Equals(System.Data.DataRowState.Detached))
{
tb.Rows.Add(dr);
}
dt.update();
}
return("Save Successfully");
}
catch (Exception e)
{
return(e.Message);
}
}
}
public string save()
{
using (Connection cn = new Connection())
{
try
{
string sql = string.Format("select * from " + tbname + " where oid='{0}'", this.oid);
using (MysqlDataTable dt = new MysqlDataTable(sql, cn.getConnection()))
{
var tb = dt.data;
var dr = tb.NewRow();
if (tb.Rows.Count > 0)
{
dr = tb.Rows[0];
}
else
{
dr["oid"] = 0;
}
dr["CKDAPRNUM"] = this.CKDAPRNUM;
dr["BANNME"] = this.BANNME;
dr["PRDATB1"] = this.PRDATB1;
dr["PRDCDE"] = this.PRDCDE;
dr["CMPTAXNUM"] = this.CMPTAXNUM;
dr["CMPBRN"] = this.CMPBRN;
dr["PRTTYP"] = this.PRTTYP;
dr["DPMIDT"] = this.DPMIDT;
dr["JOBTYP"] = this.JOBTYP;
dr["CKDPRTNME"] = this.CKDPRTNME;
dr["PRTNTE"] = this.PRTNTE;
dr["UIDCTEAMN"] = this.UIDCTEAMN;
dr["CKDSEQNUM"] = this.CKDSEQNUM;
dr["QTYPERUNT"] = this.QTYPERUNT;
dr["DTESTR"] = this.DTESTR;
dr["DTEFIN"] = this.DTEFIN;
dr["DTECTEAMN"] = this.DTECTEAMN;
dr["TMECTEAMN"] = this.TMECTEAMN;
if (dr.RowState.Equals(System.Data.DataRowState.Detached))
{
tb.Rows.Add(dr);
}
dt.update();
}
return("Save Successfully");
}
catch (Exception e)
{
return(e.Message);
}
}
}
public string save()
{
using (Connection cn = new Connection())
{
try
{
string sql = string.Format("select * from " + tbname + " where oid='{0}'", this.oid);
using (MysqlDataTable dt = new MysqlDataTable(sql, cn.getConnection()))
{
var tb = dt.data;
var dr = tb.NewRow();
if (tb.Rows.Count > 0)
{
dr = tb.Rows[0];
}
else
{
dr["oid"] = 0;
}
dr["BOINumber"] = this.BOINumber;
dr["BOI_Expand"] = this.BOI_Expand;
dr["RefNumber"] = this.RefNumber;
dr["TaxNumber1"] = this.TaxNumber1;
dr["TaxNumber2"] = this.TaxNumber2;
dr["TaxNumber3"] = this.TaxNumber3;
dr["TaxNumber4"] = this.TaxNumber4;
dr["UID"] = this.UID;
dr["GoodType1"] = this.GoodType1;
dr["GoodType2"] = this.GoodType2;
dr["GoodType3"] = this.GoodType3;
dr["IssuedDate"] = this.IssuedDate;
dr["MachineEffDate"] = this.MachineEffDate;
dr["RecDate"] = this.RecDate;
dr["RecTime"] = this.RecTime;
dr["MachineExpDate"] = this.MachineExpDate;
dr["RawMatEffDate"] = this.RawMatEffDate;
dr["RawMatExpDate"] = this.RawMatExpDate;
if (dr.RowState.Equals(System.Data.DataRowState.Detached))
{
tb.Rows.Add(dr);
}
dt.update();
}
return("Save Successfully");
}
catch (Exception e)
{
return(e.Message);
}
}
}
public string save()
{
using (Connection cn = new Connection())
{
try
{
string sql = string.Format("select * from " + tbname + " where oid='{0}'", this.oid);
using (MysqlDataTable dt = new MysqlDataTable(sql, cn.getConnection()))
{
var tb = dt.data;
var dr = tb.NewRow();
if (tb.Rows.Count > 0)
{
dr = tb.Rows[0];
}
else
{
dr["oid"] = 0;
}
dr["TariffClass"] = this.TariffClass;
dr["TariffCode"] = this.TariffCode;
dr["PermissionGT"] = this.PermissionGT;
dr["PermitIssue"] = this.PermitIssue;
dr["ValidateIndicator"] = this.ValidateIndicator;
dr["Country"] = this.Country;
dr["QUnit"] = this.QUnit;
dr["GoodsDesc1"] = this.GoodsDesc1;
dr["GoodsDesc2"] = this.GoodsDesc2;
dr["GoodsDesc3"] = this.GoodsDesc3;
dr["GoodsDesc4"] = this.GoodsDesc4;
dr["Condition"] = this.Condition;
dr["AnnounceNo"] = this.AnnounceNo;
dr["Quantity"] = this.Quantity;
dr["AnnounceDate"] = this.AnnounceDate;
dr["StartDate"] = this.StartDate;
dr["FinishDate"] = this.FinishDate;
if (dr.RowState.Equals(System.Data.DataRowState.Detached))
{
tb.Rows.Add(dr);
}
dt.update();
}
return("Save Successfully");
}
catch (Exception e)
{
return(e.Message);
}
}
}
public string save()
{
using (Connection cn = new Connection())
{
try
{
string sql = string.Format("select * from " + tbname + " where oid='{0}'", this.oid);
using (MysqlDataTable dt = new MysqlDataTable(sql, cn.getConnection()))
{
var tb = dt.data;
var dr = tb.NewRow();
if (tb.Rows.Count > 0)
{
dr = tb.Rows[0];
}
else
{
dr["oid"] = 0;
}
dr["TariffClass"] = this.TariffClass;
dr["TariffSeq"] = this.TariffSeq;
dr["DutyCode"] = this.DutyCode;
dr["SpecCode"] = this.SpecCode;
dr["DescTh"] = this.DescTh;
dr["DescEng"] = this.DescEng;
dr["AnnounceNo"] = this.AnnounceNo;
dr["AnnounceDesc"] = this.AnnounceDesc;
dr["Description"] = this.Description;
dr["AdDutyRate"] = this.AdDutyRate;
dr["SpecDutyRate"] = this.SpecDutyRate;
dr["AnnounceDate"] = this.AnnounceDate;
dr["StartDate"] = this.StartDate;
dr["FinishDate"] = this.FinishDate;
dr["LastUpdate"] = this.LastUpdate;
if (dr.RowState.Equals(System.Data.DataRowState.Detached))
{
tb.Rows.Add(dr);
}
dt.update();
}
return("Save Successfully");
}
catch (Exception e)
{
return(e.Message);
}
}
}
public string save()
{
using (Connection cn = new Connection())
{
try
{
string sql = string.Format("select * from " + tbname + " where oid='{0}'", this.oid);
using (MysqlDataTable dt = new MysqlDataTable(sql, cn.getConnection()))
{
var tb = dt.data;
var dr = tb.NewRow();
if (tb.Rows.Count > 0)
{
dr = tb.Rows[0];
}
else
{
dr["oid"] = 0;
}
dr["TariffClass"] = this.TariffClass;
dr["TariffStatCode"] = this.TariffStatCode;
dr["GoodsUnitCode"] = this.GoodsUnitCode;
dr["Desc1"] = this.Desc1;
dr["Desc2"] = this.Desc2;
dr["Desc3"] = this.Desc3;
dr["Desc4"] = this.Desc4;
dr["Desc5"] = this.Desc5;
dr["StatDescThai"] = this.StatDescThai;
dr["StatDescEng"] = this.StatDescEng;
dr["AnnualNo"] = this.AnnualNo;
dr["AnnualDate"] = this.AnnualDate;
dr["StartDate"] = this.StartDate;
dr["FinishDate"] = this.FinishDate;
dr["LastUpDate"] = this.LastUpDate;
if (dr.RowState.Equals(System.Data.DataRowState.Detached))
{
tb.Rows.Add(dr);
}
dt.update();
}
return("Save Successfully");
}
catch (Exception e)
{
return(e.Message);
}
}
}
public string save()
{
using (Connection cn = new Connection())
{
try
{
string sql = string.Format("select * from " + tbname + " where oid='{0}'", this.oid);
using (MysqlDataTable dt = new MysqlDataTable(sql, cn.getConnection()))
{
var tb = dt.data;
var dr = tb.NewRow();
if (tb.Rows.Count > 0)
{
dr = tb.Rows[0];
}
else
{
dr["oid"] = 0;
}
dr["ETBNUM"] = this.ETBNUM;
dr["ETBNME"] = this.ETBNME;
dr["CMPTAXNUM"] = this.CMPTAXNUM;
dr["CMPBRN"] = this.CMPBRN;
dr["ADR1"] = this.ADR1;
dr["ADR2"] = this.ADR2;
dr["PHN"] = this.PHN;
dr["FAXNUM"] = this.FAXNUM;
dr["ETBOFRNME"] = this.ETBOFRNME;
dr["ETBFACCDE"] = this.ETBFACCDE;
dr["UIDCTEAMN"] = this.UIDCTEAMN;
dr["DTESTR"] = this.DTESTR;
dr["DTEFIN"] = this.DTEFIN;
dr["DTECTEAMN"] = this.DTECTEAMN;
dr["TMECTEAMN"] = this.TMECTEAMN;
if (dr.RowState.Equals(System.Data.DataRowState.Detached))
{
tb.Rows.Add(dr);
}
dt.update();
}
return("Save Successfully");
}
catch (Exception e)
{
return(e.Message);
}
}
}
public string save()
{
using (Connection cn = new Connection())
{
try
{
string sql = string.Format("select * from " + tbname + " where oid='{0}'", this.oid);
using (MysqlDataTable dt = new MysqlDataTable(sql, cn.getConnection()))
{
var tb = dt.data;
var dr = tb.NewRow();
if (tb.Rows.Count > 0)
{
dr = tb.Rows[0];
}
else
{
dr["oid"] = 0;
}
dr["TRFCLS"] = this.TRFCLS;
dr["TRFSEQ"] = this.TRFSEQ;
dr["DTYCDE"] = this.DTYCDE;
dr["SPECDE"] = this.SPECDE;
dr["ANONUM"] = this.ANONUM;
dr["ANODES"] = this.ANODES;
dr["DSCTRS1"] = this.DSCTRS1;
dr["DSCTRS2"] = this.DSCTRS2;
dr["UIDCTEAMN"] = this.UIDCTEAMN;
dr["PRVCDE"] = this.PRVCDE;
dr["DTEANO"] = this.DTEANO;
dr["DTESTR"] = this.DTESTR;
dr["DTEFIN"] = this.DTEFIN;
dr["DTECTEAMN"] = this.DTECTEAMN;
dr["TMECTEAMN"] = this.TMECTEAMN;
if (dr.RowState.Equals(System.Data.DataRowState.Detached))
{
tb.Rows.Add(dr);
}
dt.update();
}
return("Save Successfully");
}
catch (Exception e)
{
return(e.Message);
}
}
}
public string save()
{
using (Connection cn = new Connection())
{
try
{
string sql = string.Format("select * from " + tbname + " where oid='{0}'", this.oid);
using (MysqlDataTable dt = new MysqlDataTable(sql, cn.getConnection()))
{
var tb = dt.data;
var dr = tb.NewRow();
if (tb.Rows.Count > 0)
{
dr = tb.Rows[0];
}
else
{
dr["oid"] = 0;
}
dr["RefVer"] = this.RefVer;
dr["RefNo"] = this.RefNo;
dr["DocType"] = this.DocType;
dr["DocStatus"] = this.DocStatus;
dr["DocRejectReason"] = this.DocRejectReason;
dr["ProveBy"] = this.ProveBy;
dr["RejectBy"] = this.RejectBy;
dr["SignBy"] = this.SignBy;
dr["RefDate"] = this.RefDate;
dr["ProveDate"] = this.ProveDate;
dr["RejectDate"] = this.RejectDate;
dr["SignDate"] = this.SignDate;
if (dr.RowState.Equals(System.Data.DataRowState.Detached))
{
tb.Rows.Add(dr);
}
dt.update();
}
return("Save Successfully");
}
catch (Exception e)
{
return(e.Message);
}
}
}
public string save()
{
using (Connection cn = new Connection())
{
try
{
string sql = string.Format("select * from " + tbname + " where oid='{0}'", this.oid);
using (MysqlDataTable dt = new MysqlDataTable(sql, cn.getConnection()))
{
var tb = dt.data;
var dr = tb.NewRow();
if (tb.Rows.Count > 0)
{
dr = tb.Rows[0];
}
else
{
dr["oid"] = 0;
}
dr["BranchCode"] = this.BranchCode;
dr["BookCode"] = this.BookCode;
dr["BookName"] = this.BookName;
dr["BankCode"] = this.BankCode;
dr["BankBranch"] = this.BankBranch;
dr["ACType"] = this.ACType;
dr["TAddress1"] = this.TAddress1;
dr["TAddress2"] = this.TAddress2;
dr["EAddress1"] = this.EAddress1;
dr["EAddress2"] = this.EAddress2;
dr["Phone"] = this.Phone;
dr["FaxNumber"] = this.FaxNumber;
dr["IsLocal"] = this.IsLocal;
if (dr.RowState.Equals(System.Data.DataRowState.Detached))
{
tb.Rows.Add(dr);
}
dt.update();
}
return("Save Successfully");
}
catch (Exception e)
{
return(e.Message);
}
}
}
public string save()
{
using (Connection cn = new Connection())
{
try
{
string sql = string.Format("select * from " + tbname + " where oid='{0}'", this.oid);
using (MysqlDataTable dt = new MysqlDataTable(sql, cn.getConnection()))
{
var tb = dt.data;
var dr = tb.NewRow();
if (tb.Rows.Count > 0)
{
dr = tb.Rows[0];
}
else
{
dr["oid"] = 0;
}
dr["BrokerID"] = this.BrokerID;
dr["BrokerName"] = this.BrokerName;
dr["TStreet"] = this.TStreet;
dr["TDistrict"] = this.TDistrict;
dr["TSubProvince"] = this.TSubProvince;
dr["TProvince"] = this.TProvince;
dr["TPostCode"] = this.TPostCode;
dr["EMailAddress"] = this.EMailAddress;
dr["Branch"] = this.Branch;
dr["BrokerTax13No"] = this.BrokerTax13No;
dr["CardBeginDate"] = this.CardBeginDate;
dr["CardFinishDate"] = this.CardFinishDate;
dr["LastUpdate"] = this.LastUpdate;
if (dr.RowState.Equals(System.Data.DataRowState.Detached))
{
tb.Rows.Add(dr);
}
dt.update();
}
return("Save Successfully");
}
catch (Exception e)
{
return(e.Message);
}
}
}
public string save()
{
using (Connection cn = new Connection())
{
try
{
string sql = string.Format("select * from " + tbname + " where oid='{0}'", this.oid);
using (MysqlDataTable dt = new MysqlDataTable(sql, cn.getConnection()))
{
var tb = dt.data;
var dr = tb.NewRow();
if (tb.Rows.Count > 0)
{
dr = tb.Rows[0];
}
else
{
dr["oid"] = 0;
}
dr["FormulaNo"] = this.FormulaNo;
dr["TaxNumber"] = this.TaxNumber;
dr["Parent"] = this.Parent;
dr["Desc1"] = this.Desc1;
dr["Desc2"] = this.Desc2;
dr["Desc3"] = this.Desc3;
dr["Desc4"] = this.Desc4;
dr["Desc5"] = this.Desc5;
dr["UID"] = this.UID;
dr["StartDate"] = this.StartDate;
dr["FinishDate"] = this.FinishDate;
dr["RecDate"] = this.RecDate;
dr["RecTime"] = this.RecTime;
if (dr.RowState.Equals(System.Data.DataRowState.Detached))
{
tb.Rows.Add(dr);
}
dt.update();
}
return("Save Successfully");
}
catch (Exception e)
{
return(e.Message);
}
}
}
public string save()
{
using (Connection cn = new Connection())
{
try
{
string sql = string.Format("select * from " + tbname + " where oid='{0}'", this.oid);
using (MysqlDataTable dt = new MysqlDataTable(sql, cn.getConnection()))
{
var tb = dt.data;
var dr = tb.NewRow();
if (tb.Rows.Count > 0)
{
dr = tb.Rows[0];
}
else
{
dr["oid"] = 0;
}
dr["BranchCode"] = this.BranchCode;
dr["RefNO"] = this.RefNO;
dr["Title"] = this.Title;
dr["Dremark"] = this.Dremark;
dr["RecBy"] = this.RecBy;
dr["OwnerType"] = this.OwnerType;
dr["ItemNo"] = this.ItemNo;
dr["Revised"] = this.Revised;
dr["RecDate"] = this.RecDate;
dr["RecTime"] = this.RecTime;
if (dr.RowState.Equals(System.Data.DataRowState.Detached))
{
tb.Rows.Add(dr);
}
dt.update();
}
return("Save Successfully");
}
catch (Exception e)
{
return(e.Message);
}
}
}
public string save()
{
using (Connection cn = new Connection())
{
try
{
string sql = string.Format("select * from " + tbname + " where oid='{0}'", this.oid);
using (MysqlDataTable dt = new MysqlDataTable(sql, cn.getConnection()))
{
var tb = dt.data;
var dr = tb.NewRow();
if (tb.Rows.Count > 0)
{
dr = tb.Rows[0];
}
else
{
dr["oid"] = 0;
}
dr["NewsID"] = this.NewsID;
dr["NewsType"] = this.NewsType;
dr["PaperStatus"] = this.PaperStatus;
dr["Descrp"] = this.Descrp;
dr["Refer"] = this.Refer;
dr["NewsTime"] = this.NewsTime;
dr["NewsStatus"] = this.NewsStatus;
dr["Priority"] = this.Priority;
dr["DisplayTimes"] = this.DisplayTimes;
dr["NewsDate"] = this.NewsDate;
dr["LastGetDate"] = this.LastGetDate;
dr["LastResponseDate"] = this.LastResponseDate;
if (dr.RowState.Equals(System.Data.DataRowState.Detached))
{
tb.Rows.Add(dr);
}
dt.update();
}
return("Save Successfully");
}
catch (Exception e)
{
return(e.Message);
}
}
}
public string save()
{
using (Connection cn = new Connection())
{
try
{
string sql = string.Format("select * from " + tbname + " where oid='{0}'", this.oid);
using (MysqlDataTable dt = new MysqlDataTable(sql, cn.getConnection()))
{
var tb = dt.data;
var dr = tb.NewRow();
if (tb.Rows.Count > 0)
{
dr = tb.Rows[0];
}
else
{
dr["oid"] = 0;
}
dr["RegsNumber"] = this.RegsNumber;
dr["Name"] = this.Name;
dr["OwnerTax"] = this.OwnerTax;
dr["NaCountry"] = this.NaCountry;
dr["CargoType"] = this.CargoType;
dr["VesselType"] = this.VesselType;
dr["RiskRating"] = this.RiskRating;
dr["TareTonnage"] = this.TareTonnage;
dr["InspecCount"] = this.InspecCount;
dr["StartDate"] = this.StartDate;
dr["FinishDate"] = this.FinishDate;
dr["LastUpdate"] = this.LastUpdate;
if (dr.RowState.Equals(System.Data.DataRowState.Detached))
{
tb.Rows.Add(dr);
}
dt.update();
}
return("Save Successfully");
}
catch (Exception e)
{
return(e.Message);
}
}
}
public string save()
{
using (Connection cn = new Connection())
{
try
{
string sql = string.Format("select * from " + tbname + " where oid='{0}'", this.oid);
using (MysqlDataTable dt = new MysqlDataTable(sql, cn.getConnection()))
{
var tb = dt.data;
var dr = tb.NewRow();
if (tb.Rows.Count > 0)
{
dr = tb.Rows[0];
}
else
{
dr["oid"] = 0;
}
dr["PermitID"] = this.PermitID;
dr["PermitIssue"] = this.PermitIssue;
dr["TaxNumber"] = this.TaxNumber;
dr["TariffClass"] = this.TariffClass;
dr["InvoiceNumber"] = this.InvoiceNumber;
dr["PermitDesc1"] = this.PermitDesc1;
dr["PermitDesc2"] = this.PermitDesc2;
dr["StartDate"] = this.StartDate;
dr["FinishDate"] = this.FinishDate;
dr["InvoiceDate"] = this.InvoiceDate;
dr["LastUpdate"] = this.LastUpdate;
if (dr.RowState.Equals(System.Data.DataRowState.Detached))
{
tb.Rows.Add(dr);
}
dt.update();
}
return("Save Successfully");
}
catch (Exception e)
{
return(e.Message);
}
}
}
public string save()
{
using (Connection cn = new Connection())
{
try
{
string sql = string.Format("select * from " + tbname + " where oid='{0}'", this.oid);
using (MysqlDataTable dt = new MysqlDataTable(sql, cn.getConnection()))
{
var tb = dt.data;
var dr = tb.NewRow();
if (tb.Rows.Count > 0)
{
dr = tb.Rows[0];
}
else
{
dr["oid"] = 0;
}
dr["TaxNumber"] = this.TaxNumber;
dr["Name"] = this.Name;
dr["CardID"] = this.CardID;
dr["LtdPsNation"] = this.LtdPsNation;
dr["SeqNO"] = this.SeqNO;
dr["Type"] = this.Type;
dr["LtdPsOld"] = this.LtdPsOld;
dr["CardBeginDate"] = this.CardBeginDate;
dr["CardFinishDate"] = this.CardFinishDate;
dr["LastUpDate"] = this.LastUpDate;
if (dr.RowState.Equals(System.Data.DataRowState.Detached))
{
tb.Rows.Add(dr);
}
dt.update();
}
return("Save Successfully");
}
catch (Exception e)
{
return(e.Message);
}
}
}
public string save()
{
using (Connection cn = new Connection())
{
try
{
string sql = string.Format("select * from " + tbname + " where oid='{0}'", this.oid);
using (MysqlDataTable dt = new MysqlDataTable(sql, cn.getConnection()))
{
var tb = dt.data;
var dr = tb.NewRow();
if (tb.Rows.Count > 0)
{
dr = tb.Rows[0];
}
else
{
dr["oid"] = 0;
}
dr["LDocNo"] = this.LDocNo;
dr["LReleasePort"] = this.LReleasePort;
dr["RID"] = this.RID;
dr["RDocNo"] = this.RDocNo;
dr["RReleasePort"] = this.RReleasePort;
dr["RefNo"] = this.RefNo;
dr["RowID"] = this.RowID;
dr["LID"] = this.LID;
dr["LTransmitDate"] = this.LTransmitDate;
dr["RTransmitDate"] = this.RTransmitDate;
if (dr.RowState.Equals(System.Data.DataRowState.Detached))
{
tb.Rows.Add(dr);
}
dt.update();
}
return("Save Successfully");
}
catch (Exception e)
{
return(e.Message);
}
}
}
public string save()
{
using (Connection cn = new Connection())
{
try
{
string sql = string.Format("select * from " + tbname + " where oid='{0}'", this.oid);
using (MysqlDataTable dt = new MysqlDataTable(sql, cn.getConnection()))
{
var tb = dt.data;
var dr = tb.NewRow();
if (tb.Rows.Count > 0)
{
dr = tb.Rows[0];
}
else
{
dr["oid"] = 0;
}
dr["MANCDE"] = this.MANCDE;
dr["SUBCDE"] = this.SUBCDE;
dr["TYPDSC"] = this.TYPDSC;
dr["UIDAMN"] = this.UIDAMN;
dr["MNT"] = this.MNT;
dr["DTESTR"] = this.DTESTR;
dr["DTEFIN"] = this.DTEFIN;
dr["DTEAMN"] = this.DTEAMN;
dr["TMEAMN"] = this.TMEAMN;
if (dr.RowState.Equals(System.Data.DataRowState.Detached))
{
tb.Rows.Add(dr);
}
dt.update();
}
return("Save Successfully");
}
catch (Exception e)
{
return(e.Message);
}
}
}
public string save()
{
using (Connection cn = new Connection())
{
try
{
string sql = string.Format("select * from " + tbname + " where oid='{0}'", this.oid);
using (MysqlDataTable dt = new MysqlDataTable(sql, cn.getConnection()))
{
var tb = dt.data;
var dr = tb.NewRow();
if (tb.Rows.Count > 0)
{
dr = tb.Rows[0];
}
else
{
dr["oid"] = 0;
}
dr["RefID"] = this.RefID;
dr["CounterTaxID"] = this.CounterTaxID;
dr["DocType"] = this.DocType;
dr["TotalFileSize"] = this.TotalFileSize;
dr["SumMonth"] = this.SumMonth;
dr["SumYear"] = this.SumYear;
dr["BillingStatus"] = this.BillingStatus;
dr["LastSendDate"] = this.LastSendDate;
dr["LastResponseDate"] = this.LastResponseDate;
if (dr.RowState.Equals(System.Data.DataRowState.Detached))
{
tb.Rows.Add(dr);
}
dt.update();
}
return("Save Successfully");
}
catch (Exception e)
{
return(e.Message);
}
}
}
public string save()
{
using (Connection cn = new Connection())
{
try
{
string sql = string.Format("select * from " + tbname + " where oid='{0}'", this.oid);
using (MysqlDataTable dt = new MysqlDataTable(sql, cn.getConnection()))
{
var tb = dt.data;
var dr = tb.NewRow();
if (tb.Rows.Count > 0)
{
dr = tb.Rows[0];
}
else
{
dr["oid"] = 0;
}
dr["CusresFileName"] = this.CusresFileName;
dr["CusType"] = this.CusType;
dr["Status"] = this.Status;
dr["RefNo"] = this.RefNo;
dr["AuditTime"] = this.AuditTime;
dr["ContainerNo"] = this.ContainerNo;
dr["Vessel"] = this.Vessel;
dr["DecNo"] = this.DecNo;
if (dr.RowState.Equals(System.Data.DataRowState.Detached))
{
tb.Rows.Add(dr);
}
dt.update();
}
return("Save Successfully");
}
catch (Exception e)
{
return(e.Message);
}
}
}
public string save()
{
using (Connection cn = new Connection())
{
try
{
string sql = string.Format("select * from " + tbname + " where oid='{0}'", this.oid);
using (MysqlDataTable dt = new MysqlDataTable(sql, cn.getConnection()))
{
var tb = dt.data;
var dr = tb.NewRow();
if (tb.Rows.Count > 0)
{
dr = tb.Rows[0];
}
else
{
dr["oid"] = 0;
}
dr["Description"] = this.Description;
dr["UID"] = this.UID;
dr["GoodsType"] = this.GoodsType;
dr["StartDate"] = this.StartDate;
dr["FinishDate"] = this.FinishDate;
dr["RecDate"] = this.RecDate;
dr["RecTime"] = this.RecTime;
if (dr.RowState.Equals(System.Data.DataRowState.Detached)) tb.Rows.Add(dr);
dt.update();
}
return "Save Successfully";
}
catch (Exception e)
{
return e.Message;
}
}
}
public string save()
{
using (Connection cn = new Connection())
{
try
{
string sql = string.Format("select * from " + tbname + " where oid='{0}'", this.oid);
using (MysqlDataTable dt = new MysqlDataTable(sql, cn.getConnection()))
{
var tb = dt.data;
var dr = tb.NewRow();
if (tb.Rows.Count > 0)
{
dr = tb.Rows[0];
}
else
{
dr["oid"] = 0;
}
dr["CustCode"] = this.CustCode;
dr["Branch"] = this.Branch;
dr["CustGroup"] = this.CustGroup;
dr["Title"] = this.Title;
dr["NameThai"] = this.NameThai;
dr["TaxNumber"] = this.TaxNumber;
dr["NameEng"] = this.NameEng;
dr["TAddress1"] = this.TAddress1;
dr["TAddress2"] = this.TAddress2;
dr["EAddress1"] = this.EAddress1;
dr["EAddress2"] = this.EAddress2;
dr["Phone"] = this.Phone;
dr["FaxNumber"] = this.FaxNumber;
dr["TAddress"] = this.TAddress;
dr["TStreet"] = this.TStreet;
dr["TDistrict"] = this.TDistrict;
dr["TSubProvince"] = this.TSubProvince;
dr["TProvince"] = this.TProvince;
dr["TPostCode"] = this.TPostCode;
dr["LoginName"] = this.LoginName;
dr["LoginPassword"] = this.LoginPassword;
dr["ManagerCode"] = this.ManagerCode;
dr["CSCodeIM"] = this.CSCodeIM;
dr["CSCodeEX"] = this.CSCodeEX;
dr["CSCodeOT"] = this.CSCodeOT;
dr["GLAccountCode"] = this.GLAccountCode;
dr["UsedLanguage"] = this.UsedLanguage;
dr["BillToCustCode"] = this.BillToCustCode;
dr["BillToBranch"] = this.BillToBranch;
dr["LevelGrade"] = this.LevelGrade;
dr["BillCondition"] = this.BillCondition;
dr["MapText"] = this.MapText;
dr["MapFileName"] = this.MapFileName;
dr["CmpType"] = this.CmpType;
dr["CmpLevelExp"] = this.CmpLevelExp;
dr["CmpLevelImp"] = this.CmpLevelImp;
dr["LnNO"] = this.LnNO;
dr["AdjTaxCode"] = this.AdjTaxCode;
dr["BkAuthorNo"] = this.BkAuthorNo;
dr["BkAuthorCnn"] = this.BkAuthorCnn;
dr["LtdPsWkName"] = this.LtdPsWkName;
dr["ConsStatus"] = this.ConsStatus;
dr["CommLevel"] = this.CommLevel;
dr["DMailAddress"] = this.DMailAddress;
dr["PrivilegeOption"] = this.PrivilegeOption;
dr["Email"] = this.Email;
dr["SignPrivilege"] = this.SignPrivilege;
dr["ImporterNo"] = this.ImporterNo;
dr["ExporterNo"] = this.ExporterNo;
dr["CustSignMail"] = this.CustSignMail;
dr["Tax13No"] = this.Tax13No;
dr["TProvinceName"] = this.TProvinceName;
dr["AEOsReferenceNumber"] = this.AEOsReferenceNumber;
dr["GDEXRptName"] = this.GDEXRptName;
dr["GDIMRptName"] = this.GDIMRptName;
dr["GOODSRptName"] = this.GOODSRptName;
dr["CreditLimit"] = this.CreditLimit;
dr["DutyLimit"] = this.DutyLimit;
dr["CommRate"] = this.CommRate;
dr["CustType"] = this.CustType;
dr["TermOfPayment"] = this.TermOfPayment;
dr["MgrSeq"] = this.MgrSeq;
dr["Is19bis"] = this.Is19bis;
dr["LevelNoExp"] = this.LevelNoExp;
dr["LevelNoImp"] = this.LevelNoImp;
dr["GoldCardNO"] = this.GoldCardNO;
dr["CustomsBrokerSeq"] = this.CustomsBrokerSeq;
if (dr.RowState.Equals(System.Data.DataRowState.Detached))
{
tb.Rows.Add(dr);
}
dt.update();
}
return("Save Successfully");
}
catch (Exception e)
{
return(e.Message);
}
}
}
public string save()
{
using (Connection cn = new Connection())
{
try
{
string sql = string.Format("select * from " + tbname + " where oid='{0}'", this.oid);
using (MysqlDataTable dt = new MysqlDataTable(sql, cn.getConnection()))
{
var tb = dt.data;
var dr = tb.NewRow();
if (tb.Rows.Count > 0)
{
dr = tb.Rows[0];
}
else
{
dr["oid"] = 0;
}
dr["BranchCode"] = this.BranchCode;
dr["RefNO"] = this.RefNO;
dr["InvNO"] = this.InvNO;
dr["TrackingNO"] = this.TrackingNO;
dr["CmpCode"] = this.CmpCode;
dr["CmpTaxNumber"] = this.CmpTaxNumber;
dr["CmpBranch"] = this.CmpBranch;
dr["SellerStatus"] = this.SellerStatus;
dr["ConsigneeStatus"] = this.ConsigneeStatus;
dr["CommercialLevel"] = this.CommercialLevel;
dr["BuyerCode"] = this.BuyerCode;
dr["BuyerName"] = this.BuyerName;
dr["Street"] = this.Street;
dr["District"] = this.District;
dr["Subprovince"] = this.Subprovince;
dr["Province"] = this.Province;
dr["Postcode"] = this.Postcode;
dr["EmailAddr"] = this.EmailAddr;
dr["ConsigneeAddr"] = this.ConsigneeAddr;
dr["PurchaseCountry"] = this.PurchaseCountry;
dr["NotifyPartyCode"] = this.NotifyPartyCode;
dr["NotifyPartyName"] = this.NotifyPartyName;
dr["NotifyPartyAddr"] = this.NotifyPartyAddr;
dr["NotifyPartyEMail"] = this.NotifyPartyEMail;
dr["DestinationCountry"] = this.DestinationCountry;
dr["IncoTerms"] = this.IncoTerms;
dr["InvCurrency"] = this.InvCurrency;
dr["NetWUnit"] = this.NetWUnit;
dr["CurExpOther"] = this.CurExpOther;
dr["CurExplanding"] = this.CurExplanding;
dr["CurExpInland"] = this.CurExpInland;
dr["CurExpPack"] = this.CurExpPack;
dr["CurExpFwd"] = this.CurExpFwd;
dr["CurExpShp"] = this.CurExpShp;
dr["CurExpFrg"] = this.CurExpFrg;
dr["CurExpIns"] = this.CurExpIns;
dr["AvgExpOther"] = this.AvgExpOther;
dr["AvgExpInland"] = this.AvgExpInland;
dr["AvgExplanding"] = this.AvgExplanding;
dr["AvgExpFwd"] = this.AvgExpFwd;
dr["AvgExpPack"] = this.AvgExpPack;
dr["AvgExpShp"] = this.AvgExpShp;
dr["AvgExpFrg"] = this.AvgExpFrg;
dr["AvgExpIns"] = this.AvgExpIns;
dr["RecByUser"] = this.RecByUser;
dr["UIDTransmit"] = this.UIDTransmit;
dr["SignBy"] = this.SignBy;
dr["FileToSend"] = this.FileToSend;
dr["PoNo"] = this.PoNo;
dr["PaymentTerm"] = this.PaymentTerm;
dr["OtherChargeDesc"] = this.OtherChargeDesc;
dr["SelfCertRemark"] = this.SelfCertRemark;
dr["AEOsReferNo"] = this.AEOsReferNo;
dr["NotifyStreet"] = this.NotifyStreet;
dr["NotifyDistrict"] = this.NotifyDistrict;
dr["NotifySubProvince"] = this.NotifySubProvince;
dr["NotifyProvince"] = this.NotifyProvince;
dr["NotifyPostCode"] = this.NotifyPostCode;
dr["InvCurRate"] = this.InvCurRate;
dr["TotalNetW"] = this.TotalNetW;
dr["TotalInvoice"] = this.TotalInvoice;
dr["TotalInvTHB"] = this.TotalInvTHB;
dr["CurExpOtherRate"] = this.CurExpOtherRate;
dr["TotalExpOther"] = this.TotalExpOther;
dr["TotalExpOtherTHB"] = this.TotalExpOtherTHB;
dr["CurExplandingRate"] = this.CurExplandingRate;
dr["TotalExplanding"] = this.TotalExplanding;
dr["TotalExplandingTHB"] = this.TotalExplandingTHB;
dr["CurExpInlandRate"] = this.CurExpInlandRate;
dr["TotalExpInland"] = this.TotalExpInland;
dr["TotalExpInlandTHB"] = this.TotalExpInlandTHB;
dr["CurExpPackRate"] = this.CurExpPackRate;
dr["TotalExpPack"] = this.TotalExpPack;
dr["TotalExpPackTHB"] = this.TotalExpPackTHB;
dr["CurExpFwdRate"] = this.CurExpFwdRate;
dr["TotalExpForward"] = this.TotalExpForward;
dr["TotalExpForwardTHB"] = this.TotalExpForwardTHB;
dr["CurExpShpRate"] = this.CurExpShpRate;
dr["TotalExpShipping"] = this.TotalExpShipping;
dr["TotalExpShippingTHB"] = this.TotalExpShippingTHB;
dr["CurExpFrgRate"] = this.CurExpFrgRate;
dr["TotalExpFreight"] = this.TotalExpFreight;
dr["TotalExpFreightTHB"] = this.TotalExpFreightTHB;
dr["CurExpInsRate"] = this.CurExpInsRate;
dr["TotalExpInsurance"] = this.TotalExpInsurance;
dr["TotalExpInsuranceTHB"] = this.TotalExpInsuranceTHB;
dr["TotalIncreasedPrice"] = this.TotalIncreasedPrice;
dr["TotalIncreasedPriceTHB"] = this.TotalIncreasedPriceTHB;
dr["DocStatus"] = this.DocStatus;
dr["ResponseStatus"] = this.ResponseStatus;
dr["IsCancel"] = this.IsCancel;
dr["InvoiceType"] = this.InvoiceType;
dr["IsNotAutoCal"] = this.IsNotAutoCal;
dr["InvDate"] = this.InvDate;
dr["DepartureDate"] = this.DepartureDate;
dr["RecDate"] = this.RecDate;
dr["RecTime"] = this.RecTime;
dr["SignDate"] = this.SignDate;
dr["SignTime"] = this.SignTime;
if (dr.RowState.Equals(System.Data.DataRowState.Detached))
{
tb.Rows.Add(dr);
}
dt.update();
}
return("Save Successfully");
}
catch (Exception e)
{
return(e.Message);
}
}
}