public static Data.PBJCollection GetPBJCollection(string varKODEKELENGKAPAN) { SubSonic.QueryCommand cmd = new SubSonic.QueryCommand( "SELECT * FROM PBJ INNER JOIN KELENGKAPANPBJ ON " + "PBJ.KODEPBJ=KELENGKAPANPBJ.KODEBPJ WHERE KELENGKAPANPBJ.KODEKELENGKAPAN=@KODEKELENGKAPAN", KELENGKAPAN.Schema.Provider.Name); cmd.AddParameter("@KODEKELENGKAPAN", varKODEKELENGKAPAN, DbType.String); IDataReader rdr = SubSonic.DataService.GetReader(cmd); PBJCollection coll = new PBJCollection(); coll.LoadAndCloseReader(rdr); return(coll); }
public static void SavePBJMap(string varKODEKELENGKAPAN, PBJCollection items) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM KELENGKAPANPBJ WHERE KODEKELENGKAPAN=@KODEKELENGKAPAN", KELENGKAPAN.Schema.Provider.Name); cmdDel.AddParameter("@KODEKELENGKAPAN", varKODEKELENGKAPAN); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (PBJ item in items) { KELENGKAPANPBJ varKELENGKAPANPBJ = new KELENGKAPANPBJ(); varKELENGKAPANPBJ.SetColumnValue("KODEKELENGKAPAN", varKODEKELENGKAPAN); varKELENGKAPANPBJ.SetColumnValue("KODEBPJ", item.GetPrimaryKeyValue()); varKELENGKAPANPBJ.Save(); } }
private void GetData() { bool bNoRecordsFirstPage = false; if (bNoRecordsFirstPage) { collection = new Data.SKPDCollection(); numrows = 0; } else { if (Search == 0) { GetSearchRows(); } else if (Search == 2) { GetAdvancedSearchRows(); } else { GetAllRows(); } } Data.PBJController PBJ_detailController = new Data.PBJController(); //foreach @TABLE.arrKeyFields as @tk ArrayList PBJ_masterids = new ArrayList(); for (int i = 0; i < collection.Count; ++i) { try{ PBJ_masterids.Add(collection[i].KODESKPD.ToString()); } catch { } } PBJ_detailCollection = PBJ_detailController.FetchForDetails("KODESKPD", PBJ_masterids.ToArray(), OwnerColumn, OwnerID); // save SQL for use in "Export" and "Printer-friendly" pages // select and display records if (allow_search) { // Pagination: if (numrows == 0) { rowsfound = false; message = "No records found"; IDictionary message_block = array(); message_block["begin"] = "<span name=\"notfound_message\">"; message_block["end"] = "</span>"; smarty.Add("message_block", message_block); smarty.Add("message", message); } else { rowsfound = true; int maxRecords = numrows; smarty.Add("records_found", numrows); int maxpages = (int)Math.Ceiling((double)maxRecords / PageSize); if (mypage > maxpages) { mypage = maxpages; } if (mypage < 1) { mypage = 1; } smarty.Add("page", mypage); smarty.Add("maxpages", maxpages); // write pagination if (maxpages > 1) { smarty.Add("pagination_block", true); string pagination = string.Format("<script language=\"JavaScript\">WritePagination({0},{1});function GotoPage(nPageNumber)", mypage, maxpages); pagination += "{window.location='SKPD_list.aspx?goto=' + nPageNumber;}</script>"; smarty.Add("pagination", pagination); } } // hide colunm headers if needed int recordsonpage = numrows - (mypage - 1) * PageSize; if (recordsonpage > PageSize) { recordsonpage = PageSize; } colsonpage = 1; if (colsonpage > recordsonpage) { colsonpage = recordsonpage; } if (colsonpage < 1) { colsonpage = 1; } } }