public int Update(MChiTietLuat chiTietLuat) { String query = "Update " + tableName + " Set RuleID=" + chiTietLuat.RuleID.ToString() + "," + chiTietLuat.LeftID.ToString() + " Where ID=" + chiTietLuat.ID; return(da.Write(query)); }
public int Insert(MChiTietLuat chiTietLuat) { if (!Exist(chiTietLuat.RuleID, chiTietLuat.LeftID)) { String query = "Insert Into " + tableName + "(RuleID, LeftID) Values(" + chiTietLuat.RuleID.ToString() + "," + chiTietLuat.LeftID.ToString() + ")"; return(da.Write(query)); } else { return(0); } }
public List <MChiTietLuat> SelectAllList(String condition) { DataTable tb = SelectAll(condition); if (tb != null) { List <MChiTietLuat> ds = new List <MChiTietLuat>(); foreach (DataRow r in tb.Rows) { MChiTietLuat m = new MChiTietLuat(); m.ID = int.Parse(r["ID"].ToString()); m.RuleID = int.Parse(r["RuleID"].ToString()); m.LeftID = int.Parse(r["LeftID"].ToString()); ds.Add(m); } return(ds); } else { return(null); } }