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();
}
}
}
