public int ThemPhieuChuyenKho(ChuyenKho ck)
{
string sql = string.Format("insert into [PhieuChuyenKho] Values('{0}', '{1}',N'{2}',N'{3}',N'{4}',N'{5}',N'{6}')", ck.Phieu, ck.Ngay, ck.KhoXuat, ck.KhoNhan, ck.NguoiNhan, ck.NguoiGui, ck.GhiChu);
var rs = db.ExecuteSQL(sql);
return(rs);
}
private void barbtnchuyenkho_ItemClick(object sender, ItemClickEventArgs e)
{
ChuyenKho ChuyenKho = new ChuyenKho();
if (ExistsForm(ChuyenKho))
{
return;
}
ChuyenKho.MdiParent = this;
ChuyenKho.Show();
}
private void groupControl2_CustomButtonClick(object sender, DevExpress.XtraBars.Docking2010.BaseButtonEventArgs e)
{
if (e.Button.Properties.Caption == "Tạo Mới")
{
gridView1.OptionsSelection.MultiSelect = true;
gridView1.SelectAll();
gridView1.DeleteSelectedRows();
}
if (e.Button.Properties.Caption == "Đóng")
{
System.Windows.Forms.Form tmp = this.FindForm();
tmp.Close();
tmp.Dispose();
}
if (e.Button.Properties.Caption == "Nạp Lại")
{
gridView1.OptionsSelection.MultiSelect = true;
gridView1.SelectAll();
gridView1.DeleteSelectedRows();
}
if (e.Button.Properties.Caption == "Lưu & Thêm")
{
string MaSP="";
string khoNhan = cbKhoNhan.EditValue.ToString();
for (int i = 0; i < gridView1.DataRowCount; i++)
{
MaSP = gridView1.GetRowCellValue(i, "MaSP").ToString();
}
ChuyenKho ck = new ChuyenKho()
{
Phieu = txtPhieuCK.Text,
Ngay = DateTime.Parse(cbNgay.Text),
KhoXuat=cbKhoXuat.Text,
KhoNhan=cbKhoNhan.Text,
NguoiGui=cbNguoiChuyen.Text,
NguoiNhan=cbNguoiNhan.Text,
GhiChu=txtGhiChu.Text
};
bus_ck.ThemDV(ck);
bus_ck.Update(MaSP, khoNhan);
gridView1.OptionsSelection.MultiSelect = true;
gridView1.SelectAll();
gridView1.DeleteSelectedRows();
}
}
public int ThemDV(ChuyenKho ck)
{
return(ck_dao.ThemPhieuChuyenKho(ck));
}
public IHttpActionResult PutKHO_CHUYEN_KHO(ChuyenKho chuyenkho)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var kho = db.KHO_CHUYEN_KHO.Where(x => x.SO_CHUNG_TU == chuyenkho.SO_CHUNG_TU).FirstOrDefault();
kho.SO_CHUNG_TU = chuyenkho.SO_CHUNG_TU;
kho.NGAY_CHUNG_TU = GeneralFunction.ConvertToTime(chuyenkho.NGAY_CHUNG_TU);
kho.NGAY_HACH_TOAN = GeneralFunction.ConvertToTime(chuyenkho.NGAY_HACH_TOAN);
kho.NGUOI_LAP_PHIEU = chuyenkho.NGUOI_LAP_PHIEU;
kho.TRUC_THUOC = chuyenkho.TRUC_THUOC;
kho.DIEN_GIAI = chuyenkho.DIEN_GIAI;
// Chi tiết chuyển kho
foreach (ChiTietChuyenKho item in chuyenkho.ChiTiet)
{
var newItem = db.KHO_CT_CHUYEN_KHO.Where(x => x.SO_CHUNG_TU == chuyenkho.SO_CHUNG_TU).FirstOrDefault();
int sl_cu = newItem.SO_LUONG;
newItem.SO_CHUNG_TU = kho.SO_CHUNG_TU;
newItem.MA_HANG = item.MA_HANG;
newItem.XUAT_TAI_KHO = item.MA_KHO_CON;
newItem.NHAP_TAI_KHO = item.NHAP_TAI_KHO;
newItem.SO_LUONG = item.SO_LUONG;
newItem.DVT = item.DVT;
//Chuyển hàng vào kho
TONKHO_HOPLONG newkhoxuat = db.TONKHO_HOPLONG.Where(x => x.MA_HANG == item.MA_HANG && x.MA_KHO_CON == item.MA_KHO_CON).FirstOrDefault();
newkhoxuat.SL_HOPLONG = newkhoxuat.SL_HOPLONG + sl_cu;
TONKHO_HOPLONG newkhonhap = db.TONKHO_HOPLONG.Where(x => x.MA_HANG == item.MA_HANG && x.MA_KHO_CON == item.NHAP_TAI_KHO).FirstOrDefault();
newkhonhap.SL_HOPLONG = newkhonhap.SL_HOPLONG - sl_cu;
if (newkhoxuat == null || newkhoxuat.SL_HOPLONG < item.SO_LUONG)
{
return(Ok("Hàng không có trong kho hoặc SL tồn không đủ"));
}
newkhoxuat.SL_HOPLONG -= Convert.ToInt32(item.SO_LUONG);
if (newkhonhap == null)
{
newkhonhap = new TONKHO_HOPLONG();
newkhonhap.MA_HANG = item.MA_HANG;
newkhonhap.MA_KHO_CON = item.NHAP_TAI_KHO;
newkhonhap.SL_HOPLONG = Convert.ToInt32(item.SO_LUONG);
}
else
{
newkhonhap.MA_HANG = item.MA_HANG;
newkhonhap.SL_HOPLONG += Convert.ToInt32(item.SO_LUONG);
}
}
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (KHO_CHUYEN_KHOExists(chuyenkho.SO_CHUNG_TU))
{
return(Conflict());
}
else
{
throw;
}
}
return(Ok(kho.SO_CHUNG_TU));
}
public IHttpActionResult ChuyenKhoGiuHang(int id, ChuyenKho chuyenkho)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
KHO_CHUYEN_KHO kho = new KHO_CHUYEN_KHO();
kho.SO_CHUNG_TU = GeneralChungTu();
kho.NGAY_CHUNG_TU = DateTime.Today.Date;
kho.NGAY_HACH_TOAN = DateTime.Today.Date;
kho.NGUOI_LAP_PHIEU = chuyenkho.NGUOI_LAP_PHIEU;
kho.TRUC_THUOC = chuyenkho.TRUC_THUOC;
kho.DIEN_GIAI = chuyenkho.DIEN_GIAI;
db.KHO_CHUYEN_KHO.Add(kho);
// Chi tiết chuyển kho
foreach (ChiTietChuyenKho item in chuyenkho.ChiTiet)
{
KHO_CT_CHUYEN_KHO newItem = new KHO_CT_CHUYEN_KHO();
newItem.SO_CHUNG_TU = kho.SO_CHUNG_TU;
newItem.MA_HANG = item.MA_HANG;
newItem.XUAT_TAI_KHO = item.MA_KHO_CON;
newItem.NHAP_TAI_KHO = item.NHAP_TAI_KHO;
newItem.SO_LUONG = item.SO_LUONG;
newItem.DVT = item.DVT;
db.KHO_CT_CHUYEN_KHO.Add(newItem);
//Chuyển hàng vào kho
TONKHO_HOPLONG newkhoxuat = db.TONKHO_HOPLONG.Where(x => x.MA_HANG == item.MA_HANG && x.MA_KHO_CON == item.MA_KHO_CON).FirstOrDefault();
if (newkhoxuat == null || newkhoxuat.SL_HOPLONG < item.SO_LUONG)
{
return(Ok("Hàng không có trong kho hoặc SL tồn không đủ"));
}
newkhoxuat.SL_HOPLONG -= Convert.ToInt32(item.SO_LUONG);
TONKHO_HOPLONG newkhonhap = db.TONKHO_HOPLONG.Where(x => x.MA_HANG == item.MA_HANG && x.MA_KHO_CON == item.NHAP_TAI_KHO).FirstOrDefault();
if (newkhonhap == null)
{
newkhonhap = new TONKHO_HOPLONG();
newkhonhap.MA_HANG = item.MA_HANG;
newkhonhap.MA_KHO_CON = item.NHAP_TAI_KHO;
newkhonhap.SL_HOPLONG = Convert.ToInt32(item.SO_LUONG);
db.TONKHO_HOPLONG.Add(newkhonhap);
}
else
{
newkhonhap.MA_HANG = item.MA_HANG;
newkhonhap.SL_HOPLONG += Convert.ToInt32(item.SO_LUONG);
}
}
var query = db.BH_CT_DON_HANG_PO.Where(x => x.ID == id).FirstOrDefault();
query.CAN_GIU_HANG = true;
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (KHO_CHUYEN_KHOExists(chuyenkho.SO_CHUNG_TU))
{
return(Conflict());
}
else
{
throw;
}
}
return(Ok(kho.SO_CHUNG_TU));
}
