//public void FormatDataTime()
//{
// chkFromTime.Checked = true;
// DateTime fromDateTaken = new DateTime(1971, 1, 1, System.DateTime.Now.Hour, System.DateTime.Now.Minute, System.DateTime.Now.Second);
// fromDateTaken.Value = System.DateTime.Now;
// toDateTaken.Value = System.DateTime.Now;
// DateTime firstDate = new DateTime(1971, 1, 1, 12, 0, 0);
// DateTime secondDate = new DateTime(1971, 1, 1, 6, 59, 59);
// DateTime excepTime = dtpStart.Value.AddHours(-1);
// if (fromDateTaken >= firstDate && fromDateTaken <= secondDate || excepTime.Day < dtpStart.Value.Day)
// {
// fromDate.Value = fromDate.Value.AddDays(-1);
// }
// else
// {
// toDate.Value = toDate.Value.AddDays(1);
// }
//}
private void button1_Click(object sender, EventArgs e)
{
DataSet dsSalesRecords = new DataSet();
CResult objResult = new CResult();
SystemManager objSystemMgnr = new SystemManager();
DateTime fromDateTaken = new DateTime();
DateTime toDateTaken = new DateTime();
fromDateTaken = new DateTime(fromDate.Value.Year, fromDate.Value.Month, fromDate.Value.Day, 7, 0, 0);
toDateTaken = new DateTime(toDate.Value.Year, toDate.Value.Month, toDate.Value.Day, 6, 59, 59);
toDateTaken = toDateTaken.AddDays(1);
objResult = objSystemMgnr.GetRawMat(fromDateTaken.Ticks, toDateTaken.Ticks);
RawMatGrid.DataSource = null;
DataTable dt = (DataTable)objResult.Data;
tableReport = new DataTable();
tableReport.Columns.Add("cat3_id", typeof(int));
tableReport.Columns.Add("cat3_name", typeof(string));
tableReport.Columns.Add("UnitsInStock", typeof(float));
tableReport.Columns.Add("uom", typeof(string));
tableReport.Columns.Add("Date", typeof(DateTime));
tableReport.Columns.Add("AdditionalQty", typeof(float));
tableReport.Columns.Add("PrevQty",typeof(float));
//long beginTicks = new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc).Ticks;
if (dt != null || dt.Rows.Count > 0)
for (int i = 0; i < dt.Rows.Count; i++)
{
//long dateNumber = Convert.ToInt64(dt.Rows[i]["datetime"]);
// DateTime dateValue = new DateTime(beginTicks + Convert.ToInt64(dt.Rows[i]["datetime"]) * 10000);
tableReport.Rows.Add(Convert.ToInt16(dt.Rows[i]["cat3_id"]), Convert.ToString(dt.Rows[i]["cat3_name"]), dt.Rows[i]["UnitsInStock"].ToString(), dt.Rows[i]["uom"].ToString(), dt.Rows[i]["Date"], dt.Rows[i]["AdditionalQty"], dt.Rows[i]["PrevQty"]);
}
RawMatGrid.AutoGenerateColumns = false;
RawMatGrid.DataSource = tableReport;
// decimal GrandTotal = 0, TotalQty = 0;
// foreach (DataRow row in dt.Rows)
// {
// GrandTotal = GrandTotal + Convert.ToDecimal(row["TotalAmount"]);
// TotalQty = TotalQty + Convert.ToDecimal(row["quantity"]);
// }
// this.OpenConnection();
// SqlCommand Comm = new SqlCommand();
}
