public string CreateCode() { string MaDL; using (QLDLDataContext db = new QLDLDataContext()) { List <string> lstMa = db.DAILies.Select(p => p.MaDaiLy.Trim()).ToList(); MaDL = lstMa[0]; foreach (string temp in lstMa) { if (temp.Length > MaDL.Length) { MaDL = temp; } else if (temp.Length == MaDL.Length) { if (String.Compare(temp.Substring(2, temp.Length - 2), MaDL.Substring(2, MaDL.Length - 2)) > 0) { MaDL = temp; } } } MaDL = MaDL.TrimEnd(); string x = MaDL.Substring(2); string y = (int.Parse(x) + 1).ToString(); MaDL = "DL" + y; } return(MaDL); }
//Create Code public string CreateCode() { //select max(t.MaDangKy) as N'MaDangKy' from THONGTINDANGKY t where LEN(t.MaDangKy)" + // ">= all(select len(x.MaDangKy) from THONGTINDANGKY x)" string Ma; using (QLDLDataContext db = new QLDLDataContext()) { List <string> lstMa = db.BAOCAODOANHSOs.Select(p => p.MaBaoCaoDoanhSo).ToList(); Ma = lstMa[0]; foreach (string temp in lstMa) { if (temp.Length > Ma.Length || string.Compare(temp, Ma) == 1) { Ma = temp; } } Ma = Ma.TrimEnd(); string x = Ma.Substring(4); string y = (int.Parse(x) + 1).ToString(); Ma = "BCDS" + y; } return(Ma); }
public string CreateCode() { string MaPX; using (QLDLDataContext db = new QLDLDataContext()) { List <string> lstMa = db.PHIEUXUATHANGs.Select(p => p.MaPhieuXuat.Trim()).ToList(); MaPX = lstMa[0]; foreach (string temp in lstMa) { if (temp.Length > MaPX.Length) { MaPX = temp; } else if (temp.Length == MaPX.Length) { if (String.Compare(temp.Substring(2, temp.Length - 2), MaPX.Substring(2, MaPX.Length - 2)) > 0) { MaPX = temp; } } } MaPX = MaPX.TrimEnd(); string x = MaPX.Substring(2); string y = (int.Parse(x) + 1).ToString(); MaPX = "PX" + y; } return(MaPX); }
public string CreateCode() { string MaMH; using (QLDLDataContext db = new QLDLDataContext()) { List <string> lstMa = db.MATHANGs.Select(p => p.MaMatHang.Trim()).ToList(); MaMH = lstMa[0]; foreach (string temp in lstMa) { if (temp.Length > MaMH.Length) { MaMH = temp; } else if (temp.Length == MaMH.Length) { if (String.Compare(temp.Substring(2, temp.Length - 2), MaMH.Substring(2, MaMH.Length - 2)) > 0) { MaMH = temp; } } } MaMH = MaMH.TrimEnd(); string x = MaMH.Substring(2); string y = (int.Parse(x) + 1).ToString(); MaMH = "MH" + y; } return(MaMH); }
public string CreateCode() { string MaPT; using (QLDLDataContext db = new QLDLDataContext()) { List <string> lstMa = db.PHIEUTHUTIENs.Select(p => p.MaPhieuThu).ToList(); if (lstMa.Count == 0) { return("PT1"); } MaPT = lstMa[0]; foreach (string temp in lstMa) { if (temp.Length > MaPT.Length || string.Compare(temp, MaPT) == 1) { MaPT = temp; } } MaPT = MaPT.TrimEnd(); string x = MaPT.Substring(2); string y = (int.Parse(x) + 1).ToString(); MaPT = "PT" + y; } return(MaPT); }
public List <LOAIDAILY> GetAll() { using (QLDLDataContext db = new QLDLDataContext()) { var query = db.LOAIDAILies.Select(q => q).ToList(); return(query); } }
///////////// public TAIKHOAN GetByID(string tenTK) { TAIKHOAN temp; QLDLDataContext db = new QLDLDataContext(); temp = db.TAIKHOANs.Where(p => p.TenTaiKhoan == tenTK).FirstOrDefault(); return(temp); }
public List <QUAN> GetAll() { using (QLDLDataContext db = new QLDLDataContext()) { var query = db.QUANs.Select(q => q).ToList(); return(query); } }
// viết các hàm cần thiết public PHIEUTHUTIEN GetByID(string MaDL) { PHIEUTHUTIEN temp; QLDLDataContext db = new QLDLDataContext(); temp = db.PHIEUTHUTIENs.Where(p => p.MaPhieuThu == MaDL).FirstOrDefault(); return(temp); }
public void getAl(DataGridView dgv) { using (QLDLDataContext db = new QLDLDataContext()) { var query = db.MATHANGs.Select(i => i).ToList(); dgv.DataSource = query; } }
// viết các hàm cần thiết public DAILY GetByID(string MaDL) { DAILY temp; QLDLDataContext db = new QLDLDataContext(); temp = db.DAILies.Where(p => p.MaDaiLy == MaDL).FirstOrDefault(); return(temp); }
//lấy dữ liệu từ CSDL public QUAN GetByID(string MaQ) { QUAN temp; using (QLDLDataContext db = new QLDLDataContext()) { temp = db.QUANs.First(p => p.MaQuan == MaQ); } return(temp); }
// viết các hàm cần thiết public DOANHSO_DAILY GetByID(string MaDS, string MaDL) { DOANHSO_DAILY temp; using (QLDLDataContext db = new QLDLDataContext()) { temp = db.DOANHSO_DAILies.Where(p => p.MaBaoCaoDoanhSo == MaDS && p.MaDaiLy == MaDL).FirstOrDefault(); } return(temp); }
// viết các hàm cần thiết public BAOCAOCONGNO GetByID(string MaCN) { BAOCAOCONGNO temp; using (QLDLDataContext db = new QLDLDataContext()) { temp = db.BAOCAOCONGNOs.Where(p => p.MaBaoCaoCongNo == MaCN).FirstOrDefault(); } return(temp); }
// viết các hàm cần thiết public LOAIDAILY GetByID(int MaL) { LOAIDAILY temp; using (QLDLDataContext db = new QLDLDataContext()) { temp = db.LOAIDAILies.Where(p => p.MaLoaiDaiLy == MaL).FirstOrDefault(); } return(temp); }
// viết các hàm cần thiết public PHIEUXUATHANG GetByID(string MaDL) { PHIEUXUATHANG temp; using (QLDLDataContext db = new QLDLDataContext()) { temp = db.PHIEUXUATHANGs.Where(p => p.MaPhieuXuat == MaDL).FirstOrDefault(); } return(temp); }
// viết các hàm cần thiết public CONGNO_DAILY GetByID(string MaCN, string MaDL) { CONGNO_DAILY temp; using (QLDLDataContext db = new QLDLDataContext()) { temp = db.CONGNO_DAILies.Where(p => p.MaBaoCaoCongNo == MaCN && p.MaDaiLy == MaDL).FirstOrDefault(); } return(temp); }
// viết các hàm cần thiết public PHIEUXUAT_MATHANG GetByID(string maMH, string maPX) { PHIEUXUAT_MATHANG temp; using (QLDLDataContext db = new QLDLDataContext()) { temp = db.PHIEUXUAT_MATHANGs.Where((p => p.MaMatHang == maMH && p.MaPhieuXuat == maPX)).FirstOrDefault(); } return(temp); }
// viết các hàm cần thiết public BAOCAODOANHSO GetByID(string MaDS) { BAOCAODOANHSO temp; using (QLDLDataContext db = new QLDLDataContext()) { temp = db.BAOCAODOANHSOs.Where(p => p.MaBaoCaoDoanhSo == MaDS).FirstOrDefault(); } return(temp); }
public THAMSO GetAll() { THAMSO temp; using (QLDLDataContext db = new QLDLDataContext()) { temp = db.THAMSOs.Select(p => p).FirstOrDefault(); } return(temp); }
public MATHANG getById(string id) { MATHANG item; QLDLDataContext db = new QLDLDataContext(); item = db.MATHANGs.Where(i => i.MaMatHang == id).FirstOrDefault(); return(item); }
public List <DONVITINH> GetAll() { List <DONVITINH> lstDL = new List <DONVITINH>(); using (QLDLDataContext db = new QLDLDataContext()) { lstDL = db.DONVITINHs.Select(p => p).ToList(); } return(lstDL); }
public List <MATHANG> GetAll() { List <MATHANG> lstDL = new List <MATHANG>(); using (QLDLDataContext db = new QLDLDataContext()) { lstDL = db.MATHANGs.Select(p => p).ToList(); } return(lstDL); }
//get alldaily public List <DAILY> GetAll() { List <DAILY> lstDL = new List <DAILY>(); using (QLDLDataContext db = new QLDLDataContext()) { lstDL = db.DAILies.Select(p => p).ToList(); } return(lstDL); }
//baocaocongno by tháng public List <string> GetMaBaoCaoCongNoByThang(int Thang) { List <BAOCAOCONGNO> temp = new List <BAOCAOCONGNO>(); QLDLDataContext db = new QLDLDataContext(); //db.DeferredLoadingEnabled = false; List <string> a = new List <string>(); a = db.BAOCAOCONGNOs.Where(p => p.Thang == Thang).Select(p => p.MaBaoCaoCongNo).ToList(); temp = db.BAOCAOCONGNOs.Where(p => p.Thang == Thang).ToList(); return(a); }
public void Insert(MATHANG mh) { using (QLDLDataContext db = new QLDLDataContext()) { try { db.MATHANGs.InsertOnSubmit(mh); db.SubmitChanges(); } catch (Exception e) { throw e; } } }
//insert public bool Insert(PHIEUTHUTIEN dl) { using (QLDLDataContext db = new QLDLDataContext()) { try { db.PHIEUTHUTIENs.InsertOnSubmit(dl); db.SubmitChanges(); return(true); } catch { return(false); } } }
//insert public bool Insert(PHIEUXUATHANG px) { using (QLDLDataContext db = new QLDLDataContext()) { try { db.PHIEUXUATHANGs.InsertOnSubmit(px); db.SubmitChanges(); return(true); } catch { return(false); } } }
//insert public bool Insert(BAOCAODOANHSO ds) { using (QLDLDataContext db = new QLDLDataContext()) { try { db.BAOCAODOANHSOs.InsertOnSubmit(ds); db.SubmitChanges(); return(true); } catch { return(false); } } }
//insert public bool Insert(DAILY dl) { using (QLDLDataContext db = new QLDLDataContext()) { try { db.DAILies.InsertOnSubmit(dl); db.SubmitChanges(); return(true); } catch { return(false); } } }