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);
}
}
}
