public void loadcnh(CheckEdit cechd, string active, string role, DevExpress.XtraGrid.GridControl gridControl1, GridView gridView1, TextEdit txtsct, ComboBoxEdit cbldt, LookUpEdit ledv, DateEdit denct, DateEdit denht,
DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit repositoryItemLookUpEdit1, DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit tkco, DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit rpkh,
DevExpress.XtraEditors.Repository.RepositoryItemDateEdit nphhd, DevExpress.XtraEditors.Repository.RepositoryItemTextEdit sotien, Frm_phieuthu F, LookUpEdit ledt, TextEdit txtnn, TextEdit txtldn, TextEdit txtctg,
ToolStripButton tsbtsua, ToolStripButton tsbtxoa, ToolStripButton tsbtcat, ToolStripButton tsbtboghi, ToolStripButton tsbtghiso, ToolStripButton tsbtnap, ToolStripButton tsbtin, string ngaychungtu, string tsbt, ComboBoxEdit cbthue, TextEdit txthtt, ToolStripSplitButton tsbttruoc, ToolStripSplitButton tsbtsau, DataTable khach, string userid, DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit rpmanganh, DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit rpmachiphi, SearchLookUpEdit danhmuc)
{
DataTable dt = new DataTable();
phieuchitm ctm = new phieuchitm();
ctm.loadstart(cechd, gridControl1, gridView1, cbldt, ledv, denct, denht, repositoryItemLookUpEdit1, tkco, rpkh, nphhd, sotien, ledt, tsbtsua, tsbtxoa, tsbtcat, tsbtboghi, tsbtghiso, tsbtnap, tsbtin, ngaychungtu, dt, tsbt, cbthue, khach, userid, rpmanganh, rpmachiphi, danhmuc);
if (active == "1")
{
DataTable da = new DataTable();
da = gen.GetTable("select a.Description,DebitAccount,CreditAccount,Amount,AccountingObjectCode,InvDate,InvSeries,InvNo,CustomField5,CustomField4 from BATransferDetail a,AccountingObject b where a.AccountingObjectID=b.AccountingObjectID and RefID='" + role + "' order by SortOrder");
for (int i = 0; i < da.Rows.Count; i++)
{
DataRow dr = dt.NewRow();
dr[0] = da.Rows[i][1].ToString();
dr[1] = da.Rows[i][2].ToString();
if (da.Rows[i][5].ToString() != "")
{
dr[2] = DateTime.Parse(da.Rows[i][5].ToString());
cechd.Checked = true;
}
dr[3] = da.Rows[i][7].ToString();
dr[4] = da.Rows[i][6].ToString();
dr[5] = da.Rows[i][8].ToString();
dr[6] = da.Rows[i][3].ToString();
dr[7] = da.Rows[i][4].ToString();
dr[8] = da.Rows[i][0].ToString();
dr[9] = da.Rows[i][9].ToString();
dt.Rows.Add(dr);
}
gridControl1.DataSource = dt;
tsbtcat.Enabled = false;
F.Text = "Xem phiếu chi ngân hàng";
da = gen.GetTable("select AccountingObjectCode,a.Contactname,JournalMemo,DocumentIncluded,RefDate,PostedDate,RefNo,StockCode,Posted,AccountingObjectType,Cancel,Tax,ExDate,a.RefOrder from BATransfer a, AccountingObject b,Stock c where a.AccountingObjectID=b.AccountingObjectID and a.StockID=c.StockID and RefID='" + role + "'");
try
{
cbldt.SelectedIndex = Int32.Parse(da.Rows[0][9].ToString());
}
catch { }
try
{
txthtt.EditValue = Double.Parse(da.Rows[0][12].ToString());
}
catch { txthtt.EditValue = 0; }
ledv.EditValue = da.Rows[0][7].ToString();
ledt.EditValue = da.Rows[0][0].ToString();
txtnn.Text = da.Rows[0][1].ToString();
txtldn.Text = da.Rows[0][2].ToString();
txtctg.Text = da.Rows[0][3].ToString();
denct.EditValue = DateTime.Parse(da.Rows[0][4].ToString());
denht.EditValue = DateTime.Parse(da.Rows[0][5].ToString());
txtsct.Text = da.Rows[0][6].ToString();
cbthue.EditValue = da.Rows[0][11].ToString();
danhmuc.EditValue = da.Rows[0][13].ToString();
if (da.Rows[0][8].ToString() == "True")
{
tsbtghiso.Visible = false;
tsbtboghi.Visible = true;
tsbtsua.Enabled = false;
}
else
{
tsbtboghi.Visible = false;
tsbtghiso.Visible = true;
}
if (da.Rows[0][10].ToString() == "True")
{
tsbtboghi.Enabled = false;
tsbtghiso.Enabled = false;
}
checktruocsau(tsbttruoc, tsbtsau, txtsct.Text, ngaychungtu, userid);
}
else
{
try
{
F.Text = "Thêm phiếu chi ngân hàng";
txthtt.EditValue = 0;
themsct(ngaychungtu, txtsct, tsbttruoc, tsbtsau, userid);
denct.EditValue = DateTime.Parse(ngaychungtu);
denht.EditValue = DateTime.Parse(ngaychungtu);
cechd.Checked = true;
cechd.Checked = false;
}
catch
{
XtraMessageBox.Show("Vui lòng kiểm tra lại < Ngày chứng từ >.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
F.Close();
}
}
}
public void loadtm(CheckEdit cechd, string active, string role, DevExpress.XtraGrid.GridControl gridControl1, GridView gridView1, TextEdit txtsct, ComboBoxEdit cbldt, LookUpEdit ledv, DateEdit denct, DateEdit denht,
DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit repositoryItemLookUpEdit1, DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit tkco, DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit rpkh,
DevExpress.XtraEditors.Repository.RepositoryItemDateEdit nphhd, DevExpress.XtraEditors.Repository.RepositoryItemTextEdit sotien, Frm_phieuthu F, LookUpEdit ledt, TextEdit txtnn, TextEdit txtldn, TextEdit txtctg,
ToolStripButton tsbtsua, ToolStripButton tsbtxoa, ToolStripButton tsbtcat, ToolStripButton tsbtboghi, ToolStripButton tsbtghiso, ToolStripButton tsbtnap, ToolStripButton tsbtin, string ngaychungtu, string tsbt, ComboBoxEdit cbthue, ToolStripSplitButton tsbttruoc, ToolStripSplitButton tsbtsau, DataTable khach, string userid, DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit rpmanganh, DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit rpmachiphi, SearchLookUpEdit danhmuc, LookUpEdit letq, ToolStripButton tsbtkc, TextEdit txtspt)
{
DataTable dt = new DataTable();
phieuchitm ctm = new phieuchitm();
letq.Properties.DataSource = gen.GetTable("select StockCode as 'Mã đơn vị',StockName as 'Tên đơn vị' from Stock order by StockCode ");
letq.Properties.DisplayMember = "Mã đơn vị";
letq.Properties.ValueMember = "Mã đơn vị";
letq.Properties.PopupWidth = 300;
ctm.loadstart(cechd, gridControl1, gridView1, cbldt, ledv, denct, denht, repositoryItemLookUpEdit1, tkco, rpkh, nphhd, sotien, ledt, tsbtsua, tsbtxoa, tsbtcat, tsbtboghi, tsbtghiso, tsbtnap, tsbtin, ngaychungtu, dt, tsbt, cbthue, khach, userid, rpmanganh, rpmachiphi, danhmuc);
if (active == "1")
{
DataTable da = new DataTable();
da = gen.GetTable("select a.Description,DebitAccount,CreditAccount,Amount,AccountingObjectCode,InvDate,InvSeries,InvNo,CustomField5,CustomField4,Note from CAReceiptDetail a,AccountingObject b where a.AccountingObjectID=b.AccountingObjectID and RefID='" + role + "' order by SortOrder");
for (int i = 0; i < da.Rows.Count; i++)
{
DataRow dr = dt.NewRow();
dr[0] = da.Rows[i][2].ToString();
dr[1] = da.Rows[i][1].ToString();
if (da.Rows[i][5].ToString() != "")
{
dr[2] = DateTime.Parse(da.Rows[i][5].ToString());
cechd.Checked = true;
}
dr[3] = da.Rows[i][7].ToString();
dr[4] = da.Rows[i][6].ToString();
dr[5] = da.Rows[i][8].ToString();
dr[6] = da.Rows[i][3].ToString();
dr[7] = da.Rows[i][4].ToString();
dr[8] = da.Rows[i][0].ToString();
dr[9] = da.Rows[i][9].ToString();
dr[10] = da.Rows[i][10].ToString();
dt.Rows.Add(dr);
}
gridControl1.DataSource = dt;
tsbtcat.Enabled = false;
F.Text = "Xem phiếu thu tiền mặt";
da = gen.GetTable("select AccountingObjectCode,a.Contactname,JournalMemo,DocumentIncluded,RefDate,PostedDate,RefNo,StockCode,Posted,AccountingObjectType,Cancel,Tax,a.RefOrder,ShippingMethodID,EditVersion,a.CustomField5 from CAReceipt a, AccountingObject b,Stock c where a.AccountingObjectID=b.AccountingObjectID and a.StockID=c.StockID and RefID='" + role + "'");
try
{
cbldt.SelectedIndex = Int32.Parse(da.Rows[0][9].ToString());
}
catch { }
ledv.EditValue = da.Rows[0][7].ToString();
ledt.EditValue = da.Rows[0][0].ToString();
txtnn.Text = da.Rows[0][1].ToString();
txtldn.Text = da.Rows[0][2].ToString();
txtctg.Text = da.Rows[0][3].ToString();
denct.EditValue = DateTime.Parse(da.Rows[0][4].ToString());
denht.EditValue = DateTime.Parse(da.Rows[0][5].ToString());
txtsct.Text = da.Rows[0][6].ToString();
cbthue.Text = da.Rows[0][11].ToString();
danhmuc.EditValue = da.Rows[0][12].ToString();
if (da.Rows[0][13].ToString() != "")
{
letq.EditValue = gen.GetString("select StockCode from Stock where StockID='" + da.Rows[0][13].ToString() + "'");
}
if (da.Rows[0][8].ToString() == "True")
{
tsbtghiso.Visible = false;
tsbtboghi.Visible = true;
tsbtsua.Enabled = false;
}
else
{
tsbtboghi.Visible = false;
tsbtghiso.Visible = true;
}
if (da.Rows[0][10].ToString() == "True")
{
tsbtboghi.Enabled = false;
tsbtghiso.Enabled = false;
}
if (da.Rows[0][14].ToString() == "2" || da.Rows[0][14].ToString() == "1")
{
tsbtcat.Visible = false;
tsbtkc.Visible = false;
}
txtspt.Text = da.Rows[0][15].ToString();
checktruocsau(tsbttruoc, tsbtsau, txtsct.Text, ngaychungtu, userid);
}
else
{
/*try
* {*/
F.Text = "Thêm phiếu thu tiền mặt";
//themsct(ngaychungtu, txtsct, tsbttruoc, tsbtsau, userid, ledv.EditValue.ToString());
denct.EditValue = DateTime.Parse(ngaychungtu);
denht.EditValue = DateTime.Parse(ngaychungtu);
cechd.Checked = true;
cechd.Checked = false;
/*}
* catch
* {
* XtraMessageBox.Show("Vui lòng kiểm tra lại < Ngày chứng từ >.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
* F.Close();
* }*/
}
}
