private void btnQuery_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
AccoumtBalance_atb_info atbInfo = new AccoumtBalance_atb_info();
DateTime startTime = DateTime.Parse(this.rspSearch.RSP_TimeFrom.ToString("yyyy/MM/dd"));
DateTime endTime = DateTime.Parse(this.rspSearch.RSP_TimeTo.ToString("yyyy/MM/dd")).AddDays(1);
atbInfo.AccountDate_From = startTime;
atbInfo.AccountDate_To = endTime;
if (!String.IsNullOrEmpty(this.rspSearch.RSP_GradeID.ToString()))
{
atbInfo.GradeID = new Guid(this.rspSearch.RSP_GradeID.ToString());
}
if (!String.IsNullOrEmpty(this.rspSearch.RSP_ClassID.ToString()))
{
atbInfo.ClassID = new Guid(this.rspSearch.RSP_ClassID.ToString());
}
List<AccoumtBalance_atb_info> infoList = _iabBL.SearchRecords(atbInfo);
infoList = infoList.OrderBy(p => p.AccountDate).ToList();
if (infoList != null && infoList.Count > 0)
{
ShowReport(infoList);
}
else
{
ShowWarningMessage("找不到符合条件的记录。");
}
}
catch
{
}
this.Cursor = Cursors.Default;
}
public List<Model.HHZX.Report.AccoumtBalance_atb_info> GetRecord(Model.HHZX.Report.AccoumtBalance_atb_info infoObject)
{
List<AccoumtBalance_atb_info> returnList = new List<AccoumtBalance_atb_info>();
try
{
string conectionString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLModel.Properties.Settings.SIOTS_HHZXDBConnectionString"].ConnectionString;
SqlConnection sqlconn = new SqlConnection(conectionString);
SqlCommand cmd = new SqlCommand("usp_GetAccoumtBalanceReport", sqlconn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 300;
SqlParameter[] parameters = {
new SqlParameter("@dTimeFrom", SqlDbType.DateTime) ,
new SqlParameter("@dTimeTo", SqlDbType.DateTime) ,
new SqlParameter("@GradeID", SqlDbType.UniqueIdentifier) ,
new SqlParameter("@ClassID", SqlDbType.UniqueIdentifier)
};
parameters[0].Value = infoObject.AccountDate_From;
parameters[1].Value = infoObject.AccountDate_To;
parameters[2].Value = infoObject.GradeID;
parameters[3].Value = infoObject.ClassID;
cmd.Parameters.Add(parameters[0]);
cmd.Parameters.Add(parameters[1]);
cmd.Parameters.Add(parameters[2]);
cmd.Parameters.Add(parameters[3]);
sqlconn.Open();
//cmd.ExecuteNonQuery();
SqlDataAdapter dp = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
dp.Fill(dt);
if (dt != null)
{
for (int index = 0; index < dt.Rows.Count; index++)
{
AccoumtBalance_atb_info atbInfo = new AccoumtBalance_atb_info();
atbInfo.AccountDate = (DateTime)(dt.Rows[index]["AccountDate"] != null ? dt.Rows[index]["AccountDate"] : 0);//统计日期
atbInfo.BookingMoney = Decimal.Parse(dt.Rows[index]["BookingMoney"].ToString());//定餐统计
atbInfo.MealPayMoney = Decimal.Parse(dt.Rows[index]["MealPayMoney"].ToString());//加菜消费
atbInfo.HotWaterMoney = Decimal.Parse(dt.Rows[index]["HotWaterMoney"].ToString());//热水消费统计
atbInfo.DrinkMoney = Decimal.Parse(dt.Rows[index]["DrinkMoney"].ToString());//饮料消费统计
atbInfo.NightMealMoney = Decimal.Parse(dt.Rows[index]["NightMealMoney"].ToString());//宵夜统计
atbInfo.ExpendMoney = Decimal.Parse(dt.Rows[index]["ExpendMoney"].ToString());//部门支出统计
atbInfo.BankSavings = Decimal.Parse(dt.Rows[index]["BankSavings"].ToString());//充值额
atbInfo.Breakfast_Act = Int32.Parse(dt.Rows[index]["Breakfast_Act"].ToString());//早餐实际数
atbInfo.Breakfast_Est = Int32.Parse(dt.Rows[index]["Breakfast_Est"].ToString());//早餐计划数
atbInfo.Lunch_Act = Int32.Parse(dt.Rows[index]["Lunch_Act"].ToString());//午餐实际数
atbInfo.Lunch_Est = Int32.Parse(dt.Rows[index]["Lunch_Est"].ToString());//午餐计划数
atbInfo.Dinner_Act = Int32.Parse(dt.Rows[index]["Dinner_Act"].ToString());//晚餐实际数
atbInfo.Dinner_Est = Int32.Parse(dt.Rows[index]["Dinner_Est"].ToString());//晚餐计划数
atbInfo.TotalMoney = Decimal.Parse(dt.Rows[index]["TotalMoney"].ToString());//账户余额
returnList.Add(atbInfo);
}
}
sqlconn.Close();
}
catch
{
}
return returnList;
}
