public void tsbtpnk(string a, Form1 F, DevExpress.XtraGrid.Views.Grid.GridView view, string roleid, string subsys, string ngaychungtu, string userid, string branchid)
{
try
{
Frm_phieunhapgas u = new Frm_phieunhapgas();
u.myac = new Frm_phieunhapgas.ac(F.refreshpnkgas);
u.getactive(a);
u.getroleid(roleid);
u.getsub(subsys);
u.getpt("pnk");
u.getdate(ngaychungtu);
u.getuser(userid);
u.getbranch(branchid);
/*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 kho Gas trước khi sửa."); }
}
public void checkpnk(string active, string role, Frm_phieunhapgas F, GridView gridView1, GridView gridView2, LookUpEdit ledt, LookUpEdit ledv, ComboBoxEdit cbldt, TextEdit txtsct, TextEdit txtname, TextEdit txtdc,
TextEdit txtngh, TextEdit txtctg, TextEdit txtldn, DateEdit denct, DateEdit denht, ToolStripButton tsbtboghi, ToolStripButton tsbtghiso, ToolStripButton tsbtxoa,
ToolStripButton tsbtcat, ToolStripSplitButton tsbtin, ToolStripButton tsbtsua, ToolStripButton tsbtnap, string ngaychungtu, TextEdit txtmst, TextEdit txtptvc, string userid, string branchid, TextEdit txtpnv, LookUpEdit lenv, ToolStripSplitButton tsbttruoc, ToolStripSplitButton tsbtsau)
{
try
{
string dt = gen.GetString("select * from AccountingObject where AccountingObjectCode='" + ledt.EditValue.ToString() + "'");
string[,] detail = new string[20, 8];
string[,] detail1 = 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(",", ".");
detail[i, 3] = gridView1.GetRowCellValue(i, "Diễn giải").ToString();
}
for (int i = 0; i < gridView2.RowCount; i++)
{
if (gridView2.GetRowCellValue(i, "Mã hàng").ToString() == "")
{
check = "1";
}
else
{
string mh = gen.GetString("select * from InventoryItem where InventoryItemCode='" + gridView2.GetRowCellValue(i, "Mã hàng").ToString() + "'");
detail1[i, 0] = mh;
}
if (gridView2.GetRowCellValue(i, "Số lượng").ToString() == "")
{
check = "1";
}
detail1[i, 1] = gridView2.GetRowCellValue(i, "Số lượng").ToString().Replace(".", "");
detail1[i, 2] = gridView2.GetRowCellValue(i, "Số lượng").ToString().Replace(".", "");
detail1[i, 3] = gridView2.GetRowCellValue(i, "Diễn giải").ToString();
if (gridView2.GetRowCellValue(i, "Đơn giá").ToString() == "")
{
check = "1";
}
detail1[i, 4] = gridView2.GetRowCellValue(i, "Đơn giá").ToString().Replace(".", "");
if (gridView2.GetRowCellValue(i, "Thành tiền").ToString() == "")
{
check = "1";
}
detail1[i, 5] = gridView2.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 <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 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 tongtien = gridView2.Columns["Thành tiền"].SummaryText.Replace(".", "");
string nv = "";
try
{
nv = gen.GetString("select * from AccountingObject where AccountingObjectCode='" + lenv.EditValue.ToString() + "'");
}
catch { }
if (active == "0")
{
try
{
string ton = gen.GetString("select * from INInward where RefNo='" + txtsct.Text + "'");
themsct(ngaychungtu, txtsct, ledv.EditValue.ToString(), branchid, txtpnv, 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 INInwardSU where RefNo='" + txtpnv.Text + "'");
themsct(ngaychungtu, txtsct, ledv.EditValue.ToString(), branchid, txtpnv, 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 " + txtpnv.Text, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch { }
try
{
gen.ExcuteNonquery("insert into INInward(RefID,RefType,RefDate,PostedDate,RefNo,AccountingObjectID,AccountingObjectName,AccountingObjectAddress,Contactname,JournalMemo,DocumentIncluded,Posted,StockID,AccountingObjectType,ShippingNo,EmployeeID,EmployeeIDPU) values(newid(),101,'" + denct.EditValue.ToString() + "','" + denht.EditValue.ToString() + "','" + txtsct.Text + "','" + dt + "',N'" + txtname.Text + "',N'" + txtdc.Text + "',N'" + txtngh.Text + "',N'" + txtldn.Text + "',N'" + txtctg.Text + "','False','" + dv + "','" + ldt + "','" + txtptvc.Text + "','" + userid + "','" + nv + "')");
}
catch
{
gen.ExcuteNonquery("insert into INInward(RefID,RefType,RefDate,PostedDate,RefNo,AccountingObjectID,AccountingObjectName,AccountingObjectAddress,Contactname,JournalMemo,DocumentIncluded,Posted,StockID,AccountingObjectType,ShippingNo,EmployeeID) values(newid(),101,'" + denct.EditValue.ToString() + "','" + denht.EditValue.ToString() + "','" + txtsct.Text + "','" + dt + "',N'" + txtname.Text + "',N'" + txtdc.Text + "',N'" + txtngh.Text + "',N'" + txtldn.Text + "',N'" + txtctg.Text + "','False','" + dv + "','" + ldt + "','" + txtptvc.Text + "','" + userid + "')");
}
string refid = gen.GetString("select * from INInward where RefNo='" + txtsct.Text + "'");
F.getrole(refid);
for (int i = 0; i < gridView1.RowCount - 1; i++)
{
gen.ExcuteNonquery("insert into INInwardDetail(RefDetailID,RefID,Quantity,QuantityConvert,SortOrder,InventoryItemID,Description,QuantityExits,QuantityConvertExits) values(newid(),'" + refid + "','" + detail[i, 1] + "','" + detail[i, 2] + "'," + i + ",'" + detail[i, 0] + "',N'" + detail[i, 3] + "',0,0)");
}
gen.ExcuteNonquery("insert into INInwardSU(RefID,RefType,RefDate,PostedDate,RefNo,AccountingObjectID,AccountingObjectName,AccountingObjectAddress,Contactname,JournalMemo,DocumentIncluded,Posted,StockID,AccountingObjectType,ShippingNo,TotalAmount,EmployeeID) values(newid(),101,'" + denct.EditValue.ToString() + "','" + denht.EditValue.ToString() + "','" + txtpnv.Text + "','" + dt + "',N'" + txtname.Text + "',N'" + txtdc.Text + "',N'" + txtngh.Text + "',N'" + txtldn.Text + "',N'" + txtctg.Text + "','False','" + dv + "','" + ldt + "','" + txtptvc.Text + "','" + tongtien + "','" + userid + "')");
string id = gen.GetString("select * from INInwardSU where RefNo='" + txtpnv.Text + "'");
gen.ExcuteNonquery("insert into HACHTOAN(RefDeteail,RefID,RefNo,DebitAccount,CreditAccount,Amount,AccountingObjectID,StockID,JournalMemo,RefDate,AccountingObjectIDMain) values(newid(),'" + id + "','" + txtsct.Text + "','1563','3313','" + tongtien + "','" + dt + "','" + dv + "',N'" + txtldn.Text + "','" + denct.EditValue.ToString() + "','" + dt + "')");
gen.ExcuteNonquery("update INInward set refSUID='" + id + "' where refID='" + refid + "' ");
for (int i = 0; i < gridView2.RowCount; i++)
{
gen.ExcuteNonquery("insert into INInwardSUDetail(RefDetailID,RefID,Quantity,QuantityConvert,SortOrder,InventoryItemID,Description,QuantityExits,QuantityConvertExits,UnitPrice,Amount,DebitAccount,CreditAccount) values(newid(),'" + id + "','" + detail1[i, 1] + "','" + detail1[i, 2] + "'," + i + ",'" + detail1[i, 0] + "',N'" + detail1[i, 3] + "',0,0,'" + detail1[i, 4] + "','" + detail1[i, 5] + "','1563','3313')");
}
}
else
{
try
{
gen.ExcuteNonquery("update INInward set RefDate='" + denct.EditValue.ToString() + "',PostedDate='" + denht.EditValue.ToString() + "',AccountingObjectID='" + dt + "',AccountingObjectName=N'" + txtname.Text + "',AccountingObjectAddress=N'" + txtdc.Text + "',Contactname=N'" + txtngh.Text + "',JournalMemo=N'" + txtldn.Text + "',DocumentIncluded=N'" + txtctg.Text + "',StockID='" + dv + "',AccountingObjectType='" + ldt + "',Posted='False',ShippingNo='" + txtptvc.Text + "',EmployeeID='" + userid + "',EmployeeIDPU='" + nv + "' where RefID='" + role + "'");
}
catch
{
gen.ExcuteNonquery("update INInward set RefDate='" + denct.EditValue.ToString() + "',PostedDate='" + denht.EditValue.ToString() + "',AccountingObjectID='" + dt + "',AccountingObjectName=N'" + txtname.Text + "',AccountingObjectAddress=N'" + txtdc.Text + "',Contactname=N'" + txtngh.Text + "',JournalMemo=N'" + txtldn.Text + "',DocumentIncluded=N'" + txtctg.Text + "',StockID='" + dv + "',AccountingObjectType='" + ldt + "',Posted='False',ShippingNo='" + txtptvc.Text + "',EmployeeID='" + userid + "',EmployeeIDPU=Null where RefID='" + role + "'");
}
gen.ExcuteNonquery("delete from INInwardDetail where RefID='" + role + "'");
for (int i = 0; i < gridView1.RowCount - 1; i++)
{
gen.ExcuteNonquery("insert into INInwardDetail(RefDetailID,RefID,Quantity,QuantityConvert,SortOrder,InventoryItemID,Description,QuantityExits,QuantityConvertExits) values(newid(),'" + role + "','" + detail[i, 1] + "','" + detail[i, 2] + "'," + i + ",'" + detail[i, 0] + "',N'" + detail[i, 3] + "',0,0)");
}
string id = gen.GetString("select refSUID from INInward where refID='" + role + "'");
gen.ExcuteNonquery("update INInwardSU set RefDate='" + denct.EditValue.ToString() + "',PostedDate='" + denht.EditValue.ToString() + "',AccountingObjectID='" + dt + "',AccountingObjectName=N'" + txtname.Text + "',AccountingObjectAddress=N'" + txtdc.Text + "',Contactname=N'" + txtngh.Text + "',JournalMemo=N'" + txtldn.Text + "',DocumentIncluded=N'" + txtctg.Text + "',StockID='" + dv + "',AccountingObjectType='" + ldt + "',Posted='False',ShippingNo='" + txtptvc.Text + "',TotalAmount='" + tongtien + "',EmployeeID='" + userid + "' where RefID = '" + id + "'");
gen.ExcuteNonquery("delete from INInwardSUDetail where RefID ='" + id + "'");
gen.ExcuteNonquery("delete HACHTOAN where RefID='" + id + "'");
gen.ExcuteNonquery("insert into HACHTOAN(RefDeteail,RefID,RefNo,DebitAccount,CreditAccount,Amount,AccountingObjectID,StockID,JournalMemo,RefDate,AccountingObjectIDMain) values(newid(),'" + id + "','" + txtsct.Text + "','1563','3313','" + tongtien + "','" + dt + "','" + dv + "',N'" + txtldn.Text + "','" + denct.EditValue.ToString() + "','" + dt + "')");
for (int i = 0; i < gridView2.RowCount; i++)
{
gen.ExcuteNonquery("insert into INInwardSUDetail(RefDetailID,RefID,Quantity,QuantityConvert,SortOrder,InventoryItemID,Description,QuantityExits,QuantityConvertExits,UnitPrice,Amount,DebitAccount,CreditAccount) values(newid(),'" + id + "','" + detail1[i, 1] + "','" + detail1[i, 2] + "'," + i + ",'" + detail1[i, 0] + "',N'" + detail1[i, 3] + "',0,0,'" + detail1[i, 4] + "','" + detail1[i, 5] + "','1563','3313')");
}
}
F.myac();
F.getactive("1");
F.Text = "Xem phiếu nhập kho Gas";
}
}
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 checksau(string sct, int vt, ToolStripSplitButton tsbttruoc, ToolStripSplitButton tsbtsau, Frm_phieunhapgas 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 INInward where RefNo > '" + sct + "' and Month(RefDate)='" + DateTime.Parse(ngay).Month.ToString() + "' and Year(RefDate)='" + DateTime.Parse(ngay).Year.ToString() + "' and refSUID is not Null and StockID='" + idkho + "' order by RefNo ASC");
}
else
{
id = gen.GetString("select Top 1 * from INInward where RefNo > '" + sct + "' and Month(RefDate)='" + DateTime.Parse(ngay).Month.ToString() + "' and Year(RefDate)='" + DateTime.Parse(ngay).Year.ToString() + "' and refSUID is not Null and StockID='" + idkho + "' order by RefNo DESC");
tsbtsau.Enabled = false;
}
F.getrole(id);
}
catch
{
tsbtsau.Enabled = false;
}
}
public void loadpnk(string active, string role, DevExpress.XtraGrid.GridControl gridControl1, GridView gridView1, TextEdit txtsct, ComboBoxEdit cbldt, LookUpEdit ledv, DateEdit denct, DateEdit denht,
DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit mahang, DevExpress.XtraEditors.Repository.RepositoryItemTextEdit soluong, DevExpress.XtraEditors.Repository.RepositoryItemTextEdit soluongqd, Frm_phieunhapgas F, LookUpEdit ledt, TextEdit txtldn, TextEdit txtctg,
ToolStripButton tsbtsua, ToolStripButton tsbtxoa, ToolStripButton tsbtcat, ToolStripButton tsbtboghi, ToolStripButton tsbtghiso, ToolStripButton tsbtnap, ToolStripSplitButton tsbtin, string ngaychungtu, string userid, string branchid, TextEdit txtngh, TextEdit txtptvc, DevExpress.XtraGrid.GridControl gridControl2, GridView gridView2, DevExpress.XtraEditors.Repository.RepositoryItemTextEdit dongia, DevExpress.XtraEditors.Repository.RepositoryItemTextEdit thanhtien, TextEdit txtpnv, LookUpEdit lenv, ToolStripSplitButton tsbttruoc, ToolStripSplitButton tsbtsau)
{
DataTable dt = new DataTable();
DataTable dt1 = new DataTable();
loadstart(gridControl1, gridView1, cbldt, ledv, denct, denht, mahang, soluong, soluongqd, ledt, tsbtsua, tsbtxoa, tsbtcat, tsbtboghi, tsbtghiso, tsbtnap, tsbtin, ngaychungtu, userid, branchid, active, dt, dt1, gridControl2, gridView2, dongia, thanhtien, lenv);
if (active == "1")
{
DataTable da = new DataTable();
da = gen.GetTable("select InventoryItemCode,Quantity,QuantityConvert,Description,InventoryItemName from INInwardDetail 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][4].ToString();
dr[2] = da.Rows[i][1].ToString();
dr[3] = da.Rows[i][2].ToString();
dr[4] = da.Rows[i][3].ToString();
dt.Rows.Add(dr);
}
gridControl1.DataSource = dt;
da = gen.GetTable("select InventoryItemCode,Quantity,QuantityConvert,Description,InventoryItemName,a.UnitPrice,a.Amount from INInwardSUDetail a,InventoryItem b where a.InventoryItemID=b.InventoryItemID and RefID in (select refSUID from INInward where refID='" + role + "') order by SortOrder");
for (int i = 0; i < da.Rows.Count; i++)
{
DataRow dr = dt1.NewRow();
dr[0] = da.Rows[i][0].ToString();
dr[1] = da.Rows[i][4].ToString();
dr[2] = da.Rows[i][1].ToString();
dr[3] = da.Rows[i][5].ToString();
dr[4] = da.Rows[i][6].ToString();
dr[5] = da.Rows[i][3].ToString();
dt1.Rows.Add(dr);
}
gridControl2.DataSource = dt1;
tsbtcat.Enabled = false;
F.Text = "Xem phiếu nhập kho Gas";
da = gen.GetTable("select AccountingObjectCode,a.Contactname,JournalMemo,DocumentIncluded,RefDate,PostedDate,RefNo,StockCode,Posted,AccountingObjectType,Cancel,ShippingNo,EmployeeIDPU from INInward a, AccountingObject b,Stock c where a.AccountingObjectID=b.AccountingObjectID and a.StockID=c.StockID and RefID='" + role + "'");
string No = gen.GetString("select a.refNo from INInwardSU a, INInward b where b.RefID='" + role + "' and a.RefID=b.refSUID");
try
{
cbldt.SelectedIndex = Int32.Parse(da.Rows[0][9].ToString());
}
catch { }
ledv.EditValue = da.Rows[0][7].ToString();
ledt.EditValue = da.Rows[0][0].ToString();
try
{
txtldn.Text = da.Rows[0][2].ToString();
}
catch { }
txtctg.Text = da.Rows[0][3].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 = No;
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;
}
else
{
tsbtboghi.Visible = false;
tsbtghiso.Visible = true;
}
if (da.Rows[0][10].ToString() == "True")
{
tsbtboghi.Enabled = false;
tsbtghiso.Enabled = false;
}
try
{
string nv = gen.GetString("select AccountingObjectCode from AccountingObject where AccountingObjectID='" + da.Rows[0][12].ToString() + "'");
lenv.EditValue = nv;
}
catch
{
lenv.EditValue = "3";
}
checktruocsau(tsbttruoc, tsbtsau, ledv.EditValue.ToString(), txtsct.Text, ngaychungtu);
}
else
{
F.Text = "Thêm phiếu nhập kho LPG";
if (role == null)
{
ledv.ItemIndex = 0;
}
else
{
ledv.EditValue = role;
}
denht.EditValue = DateTime.Parse(ngaychungtu);
denct.EditValue = DateTime.Parse(ngaychungtu);
}
}
