public void tsbtchonhd(Frm_phieunhaphangbantralai F, LookUpEdit ledt, string ngaychungtu, string branchid)
{
try
{
Frm_chonhoadon u = new Frm_chonhoadon();
u.myac = new Frm_chonhoadon.ac(F.gethoadon);
u.getdate(ngaychungtu);
string mk = gen.GetString("select * from AccountingObject where AccountingObjectCode='" + ledt.EditValue.ToString() + "'");
u.getmk(mk);
u.getbranch(branchid);
u.getform(F);
u.ShowDialog();
}
catch { MessageBox.Show("Vui lòng chọn đối tượng trước khi chọn hóa đơn."); }
}
public void tsbtpnhbtl(string a, Form1 F, DevExpress.XtraGrid.Views.Grid.GridView view, string roleid, string subsys, string ngaychungtu, string userid, string branchid, DataTable khach, DataTable hang)
{
try
{
Frm_phieunhaphangbantralai u = new Frm_phieunhaphangbantralai();
u.myac = new Frm_phieunhaphangbantralai.ac(F.refreshpnhbtl);
u.getactive(a);
u.getroleid(roleid);
u.getsub(subsys);
u.gethang(hang);
u.getkhach(khach);
u.getpt("pntl");
u.getbranch(branchid);
u.getuser(userid);
u.getdate(ngaychungtu);
/*try
* {*/
if (a == "1")
{
u.getrole(view.GetRowCellValue(view.FocusedRowHandle, "ID").ToString());
}
else
{
try
{
u.getrole(view.GetRowCellValue(view.FocusedRowHandle, "Mã kho").ToString());
}
catch
{
u.getrole(gen.GetString("select Top 1 StockCode from Stock where StockID in (select StockID from MSC_UserJoinStock where UserID='" + userid + "') order by StockCode"));
}
}
/*}
* catch { }*/
u.ShowDialog();
}
catch { MessageBox.Show("Vui lòng chọn phiếu nhập hàng bán trả lại trước khi sửa."); }
}
public void checksau(string sct, int vt, ToolStripSplitButton tsbttruoc, ToolStripSplitButton tsbtsau, Frm_phieunhaphangbantralai F, string ngay, string mk)
{
try
{
string idkho = gen.GetString("select * from Stock where StockCode='" + mk + "'");
tsbttruoc.Enabled = true;
string id;
if (vt == 0)
{
id = gen.GetString("select Top 1 * from INReInward where RefNo > '" + sct + "' and Month(RefDate)='" + DateTime.Parse(ngay).Month.ToString() + "' and Year(RefDate)='" + DateTime.Parse(ngay).Year.ToString() + "' and StockID='" + idkho + "' order by RefNo ASC");
}
else
{
id = gen.GetString("select Top 1 * from INReInward where RefNo > '" + sct + "' and Month(RefDate)='" + DateTime.Parse(ngay).Month.ToString() + "' and Year(RefDate)='" + DateTime.Parse(ngay).Year.ToString() + "' and StockID='" + idkho + "' order by RefNo DESC");
tsbtsau.Enabled = false;
}
F.getrole(id);
}
catch
{
tsbtsau.Enabled = false;
}
}
//save//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public void checkpndc(string active, string role, Frm_phieunhaphangbantralai F, GridView gridView1, LookUpEdit ledt, LookUpEdit ledv, TextEdit txtsct, TextEdit txtname,
TextEdit txtldn, DateEdit denct, DateEdit denht, ToolStripButton tsbtboghi, ToolStripButton tsbtghiso, ToolStripButton tsbtxoa,
ToolStripButton tsbtcat, ToolStripButton tsbtin, ToolStripButton tsbtsua, ToolStripButton tsbtnap, string ngaychungtu, TextEdit txtshd, TextEdit txtkhhd, TextEdit txtnhd, string userid, string branchid, TextEdit txtms, ComboBoxEdit cbthue, CheckEdit ckhd, string hoadon, TextEdit txtthue, ToolStripSplitButton tsbttruoc, ToolStripSplitButton tsbtsau)
{
try
{
string dt = gen.GetString("select * from AccountingObject where AccountingObjectCode='" + ledt.EditValue.ToString() + "'");
string[,] detail = new string[20, 8];
for (int i = 0; i < gridView1.RowCount; i++)
{
if (gridView1.GetRowCellValue(i, "Số lượng quy đổi").ToString() != "")
{
detail[i, 0] = gen.GetString("select * from InventoryItem where InventoryItemCode='" + gridView1.GetRowCellValue(i, "Mã hàng").ToString() + "'");
if (gridView1.GetRowCellValue(i, "Số lượng").ToString() == "")
{
detail[i, 1] = "0";
}
else
{
detail[i, 1] = gridView1.GetRowCellValue(i, "Số lượng").ToString().Replace(".", "");
}
if (gridView1.GetRowCellValue(i, "Đơn giá").ToString() == "")
{
detail[i, 2] = "0";
}
else
{
detail[i, 2] = gridView1.GetRowCellValue(i, "Đơn giá").ToString().Replace(".", "").Replace(",", ".");
}
if (gridView1.GetRowCellValue(i, "Đơn giá phí").ToString() == "")
{
detail[i, 3] = "0";
}
else
{
detail[i, 3] = gridView1.GetRowCellValue(i, "Đơn giá phí").ToString().Replace(".", "").Replace(",", ".");
}
if (gridView1.GetRowCellValue(i, "Thành tiền").ToString() == "")
{
detail[i, 4] = "0";
}
else
{
detail[i, 4] = gridView1.GetRowCellValue(i, "Thành tiền").ToString().Replace(".", "");
}
if (gridView1.GetRowCellValue(i, "Số lượng quy đổi").ToString() == "")
{
detail[i, 5] = "0";
}
else
{
detail[i, 5] = gridView1.GetRowCellValue(i, "Số lượng quy đổi").ToString().Replace(".", "").Replace(",", ".");
}
}
}
string dv = gen.GetString("select * from Stock where StockCode='" + ledv.EditValue.ToString() + "'");
string tong = gridView1.Columns["Thành tiền"].SummaryText.Replace(".", "");
if (active == "0")
{
try
{
string ton = gen.GetString("select * from INReInward where RefNo='" + txtsct.Text + "'");
themsct(ngaychungtu, txtsct, ledv.EditValue.ToString(), branchid, tsbttruoc, tsbtsau);
XtraMessageBox.Show("Số phiếu trùng, hệ thống tự động chỉnh số phiếu của bạn thành " + txtsct.Text, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch { }
gen.ExcuteNonquery("insert into INReInward(RefID,RefType,RefDate,PostedDate,RefNo,AccountingObjectID,AccountingObjectName,JournalMemo,Posted,StockID,TotalAmount,InvSeries,InvNo,InvDate,EmployeeID,No,Tax,CheckIn,RefIn,TotalVATAmount) values(newid(),101,'" + denct.EditValue.ToString() + "','" + denht.EditValue.ToString() + "','" + txtsct.Text + "','" + dt + "',N'" + txtname.Text + "',N'" + txtldn.Text + "','False','" + dv + "','" + tong + "','" + txtkhhd.Text + "','" + txtshd.Text + "','" + txtnhd.EditValue.ToString() + "','" + userid + "','" + txtms.Text + "','" + cbthue.EditValue.ToString() + "','" + ckhd.Checked.ToString() + "','" + hoadon + "','" + txtthue.Text.Replace(".", "") + "')");
string refid = gen.GetString("select * from INReInward where RefNo='" + txtsct.Text + "'");
gen.ExcuteNonquery("insert into HACHTOAN(RefDeteail,RefID,RefNo,DebitAccount,CreditAccount,Amount,AccountingObjectID,StockID,JournalMemo,RefDate,AccountingObjectIDMain) values(newid(),'" + refid + "','" + txtsct.Text + "','1561','632','" + tong + "','" + dt + "','" + dv + "',N'" + txtldn.Text + "','" + denct.EditValue.ToString() + "','" + dt + "')");
/*gen.ExcuteNonquery("insert into HACHTOAN(RefDeteail,RefID,RefNo,DebitAccount,CreditAccount,Amount,AccountingObjectID,StockID,JournalMemo,RefDate) values(newid(),'" + refid + "','" + txtsct.Text + "','531','131','" + tong + "','" + dt + "','" + dv + "',N'" + txtldn.Text + "','" + denct.EditValue.ToString() + "')");
* gen.ExcuteNonquery("insert into HACHTOAN(RefDeteail,RefID,RefNo,DebitAccount,CreditAccount,Amount,AccountingObjectID,StockID,JournalMemo,RefDate) values(newid(),'" + refid + "','" + txtsct.Text + "','33311','131','" + txtthue.Text.Replace(".", "") + "','" + dt + "','" + dv + "',N'" + txtldn.Text + "','" + denct.EditValue.ToString() + "')");*/
F.getrole(refid);
if (ckhd.Checked == true)
{
for (int i = 0; i < gridView1.RowCount; i++)
{
try
{
gen.ExcuteNonquery("insert into INReInwardDetail(RefDetailID,RefID,DebitAccount,CreditAccount,Amount,Quantity,SortOrder,InventoryItemID,UnitPrice,UnitPriceCost,QuantityConvert) values(newid(),'" + refid + "',1561,632,'" + detail[i, 4] + "','" + detail[i, 1] + "'," + i + ",'" + detail[i, 0] + "','" + detail[i, 2] + "','" + detail[i, 3] + "','" + detail[i, 5] + "')");
}
catch { }
}
}
else
{
for (int i = 0; i < gridView1.RowCount; i++)
{
try
{
gen.ExcuteNonquery("insert into INReInwardDetail(RefDetailID,RefID,DebitAccount,CreditAccount,Amount,Quantity,SortOrder,InventoryItemID,UnitPrice,UnitPriceCost,QuantityConvert,DebitAccountIn,CreditAccountIn) values(newid(),'" + refid + "',1561,632,'" + detail[i, 4] + "','" + detail[i, 1] + "'," + i + ",'" + detail[i, 0] + "','" + detail[i, 2] + "','" + detail[i, 3] + "','" + detail[i, 5] + "',531,632)");
}
catch {}
}
}
}
else
{
gen.ExcuteNonquery("update INReInward set RefDate='" + denct.EditValue.ToString() + "',PostedDate='" + denht.EditValue.ToString() + "',AccountingObjectID='" + dt + "',AccountingObjectName=N'" + txtname.Text + "',JournalMemo=N'" + txtldn.Text + "',StockID='" + dv + "',TotalAmount='" + tong + "',Posted='False',InvSeries='" + txtkhhd.Text + "',InvNo='" + txtshd.Text + "',InvDate='" + txtnhd.EditValue.ToString() + "',EmployeeID='" + userid + "',No='" + txtms.Text + "',Tax='" + cbthue.EditValue.ToString() + "',CheckIn='" + ckhd.Checked.ToString() + "',RefIn='" + hoadon + "',TotalVATAmount='" + txtthue.Text.Replace(".", "") + "' where RefID='" + role + "'");
gen.ExcuteNonquery("delete from INReInwardDetail where RefID='" + role + "'");
gen.ExcuteNonquery("delete HACHTOAN where RefID='" + role + "'");
gen.ExcuteNonquery("insert into HACHTOAN(RefDeteail,RefID,RefNo,DebitAccount,CreditAccount,Amount,AccountingObjectID,StockID,JournalMemo,RefDate,AccountingObjectIDMain) values(newid(),'" + role + "','" + txtsct.Text + "','156','632','" + tong + "','" + dt + "','" + dv + "',N'" + txtldn.Text + "','" + denct.EditValue.ToString() + "','" + dt + "')");
/*gen.ExcuteNonquery("insert into HACHTOAN(RefDeteail,RefID,RefNo,DebitAccount,CreditAccount,Amount,AccountingObjectID,StockID,JournalMemo,RefDate) values(newid(),'" + role + "','" + txtsct.Text + "','531','131','" + tong + "','" + dt + "','" + dv + "',N'" + txtldn.Text + "','" + denct.EditValue.ToString() + "')");
* gen.ExcuteNonquery("insert into HACHTOAN(RefDeteail,RefID,RefNo,DebitAccount,CreditAccount,Amount,AccountingObjectID,StockID,JournalMemo,RefDate) values(newid(),'" + role + "','" + txtsct.Text + "','33311','131','" + txtthue.Text.Replace(".", "") + "','" + dt + "','" + dv + "',N'" + txtldn.Text + "','" + denct.EditValue.ToString() + "')");*/
if (ckhd.Checked == true)
{
for (int i = 0; i < gridView1.RowCount; i++)
{
try
{
gen.ExcuteNonquery("insert into INReInwardDetail(RefDetailID,RefID,DebitAccount,CreditAccount,Amount,Quantity,SortOrder,InventoryItemID,UnitPrice,UnitPriceCost,QuantityConvert) values(newid(),'" + role + "',1561,632,'" + detail[i, 4] + "','" + detail[i, 1] + "'," + i + ",'" + detail[i, 0] + "','" + detail[i, 2] + "','" + detail[i, 3] + "','" + detail[i, 5] + "')");
}
catch { }
}
}
else
{
for (int i = 0; i < gridView1.RowCount; i++)
{
try
{
gen.ExcuteNonquery("insert into INReInwardDetail(RefDetailID,RefID,DebitAccount,CreditAccount,Amount,Quantity,SortOrder,InventoryItemID,UnitPrice,UnitPriceCost,QuantityConvert,DebitAccountIn,CreditAccountIn) values(newid(),'" + role + "',1561,632,'" + detail[i, 4] + "','" + detail[i, 1] + "'," + i + ",'" + detail[i, 0] + "','" + detail[i, 2] + "','" + detail[i, 3] + "','" + detail[i, 5] + "',531,632)");
}
catch { }
}
}
}
F.myac();
F.getactive("1");
F.Text = "Xem phiếu nhập hàng bán trả lại";
}
catch
{
XtraMessageBox.Show("Vui lòng chọn đối tượng trước khi lưu", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void loadpnhbtl(string active, string role, DevExpress.XtraGrid.GridControl gridControl1, GridView gridView1, TextEdit txtsct, LookUpEdit ledv, DateEdit denct, DateEdit denht,
DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit mahang, DevExpress.XtraEditors.Repository.RepositoryItemTextEdit soluong, DevExpress.XtraEditors.Repository.RepositoryItemTextEdit soluongqd, DevExpress.XtraEditors.Repository.RepositoryItemTextEdit dongia, DevExpress.XtraEditors.Repository.RepositoryItemTextEdit chiphi, DevExpress.XtraEditors.Repository.RepositoryItemTextEdit thanhtien, Frm_phieunhaphangbantralai F, LookUpEdit ledt, TextEdit txtldn,
ToolStripButton tsbtsua, ToolStripButton tsbtxoa, ToolStripButton tsbtcat, ToolStripButton tsbtboghi, ToolStripButton tsbtghiso, ToolStripButton tsbtnap, ToolStripButton tsbtin, string ngaychungtu, string tsbt, TextEdit txtshd, TextEdit txtkhhd, TextEdit txtnhd, TextEdit txtcth, TextEdit txtthue, string userid, string branchid, TextEdit txtms, ComboBoxEdit cbthue, ButtonEdit bthd, CheckEdit ckhd, ToolStripSplitButton tsbttruoc, ToolStripSplitButton tsbtsau, DataTable khach, DataTable hang)
{
DataTable dt = new DataTable();
loadstart(gridControl1, gridView1, ledv, denct, denht, mahang, soluong, soluongqd, dongia, chiphi, thanhtien, ledt, tsbtsua, tsbtxoa, tsbtcat, tsbtboghi, tsbtghiso, tsbtnap, tsbtin, ngaychungtu, dt, tsbt, userid, cbthue, khach, hang);
if (active == "1")
{
tsbtcat.Enabled = false;
DataTable da = new DataTable();
F.Text = "Xem phiếu nhập hàng bán trả lại";
da = gen.GetTable("select AccountingObjectCode,a.Contactname,JournalMemo,DocumentIncluded,RefDate,PostedDate,RefNo,StockCode,Posted,AccountingObjectType,Cancel,Tax,InvDate,InvSeries,InvNo,No,RefIn,CheckIn,TotalVATAmount from INReInward a, AccountingObject b,Stock c where a.AccountingObjectID=b.AccountingObjectID and a.StockID=c.StockID and RefID='" + role + "'");
ledv.EditValue = da.Rows[0][7].ToString();
ledt.EditValue = da.Rows[0][0].ToString();
F.gethd(da.Rows[0][16].ToString());
txtldn.Text = da.Rows[0][2].ToString();
bthd.EditValue = da.Rows[0][16].ToString();
denct.EditValue = DateTime.Parse(da.Rows[0][4].ToString());
denht.EditValue = DateTime.Parse(da.Rows[0][5].ToString());
txtsct.EditValue = da.Rows[0][6].ToString();
cbthue.EditValue = da.Rows[0][11].ToString();
Double Tienthue = Double.Parse(da.Rows[0][18].ToString());
if (da.Rows[0][17].ToString() == "True")
{
ckhd.Checked = true;
try
{
txtnhd.EditValue = DateTime.Parse(da.Rows[0][12].ToString());
}
catch { txtnhd.Text = ""; }
txtshd.Text = da.Rows[0][14].ToString();
txtms.Text = da.Rows[0][15].ToString();
txtkhhd.Text = 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;
}
da = gen.GetTable("select Amount,InventoryItemCode,a.UnitPrice,a.UnitPriceCost,Quantity,QuantityConvert from INReInwardDetail a,InventoryItem b where a.InventoryItemID=b.InventoryItemID and RefID='" + role + "' order by SortOrder");
for (int i = 0; i < da.Rows.Count; i++)
{
for (int j = 0; j < gridView1.RowCount; j++)
{
if (gridView1.GetRowCellValue(j, "Mã hàng").ToString() == da.Rows[i][1].ToString())
{
gridView1.SetRowCellValue(j, gridView1.Columns["Thành tiền"], da.Rows[i][0].ToString());
gridView1.SetRowCellValue(j, gridView1.Columns["Số lượng"], da.Rows[i][4].ToString());
gridView1.SetRowCellValue(j, gridView1.Columns["Số lượng quy đổi"], da.Rows[i][5].ToString());
gridView1.SetRowCellValue(j, gridView1.Columns["Đơn giá"], da.Rows[i][2].ToString());
gridView1.SetRowCellValue(j, gridView1.Columns["Đơn giá phí"], da.Rows[i][3].ToString());
}
}
}
txtcth.Text = gridView1.Columns["Thành tiền"].SummaryText;
txtthue.Text = String.Format("{0:n0}", Tienthue);
checktruocsau(tsbttruoc, tsbtsau, ledv.EditValue.ToString(), txtsct.Text, ngaychungtu);
}
else
{
try
{
F.Text = "Thêm phiếu nhập hàng bán trả lại";
if (role == null)
{
ledv.ItemIndex = 0;
}
else
{
ledv.EditValue = role;
}
denct.EditValue = DateTime.Parse(ngaychungtu);
denht.EditValue = DateTime.Parse(ngaychungtu);
txtnhd.EditValue = DateTime.Parse(ngaychungtu);
txtcth.Text = gridView1.Columns["Thành tiền"].SummaryText;
}
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();
}
}
}
