public static void UpdateAll(ThamSoDTO thamSos) { var q = @"UPDATE THAMSO SET LuongNhapNN=@nhapNN,LuongTonLN=@tonLN,LuongTonNN=@tonNN,NoLN=@noLN,ChoTraDu=@traDu"; var sqlParas = new[] { new SQLiteParameter("@nhapNN", thamSos.SoLuongNhapNN), new SQLiteParameter("@tonLN", thamSos.LuongTonLN), new SQLiteParameter("@tonNN", thamSos.LuongTonNN), new SQLiteParameter("@noLN", thamSos.NoLN), new SQLiteParameter("@traDu", thamSos.ChoTraDu), }; SqliteExecuteNonQuery(q,sqlParas); }
public static ThamSoDTO GetAll() { var thamSos = new ThamSoDTO(); var obj = SqliteDataReader(@"SELECT * FROM THAMSO", null); if (obj.Read()) { thamSos.SoLuongNhapNN = int.Parse(obj[0].ToString()); thamSos.LuongTonLN = int.Parse(obj[1].ToString()); thamSos.LuongTonNN = int.Parse(obj[2].ToString()); thamSos.NoLN = int.Parse(obj[3].ToString()); thamSos.ChoTraDu = bool.Parse(obj[4].ToString()); } return thamSos; }
public ThamSoDTO getThamSo() { ThamSoDTO ts = new ThamSoDTO(); string sql = "select * from THAMSO"; DataTable dt = conectData.LoadData(sql); if (dt == null || dt.Rows.Count == 0) return null; else { ts.TienKham =float.Parse(dt.Rows[0]["TienKham"].ToString()); ts.SoBenhNhanToiDa=int.Parse(dt.Rows[0]["SoBenhNhanToiDa"].ToString()); } return ts; }