public static DataSet Search_VareNr(string Search, VareStatusEnum Status, int VareGrpID) { DataSet ds = new DataSet(); DataSet dsTemp = new DataSet(); bool flag = false; DBAccess db = new DBAccess(); string[] arr = Search.Split(' '); foreach (string s in arr) { db.AddNVarChar("Search", s, 50); db.AddInt("Status", System.Convert.ToInt32(Status)); db.AddInt("VareGrpID", VareGrpID); dsTemp = db.ExecuteDataSet(_SQLSearchVareNr); db.Parameters.Clear(); //If dsTemp.Tables.Count > 0 Then ds.Merge(dsTemp); if (flag == false) { DataColumn[] pk = new DataColumn[2]; pk[0] = ds.Tables[0].Columns["ID"]; ds.Tables[0].PrimaryKey = pk; flag = true; } //End If } return(ds); }
public static List <Vare> Search_Varelist(string Search, VareStatusEnum Status, int VareGrpID) { DataSet ds = new DataSet(); DataSet dsTemp = new DataSet(); bool flag = false; DBAccess db = new DBAccess(); List <Vare> res = new List <Vare>(); string[] arr = Search.Split(' '); foreach (string s in arr) { db.AddNVarChar("Search", s, 50); db.AddInt("Status", System.Convert.ToInt32(Status)); db.AddInt("VareGrpID", VareGrpID); dsTemp = db.ExecuteDataSet(_SQLSelectBySearch); db.Parameters.Clear(); //If dsTemp.Tables.Count > 0 Then ds.Merge(dsTemp); if (flag == false) { DataColumn[] pk = new DataColumn[2]; pk[0] = ds.Tables[0].Columns["ID"]; ds.Tables[0].PrimaryKey = pk; flag = true; } //End If } Vare rec = default(Vare); DataTableReader dr = ds.Tables[0].CreateDataReader(); if (dr.HasRows) { while (dr.Read()) { rec = new Vare(); Populate(dr, rec); res.Add(rec); } } return(res); }
public static DataSet Search_VareNr(string Search, VareStatusEnum Status) { return(Search_VareNr(Search, Status, System.Convert.ToInt32(VareStatusEnum.Alle))); }
public static int Insert(int VareGrpID, string VareNr, string Navn, string Beskrivelse, int CurrencyID, decimal CurrencyRate, decimal Indkobspris, decimal FragtPct, decimal DaekningsGrad, VareStatusEnum Status, int FragtID, string FaktaArkPath) { Vare c = new Vare(); c.VareGrpID = VareGrpID; c.VareNr = VareNr; c.Navn = Navn; c.Beskrivelse = Beskrivelse; c.CurrencyID = CurrencyID; c.CurrencyRate = CurrencyRate; c.Indkobspris = Indkobspris; c.FragtPct = FragtPct; c.DaekningsGrad = DaekningsGrad; c.Status = VareStatusEnum.Aktiv; c.FragtID = FragtID; c.FaktaArkPath = FaktaArkPath; return(Insert(c)); }