public StockInHeader GetStockInHeader(StockInHeader item)
{
return((StockInHeader)stockinheaderDAL.GetItem <StockInHeader>(item));
}
public bool SaveStockInHeader(StockInHeader newItem)
{
return(stockinheaderDAL.Save(newItem));
}
public bool DeleteStockInHeader(StockInHeader item)
{
return(stockinheaderDAL.Delete(item));
}
public ActionResult Approve(string data)
{
if (accessDetail.sua)
{
using (var dbConn = Helpers.OrmliteConnection.openConn())
{
string[] separators = { "@@" };
var listItem = data.Split(separators, StringSplitOptions.RemoveEmptyEntries);
foreach (var itemid in listItem)
{
var poheader = dbConn.FirstOrDefault <POHeader>(s => s.id == int.Parse(itemid));
var podetails = dbConn.Select <PODetail>(s => s.ma_phieu_header == poheader.ma_phieu);
//var lstStockIn = podetail.GroupBy(
// p => p.ma_chi_nhanh,
// (key, g) => new { ma_chi_nhanh = key, Details = g.ToList() });
//foreach (var stockin in lstStockIn)
//{
StockInHeader stockinheader = new StockInHeader();
string ma_phieu = "";
var loai = "SI";
//var ma_don_vi = currentUser.ma_don_vi;
var yyMMdd = DateTime.Now.ToString("yyMMdd");
var existLast = dbConn.SingleOrDefault <StockInHeader>("SELECT TOP 1 * FROM StockInHeader ORDER BY id DESC");
var nextNo = 0;
var yearNow = int.Parse(DateTime.Now.Year.ToString().Substring(2, 2));
if (existLast != null)
{
nextNo = int.Parse(existLast.ma_phieu.Substring(8, existLast.ma_phieu.Length - 8)) + 1;
var yearOld = int.Parse(existLast.ma_phieu.Substring(2, 2));
if (yearOld == yearNow)
{
ma_phieu = loai + yyMMdd + String.Format("{0:00000}", nextNo);
}
else
{
ma_phieu = loai + yyMMdd + "00001";
}
}
else
{
ma_phieu = loai + yyMMdd + "00001";
}
stockinheader.ma_phieu = ma_phieu;
//stockinheader.ten_phieu_nhap_kho = stockinheader.ma_phieu_nhap_kho;
//stockinheader.ma_don_vi = stockin.ma_chi_nhanh;
//stockinheader.ma_phieu_po = poheader.ma_phieu;
stockinheader.ma_nha_cung_cap = poheader.ma_nha_cung_cap;
stockinheader.ghi_chu = poheader.ghi_chu;
stockinheader.ngay_tao = DateTime.Now;
stockinheader.nguoi_tao = currentUser.ma_nguoi_dung;
stockinheader.ngay_cap_nhat = DateTime.Parse("1900-01-01");
stockinheader.nguoi_cap_nhat = "";
stockinheader.trang_thai = "MOI";
dbConn.Insert(stockinheader);
foreach (var item in podetails)
{
StockInDetail newdata = new StockInDetail();
newdata.ma_phieu_header = stockinheader.ma_phieu;
newdata.ma_san_pham = item.ma_san_pham;
newdata.so_luong = item.so_luong;
newdata.so_luong_da_nhap = 0;
newdata.so_luong_con_lai = item.so_luong;
newdata.id_po_detail = item.id;
newdata.thong_so_ky_thuat = item.thong_so_ky_thuat;
newdata.muc_dich_su_dung = "";
newdata.nguoi_tao = currentUser.ma_nguoi_dung;
newdata.ma_to_trinh = item.ma_to_trinh;
newdata.id_StatementDetail = item.id_StatementDetail;
newdata.don_gia_vat = item.don_gia_vat;
newdata.don_gia = item.don_gia;
newdata.thue_vat = item.thue_vat;
newdata.don_vi_tinh = item.don_vi_tinh;
newdata.chi_phi = item.chi_phi;
newdata.ma_don_vi = item.ma_don_vi;
newdata.ma_chi_nhanh = item.ma_chi_nhanh;
newdata.thong_tin_noi_bo = item.thong_tin_noi_bo;
newdata.ngay_tao = DateTime.Now;
newdata.ngay_cap_nhat = DateTime.Parse("1900-01-01");
newdata.nguoi_cap_nhat = "";
newdata.trang_thai = "";
dbConn.Insert <StockInDetail>(newdata);
}
dbConn.Update <POHeader>(set: "trang_thai = {0}, ngay_duyet = {1}".Params(AllConstant.TRANGTHAI_DA_DUYET, DateTime.Now), where : "id = {0}".Params(int.Parse(itemid)));
}
//}
return(Json(new { success = true }));
}
}
else
{
return(Json(new { success = false, error = "Bạn không có quyền duyệt đơn đặt hàng" }));
}
}
