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 + "')"); }