private void LoadData()
{
ArrayList al = DBLayer.Charges.GetList(Date1, Date2);
DataTable dt = new DataTable();
dt.Columns.Add("Id", typeof(int));
dt.Columns.Add("Date", typeof(DateTime));
dt.Columns.Add("Summ", typeof(double));
dt.Columns.Add("GroupName");
dt.Columns.Add("Name");
double total = 0;
for (int i = 0; i < al.Count; i++)
{
DBLayer.Charges.Charges_WideDetails det = (DBLayer.Charges.Charges_WideDetails)al[i];
DataRow dr = dt.Rows.Add();
dr["Id"] = det.Id;
dr["GroupName"] = det.GroupName;
dr["Date"] = det.Date;
dr["Name"] = det.Name;
dr["Summ"] = det.Summ;
total += det.Summ;
}
lblTotal.Text = total.ToString();
grCharges.DataSource = dt;
advBandedGridView1.BestFitColumns();
}
public static ArrayList GetList(DateTime date1, DateTime date2)
{
string sql = "SELECT c.*, cg.[Name] AS ChargeGroup, a.FIO ";
sql += " FROM Charges AS c INNER JOIN ChargeGroup AS cg ON c.[GroupId] = cg.[Id] LEFT JOIN Administrators AS a ON c.[AdministratorId] = a.[Id] ";
sql += " WHERE c.[Date] BETWEEN '" + date1.ToString("yyyyMMdd") + "' AND '" + date2.ToString("yyyyMMdd") + "'";
sql += " ORDER BY [Date]";
DataTable dt = ZFort.DB.Execute.ExecuteString_DataTable(sql);
ArrayList al = new ArrayList();
foreach (DataRow dr in dt.Rows)
{
DBLayer.Charges.Charges_WideDetails det = new DBLayer.Charges.Charges_WideDetails();
if (!dr.IsNull("Id"))
{
det.Id = Convert.ToInt32(dr["Id"]);
}
det.Name = dr["Name"].ToString();
det.GroupName = dr["ChargeGroup"].ToString();
if (!dr.IsNull("Summ"))
{
det.Summ = Convert.ToDouble(dr["Summ"]);
}
if (!dr.IsNull("Date"))
{
det.Date = Convert.ToDateTime(dr["Date"]);
}
if (!dr.IsNull("AdministratorId"))
{
det.AdminstratorId = Convert.ToInt32(dr["AdministratorId"]);
}
det.FIO = dr["FIO"].ToString();
al.Add(det);
}
return(al);
}
