public DataTable DanhSachBuuGui_ChuyenTiep()
{
db.TaoKetNoi(FileConfigBCCP);
DataSet ds;
ds = db.ChayThuTuc("select A.ForwardDate as NgayDoiSoat, A.ItemCode as SoHieu,E.VietnameseCauseName as LyDo, A.ForwardDate as NgayNhanChuyenTiep, " +
"A.ReceiverFullnameOld TenNguoiNhan, A.ReceiverAddressOld DiaChiNguoiNhan, A.ReceiverTelOld ReceiverTel,B.Weight,D.Value, " +
"0 as CuocChinh, 0 as PhuPhiXD,0 TongCuoc, 0 VAT, B.TotalFreightVAT ThanhTien, A.ForwardPOSCode as MaBuuCucNhap " +
"from ItemForward A " +
"left join Item B on A.ItemCode=B.ItemCode " +
"inner join ItemVASPropertyValue D " +
"on D.ItemCode = A.ItemCode " +
"left join Cause E on A.Reason=E.CauseCode " +
"where A.ForwardDate between '" + TuNgay.ToString("MM/dd/yyyy") + "' and '" + DenNgay.AddDays(1).ToString("MM/dd/yyyy") + "'" + " and D.PropertyCode = 'Amount' and isnull(D.Value, 0) <> 0 ");
return(ds.Tables[0]);
//Lay tat ca so lieu cua mot buu cuc
/*db.ChuoiKetNoi = ChuoiKetNoi;
* db.TaoKetNoi();
* DataSet ds;
* ds = db.ChayThuTuc("select ForwardDate as NgayDoiSoat, ItemCode as SoHieu, Reason LyDo, ForwardDate as NgayGioChuyenTiep, " +
* "ReceiverFullname TenNguoiNhan, ReceiverAddress DiaChiNguoiNhan, ProvinceCode MaTinh, POSCode MaBuuCuc, ForwardPOSCode MaBuuCucNhap, " +
* "ReceiverFullnameOld TenNguoiNhanCu, ReceiverAddressOld DiaChiNguoiNhanCu, POSCodeOld MaBuuCucCu " +
* "from ItemForward " +
* "where ForwardDate between '" + TuNgay.ToString("MM/dd/yyyy") + "' and '" + DenNgay.AddDays(1).ToString("MM/dd/yyyy") + "'");
* return ds.Tables[0];*/
}
public DataTable DanhSachBuuGui_TrangThai_PhatThanhCong()
{
//Lay tat ca so lieu cua mot buu cuc
db.ChuoiKetNoi = ChuoiKetNoi;
db.TaoKetNoi();
DataSet ds;
ds = db.ChayThuTuc("select DeliveryDate as NgayDoiSoat, ItemCode as SoHieu, DeliveryDate as NgayGioPhat,DeliveryNote GhiChu, " +
"RealReciverName NguoiKyNhan, InputDate as NgayGioNhap, InputingUser NguoiNhap, ToPosCode as MaBuuCucNhap " +
"from Delivery " +
"where IsDeliverable=1 and DeliveryDate between '" + TuNgay.ToString("MM/dd/yyyy") + "' and '" + DenNgay.AddDays(1).ToString("MM/dd/yyyy") + "'");
return(ds.Tables[0]);
}
public DataTable DanhSachBuuGui_ChuyenHoan()
{
//Lay tat ca so lieu cua mot buu cuc
db.TaoKetNoi(FileConfigBCCP);
DataSet ds;
ds = db.ChayThuTuc("select A.ReturnDate as NgayDoiSoat, A.ItemCode as SoHieu,E.VietnameseCauseName as LyDo, A.ReturnDate as NgayNhanChuyenHoan, " +
"A.ReceiverFullname TenNguoiNhan, A.ReceiverAddress DiaChiNguoiNhan, A.ReceiverTel,B.Weight,D.Value, " +
"A.MainFreight as CuocChinh, A.FuelSurchargeFreight as PhuPhiXD, A.Freight TongCuoc, A.VATFreight VAT, A.FreightVAT ThanhTien, A.POSCode as MaBuuCucNhap " +
"from ItemReturn A " +
"left join Item B on A.ItemCode=B.ItemCode " +
"inner join ItemVASPropertyValue D " +
"on D.ItemCode = A.ItemCode " +
"left join Cause E on A.Reason=E.CauseCode " +
"where A.ReturnDate between '" + TuNgay.ToString("MM/dd/yyyy") + "' and '" + DenNgay.AddDays(1).ToString("MM/dd/yyyy") + "'" + " and D.PropertyCode = 'Amount' and isnull(D.Value, 0) <> 0 ");
return(ds.Tables[0]);
}
public bool Add_Giay_Di_Duong()
{
int check;
IDataParameter[] paras = new IDataParameter[20] {
new NpgsqlParameter("p_ma_quyet_dinh", Ma_Quyet_Dinh + "_" + TuNgay.ToString("ddMMyyyy")),
new NpgsqlParameter("p_ma_nv", Ma_NV),
new NpgsqlParameter("p_chuc_vu_id", ChucVu_ID),
new NpgsqlParameter("p_noi_cong_tac", NoiCongTac),
new NpgsqlParameter("p_ma_so_cong_van", CongVanSo),
new NpgsqlParameter("p_ngay_cong_van", CongVanNgay),
new NpgsqlParameter("p_tu_ngay", TuNgay),
new NpgsqlParameter("p_den_ngay", DenNgay),
new NpgsqlParameter("p_tien_luong", TienLuong),
new NpgsqlParameter("p_cong_tac_phi", CongTacPhi),
new NpgsqlParameter("p_ghi_chu", GhiChu),
new NpgsqlParameter("p_path", Path),
new NpgsqlParameter("p_seq_id", SEQ_ID),
new NpgsqlParameter("p_ptdc_id", PTDC_ID),
new NpgsqlParameter("p_di_or_den", Di_Or_Den),
new NpgsqlParameter("p_dia_diem", DiaDiem),
new NpgsqlParameter("p_ngay_khoi_hanh", NgayKhoiHanh),
new NpgsqlParameter("p_so_ngay_cong_tac", SoNgayCT),
new NpgsqlParameter("p_ly_do_luu_tru", LyDoLuuTru),
new NpgsqlParameter("p_ghi_chu_detail", GhiChu_Detail)
};
check = (int)dp.executeScalarProc("sp3_insert_giay_di_duong", paras);
if (check > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
var cqId = Security.CqId;
TuyenId = Request["ID"];
TuNgay = Request["Thang"];
if (string.IsNullOrEmpty(TuyenId))
{
TuyenId = "2";
}
if (string.IsNullOrEmpty(TuNgay))
{
TuNgay = string.Format("{0:MM}/{0:yyyy}", DateTime.Now);
}
var thangStr = TuNgay.Split(new char[] { '/' });
var thangInt = Convert.ToInt32(thangStr[0]);
var namInt = Convert.ToInt32(thangStr[1]);
var tuNgay = new DateTime(namInt, thangInt, 1).AddDays(-1);
var denNgay = tuNgay.AddMonths(1);
var newListXe = new List <Xe>();
var item = new LichItem();
var listNgay = new List <LichItem>();
var listChamCong = new List <ChamCong>();
var startRener = DateTime.Now;
var endRender = DateTime.Now; // Kết thúc render
using (var con = DAL.con())
{
Item = TuyenDal.SelectById(con, Convert.ToInt32(TuyenId));
var listXe = XeDal.SelectByTuyenId(con, Item.ID);
foreach (var xe in listXe)
{
listChamCong = ChamCongDal.SelectByXeTuNgayCqId(con, cqId, tuNgay.ToString("dd/MM/yyyy"), denNgay.ToString("dd/MM/yyyy"), xe.ID);
listNgay = new List <LichItem>();
for (var d = tuNgay.AddDays(1); d <= denNgay; d = d.AddDays(1))
{
item = new LichItem()
{
Day = d
};
var ngayChamCong = listChamCong.Where(x => x.Ngay == d);
if (ngayChamCong.Any())
{
var chamCongBinhThuong = ngayChamCong.FirstOrDefault();
if (chamCongBinhThuong != null)
{
// Xác định chấm công này đã được lãnh đạo duyệt hay chưa
var kieuChamCong = chamCongBinhThuong.Loai != 3 ? chamCongBinhThuong.Loai : (chamCongBinhThuong.Duyet ? 3 : 5);
if (chamCongBinhThuong.TrangThaiNo == 1)
{
kieuChamCong = 6;
}
item.Item = chamCongBinhThuong;
item.KieuChamCong = kieuChamCong;
item.SoChuyen = ngayChamCong.Count();
item.GhiChu = chamCongBinhThuong.GhiChu;
item.TangCuong = chamCongBinhThuong.TangCuong;
item.Clickable = false;
}
}
listNgay.Add(item);
}
xe.ListChamCong = listChamCong;
xe.ListLichItem = listNgay;
newListXe.Add(xe);
}
}
endRender = DateTime.Now; // Kết thúc render
BangChamCongTheoCoQuan_List.Ngay = listNgay;
BangChamCongTheoCoQuan_List.List = newListXe;
BangChamCongTheoCoQuan_List.Item = Item;
BangChamCongTheoCoQuan_List.TuNgay = TuNgay;
}
public DataTable BaoCaoDonViCot()
{
daDB dDB = new daDB();
dDB.TaoKetNoiTuConfig();
return(dDB.ChayThuTuc("sp_tblDoanhThuKhachHangDichVu_BaoCao_DonViCot '" + TuNgay.ToString() + "','" + DenNgay.ToString() + "','" + MaDonVi + "'").Tables[0]);
}
