public void tsbtpxhmtl(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_phieuxuathangmuatralai u = new Frm_phieuxuathangmuatralai();
u.myac = new Frm_phieuxuathangmuatralai.ac(F.refreshpxhmtl);
u.getactive(a);
u.getroleid(roleid);
u.getsub(subsys);
u.gethang(hang);
u.getkhach(khach);
u.getpt("pxtl");
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."); }
}
//save//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public void checkpndc(string active, string role, Frm_phieuxuathangmuatralai 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, 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 - 1; 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 INReOutward 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 INReOutward(RefID,RefType,RefDate,PostedDate,RefNo,AccountingObjectID,AccountingObjectName,JournalMemo,Posted,StockID,TotalAmount,InvSeries,InvNo,InvDate,EmployeeID,No,Tax,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() + "','" + txtthue.Text.Replace(".", "") + "')");
string refid = gen.GetString("select * from INReOutward 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,AccountingObjectIDMain) values(newid(),'" + refid + "','" + txtsct.Text + "','331','1561','" + 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,AccountingObjectIDMain) values(newid(),'" + refid + "','" + txtsct.Text + "','331','1331','" + txtthue.Text.Replace(".", "") + "','" + dt + "','" + dv + "',N'" + txtldn.Text + "','" + denct.EditValue.ToString() + "','" + dt + "')");
F.getrole(refid);
for (int i = 0; i < gridView1.RowCount; i++)
{
try
{
gen.ExcuteNonquery("insert into INReOutwardDetail(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
{
gen.ExcuteNonquery("update INReOutward 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() + "',TotalVATAmount='" + txtthue.Text.Replace(".", "") + "' where RefID='" + role + "'");
gen.ExcuteNonquery("delete from INReOutwardDetail 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,AccountingObjectIDMain) values(newid(),'" + role + "','" + txtsct.Text + "','331','1561','" + 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,AccountingObjectIDMain) values(newid(),'" + role + "','" + txtsct.Text + "','331','1331','" + txtthue.Text.Replace(".", "") + "','" + dt + "','" + dv + "',N'" + txtldn.Text + "','" + denct.EditValue.ToString() + "','" + dt + "')");
for (int i = 0; i < gridView1.RowCount; i++)
{
try
{
gen.ExcuteNonquery("insert into INReOutwardDetail(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 { }
}
}
F.myac();
F.getactive("1");
F.Text = "Xem phiếu xuất hàng mua 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 loadpxhmtl(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_phieuxuathangmuatralai 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, string userid, string branchid, TextEdit txtms, ComboBoxEdit cbthue, 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")
{
DataTable da = new DataTable();
da = gen.GetTable("select Amount,InventoryItemCode,a.UnitPrice,a.UnitPriceCost,Quantity,QuantityConvert,InventoryItemName from INReOutwardDetail 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][1].ToString();
dr[1] = da.Rows[i][6].ToString();
dr[2] = da.Rows[i][4].ToString();
dr[3] = da.Rows[i][5].ToString();
dr[4] = da.Rows[i][2].ToString();
dr[6] = da.Rows[i][0].ToString();
dt.Rows.Add(dr);
}
gridControl1.DataSource = dt;
tsbtcat.Enabled = false;
F.Text = "Xem phiếu xuất hàng mua 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 from INReOutward 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();
txtldn.Text = da.Rows[0][2].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();
txtnhd.EditValue = DateTime.Parse(da.Rows[0][12].ToString());
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;
}
txtcth.Text = gridView1.Columns["Thành tiền"].SummaryText;
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;
}
cbthue.SelectedIndex = 2;
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();
}
}
}
