public int delPhat(string maphat) { try { CHITIETPHAT ph = linqToMySQL.CHITIETPHATs.Where(t => t.MAPHAT == maphat).FirstOrDefault(); ph.GHICHU = "1"; linqToMySQL.SubmitChanges(); return(1); } catch { return(0); } }
////XuLy //public double tienphat(DateTime ngaydukien,DateTime ngaytra) //{ // double day = (ngaytra - ngaydukien).TotalDays; // day = (double) Math.Round((decimal)day); // if (day < 1) // return 0; // else // { // return day * 1000; // } //} public bool ktSVPhat(string masv) { List <PHAT> phat = linqToMySQL.PHATs.Where(t => t.MADG == masv).Select(t => t).ToList <PHAT>(); foreach (PHAT item in phat) { CHITIETPHAT ct = linqToMySQL.CHITIETPHATs.Where(t => t.MAPHAT == item.MAPHAT).Select(t => t).FirstOrDefault(); if (ct != null && ct.GHICHU == "0") { return(false); } } return(true); }
public void addCTPhat(string maphat, string loai, string masach, int ngayquahan) { CHITIETPHAT ct = new CHITIETPHAT(); ct.MAPHAT = maphat; ct.MALOAIVIPHAM = loai; ct.GHICHU = "0"; DIEUKHOANVIPHAM dk = linqToMySQL.DIEUKHOANVIPHAMs.Where(t => t.MADIEUKHOAN == loai).Select(t => t).FirstOrDefault(); if (dk.MADIEUKHOAN == "DK001") { ct.TIENPHAT = dk.SOTIENPHAT * ngayquahan; } else { SACH s = linqToMySQL.SACHES.Where(t => t.MASACH == masach).Select(t => t).FirstOrDefault(); ct.TIENPHAT = dk.SOTIENPHAT / 100 * s.GIA; } linqToMySQL.CHITIETPHATs.InsertOnSubmit(ct); linqToMySQL.SubmitChanges(); }