public static int SaveAPDoc(APDoc info) { int kq = ConnectDB.ExecuteScalar("sp_APDocSave", new String[] { "BranchID","DocNbr","DocType","DocDesc","DocAcct","VendID", "DocBal","OrigDocAmt","DocDate","PONbr","InvcNbr","InvcNote","Rlsed","TaxId", "PreTaxAmt","TaxAmt","TimeLmtID","DueDate","Note","Crtd_DateTime","Crtd_Prog", "Crtd_User","LUpd_DateTime","LUpd_Prog","LUpd_User","Version"}, new Object[] { info.BranchID,info.DocNbr,info.DocType,info.DocDesc,info.DocAcct,info.VendID, info.DocBal,info.OrigDocAmt,info.DocDate,info.PONbr,info.InvcNbr,info.InvcNote,info.Rlsed,info.TaxId, info.PreTaxAmt,info.TaxAmt,info.TimeLmtID,info.DueDate,info.Note,info.Crtd_DateTime,info.Crtd_Prog, info.Crtd_User,info.LUpd_DateTime,info.LUpd_Prog,info.LUpd_User,info.Version}); return kq; }
private void btnAdd_Click(object sender, EventArgs e) { _info = new APDoc(); _ResetPanelInput(); _SetButtomStatus(); }
private void _BindPanel(APDoc info) { cmbBranchID.SelectedValue = info.BranchID; txtDocNbr.Text = info.DocNbr; cmbType.SelectedValue = info.DocType; txtDocDescr.Text = info.DocDesc; cmbDocAcct.SelectedValue = info.DocAcct; txtVendID.Text = info.VendID; //info.DocBal = null; txtOrigDocAmt.Text = info.OrigDocAmt.ToString().Trim(); dtmDocDate.Value = info.DocDate; //info.PONbr = ""; txtInvcNbr.Text = info.InvcNbr; txtInvcNote.Text = info.InvcNote; cmbStatus.SelectedValue = info.Rlsed; cmbTaxID.SelectedValue = info.TaxId; txtPreTaxAmt.Text = info.PreTaxAmt.ToString().Trim(); txtTaxAmt.Text = info.TaxAmt.ToString().Trim(); //info.TimeLmtID = ""; dtmDueDate.Value = info.DueDate; //info.Note = ""; //info.Crtd_DateTime = //info.Crtd_Prog = _strPro; //info.Crtd_User = _strUser; //info.LUpd_DateTime = DateTime.Now; //info.LUpd_Prog = _strPro; //info.LUpd_User = _strUser; //info.Version = ""; //return info; }
private void btnSave_Click(object sender, EventArgs e) { if (_CheckValid() == true) { if (txtDocNbr.Text.ToString().Trim() == "") { DataTable _dtLastNbr = AP201Ctrl.GetSASetupGetLastNbr("AP", _DocType); _strLastNbr = _dtLastNbr.Rows[0]["LastNbr"].ToString(); string strLastNbr = (Int16.Parse(_strLastNbr) + 1).ToString("000000"); txtDocNbr.Text = _DocType + strLastNbr; //info.DocNbr = _DocType + strLastNbr; _SaveSASetup("AP", _DocType, strLastNbr); _GetPanel(0); } else { _GetPanel(0); _info.LUpd_DateTime = DateTime.Now; _info.LUpd_Prog = _strPro; _info.LUpd_User = _strUser; } int kq = _SaveAPDoc(0); if (kq != 0) { APDoc tmp = new APDoc(); tmp.ConvertToAPDoc( AP201Ctrl.GetAPDoc(_info.BranchID, _info.DocNbr).Rows[0]); _info = tmp; _SetButtomStatus(); } } }