public static ArrayList GetList()
{
DataTable dt = ZFort.DB.Execute.ExecuteString_DataTable("SELECT * FROM Suppliers");
ArrayList al = new ArrayList();
foreach (DataRow dr in dt.Rows)
{
DBLayer.Suppliers.Details det = new DBLayer.Suppliers.Details();
if (!dr.IsNull("Id"))
{
det.Id = Convert.ToInt32(dr["Id"]);
}
det.Name = dr["Name"].ToString();
det.Director = dr["Director"].ToString();
det.Phone = dr["Phone"].ToString();
det.Fax = dr["Fax"].ToString();
if (!dr.IsNull("Type"))
{
det.Type = Convert.ToInt32(dr["Type"]);
}
al.Add(det);
}
return(al);
}
public static void Update(DBLayer.Suppliers.Details det)
{
ZFort.DB.Execute.ExecuteString_void("UPDATE Suppliers SET [Name] = '" + det.Name + "' WHERE [Id] = " + det.Id.ToString());
ZFort.DB.Execute.ExecuteString_void("UPDATE Suppliers SET [Director] = '" + det.Director + "' WHERE [Id] = " + det.Id.ToString());
ZFort.DB.Execute.ExecuteString_void("UPDATE Suppliers SET [Phone] = '" + det.Phone + "' WHERE [Id] = " + det.Id.ToString());
ZFort.DB.Execute.ExecuteString_void("UPDATE Suppliers SET [Fax] = '" + det.Fax + "' WHERE [Id] = " + det.Id.ToString());
ZFort.DB.Execute.ExecuteString_void("UPDATE Suppliers SET [Type] = " + det.Type.ToString() + " WHERE [Id] = " + det.Id.ToString());
}
private void LoadData()
{
ArrayList al = DBLayer.Suppliers.GetList();
DataTable dt = new DataTable();
dt.Columns.Add("Id", typeof(int));
dt.Columns.Add("Name");
dt.Columns.Add("Director");
dt.Columns.Add("Fax");
dt.Columns.Add("Phone");
dt.Columns.Add("Type", typeof(int));
dt.Columns.Add("TypeName");
for (int i = 0; i < al.Count; i++)
{
DBLayer.Suppliers.Details det = (DBLayer.Suppliers.Details)al[i];
DataRow dr = dt.Rows.Add();
dr["Id"] = det.Id;
dr["Name"] = det.Name;
dr["Director"] = det.Director;
dr["Phone"] = det.Phone;
dr["Fax"] = det.Fax;
switch (det.Type)
{
case 0:
dr["TypeName"] = "Постоянный";
break;
case 1:
dr["TypeName"] = "Единоразовый";
break;
case 2:
dr["TypeName"] = "Ситуативный";
break;
}
}
grSources.DataSource = dt;
}
public FrmEditSupplier(int id)
{
InitializeComponent();
this.Id = id;
//MessageBox.Show(this.Id.ToString());
this.Details = DBLayer.Suppliers.GetDetails(id);
tbName.Text = this.Details.Name;
tbDirector.Text = this.Details.Director;
tbFax.Text = this.Details.Fax;
tbPhone.Text = this.Details.Phone;
ddlType.SelectedIndex = this.Details.Type;
}
private void LoadSuppliers(int id)
{
ArrayList al = DBLayer.Suppliers.GetList();
cbSuppliers.Items.Clear();
for (int i = 0; i < al.Count; i++)
{
DBLayer.Suppliers.Details det = (DBLayer.Suppliers.Details)al[i];
Lib.ServiceFunctions.ListItem li = new FitnessProject.Lib.ServiceFunctions.ListItem();
li.ID = det.Id;
li.Name = det.Name;
cbSuppliers.Items.Add(li);
}
if (cbSuppliers.Items.Count > 0)
{
if (id == 0)
{
cbSuppliers.SelectedIndex = 0;
}
else
{
for (int i = 0; i < cbSuppliers.Items.Count; i++)
{
Lib.ServiceFunctions.ListItem li = (Lib.ServiceFunctions.ListItem)cbSuppliers.Items[i];
if (li.ID == id)
{
cbSuppliers.SelectedIndex = i;
break;
}
}
}
}
}
/*#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.Suppliers.Details det)
{
ZFort.DB.Execute.ExecuteString_void("INSERT INTO Suppliers ([Type], [Name], Director, Phone, Fax) VALUES (" + det.Type.ToString() + ", '" + det.Name + "', '" + det.Director + "', '" + det.Phone + "', '" + det.Fax + "')");
}
