public void tsbtpnk(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_phieunhapvo u = new Frm_phieunhapvo();
u.myac = new Frm_phieunhapvo.ac(F.refreshpnkvo);
u.getactive(a);
u.getsub(subsys);
u.getroleid(roleid);
u.getkhach(khach);
u.gethang(hang);
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 trước khi sửa."); }
}
public void checksau(string sct, int vt, ToolStripSplitButton tsbttruoc, ToolStripSplitButton tsbtsau, Frm_phieunhapvo 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 INInwardSU where RefNo > '" + sct + "' and Month(RefDate)='" + DateTime.Parse(ngay).Month.ToString() + "' and Year(RefDate)='" + DateTime.Parse(ngay).Year.ToString() + "' and StockID='" + idkho + "' order by RefNo ASC");
}
else
{
id = gen.GetString("select Top 1 * from INInwardSU where RefNo > '" + sct + "' and Month(RefDate)='" + DateTime.Parse(ngay).Month.ToString() + "' and Year(RefDate)='" + DateTime.Parse(ngay).Year.ToString() + "' 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 dongia, DevExpress.XtraEditors.Repository.RepositoryItemTextEdit thanhtien, Frm_phieunhapvo 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.XtraEditors.Repository.RepositoryItemLookUpEdit taikhoan, ToolStripSplitButton tsbttruoc, ToolStripSplitButton tsbtsau, DataTable khach, DataTable hang, CheckEdit chtc)
{
DataTable dt = new DataTable();
loadstart(gridControl1, gridView1, cbldt, ledv, denct, denht, mahang, soluong, dongia, thanhtien, ledt, tsbtsua, tsbtxoa, tsbtcat, tsbtboghi, tsbtghiso, tsbtnap, tsbtin, ngaychungtu, userid, branchid, active, dt, taikhoan, khach, hang);
if (active == "1")
{
DataTable da = new DataTable();
da = gen.GetTable("select InventoryItemCode,Quantity,QuantityConvert,Description,InventoryItemName,a.UnitPrice,a.Amount,CreditAccount,DebitAccount,a.UnitPriceConvertOC,a.AmountOC from INInwardSUDetail 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][8].ToString();
dr[1] = da.Rows[i][7].ToString();
dr[2] = da.Rows[i][0].ToString();
dr[3] = da.Rows[i][4].ToString();
dr[4] = da.Rows[i][1].ToString();
dr[5] = da.Rows[i][5].ToString();
dr[6] = da.Rows[i][6].ToString();
if (da.Rows[i][8].ToString() == "131" || da.Rows[i][7].ToString() == "331")
{
dr[7] = "True";
}
if (da.Rows[i][7].ToString() == "34412" || da.Rows[i][8].ToString() == "24412")
{
dr[9] = "True";
}
if (da.Rows[i][7].ToString() == "131")
{
dr[8] = "True";
}
if (da.Rows[i][9].ToString() != "")
{
dr[10] = da.Rows[i][9].ToString();
}
if (da.Rows[i][10].ToString() != "")
{
dr[11] = da.Rows[i][10].ToString();
}
dr[12] = da.Rows[i][3].ToString();
dt.Rows.Add(dr);
}
gridControl1.DataSource = dt;
tsbtcat.Enabled = false;
F.Text = "Xem phiếu nhập Vỏ";
da = gen.GetTable("select AccountingObjectCode,a.Contactname,JournalMemo,DocumentIncluded,RefDate,PostedDate,RefNo,StockCode,Posted,AccountingObjectType,Cancel,ShippingNo,InwardType from INInwardSU a, AccountingObject b,Stock c where a.AccountingObjectID=b.AccountingObjectID and a.StockID=c.StockID and RefID='" + role + "'");
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();
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;
}
if (da.Rows[0][12].ToString() == "True")
{
chtc.Checked = true;
}
checktruocsau(tsbttruoc, tsbtsau, ledv.EditValue.ToString(), txtsct.Text, ngaychungtu);
}
else
{
F.Text = "Thêm phiếu nhập Vỏ";
if (role == null)
{
ledv.ItemIndex = 0;
}
else
{
ledv.EditValue = role;
}
chtc.Checked = false;
denht.EditValue = DateTime.Parse(ngaychungtu);
denct.EditValue = DateTime.Parse(ngaychungtu);
}
}
public void checkpnk(string active, string role, Frm_phieunhapvo F, GridView gridView1, 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, ToolStripSplitButton tsbttruoc, ToolStripSplitButton tsbtsau, CheckEdit chtc)
{
try
{
string dt = gen.GetString("select * from AccountingObject where AccountingObjectCode='" + ledt.EditValue.ToString() + "'");
string[,] detail = new string[20, 10];
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() == "")
{
check = "1";
}
detail[i, 1] = gridView1.GetRowCellValue(i, "Số lượng").ToString().Replace(".", "");
detail[i, 2] = gridView1.GetRowCellValue(i, "Số lượng").ToString().Replace(".", "");
detail[i, 3] = gridView1.GetRowCellValue(i, "Diễn giải").ToString();
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(".", "");
}
if (DateTime.Parse(ngaychungtu) < DateTime.Parse("09/01/2017"))
{
detail[i, 7] = gridView1.GetRowCellValue(i, "Tài khoản nợ").ToString();
detail[i, 6] = gridView1.GetRowCellValue(i, "Tài khoản có").ToString();
}
else
{
if (cbldt.EditValue.ToString() == "Khách hàng")
{
if (gridView1.GetRowCellValue(i, "Mượn").ToString() == "True")
{
detail[i, 7] = "131";
if (gridView1.GetRowCellValue(i, "Khác").ToString() == "True")
{
detail[i, 6] = "34412";
}
else
{
detail[i, 6] = "34411";
}
}
else if (gridView1.GetRowCellValue(i, "Trả").ToString() == "True")
{
detail[i, 6] = "131";
detail[i, 7] = "34411";
}
else
{
detail[i, 7] = "003";
}
}
else
{
if (gridView1.GetRowCellValue(i, "Mượn").ToString() == "True")
{
detail[i, 6] = "331";
if (gridView1.GetRowCellValue(i, "Khác").ToString() == "True")
{
detail[i, 7] = "24412";
}
else
{
detail[i, 7] = "24411";
}
}
else
{
detail[i, 7] = "003";
}
}
}
if (gridView1.GetRowCellValue(i, "Đơn giá BX").ToString() == "")
{
detail[i, 8] = "0";
}
else
{
detail[i, 8] = gridView1.GetRowCellValue(i, "Đơn giá BX").ToString().Replace(".", "").Replace(",", ".");
}
if (gridView1.GetRowCellValue(i, "Bốc xếp").ToString() == "")
{
detail[i, 9] = "0";
}
else
{
detail[i, 9] = gridView1.GetRowCellValue(i, "Bốc xếp").ToString().Replace(".", "").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);
return;
}
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 = gridView1.Columns["Thành tiền"].SummaryText.Replace(".", "");
if (active == "0")
{
try
{
string ton = gen.GetString("select * from INInwardSU 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 INInwardSU(RefID,RefType,RefDate,PostedDate,RefNo,AccountingObjectID,AccountingObjectName,AccountingObjectAddress,Contactname,JournalMemo,DocumentIncluded,Posted,StockID,AccountingObjectType,ShippingNo,TotalAmount,UserID,InwardType) 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 + "','" + tongtien + "','" + userid + "','" + chtc.Checked + "')");
string refid = gen.GetString("select * from INInwardSU where RefNo='" + txtsct.Text + "'");
F.getrole(refid);
for (int i = 0; i < gridView1.RowCount - 1; i++)
{
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 + "','" + detail[i, 7] + "','" + detail[i, 6] + "','" + detail[i, 5] + "','" + dt + "','" + dv + "',N'" + txtldn.Text + "','" + denct.EditValue.ToString() + "','" + dt + "')");
}
else
{
gen.ExcuteNonquery("insert into HACHTOAN(RefDeteail,RefID,RefNo,DebitAccount,CreditAccount,Amount,AccountingObjectID,StockID,JournalMemo,RefDate,AccountingObjectIDMain) values(newid(),'" + refid + "','" + txtsct.Text + "','" + detail[i, 7] + "','" + detail[i, 6] + "',0,'" + dt + "','" + dv + "',N'" + txtldn.Text + "','" + denct.EditValue.ToString() + "','" + dt + "')");
}
gen.ExcuteNonquery("insert into INInwardSUDetail(RefDetailID,RefID,Quantity,QuantityConvert,SortOrder,InventoryItemID,Description,QuantityExits,QuantityConvertExits,UnitPrice,Amount,DebitAccount,CreditAccount,UnitPriceConvertOC,AmountOC) values(newid(),'" + refid + "','" + detail[i, 1] + "','" + detail[i, 2] + "'," + i + ",'" + detail[i, 0] + "',N'" + detail[i, 3] + "',0,0,'" + detail[i, 4] + "','" + detail[i, 5] + "','" + detail[i, 7] + "','" + detail[i, 6] + "','" + detail[i, 8] + "','" + detail[i, 9] + "')");
}
}
else
{
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 + "',UserID='" + userid + "', InwardType='" + chtc.Checked + "' where RefID = '" + role + "'");
gen.ExcuteNonquery("delete from INInwardSUDetail where RefID ='" + role + "'");
gen.ExcuteNonquery("delete HACHTOAN where RefID='" + role + "'");
for (int i = 0; i < gridView1.RowCount - 1; i++)
{
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 + "','" + detail[i, 7] + "','" + detail[i, 6] + "','" + detail[i, 5] + "','" + dt + "','" + dv + "',N'" + txtldn.Text + "','" + denct.EditValue.ToString() + "','" + dt + "')");
}
else
{
gen.ExcuteNonquery("insert into HACHTOAN(RefDeteail,RefID,RefNo,DebitAccount,CreditAccount,Amount,AccountingObjectID,StockID,JournalMemo,RefDate,AccountingObjectIDMain) values(newid(),'" + role + "','" + txtsct.Text + "','" + detail[i, 7] + "','" + detail[i, 6] + "',0,'" + dt + "','" + dv + "',N'" + txtldn.Text + "','" + denct.EditValue.ToString() + "','" + dt + "')");
}
gen.ExcuteNonquery("insert into INInwardSUDetail(RefDetailID,RefID,Quantity,QuantityConvert,SortOrder,InventoryItemID,Description,QuantityExits,QuantityConvertExits,UnitPrice,Amount,DebitAccount,CreditAccount,UnitPriceConvertOC,AmountOC) values(newid(),'" + role + "','" + detail[i, 1] + "','" + detail[i, 2] + "'," + i + ",'" + detail[i, 0] + "',N'" + detail[i, 3] + "',0,0,'" + detail[i, 4] + "','" + detail[i, 5] + "','" + detail[i, 7] + "','" + detail[i, 6] + "','" + detail[i, 8] + "','" + detail[i, 9] + "')");
}
}
F.getactive("1");
F.Text = "Xem phiếu nhập kho Vỏ";
}
}
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 checkpnk(string active, string role, Frm_phieunhapvo F, GridView gridView1, 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, ToolStripSplitButton tsbttruoc, ToolStripSplitButton tsbtsau, CheckEdit chtc, TextEdit txttaixe)
{
/*try
* {*/
string dtt = gen.GetString("select * from AccountingObject where AccountingObjectCode='" + ledt.EditValue.ToString() + "'");
string dt = gen.GetString("select * from hamaco.dbo.AccountingObject where AccountingObjectCode='" + ledt.EditValue.ToString() + "'");
string dt_ta = gen.GetString("select * from hamaco_ta.dbo.AccountingObject where AccountingObjectCode='" + ledt.EditValue.ToString() + "'");
string dt_tn = gen.GetString("select * from hamaco_tn.dbo.AccountingObject where AccountingObjectCode='" + ledt.EditValue.ToString() + "'");
string[,] detail = new string[20, 15];
Double[,] tong = new Double[20, 20];
for (int j = 0; j < 3; j++)
{
tong[j, 0] = 0;
tong[j, 1] = 0;
tong[j, 2] = 0;
}
string check = "0";
for (int i = 0; i < gridView1.RowCount - 1; i++)
{
if (gridView1.GetRowCellValue(i, "Mã hàng").ToString() == "")
{
check = "1";
}
else
{
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";
detail[i, 2] = "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(".", "");
}
if (gridView1.GetRowCellValue(i, "Số lượng xuất").ToString() == "")
{
detail[i, 8] = "0";
}
else
{
detail[i, 8] = gridView1.GetRowCellValue(i, "Số lượng xuất").ToString().Replace(".", "");
}
if (gridView1.GetRowCellValue(i, "Chênh lệch").ToString() == "")
{
detail[i, 9] = "0";
}
else
{
detail[i, 9] = gridView1.GetRowCellValue(i, "Chênh lệch").ToString().Replace(".", "");
}
if (gridView1.GetRowCellValue(i, "Thế chân").ToString() == "")
{
detail[i, 11] = "0";
}
else
{
detail[i, 11] = gridView1.GetRowCellValue(i, "Thế chân").ToString().Replace(".", "");
}
if (gridView1.GetRowCellValue(i, "Đơn giá BX").ToString() == "")
{
detail[i, 12] = "0";
}
else
{
detail[i, 12] = gridView1.GetRowCellValue(i, "Đơn giá BX").ToString().Replace(".", "").Replace(",", ".");
}
if (gridView1.GetRowCellValue(i, "Bốc xếp").ToString() == "")
{
detail[i, 13] = "0";
}
else
{
detail[i, 13] = gridView1.GetRowCellValue(i, "Bốc xếp").ToString().Replace(".", "").Replace(",", ".");
}
if (cbldt.EditValue.ToString() == "Khách hàng")
{
if (Double.Parse(detail[i, 9]) > 0)
{
detail[i, 7] = "131";
detail[i, 6] = "34411";
}
else if (Double.Parse(detail[i, 9]) < 0)
{
detail[i, 6] = "131";
detail[i, 7] = "34411";
}
}
else
{
if (Double.Parse(detail[i, 9]) < 0)
{
detail[i, 6] = "331";
detail[i, 7] = "24411";
}
}
detail[i, 3] = gridView1.GetRowCellValue(i, "Diễn giải").ToString();
if (detail[i, 3] == "HAMACO")
{
detail[i, 10] = gen.GetString("select * from hamaco.dbo.InventoryItem where InventoryItemCode='" + gridView1.GetRowCellValue(i, "Mã hàng").ToString() + "'");
tong[0, 0] = tong[0, 0] + Double.Parse(detail[i, 5]);
}
else if (detail[i, 3] == "Thiên An")
{
detail[i, 10] = gen.GetString("select * from hamaco_ta.dbo.InventoryItem where InventoryItemCode='" + gridView1.GetRowCellValue(i, "Mã hàng").ToString() + "'");
tong[1, 0] = tong[1, 0] + Double.Parse(detail[i, 5]);
}
else if (detail[i, 3] == "Dịch vụ HAMACO")
{
detail[i, 10] = gen.GetString("select * from hamaco_tn.dbo.InventoryItem where InventoryItemCode='" + gridView1.GetRowCellValue(i, "Mã hàng").ToString() + "'");
tong[2, 0] = tong[2, 0] + Double.Parse(detail[i, 5]);
}
}
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);
return;
}
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 = gridView1.Columns["Thành tiền"].SummaryText.Replace(".", "");
if (active == "0")
{
/*try
* {
* string ton = gen.GetString("select * from INInwardLPG 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 { }*/
themsct(ngaychungtu, txtsct, ledv.EditValue.ToString(), branchid, tsbttruoc, tsbtsau);
gen.ExcuteNonquery("insert into INInwardLPG(RefID,RefType,RefDate,PostedDate,RefNo,AccountingObjectID,AccountingObjectName,AccountingObjectAddress,Contactname,JournalMemo,DocumentIncluded,Posted,StockID,AccountingObjectType,ShippingNo,TotalAmount,UserID,InwardType,CustomField2) values(newid(),101,'" + denct.EditValue.ToString() + "','" + denht.EditValue.ToString() + "','" + txtsct.Text + "','" + dtt + "',N'" + txtname.Text + "',N'" + txtdc.Text + "',N'" + txtngh.Text + "',N'" + txtldn.Text + "',N'" + txtctg.Text + "','False','" + dv + "','" + ldt + "',N'" + txtptvc.Text + "','" + tongtien + "','" + userid + "','" + chtc.Checked + "',N'" + txttaixe.Text + "')");
gen.ExcuteNonquery("insert into hamaco.dbo.INInwardSU(RefID,RefType,RefDate,PostedDate,RefNo,AccountingObjectID,AccountingObjectName,AccountingObjectAddress,Contactname,JournalMemo,DocumentIncluded,Posted,StockID,AccountingObjectType,ShippingNo,TotalAmount,UserID,InwardType,CustomField2) 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 + "',N'" + txtptvc.Text + "','" + tong[0, 0] + "','" + userid + "','" + chtc.Checked + "',N'" + txttaixe.Text + "')");
gen.ExcuteNonquery("insert into hamaco_ta.dbo.INInwardSU(RefID,RefType,RefDate,PostedDate,RefNo,AccountingObjectID,AccountingObjectName,AccountingObjectAddress,Contactname,JournalMemo,DocumentIncluded,Posted,StockID,AccountingObjectType,ShippingNo,TotalAmount,UserID,InwardType,CustomField2) values(newid(),101,'" + denct.EditValue.ToString() + "','" + denht.EditValue.ToString() + "','" + txtsct.Text + "','" + dt_ta + "',N'" + txtname.Text + "',N'" + txtdc.Text + "',N'" + txtngh.Text + "',N'" + txtldn.Text + "',N'" + txtctg.Text + "','False','" + dv + "','" + ldt + "',N'" + txtptvc.Text + "','" + tong[1, 0] + "','" + userid + "','" + chtc.Checked + "',N'" + txttaixe.Text + "')");
gen.ExcuteNonquery("insert into hamaco_tn.dbo.INInwardSU(RefID,RefType,RefDate,PostedDate,RefNo,AccountingObjectID,AccountingObjectName,AccountingObjectAddress,Contactname,JournalMemo,DocumentIncluded,Posted,StockID,AccountingObjectType,ShippingNo,TotalAmount,UserID,InwardType,CustomField2) values(newid(),101,'" + denct.EditValue.ToString() + "','" + denht.EditValue.ToString() + "','" + txtsct.Text + "','" + dt_tn + "',N'" + txtname.Text + "',N'" + txtdc.Text + "',N'" + txtngh.Text + "',N'" + txtldn.Text + "',N'" + txtctg.Text + "','False','" + dv + "','" + ldt + "',N'" + txtptvc.Text + "','" + tong[2, 0] + "','" + userid + "','" + chtc.Checked + "',N'" + txttaixe.Text + "')");
string refid = gen.GetString("select * from INInwardLPG where RefNo='" + txtsct.Text + "'");
F.getrole(refid);
for (int i = 0; i < gridView1.RowCount - 1; i++)
{
gen.ExcuteNonquery("insert into INInwardLPGDetail(RefDetailID,RefID,Quantity,QuantityConvert,SortOrder,InventoryItemID,Description,QuantityExits,QuantityConvertExits,UnitPrice,Amount,DebitAccount,CreditAccount,ListItemID,ConvertRate,UnitPriceConvertOC,AmountOC) values(newid(),'" + refid + "','" + detail[i, 1] + "','" + detail[i, 2] + "'," + i + ",'" + detail[i, 0] + "',N'" + detail[i, 3] + "','" + detail[i, 8] + "','" + detail[i, 9] + "','" + detail[i, 4] + "','" + detail[i, 5] + "','" + detail[i, 7] + "','" + detail[i, 6] + "','" + detail[i, 10] + "','" + detail[i, 11] + "','" + detail[i, 12] + "','" + detail[i, 13] + "')");
}
}
else
{
gen.ExcuteNonquery("update INInwardLPG set RefDate='" + denct.EditValue.ToString() + "',PostedDate='" + denht.EditValue.ToString() + "',AccountingObjectID='" + dtt + "',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=N'" + txtptvc.Text + "',TotalAmount='" + tongtien + "',UserID='" + userid + "', InwardType='" + chtc.Checked + "',CustomField2=N'" + txttaixe.Text + "' where RefID = '" + role + "'");
gen.ExcuteNonquery("update hamaco.dbo.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=N'" + txtptvc.Text + "',TotalAmount='" + tong[0, 0] + "',UserID='" + userid + "', InwardType='" + chtc.Checked + "',CustomField2=N'" + txttaixe.Text + "' where RefNo = '" + txtsct.Text + "'");
gen.ExcuteNonquery("update hamaco_ta.dbo.INInwardSU set RefDate='" + denct.EditValue.ToString() + "',PostedDate='" + denht.EditValue.ToString() + "',AccountingObjectID='" + dt_ta + "',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=N'" + txtptvc.Text + "',TotalAmount='" + tong[1, 0] + "',UserID='" + userid + "', InwardType='" + chtc.Checked + "',CustomField2=N'" + txttaixe.Text + "' where RefNo = '" + txtsct.Text + "'");
gen.ExcuteNonquery("update hamaco_tn.dbo.INInwardSU set RefDate='" + denct.EditValue.ToString() + "',PostedDate='" + denht.EditValue.ToString() + "',AccountingObjectID='" + dt_tn + "',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=N'" + txtptvc.Text + "',TotalAmount='" + tong[2, 0] + "',UserID='" + userid + "', InwardType='" + chtc.Checked + "',CustomField2=N'" + txttaixe.Text + "' where RefNo = '" + txtsct.Text + "'");
gen.ExcuteNonquery("delete from INInwardLPGDetail where RefID ='" + role + "'");
for (int i = 0; i < gridView1.RowCount - 1; i++)
{
gen.ExcuteNonquery("insert into INInwardLPGDetail(RefDetailID,RefID,Quantity,QuantityConvert,SortOrder,InventoryItemID,Description,QuantityExits,QuantityConvertExits,UnitPrice,Amount,DebitAccount,CreditAccount,ListItemID,ConvertRate,UnitPriceConvertOC,AmountOC) values(newid(),'" + role + "','" + detail[i, 1] + "','" + detail[i, 2] + "'," + i + ",'" + detail[i, 0] + "',N'" + detail[i, 3] + "','" + detail[i, 8] + "','" + detail[i, 9] + "','" + detail[i, 4] + "','" + detail[i, 5] + "','" + detail[i, 7] + "','" + detail[i, 6] + "','" + detail[i, 10] + "','" + detail[i, 11] + "','" + detail[i, 12] + "','" + detail[i, 13] + "')");
}
}
gen.ExcuteNonquery("dondathangvolpg '" + txtsct.Text + "'");
F.getactive("1");
}
/*}
* catch
* {
* XtraMessageBox.Show("Vui lòng chọn đối tượng trước khi lưu", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
* }*/
}
