public static void DelSp(int spid) { Query q = Supply.Query(); q.AddWhere(Supply.Columns.SupplyId, spid); q.QueryType = QueryType.Delete; q.Execute(); }
public static bool IsSheetNum(string sheetnum) { Query q = Supply.Query(); q.AddWhere(Supply.Columns.SheetNum, sheetnum); DataTable dt = q.ExecuteDataSet().Tables[0]; if (dt.Rows.Count > 0) { return(true); } else { return(false); } }
public static DataTable getSupply() { Query q = Supply.Query(); return(q.ExecuteDataSet().Tables[0]); }