public static int SaveINDoc(INDoc info) { return ConnectDB.ExecuteScalar("sp_INDocSave", new String[] { "BranchID", "DocNbr", "DocDate", "DocDescr", "Module", "TranType", "WhID", "ToWhID", "TotQty", "TotAmt", "RsID", "Rlsed", "Note", "Crtd_DateTime", "Crtd_Prog", "Crtd_User", "LUpd_DateTime", "LUpd_Prog", "LUpd_User", "Version" }, new Object[] { info.BranchID, info.DocNbr, info.DocDate, info.DocDescr, info.Module, info.TranType, info.WhID, info.ToWhID, info.TotQty, info.TotAmt, info.RsID, info.Rlsed, info.Note, info.Crtd_DateTime, info.Crtd_Prog, info.Crtd_User, info.LUpd_DateTime, info.LUpd_Prog, info.LUpd_User, info.Version }); }
private void _SaveINDoc() { if (dgvDocDet.RowCount == 0) MessageBoxEx.Show("Đơn hàng không có chi tiết, không thể Save", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Stop); else { INDoc _infoDoc = new INDoc(); _infoDoc.BranchID = cmbBranchID.SelectedValue.ToString(); if (txtDocNbr.Text == "") _infoDoc.DocNbr = _strFistChar + (Int16.Parse(_strLastNbr) + 1).ToString("000000"); else _infoDoc.DocNbr = txtDocNbr.Text; _infoDoc.Module = "IN"; _infoDoc.TranType = _strFistChar; _infoDoc.TotQty = float.Parse(txtTotalQty.Number); _infoDoc.WhID = cmbWhID.SelectedValue.ToString(); _infoDoc.ToWhID = ""; _infoDoc.TotAmt = float.Parse(txtTotalAmt.Number); _infoDoc.DocDate = dtmDocDate.Value.Date; _infoDoc.DocDescr = txtDocDescr.Text; _infoDoc.RsID = cmbReason.SelectedValue.ToString(); _infoDoc.Rlsed = 0; _infoDoc.Note = ""; _infoDoc.Crtd_DateTime = DateTime.Now; _infoDoc.Crtd_Prog = _strPro; _infoDoc.Crtd_User = _strUser; _infoDoc.LUpd_DateTime = DateTime.Now; _infoDoc.LUpd_Prog = _strPro; _infoDoc.LUpd_User = _strUser; int kq; if (_infoDoc.DocNbr != "" && _infoDoc.DocNbr != "") kq = IN201Ctrl.SaveINDoc(_infoDoc); if (txtDocNbr.Text == "") { string strLastNbr = (Int16.Parse(_strLastNbr) + 1).ToString("000000"); txtDocNbr.Text = _strFistChar + strLastNbr; _SaveSASetup("IN", _strFistChar, strLastNbr); } _SaveINDocDet(); _BindDocList(); _BinEditPanel(cmbBranchID.SelectedValue.ToString(), txtDocNbr.Text, "IN"); } }
private void btnRelease_Click(object sender, EventArgs e) { if (dgvDocDet.RowCount == 0) MessageBoxEx.Show("Đơn hàng không có chi tiết, không thể Cập nhật", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Stop); else { INDoc _infoDoc = new INDoc(); _infoDoc.BranchID = cmbBranchID.SelectedValue.ToString(); if (txtDocNbr.Text != "") _infoDoc.DocNbr = txtDocNbr.Text; _infoDoc.Module = "IN"; _infoDoc.TranType = _strFistChar; _infoDoc.TotQty = float.Parse(txtTotalQty.Number); _infoDoc.WhID = cmbWhID.SelectedValue.ToString(); _infoDoc.ToWhID = ""; _infoDoc.TotAmt = float.Parse(txtTotalAmt.Number); _infoDoc.DocDate = dtmDocDate.Value.Date; _infoDoc.DocDescr = txtDocDescr.Text; _infoDoc.RsID = cmbReason.SelectedValue.ToString(); _infoDoc.Rlsed = 1; _infoDoc.Note = ""; _infoDoc.Crtd_DateTime = DateTime.Now; _infoDoc.Crtd_Prog = _strPro; _infoDoc.Crtd_User = _strUser; _infoDoc.LUpd_DateTime = DateTime.Now; _infoDoc.LUpd_Prog = _strPro; _infoDoc.LUpd_User = _strUser; int kq; if (_infoDoc.DocNbr != "" && _infoDoc.DocNbr != "") kq = IN201Ctrl.SaveINDoc(_infoDoc); _BindDocList(); _BinEditPanel(cmbBranchID.SelectedValue.ToString(), txtDocNbr.Text, "IN"); } }
private void btnDestroy_Click(object sender, EventArgs e) { INDoc _infoDoc = new INDoc(); _infoDoc.BranchID = cmbBranchID.SelectedValue.ToString(); if (txtDocNbr.Text != "") _infoDoc.DocNbr = txtDocNbr.Text; _infoDoc.Module = "IN"; _infoDoc.TranType = _strFistChar; _infoDoc.TotQty = float.Parse(txtTotalQty.Number); _infoDoc.WhID = cmbWhID.SelectedValue.ToString(); _infoDoc.ToWhID = ""; _infoDoc.TotAmt = float.Parse(txtTotalAmt.Number); _infoDoc.DocDate = dtmDocDate.Value.Date; _infoDoc.DocDescr = txtDocDescr.Text; _infoDoc.RsID = cmbReason.SelectedValue.ToString(); _infoDoc.Rlsed = -1; _infoDoc.Note = ""; _infoDoc.Crtd_DateTime = DateTime.Now; _infoDoc.Crtd_Prog = _strPro; _infoDoc.Crtd_User = _strUser; _infoDoc.LUpd_DateTime = DateTime.Now; _infoDoc.LUpd_Prog = _strPro; _infoDoc.LUpd_User = _strUser; int kq; if (_infoDoc.DocNbr != "" && _infoDoc.DocNbr != "") kq = IN201Ctrl.SaveINDoc(_infoDoc); _BindDocList(); _BinEditPanel(cmbBranchID.SelectedValue.ToString(), txtDocNbr.Text, "IN"); }
private INDoc _GetINDoc() { INDoc indoc = new INDoc(); indoc.BranchID = cmbBranchID.SelectedValue.ToString(); indoc.DocNbr = txtDocNbr.Text; indoc.Module = "IN"; indoc.TranType = _strFistChar; indoc.TotQty = float.Parse(txtTotalQty.Number.ToString()); indoc.WhID = cmbWhID.SelectedValue.ToString(); indoc.ToWhID = cmbToWhID.SelectedValue.ToString(); indoc.TotAmt = float.Parse(txtTotalAmt.Number.ToString()); indoc.DocDate = dtmDocDate.Value.Date; indoc.DocDescr = txtDocDescr.Text; indoc.RsID = cmbReason.SelectedValue.ToString(); indoc.Rlsed = 0; indoc.Note = ""; indoc.Crtd_DateTime = DateTime.Now; indoc.Crtd_Prog = _strPro; indoc.Crtd_User = _strUser; indoc.LUpd_DateTime = DateTime.Now; indoc.LUpd_Prog = _strPro; indoc.LUpd_User = _strUser; indoc.Version = label1.Text; return indoc; }
//public static string Execute(string Prompt) //{ // using (var f = new MyInputDialog()) // { // f.lblPrompt.Text = Prompt; // f.ShowModal(); // return f.txtInput.Text; // } //} private void btnDestroy_Click(object sender, EventArgs e) { INDoc _infoDoc = new INDoc(); _infoDoc.BranchID = cmbBranchID.SelectedValue.ToString(); if (txtDocNbr.Text != "") _infoDoc.DocNbr = txtDocNbr.Text; _infoDoc.Module = "IN"; _infoDoc.TranType = _strFistChar; _infoDoc.TotQty = float.Parse(txtTotalQty.Number.ToString()); _infoDoc.WhID = cmbWhID.SelectedValue.ToString(); _infoDoc.ToWhID = cmbToWhID.SelectedValue.ToString(); _infoDoc.TotAmt = float.Parse(txtTotalAmt.Number.ToString()); _infoDoc.DocDate = dtmDocDate.Value.Date; _infoDoc.DocDescr = txtDocDescr.Text; _infoDoc.RsID = cmbReason.SelectedValue.ToString(); _infoDoc.Rlsed = -1; InputBoxForm ib = new InputBoxForm("text", "default", "caption"); ib.ShowDialog(); _infoDoc.Note = ib.txtOut.Text ; _infoDoc.Crtd_DateTime = DateTime.Now; _infoDoc.Crtd_Prog = _strPro; _infoDoc.Crtd_User = _strUser; _infoDoc.LUpd_DateTime = DateTime.Now; _infoDoc.LUpd_Prog = _strPro; _infoDoc.LUpd_User = _strUser; _infoDoc.Version = label1.Text; int kq; if (_infoDoc.DocNbr != "" && _infoDoc.DocNbr != "") kq = IN202Ctrl.SaveINDoc(_infoDoc); _BindDocList(); _BinEditPanel(cmbBranchID.SelectedValue.ToString(), txtDocNbr.Text, "IN"); }