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));
}
