public void tsbtpck(string a, Form1 F, DevExpress.XtraGrid.Views.Grid.GridView view, string roleid, string subsys, string ngaychungtu, string userid, string branchid, string tsbt, DataTable khach, DataTable hang)
{
try
{
Frm_chuyenkhonb u = new Frm_chuyenkhonb();
u.myac = new Frm_chuyenkhonb.ac(F.refreshxhgbvlpg);
u.getactive(a);
u.getsub(subsys);
u.gethang(hang);
u.getkhach(khach);
u.getroleid(roleid);
if (tsbt == "tsbtpnhgbvlpg")
{
u.getpt(tsbt);
}
else
{
u.getpt("pxhgbvlpg");
}
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.getrole(gen.GetString("select Top 1 StockCode from Stock where StockID in (select StockID from MSC_UserJoinStock where UserID='" + userid + "') order by StockCode"));
}
}
u.ShowDialog();
}
catch { MessageBox.Show("Vui lòng chọn phiếu xuất hàng gửi bán vỏ LPG trước khi sửa."); }
}
public void checksau(string sct, int vt, ToolStripSplitButton tsbttruoc, ToolStripSplitButton tsbtsau, Frm_chuyenkhonb F, string ngay, string mk, string tsbt)
{
try
{
string idkho = gen.GetString("select * from Stock where StockCode='" + mk + "'");
tsbttruoc.Enabled = true;
string id;
if (vt == 0)
{
if (tsbt == "tsbtpnhgbvlpg")
{
id = gen.GetString("select Top 1 * from INTransferBranchSU where RefNoIn > '" + sct + "' and Month(RefDate)='" + DateTime.Parse(ngay).Month.ToString() + "' and Year(RefDate)='" + DateTime.Parse(ngay).Year.ToString() + "' and InwardStockID='" + idkho + "' order by RefNoIn ASC");
}
else
{
id = gen.GetString("select Top 1 * from INTransferBranchSU where RefNo > '" + sct + "' and Month(RefDate)='" + DateTime.Parse(ngay).Month.ToString() + "' and Year(RefDate)='" + DateTime.Parse(ngay).Year.ToString() + "' and OutwardStockID='" + idkho + "' order by RefNo ASC");
}
}
else
{
if (tsbt == "tsbtpnhgbvlpg")
{
id = gen.GetString("select Top 1 * from INTransferBranchSU where RefNoIn > '" + sct + "' and Month(RefDate)='" + DateTime.Parse(ngay).Month.ToString() + "' and Year(RefDate)='" + DateTime.Parse(ngay).Year.ToString() + "' and InwardStockID='" + idkho + "' order by RefNoIn DESC");
}
else
{
id = gen.GetString("select Top 1 * from INTransferBranchSU where RefNo > '" + sct + "' and Month(RefDate)='" + DateTime.Parse(ngay).Month.ToString() + "' and Year(RefDate)='" + DateTime.Parse(ngay).Year.ToString() + "' and OutwardStockID='" + idkho + "' order by RefNo DESC");
}
tsbtsau.Enabled = false;
}
F.getrole(id);
}
catch
{
tsbtsau.Enabled = false;
}
}
public void checkpck(string active, string role, Frm_chuyenkhonb F, GridView gridView1, LookUpEdit ledt, LookUpEdit ledv, LookUpEdit ledvn, TextEdit txtsct, TextEdit txtname, TextEdit txtngh, TextEdit txtldn, DateEdit denct, DateEdit denht, ToolStripButton tsbtboghi, ToolStripButton tsbtghiso, ToolStripButton tsbtxoa,
ToolStripButton tsbtcat, ToolStripButton tsbtin, ToolStripButton tsbtsua, ToolStripButton tsbtnap, string ngaychungtu, TextEdit txtptvc, string userid, string branchid, TextEdit txtpnv, TextEdit txtms, TextEdit txtkhhd, TextEdit txtshd, TextEdit txtnhd, ToolStripSplitButton tsbttruoc, ToolStripSplitButton tsbtsau, string bat)
{
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(".", "");
}
detail[i, 2] = gridView1.GetRowCellValue(i, "Số lượng").ToString().Replace(".", "");
if (gridView1.GetRowCellValue(i, "Đơn giá").ToString() == "")
{
detail[i, 4] = "0";
}
else
{
detail[i, 4] = gridView1.GetRowCellValue(i, "Đơn giá").ToString().Replace(".", "").Replace(",", ".");
}
if (gridView1.GetRowCellValue(i, "Thành tiền").ToString() == "")
{
detail[i, 5] = "0";
}
else
{
detail[i, 5] = gridView1.GetRowCellValue(i, "Thành tiền").ToString().Replace(".", "");
}
detail[i, 3] = gridView1.GetRowCellValue(i, "Diễn giải").ToString();
}
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 dvn = gen.GetString("select * from Stock where StockCode='" + ledvn.EditValue.ToString() + "'");
string tongtien = gridView1.Columns["Thành tiền"].SummaryText.Replace(".", "");
if (active == "0")
{
try
{
string ton = gen.GetString("select * from INTransferBranchSU 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 { }
try
{
string ton = gen.GetString("select * from INTransferBranchSU where RefNoIn='" + txtpnv.Text + "'");
themsctn(ngaychungtu, txtpnv, ledvn.EditValue.ToString());
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 INTransferBranchSU(RefID,RefType,RefDate,PostedDate,RefNo,RefNoIn,AccountingObjectID,AccountingObjectName,Contactname,JournalMemo,Posted,OutwardStockID,InwardStockID,ShippingNo,TotalAmount,No,InvSeries,InvNo,InvDate) values(newid(),101,'" + denct.EditValue.ToString() + "','" + denht.EditValue.ToString() + "','" + txtsct.Text + "','" + txtpnv.Text + "','" + dt + "',N'" + txtname.Text + "',N'" + txtngh.Text + "',N'" + txtldn.Text + "','False','" + dv + "','" + dvn + "','" + txtptvc.Text + "','" + tongtien + "','" + txtms.Text + "','" + txtkhhd.Text + "','" + txtshd.Text + "','" + txtnhd.EditValue.ToString() + "')");
string refid = gen.GetString("select * from INTransferBranchSU where RefNo='" + txtsct.Text + "'");
F.getrole(refid);
if (DateTime.Parse(ngaychungtu) < DateTime.Parse("09/01/2017"))
{
gen.ExcuteNonquery("insert into HACHTOAN(RefDeteail,RefID,RefNo,DebitAccount,CreditAccount,Amount,AccountingObjectID,StockID,JournalMemo,RefDate,AccountingObjectIDMain) values(newid(),'" + refid + "','" + txtsct.Text + "','336','1563','" + tongtien + "','" + 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 + "','" + txtpnv.Text + "','1563','336','" + tongtien + "','" + dt + "','" + dvn + "',N'" + txtldn.Text + "','" + denct.EditValue.ToString() + "','" + dt + "')");
}
for (int i = 0; i < gridView1.RowCount - 1; i++)
{
gen.ExcuteNonquery("insert into INTransferBranchSUDetail(RefDetailID,RefID,Quantity,QuantityConvert,SortOrder,InventoryItemID,Description,UnitPrice,Amount) values(newid(),'" + refid + "','" + detail[i, 1] + "','" + detail[i, 2] + "'," + i + ",'" + detail[i, 0] + "',N'" + detail[i, 3] + "','" + detail[i, 4] + "','" + detail[i, 5] + "')");
}
}
else
{
if (bat == "1")
{
try
{
string ton = gen.GetString("select * from INTransferBranchSU where RefNoIn='" + txtpnv.Text + "'");
themsctn(ngaychungtu, txtpnv, ledvn.EditValue.ToString());
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("update INTransferBranchSU set RefDate='" + denct.EditValue.ToString() + "',PostedDate='" + denht.EditValue.ToString() + "',AccountingObjectID='" + dt + "',AccountingObjectName=N'" + txtname.Text + "',Contactname=N'" + txtngh.Text + "',JournalMemo=N'" + txtldn.Text + "',RefNoIn='" + txtpnv.Text + "',InwardStockID='" + dvn + "',Posted='False',ShippingNo='" + txtptvc.Text + "',TotalAmount='" + tongtien + "',No='" + txtms.Text + "',InvSeries='" + txtkhhd.Text + "',InvNo='" + txtshd.Text + "',InvDate='" + txtnhd.EditValue.ToString() + "' where RefID='" + role + "'");
gen.ExcuteNonquery("delete from INTransferBranchSUDetail where RefID='" + role + "'");
gen.ExcuteNonquery("delete HACHTOAN where RefID='" + role + "'");
if (DateTime.Parse(ngaychungtu) < DateTime.Parse("09/01/2017"))
{
gen.ExcuteNonquery("insert into HACHTOAN(RefDeteail,RefID,RefNo,DebitAccount,CreditAccount,Amount,AccountingObjectID,StockID,JournalMemo,RefDate,AccountingObjectIDMain) values(newid(),'" + role + "','" + txtsct.Text + "','336','1563','" + tongtien + "','" + 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 + "','" + txtpnv.Text + "','1563','336','" + tongtien + "','" + dt + "','" + dvn + "',N'" + txtldn.Text + "','" + denct.EditValue.ToString() + "','" + dt + "')");
}
for (int i = 0; i < gridView1.RowCount - 1; i++)
{
gen.ExcuteNonquery("insert into INTransferBranchSUDetail(RefDetailID,RefID,Quantity,QuantityConvert,SortOrder,InventoryItemID,Description,UnitPrice,Amount) values(newid(),'" + role + "','" + detail[i, 1] + "','" + detail[i, 2] + "'," + i + ",'" + detail[i, 0] + "',N'" + detail[i, 3] + "','" + detail[i, 4] + "','" + detail[i, 5] + "')");
}
}
F.myac();
F.getactive("1");
F.Text = "Xem phiếu xuất hàng gửi bán vỏ LPG";
}
}
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 ledvn, LookUpEdit ledv, DateEdit denct, DateEdit denht,
DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit mahang, DevExpress.XtraEditors.Repository.RepositoryItemTextEdit soluong, DevExpress.XtraEditors.Repository.RepositoryItemTextEdit soluongqd, Frm_chuyenkhonb 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, TextEdit txtngh, TextEdit txtptvc, DevExpress.XtraEditors.Repository.RepositoryItemTextEdit dongia, DevExpress.XtraEditors.Repository.RepositoryItemTextEdit thanhtien, TextEdit txtpnv, TextEdit txtcth, DevExpress.XtraEditors.Repository.RepositoryItemTextEdit chiphi, TextEdit txtnhd, TextEdit txtms, TextEdit txtkhhd, TextEdit txtshd, ToolStripSplitButton tsbttruoc, ToolStripSplitButton tsbtsau, string tsbt, DataTable khach, DataTable hang, CheckEdit nhan)
{
DataTable dt = new DataTable();
loadstart(gridControl1, gridView1, ledvn, ledv, ledt, denct, denht, mahang, soluong, soluongqd, tsbtsua, tsbtxoa, tsbtcat, tsbtboghi, tsbtghiso, tsbtnap, tsbtin, ngaychungtu, userid, branchid, active, dt, dongia, thanhtien, chiphi, txtnhd, khach, hang);
if (active == "1")
{
DataTable da = new DataTable();
da = gen.GetTable("select InventoryItemCode,Quantity,Description,InventoryItemName,a.UnitPrice,a.Amount from INTransferBranchSUDetail 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][3].ToString();
dr[2] = da.Rows[i][1].ToString();
dr[3] = da.Rows[i][4].ToString();
dr[4] = da.Rows[i][5].ToString();
dr[5] = da.Rows[i][2].ToString();
dt.Rows.Add(dr);
}
gridControl1.DataSource = dt;
tsbtcat.Enabled = false;
F.Text = "Xem phiếu xuất hàng gửi bán vỏ LPG";
da = gen.GetTable("select AccountingObjectCode,a.Contactname,JournalMemo,InvSeries,RefDate,PostedDate,RefNo,OutwardStockID,Posted,InvNo,Cancel,ShippingNo,RefNoIn,InwardStockID,No,InvDate,PostVersion from INTransferBranchSU a, AccountingObject b where a.AccountingObjectID=b.AccountingObjectID and RefID='" + role + "'");
string kho = gen.GetString("select StockCode from Stock where StockID='" + da.Rows[0][7].ToString() + "'");
string khon = gen.GetString("select StockCode from Stock where StockID='" + da.Rows[0][13].ToString() + "'");
ledvn.EditValue = khon;
ledv.EditValue = kho;
ledt.EditValue = da.Rows[0][0].ToString();
txtldn.Text = da.Rows[0][2].ToString();
txtshd.Text = da.Rows[0][9].ToString();
txtkhhd.Text = da.Rows[0][3].ToString();
txtms.Text = da.Rows[0][14].ToString();
txtnhd.EditValue = DateTime.Parse(da.Rows[0][15].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();
txtpnv.Text = da.Rows[0][12].ToString();
txtngh.Text = da.Rows[0][1].ToString();
txtptvc.Text = da.Rows[0][11].ToString();
if (da.Rows[0][8].ToString() == "True")
{
tsbtghiso.Visible = false;
tsbtboghi.Visible = true;
tsbtsua.Enabled = false;
nhan.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][16].ToString() == "1")
{
nhan.Checked = true;
}
else
{
nhan.Checked = false;
}
Double tongthanhtien = Double.Parse(gridView1.Columns["Thành tiền"].SummaryText);
txtcth.Text = String.Format("{0:n0}", tongthanhtien);
if (tsbt == "tsbtpnhgbvlpg")
{
checktruocsaunhap(tsbttruoc, tsbtsau, ledvn.EditValue.ToString(), txtpnv.Text, ngaychungtu);
}
else
{
checktruocsau(tsbttruoc, tsbtsau, ledv.EditValue.ToString(), txtsct.Text, ngaychungtu);
}
}
else
{
F.Text = "Thêm phiếu xuất hàng gửi bán vỏ LPG";
if (role == null)
{
ledv.ItemIndex = 0;
}
else
{
ledv.EditValue = role;
}
denht.EditValue = DateTime.Parse(ngaychungtu);
txtnhd.EditValue = DateTime.Parse(ngaychungtu);
denct.EditValue = DateTime.Parse(ngaychungtu);
nhan.Checked = false;
}
}
public void searchform(string item, string thang, string nam, string userid)
{
DataTable temp = new DataTable();
string id, ngaychungtu, makho;
if (item.IndexOf("HDMH") >= 0)
{
temp = gen.GetTable("select RefID,PURefDate,BranchID from PUInvoice where Month(PURefDate)='" + thang + "' and Year(PURefDate)='" + nam + "' and substring(RefNo,4,12)='" + item + "'");
id = temp.Rows[0][0].ToString();
ngaychungtu = temp.Rows[0][1].ToString();
makho = temp.Rows[0][2].ToString();
Frm_hdmuahang u = new Frm_hdmuahang();
u.getactive("1");
u.getuser(userid);
u.getdate(ngaychungtu);
u.gethang(hang);
u.getkhach(khach);
u.getbranch(makho);
u.getrole(id);
u.ShowDialog();
}
else if (item.IndexOf("HDBH") >= 0)
{
string roleid = gen.GetString("select RoleID from MSC_UserJoinRole where UserID='" + userid + "'");
temp = gen.GetTable("select RefID,PURefDate,BranchID,IsExport from SSInvoice where Month(PURefDate)='" + thang + "' and Year(PURefDate)='" + nam + "' and substring(RefNo,4,12)='" + item + "'");
id = temp.Rows[0][0].ToString();
ngaychungtu = temp.Rows[0][1].ToString();
makho = temp.Rows[0][2].ToString();
if (temp.Rows[0][3].ToString() == "True")
{
Frm_hdbhkpx u = new Frm_hdbhkpx();
u.getactive("1");
u.getuser(userid);
u.getdate(ngaychungtu);
u.getbranch(makho);
u.getroleid(roleid);
u.getpt("pxk");
u.getsub("PUmnuBusinessPUInvoiceWithoutStockList");
u.gethang(hang);
u.getkhach(khach);
u.getrole(id);
u.ShowDialog();
}
else
{
Frm_hdbanhang u = new Frm_hdbanhang();
u.getactive("1");
u.getuser(userid);
u.getdate(ngaychungtu);
u.getbranch(makho);
u.getroleid(roleid);
u.getsub("PUmnuBusinessPUInvoiceWithoutStockList");
u.gethang(hang);
u.getkhach(khach);
u.getrole(id);
u.ShowDialog();
}
}
else if (item.IndexOf("XKNB") >= 0)
{
temp = gen.GetTable("select RefID,RefDate,OutwardStockID from INTransfer where Month(RefDate)='" + thang + "' and Year(RefDate)='" + nam + "' and substring(RefNo,4,12)='" + item + "'");
id = temp.Rows[0][0].ToString();
ngaychungtu = temp.Rows[0][1].ToString();
makho = temp.Rows[0][2].ToString();
Frm_chuyenkhonb u = new Frm_chuyenkhonb();
u.getpt("tsbtpncknb");
u.getactive("1");
u.getuser(userid);
u.gethang(hang);
u.getkhach(khach);
u.getdate(ngaychungtu);
u.getbranch(makho);
u.getrole(id);
u.ShowDialog();
}
}
public Form getCNB(Frm_chuyenkhonb a)
{
CNB = a;
return(CNB);
}
