public static ArrayList GetList()
{
DataTable dt = ZFort.DB.Execute.ExecuteString_DataTable("SELECT * FROM Barcodes");
ArrayList al = new ArrayList();
foreach (DataRow dr in dt.Rows)
{
DBLayer.Barcodes.Details det = new DBLayer.Barcodes.Details();
det.Name = dr["Barcode"].ToString();
al.Add(det);
}
return(al);
}
private void LoadData()
{
ArrayList al = DBLayer.Barcodes.GetList();
DataTable dt = new DataTable();
dt.Columns.Add("Name");
for (int i = 0; i < al.Count; i++)
{
DataRow dr = dt.Rows.Add();
DBLayer.Barcodes.Details det = (DBLayer.Barcodes.Details)al[i];
dr["Name"] = det.Name;
}
grBarcodes.DataSource = dt;
}
/*#region Check
*
* public static bool Check(string name, int id)
* {
*
* Database.Service serv = new Management.Database.Service();
*
* return serv.AdvertisingSource_Check(name, id);
* }
*
#endregion*/
#region Insert
public static void Insert(DBLayer.Barcodes.Details det)
{
ZFort.DB.Execute.ExecuteString_void("INSERT INTO Barcodes (Barcode) VALUES ('" + det.Name + "')");
}
