public void tsbtpck(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_hoadonxhgb u = new Frm_hoadonxhgb();
u.myac = new Frm_hoadonxhgb.ac(F.refreshhdxhgb);
u.getpt("tsbthdxhgb");
u.getactive(a);
u.getsub(subsys);
u.getroleid(roleid);
u.gethang(hang);
u.getkhach(khach);
u.getdate(ngaychungtu);
u.getuser(userid);
u.getbranch(branchid);
if (a == "1")
{
u.getrole(view.GetRowCellValue(view.FocusedRowHandle, "ID").ToString());
}
else
{
try
{
u.getrole(view.GetRowCellValue(view.FocusedRowHandle, "Mã kho").ToString());
}
catch { }
}
u.ShowDialog();
}
catch { MessageBox.Show("Vui lòng chọn phiếu xuất hàng gửi bán trước khi sửa."); }
}
public void checksau(string sct, int vt, ToolStripSplitButton tsbttruoc, ToolStripSplitButton tsbtsau, Frm_hoadonxhgb F, string ngay, string branchid, string ledv)
{
try
{
ledv = gen.GetString("select * from Stock where StockCode='" + ledv + "'");
tsbttruoc.Enabled = true;
string id;
if (vt == 0)
{
id = gen.GetString("select Top 1 * from SSInvoiceBranch where RefNo > '" + sct + "' and Month(PURefDate)='" + DateTime.Parse(ngay).Month.ToString() + "' and Year(PURefDate)='" + DateTime.Parse(ngay).Year.ToString() + "' and BranchID='" + branchid + "' and StockID='" + ledv + "' order by RefNo ASC");
}
else
{
id = gen.GetString("select Top 1 * from SSInvoiceBranch where RefNo > '" + sct + "' and Month(PURefDate)='" + DateTime.Parse(ngay).Month.ToString() + "' and Year(PURefDate)='" + DateTime.Parse(ngay).Year.ToString() + "' and BranchID='" + branchid + "' and StockID='" + ledv + "' order by RefNo DESC");
tsbtsau.Enabled = false;
}
F.getrole(id);
}
catch
{
tsbtsau.Enabled = false;
}
}
public void checkpck(string active, string role, Frm_hoadonxhgb F, GridView gridView1, LookUpEdit ledt, LookUpEdit ledv, TextEdit txtsct, TextEdit txtname, TextEdit txtdc, TextEdit txtldn, DateEdit denct, DateEdit denht, string ngaychungtu,
ComboBoxEdit cbthue, string userid, string branchid, TextEdit txtms, TextEdit txtkhhd, TextEdit txtshd, TextEdit txtnhd, TextEdit txthtt, TextEdit txthttt, TextEdit txtthue, ToolStripSplitButton tsbttruoc, ToolStripSplitButton tsbtsau, TextEdit txtquyen, LookUpEdit ledvx)
{
try
{
string dt = gen.GetString("select * from AccountingObject where AccountingObjectCode='" + ledt.EditValue.ToString() + "'");
string[,] detail = new string[20, 8];
string check = "0";
for (int i = 0; i < gridView1.RowCount - 1; i++)
{
if (gridView1.GetRowCellValue(i, "Mã hàng").ToString() == "")
{
check = "1";
}
else
{
string mh = gen.GetString("select * from InventoryItem where InventoryItemCode='" + gridView1.GetRowCellValue(i, "Mã hàng").ToString() + "'");
detail[i, 0] = mh;
}
if (gridView1.GetRowCellValue(i, "Số lượng").ToString() == "")
{
detail[i, 1] = "0";
}
else
{
detail[i, 1] = gridView1.GetRowCellValue(i, "Số lượng").ToString().Replace(".", "").Replace(",", ".");
}
if (gridView1.GetRowCellValue(i, "Số lượng quy đổi").ToString() == "")
{
check = "1";
}
detail[i, 2] = gridView1.GetRowCellValue(i, "Số lượng quy đổi").ToString().Replace(".", "").Replace(",", ".");
if (gridView1.GetRowCellValue(i, "Đơn giá").ToString() == "")
{
check = "1";
}
detail[i, 4] = gridView1.GetRowCellValue(i, "Đơn giá").ToString().Replace(".", "").Replace(",", ".");
if (gridView1.GetRowCellValue(i, "Thành tiền").ToString() == "")
{
check = "1";
}
detail[i, 5] = gridView1.GetRowCellValue(i, "Thành tiền").ToString().Replace(".", "");
if (gridView1.GetRowCellValue(i, "Chi phí").ToString() == "")
{
detail[i, 6] = "0";
}
else
{
detail[i, 6] = gridView1.GetRowCellValue(i, "Chi phí").ToString().Replace(".", "");
}
}
if (check == "1")
{
DevExpress.XtraEditors.XtraMessageBox.Show("Vui lòng kiểm tra lại dữ liệu <Mã hàng> <Số lượng quy đổi> <Đơn giá> <Thành tiền> !", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
string dv = gen.GetString("select * from Stock where StockCode='" + ledv.EditValue.ToString() + "'");
string dvx = gen.GetString("select * from Stock where StockCode='" + ledvx.EditValue.ToString() + "'");
string tongtien = gridView1.Columns["Thành tiền"].SummaryText.Replace(".", "");
string chiphi = gridView1.Columns["Chi phí"].SummaryText.Replace(".", "");
Double tongcong = Double.Parse(tongtien) + Double.Parse(chiphi);
if (active == "0")
{
try
{
string ton = gen.GetString("select * from SSInvoiceBranch 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 SSInvoiceBranch(RefID,BranchID,RefType,PURefDate,PUPostedDate,RefNo,AccountingObjectID,AccountingObjectName,AccountingObjectAddress,PUJournalMemo,Posted,TotalAmount,Tax,InvSeries,InvNo,DueDateTime,TotalFreightAmount,UserID,CABARefDate,No,PayNo,TotalVatAmount,StockID,ParalellRefNo,AccountingObjectID1562) values(newid(),'" + branchid + "',101,'" + denct.EditValue.ToString() + "','" + denht.EditValue.ToString() + "','" + txtsct.Text + "','" + dt + "',N'" + txtname.Text + "',N'" + txtdc.Text + "',N'" + txtldn.Text + "','False','" + tongtien + "','" + cbthue.Text + "','" + txtkhhd.Text + "','" + txtshd.Text + "','" + txthtt.Text + "','" + chiphi + "','" + userid + "','" + txtnhd.EditValue.ToString() + "','" + txtms.Text + "',N'" + txthttt.Text + "','" + txtthue.Text.Replace(".", "") + "','" + dv + "','" + txtquyen.Text + "','" + dvx + "')");
string refid = gen.GetString("select * from SSInvoiceBranch where RefNo='" + txtsct.Text + "'");
F.getrole(refid);
gen.ExcuteNonquery("insert into HACHTOAN(RefDeteail,RefID,RefNo,DebitAccount,CreditAccount,Amount,AccountingObjectID,StockID,JournalMemo,RefDate,AccountingObjectIDMain) values(newid(),'" + refid + "','" + txtsct.Text + "','1368','51112','" + tongcong.ToString() + "','" + dt + "','" + dvx + "',N'" + txtldn.Text + "','" + denct.EditValue.ToString() + "','" + dt + "')");
gen.ExcuteNonquery("insert into HACHTOAN(RefDeteail,RefID,RefNo,DebitAccount,CreditAccount,Amount,AccountingObjectID,StockID,JournalMemo,RefDate,AccountingObjectIDMain) values(newid(),'" + refid + "','" + txtsct.Text + "','1368','33311','" + txtthue.Text.Replace(".", "") + "','" + dt + "','" + dvx + "',N'" + txtldn.Text + "','" + denct.EditValue.ToString() + "','" + dt + "')");
for (int i = 0; i < gridView1.RowCount - 1; i++)
{
gen.ExcuteNonquery("insert into SSInvoiceBranchDetail(RefDetailID,RefID,Quantity,QuantityConvert,SortOrder,InventoryItemID,UnitPrice,Amount,FreightAmount) values(newid(),'" + refid + "','" + detail[i, 1] + "','" + detail[i, 2] + "'," + i + ",'" + detail[i, 0] + "','" + detail[i, 4] + "','" + detail[i, 5] + "','" + detail[i, 6] + "')");
}
}
else
{
gen.ExcuteNonquery("update SSInvoiceBranch set PURefDate='" + denct.EditValue.ToString() + "',PUPostedDate='" + denht.EditValue.ToString() + "',AccountingObjectID='" + dt + "',AccountingObjectName=N'" + txtname.Text + "', AccountingObjectAddress=N'" + txtdc.Text + "',PUJournalMemo=N'" + txtldn.Text + "',TotalAmount='" + tongtien + "',Tax='" + cbthue.Text + "',InvSeries='" + txtkhhd.Text + "',InvNo='" + txtshd.Text + "',DueDateTime=" + txthtt.Text + ",TotalFreightAmount='" + chiphi + "',UserID='" + userid + "',CABARefDate='" + txtnhd.EditValue.ToString() + "',No='" + txtms.Text + "',PayNo=N'" + txthttt.Text + "',TotalVatAmount='" + txtthue.Text.Replace(".", "") + "',StockID='" + dv + "',ParalellRefNo='" + txtquyen.Text + "',AccountingObjectID1562='" + dvx + "' where RefID='" + role + "'");
gen.ExcuteNonquery("delete from SSInvoiceBranchDetail 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 + "','1368','51112','" + tongcong.ToString() + "','" + dt + "','" + dvx + "',N'" + txtldn.Text + "','" + denct.EditValue.ToString() + "','" + dt + "')");
gen.ExcuteNonquery("insert into HACHTOAN(RefDeteail,RefID,RefNo,DebitAccount,CreditAccount,Amount,AccountingObjectID,StockID,JournalMemo,RefDate,AccountingObjectIDMain) values(newid(),'" + role + "','" + txtsct.Text + "','1368','33311','" + txtthue.Text.Replace(".", "") + "','" + dt + "','" + dvx + "',N'" + txtldn.Text + "','" + denct.EditValue.ToString() + "','" + dt + "')");
for (int i = 0; i < gridView1.RowCount - 1; i++)
{
gen.ExcuteNonquery("insert into SSInvoiceBranchDetail(RefDetailID,RefID,Quantity,QuantityConvert,SortOrder,InventoryItemID,UnitPrice,Amount,FreightAmount) values(newid(),'" + role + "','" + detail[i, 1] + "','" + detail[i, 2] + "'," + i + ",'" + detail[i, 0] + "','" + detail[i, 4] + "','" + detail[i, 5] + "','" + detail[i, 6] + "')");
}
}
F.myac();
F.getactive("1");
F.Text = "Xem phiếu hóa đơn xuất hàng gửi bán";
}
}
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 loadpck(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, Frm_hoadonxhgb F, LookUpEdit ledt, TextEdit txtldn,
ToolStripButton tsbtsua, ToolStripButton tsbtxoa, ToolStripButton tsbtcat, ToolStripButton tsbtboghi, ToolStripButton tsbtghiso, ToolStripButton tsbtnap, ToolStripButton tsbtin, string ngaychungtu, string userid, string branchid, DevExpress.XtraEditors.Repository.RepositoryItemTextEdit dongia, DevExpress.XtraEditors.Repository.RepositoryItemTextEdit thanhtien, TextEdit txtcth, DevExpress.XtraEditors.Repository.RepositoryItemTextEdit chiphi, TextEdit txtnhd, TextEdit txtms, TextEdit txtkhhd, TextEdit txtshd, ComboBoxEdit cbthue, TextEdit txthtt, TextEdit txthttt, TextEdit txtttthue, ToolStripSplitButton tsbttruoc, ToolStripSplitButton tsbtsau, DataTable khach, DataTable hang, TextEdit txtquyen, LookUpEdit ledvx)
{
DataTable dt = new DataTable();
loadstart(gridControl1, gridView1, ledv, ledt, denct, denht, mahang, soluong, soluongqd, tsbtsua, tsbtxoa, tsbtcat, tsbtboghi, tsbtghiso, tsbtnap, tsbtin, ngaychungtu, userid, branchid, active, dt, dongia, thanhtien, chiphi, txtnhd, cbthue, khach, hang, ledvx);
if (active == "1")
{
DataTable da = new DataTable();
F.Text = "Xem hóa đơn xuất hàng gửi bán";
da = gen.GetTable("select AccountingObjectCode,RefNo,Posted,AccountingObjectType,Cancel,PUPostedDate,PURefDate,CABARefDate,PUJournalMemo,TotalAmount,DueDateTime,AccountingObjectID1562,Tax,No,InvSeries,InvNo,PayNo,TotalVatAmount,StockCode,ParalellRefNo,AccountingObjectID1562 from SSInvoiceBranch a, AccountingObject b, Stock c where a.StockID=c.StockID and a.AccountingObjectID=b.AccountingObjectID and RefID='" + role + "'");
ledv.EditValue = da.Rows[0][18].ToString();
ledt.EditValue = da.Rows[0][0].ToString();
txtldn.Text = da.Rows[0][8].ToString();
denct.EditValue = DateTime.Parse(da.Rows[0][6].ToString());
denht.EditValue = DateTime.Parse(da.Rows[0][5].ToString());
txtsct.Text = da.Rows[0][1].ToString();
txtms.Text = da.Rows[0][13].ToString();
txtkhhd.Text = da.Rows[0][14].ToString();
txtshd.Text = da.Rows[0][15].ToString();
txtnhd.EditValue = DateTime.Parse(da.Rows[0][7].ToString());
txthtt.Text = da.Rows[0][10].ToString();
txthttt.Text = da.Rows[0][16].ToString();
cbthue.Text = da.Rows[0][12].ToString();
txtquyen.Text = da.Rows[0][19].ToString();
Double tienthue = 0;
try
{
ledvx.EditValue = gen.GetString("select StockCode from Stock where StockID='" + da.Rows[0][20].ToString() + "'");
}
catch
{
ledvx.EditValue = null;
}
try
{
tienthue = Double.Parse(da.Rows[0][17].ToString());
}
catch { }
if (da.Rows[0][2].ToString() == "True")
{
tsbtghiso.Visible = false;
tsbtboghi.Visible = true;
tsbtsua.Enabled = false;
}
else
{
tsbtboghi.Visible = false;
tsbtghiso.Visible = true;
tsbtsua.Enabled = true;
}
da = gen.GetTable("select InventoryItemCode,InventoryItemName,Quantity,QuantityConvert,a.UnitPrice,a.Amount,FreightAmount from SSInvoiceBranchDetail a,InventoryItem b where a.InventoryItemID=b.InventoryItemID and RefID='" + role + "' order by SortOrder");
for (int i = 0; i < da.Rows.Count; i++)
{
DataRow dr = dt.NewRow();
dr[0] = da.Rows[i][0].ToString();
dr[1] = da.Rows[i][1].ToString();
dr[2] = da.Rows[i][2].ToString();
dr[3] = da.Rows[i][3].ToString();
dr[4] = da.Rows[i][4].ToString();
dr[5] = da.Rows[i][5].ToString();
dr[6] = da.Rows[i][6].ToString();
dt.Rows.Add(dr);
}
gridControl1.DataSource = dt;
Double tongthanhtien = Double.Parse(gridView1.Columns["Thành tiền"].SummaryText);
Double tongchiphi = Double.Parse(gridView1.Columns["Chi phí"].SummaryText);
txtcth.Text = String.Format("{0:n0}", tongthanhtien + tongchiphi);
txtttthue.EditValue = tienthue;
checktruocsau(tsbttruoc, tsbtsau, ledv.EditValue.ToString(), txtsct.Text, ngaychungtu, branchid);
}
else
{
if (role == null)
{
ledv.ItemIndex = 0;
}
else
{
ledv.EditValue = role;
}
cbthue.EditValue = "10";
ledvx.ItemIndex = 0;
F.Text = "Thêm hóa đơn xuất hàng gửi bán";
denct.EditValue = DateTime.Parse(ngaychungtu);
denht.EditValue = DateTime.Parse(ngaychungtu);
txtnhd.EditValue = DateTime.Parse(ngaychungtu);
}
}
