private void LoadDocument(int id) { ArrayList al = DBLayer.DocumentType.GetList(); for (int i = 0; i < al.Count; i++) { DBLayer.DocumentType.Details det = (DBLayer.DocumentType.Details)al[i]; Lib.ServiceFunctions.ListItem li = new FitnessProject.Lib.ServiceFunctions.ListItem(); li.ID = det.Id; li.Name = det.Name; cbDocumentType.Items.Add(li); } for (int i = 0; i < cbDocumentType.Items.Count; i++) { Lib.ServiceFunctions.ListItem li = (Lib.ServiceFunctions.ListItem)cbDocumentType.Items[i]; if (li.ID == id) { cbDocumentType.SelectedIndex = i; break; } } }
private void LoadData() { ArrayList al = DBLayer.DocumentType.GetList(); DataTable dt = new DataTable(); dt.Columns.Add("Id", typeof(int)); dt.Columns.Add("Name"); for (int i = 0; i < al.Count; i++) { DBLayer.DocumentType.Details det = (DBLayer.DocumentType.Details)al[i]; DataRow dr = dt.Rows.Add(); dr["Id"] = det.Id; dr["Name"] = det.Name; } grSources.DataSource = dt; }
public static ArrayList GetList() { DataTable dt = ZFort.DB.Execute.ExecuteString_DataTable("SELECT * FROM DocumentType"); ArrayList al = new ArrayList(); foreach (DataRow dr in dt.Rows) { DBLayer.DocumentType.Details det = new DBLayer.DocumentType.Details(); if (!dr.IsNull("Id")) { det.Id = Convert.ToInt32(dr["Id"]); } det.Name = dr["Name"].ToString(); al.Add(det); } return(al); }
public static void Update(DBLayer.DocumentType.Details det) { ZFort.DB.Execute.ExecuteString_void("UPDATE DocumentType SET [Name] = '" + det.Name + "' WHERE [Id] = " + det.Id.ToString()); }
/*#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.DocumentType.Details det) { ZFort.DB.Execute.ExecuteString_void("INSERT INTO DocumentType ([Name]) VALUES ('" + det.Name + "')"); }