public void tsbtpctmvt(string a, Form1 F, DevExpress.XtraGrid.Views.Grid.GridView view, string roleid, string subsys, string ngaychungtu, string userid, DataTable khach, DataTable hang)
{
try
{
Frm_phieuthuvt u = new Frm_phieuthuvt();
u.myac = new Frm_phieuthuvt.ac(F.refreshpctmvt);
u.getactive(a);
u.getroleid(roleid);
u.getsub(subsys);
u.getuser(userid);
u.getkhach(khach);
u.gethang(hang);
u.getpt("pctmvt");
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 thu tiền mặt bán vật tư trước khi sửa."); }
}
//save//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public void checkpctmvt(string active, string role, Frm_phieuthuvt F, GridView gridView1, LookUpEdit ledt, LookUpEdit ledv, ComboBoxEdit cbldt, TextEdit txtsct, TextEdit txtname, TextEdit txtdc,
TextEdit txtnn, TextEdit txtctg, TextEdit txtldn, DateEdit denct, DateEdit denht, ToolStripButton tsbtboghi, ToolStripButton tsbtghiso, ToolStripButton tsbtxoa,
ToolStripButton tsbtcat, ToolStripButton tsbtin, ToolStripButton tsbtsua, ToolStripButton tsbtnap, string ngaychungtu, ComboBoxEdit cbthue, TextEdit txtshd, TextEdit txtkhhd, TextEdit txtnhd, string userid, ToolStripSplitButton tsbttruoc, ToolStripSplitButton tsbtsau)
{
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, "Tài khoản có").ToString() == "")
{
check = "1";
}
detail[i, 0] = gridView1.GetRowCellValue(i, "Tài khoản có").ToString();
if (gridView1.GetRowCellValue(i, "Tài khoản nợ").ToString() == "")
{
check = "1";
}
detail[i, 1] = gridView1.GetRowCellValue(i, "Tài khoản nợ").ToString();
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, 2] = mh;
}
if (gridView1.GetRowCellValue(i, "Số lượng").ToString() == "")
{
check = "1";
}
detail[i, 3] = gridView1.GetRowCellValue(i, "Số lượng").ToString().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 (check == "1")
{
DevExpress.XtraEditors.XtraMessageBox.Show("Vui lòng kiểm tra lại dữ liệu <Tài khoản có> <Tài khoản nợ> <Mã hàng> <Số lượng> <Đơ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 tong = gridView1.Columns["Thành tiền"].SummaryText;
tong = tong.Replace(".", "");
string ldt;
if (cbldt.EditValue.ToString() == "Khách hàng")
{
ldt = "0";
}
else if (cbldt.EditValue.ToString() == "Nhà cung cấp")
{
ldt = "1";
}
else
{
ldt = "2";
}
string nhd = txtnhd.Text;
if (active == "0")
{
try
{
string ton = gen.GetString("select * from SUCAPayment where RefNo='" + txtsct.Text + "'");
themsct(ngaychungtu, txtsct, ledv.EditValue.ToString(), 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 { }
if (nhd == "")
{
gen.ExcuteNonquery("insert into SUCAPayment(RefID,RefType,RefDate,PostedDate,RefNo,AccountingObjectID,AccountingObjectName,AccountingObjectAddress,Contactname,JournalMemo,DocumentIncluded,Posted,StockID,AccountingObjectType,TotalAmount,Tax,InvSeries,InvNo,EmployeeID) values(newid(),101,'" + denct.EditValue.ToString() + "','" + denht.EditValue.ToString() + "','" + txtsct.Text + "','" + dt + "',N'" + txtname.Text + "','" + txtdc.Text + "',N'" + txtnn.Text + "',N'" + txtldn.Text + "',N'" + txtctg.Text + "','False','" + dv + "','" + ldt + "','" + tong + "','" + cbthue.Text + "','" + txtkhhd.Text + "','" + txtshd.Text + "','" + userid + "')");
}
else
{
gen.ExcuteNonquery("insert into SUCAPayment(RefID,RefType,RefDate,PostedDate,RefNo,AccountingObjectID,AccountingObjectName,AccountingObjectAddress,Contactname,JournalMemo,DocumentIncluded,Posted,StockID,AccountingObjectType,TotalAmount,Tax,InvDate,InvSeries,InvNo,EmployeeID) values(newid(),101,'" + denct.EditValue.ToString() + "','" + denht.EditValue.ToString() + "','" + txtsct.Text + "','" + dt + "',N'" + txtname.Text + "','" + txtdc.Text + "',N'" + txtnn.Text + "',N'" + txtldn.Text + "',N'" + txtctg.Text + "','False','" + dv + "','" + ldt + "','" + tong + "','" + cbthue.Text + "','" + txtnhd.EditValue.ToString() + "','" + txtkhhd.Text + "','" + txtshd.Text + "','" + userid + "')");
}
string refid = gen.GetString("select * from SUCAPayment where RefNo='" + txtsct.Text + "'");
F.getrole(refid);
for (int i = 0; i < gridView1.RowCount - 1; i++)
{
gen.ExcuteNonquery("insert into SUCAPaymentDetail(RefDetailID,RefID,DebitAccount,CreditAccount,Amount,Quantity,SortOrder,InventoryItemID,SalePrice) values(newid(),'" + refid + "','" + detail[i, 1] + "','" + detail[i, 0] + "','" + detail[i, 5] + "','" + detail[i, 3] + "'," + i + ",'" + detail[i, 2] + "','" + detail[i, 4] + "')");
gen.ExcuteNonquery("insert into HACHTOAN(RefDeteail,RefID,RefNo,DebitAccount,CreditAccount,Amount,AccountingObjectID,StockID,JournalMemo,RefDate,AccountingObjectIDMain,Goods) values(newid(),'" + refid + "','" + txtsct.Text + "','" + detail[i, 1] + "','" + detail[i, 0] + "','" + detail[i, 5] + "','" + dt + "','" + dv + "',N'" + txtldn.Text + "','" + denct.EditValue.ToString() + "','" + dt + "','" + dv + "')");
}
}
else
{
if (nhd == "")
{
gen.ExcuteNonquery("update SUCAPayment set RefDate='" + denct.EditValue.ToString() + "',PostedDate='" + denht.EditValue.ToString() + "',AccountingObjectID='" + dt + "',AccountingObjectName=N'" + txtname.Text + "',AccountingObjectAddress='" + txtdc.Text + "',Contactname=N'" + txtnn.Text + "',JournalMemo=N'" + txtldn.Text + "',DocumentIncluded=N'" + txtctg.Text + "',StockID='" + dv + "',AccountingObjectType='" + ldt + "',TotalAmount='" + tong + "',Posted='False',Tax='" + cbthue.Text + "',InvSeries='" + txtkhhd.Text + "',InvNo='" + txtshd.Text + "',EmployeeID='" + userid + "' where RefID='" + role + "'");
}
else
{
gen.ExcuteNonquery("update SUCAPayment set RefDate='" + denct.EditValue.ToString() + "',PostedDate='" + denht.EditValue.ToString() + "',AccountingObjectID='" + dt + "',AccountingObjectName=N'" + txtname.Text + "',AccountingObjectAddress='" + txtdc.Text + "',Contactname=N'" + txtnn.Text + "',JournalMemo=N'" + txtldn.Text + "',DocumentIncluded=N'" + txtctg.Text + "',StockID='" + dv + "',AccountingObjectType='" + ldt + "',TotalAmount='" + tong + "',Posted='False',Tax='" + cbthue.Text + "',InvSeries='" + txtkhhd.Text + "',InvNo='" + txtshd.Text + "',InvDate='" + txtnhd.EditValue.ToString() + "',EmployeeID='" + userid + "' where RefID='" + role + "'");
}
gen.ExcuteNonquery("delete from SUCAPaymentDetail where RefID='" + role + "'");
gen.ExcuteNonquery("delete HACHTOAN where RefID='" + role + "'");
for (int i = 0; i < gridView1.RowCount - 1; i++)
{
gen.ExcuteNonquery("insert into SUCAPaymentDetail(RefDetailID,RefID,DebitAccount,CreditAccount,Amount,Quantity,SortOrder,InventoryItemID,SalePrice) values(newid(),'" + role + "','" + detail[i, 1] + "','" + detail[i, 0] + "','" + detail[i, 5] + "','" + detail[i, 3] + "'," + i + ",'" + detail[i, 2] + "','" + detail[i, 4] + "')");
gen.ExcuteNonquery("insert into HACHTOAN(RefDeteail,RefID,RefNo,DebitAccount,CreditAccount,Amount,AccountingObjectID,StockID,JournalMemo,RefDate,AccountingObjectIDMain,Goods) values(newid(),'" + role + "','" + txtsct.Text + "','" + detail[i, 1] + "','" + detail[i, 0] + "','" + detail[i, 5] + "','" + dt + "','" + dv + "',N'" + txtldn.Text + "','" + denct.EditValue.ToString() + "','" + dt + "','" + dv + "')");
}
}
F.myac();
F.getactive("1");
F.Text = "Xem phiếu thu tiền mặt bán vật tư";
}
}
catch
{
XtraMessageBox.Show("Vui lòng chọn đối tượng trước khi lưu", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
