public bool suaCT_PHIEUNHAP_SOLUONG(CHITIET_PHIEUNHAP ctpn)
{
// try
// {
SqlConnection con = new SqlConnection(db.connectionStr);
SqlCommand cmd = new SqlCommand("suaCT_PHIEUNHAP_SOLUONG", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ID_NHAPKHOCHITIET", SqlDbType.Int);
cmd.Parameters.Add("@CTPN_SOLUONG", SqlDbType.Int);
cmd.Parameters["@ID_NHAPKHOCHITIET"].Value = ctpn.Id_ctpn;
cmd.Parameters["@CTPN_SOLUONG"].Value = ctpn.Ctpn_solg;
con.Open();
int result = cmd.ExecuteNonQuery();
con.Close();
return(result > 0);
//}
//catch
//{
//}
}
public bool Insert(CHITIET_PHIEUNHAP ctpn)
{
// try
// {
SqlConnection con = new SqlConnection(db.connectionStr);
SqlCommand cmd = new SqlCommand("insert_CTPhieuNhap", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@id", SqlDbType.VarChar, 30);
cmd.Parameters.Add("@pn_id", SqlDbType.NVarChar, 20);
cmd.Parameters.Add("@vt_id", SqlDbType.NVarChar, 20);
cmd.Parameters.Add("@ctpn_hoatchat", SqlDbType.NVarChar, 100);
cmd.Parameters.Add("@ctpn_dvt", SqlDbType.NVarChar, 100);
cmd.Parameters.Add("@ctpn_solg", SqlDbType.Int);
cmd.Parameters.Add("@ctpn_gianhap", SqlDbType.Float);
cmd.Parameters.Add("@ngaysx", SqlDbType.DateTime);
cmd.Parameters.Add("@hansd", SqlDbType.DateTime);
cmd.Parameters.Add("@solo", SqlDbType.NVarChar, 100);
cmd.Parameters.Add("@truocthue", SqlDbType.Float);
cmd.Parameters.Add("@sauthue", SqlDbType.Float);
cmd.Parameters.Add("@giaban", SqlDbType.Float);
cmd.Parameters.Add("@hamlg", SqlDbType.NVarChar, 100);
cmd.Parameters.Add("@quycach", SqlDbType.NVarChar, 100);
cmd.Parameters["@id"].Value = ctpn.Id_ctpn;
cmd.Parameters["@pn_id"].Value = ctpn.Pn_id;
cmd.Parameters["@vt_id"].Value = ctpn.Vt_id;
cmd.Parameters["@ctpn_hoatchat"].Value = ctpn.Ctpn_hoatchat;
cmd.Parameters["@ctpn_dvt"].Value = ctpn.Ctpn_dvt;
cmd.Parameters["@ctpn_solg"].Value = ctpn.Ctpn_solg;
cmd.Parameters["@ctpn_gianhap"].Value = ctpn.Ctpn_gianhap;
cmd.Parameters["@ngaysx"].Value = ctpn.Ctpn_ngaysx;
cmd.Parameters["@hansd"].Value = ctpn.Ctpn_hsd;
cmd.Parameters["@solo"].Value = ctpn.Ctpn_solo;
cmd.Parameters["@truocthue"].Value = ctpn.Tt_truocthue;
cmd.Parameters["@sauthue"].Value = ctpn.Tt_sauthue;
cmd.Parameters["@giaban"].Value = ctpn.Giaban;
cmd.Parameters["@hamlg"].Value = ctpn.Hamluong;
cmd.Parameters["@quycach"].Value = ctpn.Quycach;
con.Open();
int result = cmd.ExecuteNonQuery();
con.Close();
return(result > 0);
//}
//catch
//{
//}
}
bool Insert_CTPN()
{
bool b = false;
DataTable dt = new DataTable();
dt = dtThuoc;
for (int i = 0; i < dt.Rows.Count; i++)
{
string id = dt.Rows[i]["CTPN_ID"].ToString();
string hoatchat = dt.Rows[i]["CTPN_HOATCHAT"].ToString();
string id_pn = dt.Rows[i]["PN_ID"].ToString();
string tenvt = dt.Rows[i]["VT_TEN"].ToString();
string vt_id = daoThuoc.getIDTHUOCbyTEN(tenvt);
string dvt = dt.Rows[i]["CTPN_DONVITINH"].ToString();
int solg = int.Parse(dt.Rows[i]["CTPN_SOLUONG"].ToString());
string solo = dt.Rows[i]["CTPN_SOLO"].ToString();
float gianhap = float.Parse(dt.Rows[i]["CTPN_DONGIANHAP"].ToString());
DateTime ngaysx = DateTime.Parse(dt.Rows[i]["CTPN_NGAYSANXUAT"].ToString());
DateTime hansd = DateTime.Parse(dt.Rows[i]["CTPN_HANSUDUNG"].ToString());
float truocthue = float.Parse(dt.Rows[i]["CTPN_TTTRUOCTHUE"].ToString());
float sauthue = float.Parse(dt.Rows[i]["CTPN_TTSAUTHUE"].ToString());
string hamlg = dt.Rows[i]["CTPN_HAMLUONG"].ToString();
string quycach = dt.Rows[i]["CTPN_QCDONGGOI"].ToString();
float giaban = float.Parse(dt.Rows[i]["CTPN_GIABAN"].ToString());
CHITIET_PHIEUNHAP ctpn = new CHITIET_PHIEUNHAP(id, hoatchat, dvt, solg, gianhap, solo, ngaysx, hansd,
truocthue, sauthue, hamlg, quycach, giaban, vt_id, id_pn);
if (daoCTPN.Insert(ctpn))
{
b = true;
}
else
{
b = false;
}
}
return(b);
}
private void btnThemThuoc_Click(object sender, EventArgs e)
{
if (KiemTraLoi() == "")
{
string ctpn_id = daoCTPN.Get_ID_Auto();
string pn_id = txtMaPN.Text;
string vt_id = daoThuoc.getIDTHUOCbyTEN(txtTenVT.Text);
string ten = txtTenVT.Text;
string dvt = txtDVT.Text;
string hoatchat = txtHoatChat.Text;
int solg = int.Parse(txtSoLG.Text);
float gianhap = float.Parse(txtGiaNhap.Text);
string solo = txtSoLo.Text;
DateTime ngaysx = Convert.ToDateTime(DateTime.Parse(dtpNgaySX.Text).ToShortDateString());
DateTime hansd = Convert.ToDateTime(DateTime.Parse(dtpHanSuDung.Text).ToShortDateString());
float vat = 0;
if (txtVAT.TextLength != 0)
{
vat = float.Parse(txtVAT.Text);
}
float truocthue = solg * gianhap;
float sauthue = truocthue + ((truocthue * vat) / 100);
string hamlg = txtHamLuong.Text;
string quycach = txtQuyCach.Text;
float giaban = float.Parse(txtGiaBan.Text);
CHITIET_PHIEUNHAP ctpn = new CHITIET_PHIEUNHAP(ctpn_id, hoatchat, dvt, solg, gianhap, solo, ngaysx, hansd,
truocthue, sauthue, hamlg, quycach, giaban, vt_id, pn_id);
if (pn_id != "")
{
if (daoPNK.KiemTraTrung(pn_id) == 0)
{
lbLoi2.Text = "Chưa có phiếu nhập " + txtMaPN.Text;
}
else
{
if (daoCTPN.KiemTraVT(pn_id, vt_id) == 0)
{
if (daoCTPN.Insert(ctpn))
{
KHO_CHI_TIET kct = layTTKHOCT(ctpn_id);
daoKCT.Insert_KCT(kct);
}
resetThuoc();
}
else
{
if (daoCTPN.Update(ctpn))
{
KHO_CHI_TIET kct = layTTKHOCT(lbID_CTPN.Text);
daoKCT.Update_KCT(kct);
}
}
}
}
else
{
lbLoi2.Text = "Chưa có phiếu nhập";
}
grcListVT.DataSource = daoCTPN.Get_CTPN_TheoID(pn_id);
}
}
private void groupControl1_CustomButtonClick(object sender, DevExpress.XtraBars.Docking2010.BaseButtonEventArgs e)
{
if (Convert.ToInt32(e.Button.Properties.Tag.ToString()) == 1)
{
PHIEUNHAPHANG pn = new PHIEUNHAPHANG();
pn.MAPN = txtmaphieunhap.Text;
pn.MADH = txtmaphieudat.Text;
pn.MANV = _message;
pn.NGAYGIAOHANG = DateTime.Parse(cmbngaylap.Text);
pn.TONGTIEN = decimal.Parse(txtthanhtien.Text);
pn.TINHTRANG = false;
BH.PHIEUNHAPHANGs.InsertOnSubmit(pn);
BH.SubmitChanges();
for (int j = 0; j < dataGridView1.Rows.Count; j++)
{
CHITIET_PHIEUNHAP ctpn = new CHITIET_PHIEUNHAP();
SANPHAM sp = new SANPHAM();
DONDATHANG dh = new DONDATHANG();
ctpn.MAPN = txtmaphieunhap.Text;
ctpn.MA_CT_DH = dataGridView1.Rows[j].Cells[5].Value.ToString();
ctpn.SOLUONG = decimal.Parse(dataGridView1.Rows[j].Cells[2].Value.ToString());
ctpn.DONGIA = decimal.Parse(dataGridView1.Rows[j].Cells[3].Value.ToString());
ctpn.THANHTIEN = decimal.Parse(dataGridView1.Rows[j].Cells[4].Value.ToString());
//cập nhật sản phẩm
int sl = (from slhanghoa in BH.SANPHAMs
where slhanghoa.MASP == dataGridView1.Rows[j].Cells[6].Value.ToString()
select
slhanghoa.SOLUONG).FirstOrDefault();
int soln = int.Parse(dataGridView1.Rows[j].Cells[2].Value.ToString());
int slcapnhat = sl + soln;
sp = BH.SANPHAMs.Where(s => s.MASP == dataGridView1.Rows[j].Cells[6].Value.ToString()).Single();
sp.SOLUONG = slcapnhat;
//kiểm tra số lượng nhập
// dem dong
int sum;
int count = (from nhaphang in BH.CHITIET_PHIEUNHAPs
where nhaphang.MA_CT_DH == dataGridView1.Rows[j].Cells[5].Value.ToString()
select
nhaphang.SOLUONG
).Count();
if (count == 0)
{
sum = 0;
}
else
{
//tổng số lượng các lần nhập hàng
sum = (int)(from nhaphang in BH.CHITIET_PHIEUNHAPs
where nhaphang.MA_CT_DH == dataGridView1.Rows[j].Cells[5].Value.ToString()
select
nhaphang.SOLUONG
).Sum();
}
// tổng nhập
int tongnhap = sum + int.Parse(dataGridView1.Rows[j].Cells[2].Value.ToString());
//số lượng chi tiết đơn đặt hàng
var sl1 = (from slhanghoa1 in BH.CT_DONDHs
where slhanghoa1.MA_CT_DH == dataGridView1.Rows[j].Cells[5].Value.ToString()
select
slhanghoa1.SOLUONG).FirstOrDefault();
if (tongnhap > int.Parse(sl1.ToString()))
{
XtraMessageBox.Show("Số lượng nhập quá lớn", "Thông báo");
}
else
{
if (tongnhap == int.Parse(sl1.ToString()))
{
// cap nhat tinh trang
dh = BH.DONDATHANGs.Where(s => s.MADH == txtmaphieudat.Text).Single();
dh.TINHTRANG = true;
}
else
{
dh.TINHTRANG = false;
}
BH.CHITIET_PHIEUNHAPs.InsertOnSubmit(ctpn);
BH.SubmitChanges();
XtraMessageBox.Show("Lưu thành công");
}
}
}
else if (Convert.ToInt32(e.Button.Properties.Tag.ToString()) == 2)
{
dataGridView1.DataSource = null;
// Bind with the new data.
dataGridView1.AutoGenerateColumns = false;
dataGridView1.ColumnCount = 7;
dataGridView1.Columns[0].Name = "Mã phiếu nhập";
dataGridView1.Columns[1].Name = "Sản phẩm";
dataGridView1.Columns[2].Name = "Số lượng";
dataGridView1.Columns[3].Name = "Đơn giá";
dataGridView1.Columns[4].Name = "Thành tiền";
dataGridView1.Columns[5].Name = "Mã CT";
dataGridView1.Columns[6].Name = "Mã sản phẩm";
bool kt = true;
var v3Value = cmbsanpham.Properties.GetDataSourceValue("MASP", cmbsanpham.ItemIndex);
string value = (from tennv in BH.CT_DONDHs
join sp in BH.SANPHAMs on tennv.MASP equals sp.MASP
join ddh in BH.DONDATHANGs on tennv.MADH equals ddh.MADH
where tennv.MASP == v3Value.ToString() && tennv.MADH == txtmaphieudat.Text
select
tennv.MA_CT_DH).FirstOrDefault();
for (int j = 0; j < dataGridView1.Rows.Count; j++)
{
if (value == dataGridView1.Rows[j].Cells[5].Value.ToString())
{
int slcong = Int32.Parse(dataGridView1.Rows[j].Cells[2].Value.ToString());
slcong = slcong + int.Parse(txtsoluong.Text);
dataGridView1.Rows[j].Cells[2].Value = slcong;
double thanhtien = 0;
thanhtien = (slcong * double.Parse(dataGridView1.Rows[j].Cells[3].Value.ToString()));
dataGridView1.Rows[j].Cells[4].Value = thanhtien;
kt = false;
break;
}
}
if (kt)
{
int row = 0;
dataGridView1.Rows.Add();
row = dataGridView1.Rows.Count - 1;
dataGridView1.Rows[row].Cells[0].Value = txtmaphieunhap.Text;
dataGridView1.Rows[row].Cells[1].Value = cmbsanpham.Text;
dataGridView1.Rows[row].Cells[2].Value = txtsoluong.Text;
dataGridView1.Rows[row].Cells[3].Value = txtdongia.Text;
double tt = int.Parse(dataGridView1.Rows[row].Cells[2].Value.ToString()) * double.Parse(dataGridView1.Rows[row].Cells[3].Value.ToString());
dataGridView1.Rows[row].Cells[4].Value = tt.ToString();
dataGridView1.Rows[row].Cells[5].Value = value;
dataGridView1.Rows[row].Cells[6].Value = v3Value;
}
double i = tinhtongtien();
txtthanhtien.Text = string.Format("{0:n0}", Double.Parse(i.ToString()));
}
}
