public ActionResult CreateUpdate(PRequestHeader data)
{
using (var dbConn = Helpers.OrmliteConnection.openConn())
{
try
{
var ma_phieu = "";
if (data.id > 0)
{
if (accessDetail.sua)
{
var exist = dbConn.SingleOrDefault <PRequestHeader>("id={0} ", data.id);
data.id = exist.id;
data.ma_phieu = exist.ma_phieu;
data.ma_don_vi = exist.ma_don_vi;
//data.ma_chi_nhanh = exist.ma_chi_nhanh;
data.file_chu_ki_TDV = exist.file_chu_ki_TDV;
data.ngay_tao_yeu_cau = !string.IsNullOrEmpty(Request["ngay_tao_yeu_cau"]) ? DateTime.Parse(DateTime.ParseExact(Request["ngay_tao_yeu_cau"], "dd/MM/yyyy", CultureInfo.InvariantCulture).ToString("yyyy-MM-dd")) : DateTime.Parse("1900-01-01");
data.ngay_tao = exist.ngay_tao;
data.ngay_giao = DateTime.Now;
data.ten_nguoi_lap_de_nghi = exist.ten_nguoi_lap_de_nghi;
data.ngay_cap_nhat = DateTime.Now;
data.nguoi_cap_nhat = currentUser.ma_nguoi_dung;
data.trang_thai = exist.trang_thai;
dbConn.Update(data);
ma_phieu = data.ma_phieu;
}
else
{
return(Json(new { success = false, error = "Bạn không có quyền cập nhật dữ liệu" }));
}
}
else
{
if (accessDetail.them)
{
var branch = dbConn.SingleOrDefault <Branch>("ma_chi_nhanh={0}", data.ma_chi_nhanh);
if (branch == null)
{
return(Json(new { success = false, error = "Bạn phải chọn Phòng ban/Chi nhánh" }));
}
var ma_don_vi = branch.ma_don_vi;
var ma_chi_nhanh = branch.ma_chi_nhanh;
var yyMMdd = DateTime.Now.ToString("yyMMdd");
var existLast = dbConn.SingleOrDefault <PRequestHeader>("SELECT TOP 1 * FROM PRequestHeader WHERE ma_don_vi={0} ORDER BY id DESC".Params(ma_don_vi));
var nextNo = 0;
var yearNow = int.Parse(DateTime.Now.Year.ToString().Substring(2, 2));
if (existLast != null)
{
nextNo = int.Parse(existLast.ma_phieu.Substring(11, existLast.ma_phieu.Length - 11)) + 1;
var yearOld = int.Parse(existLast.ma_phieu.Substring(5, 2));
if (yearOld == yearNow)
{
ma_phieu = ma_don_vi + "PR" + yyMMdd + String.Format("{0:00000}", nextNo);
}
else
{
ma_phieu = ma_don_vi + "PR" + yyMMdd + "00001";
}
}
else
{
ma_phieu = ma_don_vi + "PR" + yyMMdd + "00001";
}
data.ma_phieu = ma_phieu;
data.ma_don_vi = ma_don_vi;
data.ma_chi_nhanh = ma_chi_nhanh;
data.ngay_tao_yeu_cau = !string.IsNullOrEmpty(Request["ngay_tao_yeu_cau"]) ? DateTime.Parse(DateTime.ParseExact(Request["ngay_tao_yeu_cau"], "dd/MM/yyyy", CultureInfo.InvariantCulture).ToString("yyyy-MM-dd")) : DateTime.Parse("1900-01-01");
data.ngay_giao = !string.IsNullOrEmpty(Request["ngay_giao"]) ? DateTime.Parse(DateTime.ParseExact(Request["ngay_giao"], "dd/MM/yyyy", CultureInfo.InvariantCulture).ToString("yyyy-MM-dd")) : DateTime.Parse("1900-01-01");
data.ngay_tao = DateTime.Now;
data.ten_nguoi_lap_de_nghi = currentUser.ten_nguoi_dung;
data.so_dt_lien_lac_nguoi_lap = currentUser.dien_thoai;
data.nguoi_tao = currentUser.ma_nguoi_dung;
data.ngay_cap_nhat = DateTime.Parse("1900-01-01");
data.nguoi_cap_nhat = "";
data.trang_thai = "MOI";
data.y_kien_cua_don_vi = !string.IsNullOrEmpty(data.y_kien_cua_don_vi) ? data.y_kien_cua_don_vi : "";
data.y_kien_HCQT = !string.IsNullOrEmpty(data.y_kien_HCQT) ? data.y_kien_HCQT : "";
data.y_kien_khac_HO = !string.IsNullOrEmpty(data.y_kien_khac_HO) ? data.y_kien_khac_HO : "";
data.y_kien_QLDVKH_NQT = !string.IsNullOrEmpty(data.y_kien_QLDVKH_NQT) ? data.y_kien_QLDVKH_NQT : "";
data.y_kien_TTCNTT_NHDT = !string.IsNullOrEmpty(data.y_kien_TTCNTT_NHDT) ? data.y_kien_TTCNTT_NHDT : "";
dbConn.Insert(data);
data.id = (int)dbConn.GetLastInsertId();
}
else
{
return(Json(new { success = false, error = "Bạn không có quyền thêm dữ liệu" }));
}
}
return(Json(new { success = true, ma_phieu = ma_phieu, id = data.id }));
}
catch (Exception ex)
{
return(Json(new { success = false, error = ex.Message }));
}
}
}
public ActionResult ApproveLevel3(PRequestHeader data, List <PRequestDetail> details, string nhom_chuyen_mon, string note)
{
using (var dbConn = Helpers.OrmliteConnection.openConn())
{
try
{
foreach (var priddetail in details)
{
var prheader = dbConn.FirstOrDefault <PRequestDetail>(@"Select ma_phieu From PRequestDetail Where id = {0}", priddetail.id);
var ma_phieu = prheader.ma_phieu;
if (nhom_chuyen_mon == AllConstant.Y_KIEN_KHAC_HO)
{
dbConn.Update <PRequestDetail>(set: "trang_thai='HO_DA_DUYET_CHUYEN_MON', noi_dung_xac_nhan_cap_3 = {0},so_luong_duyet={1}".Params(priddetail.noi_dung_xac_nhan_cap_3, priddetail.so_luong_duyet), where : "id={0}".Params(priddetail.id));
dbConn.Update <PRequestHeader>(set: "y_kien_khac_HO={0}, ngay_duyet_khac_HO = GETDATE(), nguoi_duyet_khac_HO = {1}".Params(note, currentUser.ma_nguoi_dung), where : "ma_phieu={0}".Params(ma_phieu));
}
if (nhom_chuyen_mon == AllConstant.Y_KIEN_TTCN_NHDT)
{
dbConn.Update <PRequestDetail>(set: "trang_thai='CNTT_DA_DUYET_CHUYEN_MON', noi_dung_xac_nhan_cap_3 = {0},so_luong_duyet={1}".Params(priddetail.noi_dung_xac_nhan_cap_3, priddetail.so_luong_duyet), where : "id={0}".Params(priddetail.id));
dbConn.Update <PRequestHeader>(set: "y_kien_TTCNTT_NHDT={0}, ngay_duyet_TTCNTT_NHDT = GETDATE(), nguoi_duyet_TTCNTT_NHDT = {1}".Params(note, currentUser.ma_nguoi_dung), where : "ma_phieu={0}".Params(ma_phieu));
}
if (nhom_chuyen_mon == AllConstant.Y_KIEN_QLDVKH_NQT)
{
dbConn.Update <PRequestDetail>(set: "trang_thai='QLDVKH_DA_DUYET_CHUYEN_MON', noi_dung_xac_nhan_cap_3 = {0},so_luong_duyet={1}".Params(priddetail.noi_dung_xac_nhan_cap_3, priddetail.so_luong_duyet), where : "id={0}".Params(priddetail.id));
dbConn.Update <PRequestHeader>(set: "y_kien_QLDVKH_NQT={0}, ngay_duyet_QLDVKH_NQT = GETDATE(), nguoi_duyet_QLDVKH_NQT = {1}".Params(note, currentUser.ma_nguoi_dung), where : "ma_phieu={0}".Params(ma_phieu));
}
var det = dbConn.FirstOrDefault <PRequestDetail>(@"Select ma_phieu From PRequestDetail Where trang_thai not in ('CNTT_DA_DUYET_CHUYEN_MON','QLDVKH_DA_DUYET_CHUYEN_MON','HO_DA_DUYET_CHUYEN_MON') and ma_phieu = {0}", ma_phieu);
if (det != null)
{
dbConn.Update <PRequestHeader>(set: "trang_thai='QLDVKH_DA_DUYET_CHUYEN_MON'", where : "ma_phieu={0}".Params(ma_phieu));
}
else
{
dbConn.Update <PRequestHeader>(set: "trang_thai='DA_DUYET'", where : "ma_phieu={0}".Params(ma_phieu));
}
if (!string.IsNullOrEmpty(priddetail.ma_san_pham_thay_the) && priddetail.ma_san_pham_thay_the != priddetail.ma_san_pham)
{
var detail = dbConn.FirstOrDefault <PRequestDetail>(s => s.id == priddetail.id);
detail.ma_san_pham_thay_the = priddetail.ma_san_pham_thay_the;
detail.ma_nha_cung_cap = priddetail.ma_nha_cung_cap;
detail.don_gia_vat = priddetail.don_gia_vat;
detail.don_gia = priddetail.don_gia;
detail.thue_vat = priddetail.thue_vat;
detail.don_vi_tinh = priddetail.don_vi_tinh;
detail.thanh_tien = priddetail.thanh_tien;
detail.ma_chinh_sach_gia = priddetail.ma_chinh_sach_gia;
dbConn.Update(detail);
}
}
return(Json(new { success = true }));
}
catch (Exception ex)
{
return(Json(new { success = false, error = ex.Message }));
}
}
}
