private void LoadData() { ArrayList al = DBLayer.Services.GetList(); DataTable dt = new DataTable(); dt.Columns.Add("Id", typeof(int)); dt.Columns.Add("Name"); dt.Columns.Add("Dimension"); dt.Columns.Add("CostPerUnit", typeof(double)); dt.Columns.Add("Type"); for (int i = 0; i < al.Count; i++) { DBLayer.Services.Services_WideDetails det = (DBLayer.Services.Services_WideDetails)al[i]; DataRow dr = dt.Rows.Add(); dr["Id"] = det.Id; dr["Name"] = det.Name; dr["Dimension"] = det.DimensionName; dr["CostPerUnit"] = det.CostPerUnit; string name = string.Empty; switch (det.Type) { case 0: name = "Солярий"; break; case 1: name = "Массаж"; break; case 2: name = "Сауна"; break; case 3: name = "Косметология"; break; case 4: name = "Аренда"; break; } dr["Type"] = name; } grGoods.DataSource = dt; }
private void LoadServices() { ArrayList al = DBLayer.Services.GetList(); for (int i = 0; i < al.Count; i++) { DBLayer.Services.Services_WideDetails det = (DBLayer.Services.Services_WideDetails)al[i]; Lib.ServiceFunctions.ListItem liP = new FitnessProject.Lib.ServiceFunctions.ListItem(); liP.ID = det.Id; liP.Name = det.Name; cbProduct.Items.Add(liP); } }
public static ArrayList GetList() { string sql = "SELECT s.[Name], s.[Id], s.DimensionId, d.[Name] AS Dimension, s.CostPerUnit, s.[Type] "; sql += " FROM Services AS s "; sql += " INNER JOIN Dimensions AS d ON d.[Id] = s.[DimensionId] "; DataTable dt = ZFort.DB.Execute.ExecuteString_DataTable(sql); ArrayList al = new ArrayList(); foreach (DataRow dr in dt.Rows) { DBLayer.Services.Services_WideDetails det = new DBLayer.Services.Services_WideDetails(); if (!dr.IsNull("Id")) { det.Id = Convert.ToInt32(dr["Id"]); } det.Name = dr["Name"].ToString(); if (!dr.IsNull("CostPerUnit")) { det.CostPerUnit = Convert.ToDouble(dr["CostPerUnit"]); } if (!dr.IsNull("DimensionId")) { det.DimensionId = Convert.ToInt32(dr["DimensionId"]); } det.DimensionName = dr["Dimension"].ToString(); if (!dr.IsNull("Type")) { det.Type = Convert.ToInt32(dr["Type"]); } al.Add(det); } return(al); }