public List<CwMonthKcInfo> GetListCwMonthKc(int year, int month)
{
StringBuilder sql = new StringBuilder();
sql.Append(" 1=1 ");
sql.AppendFormat(" and year(BillDate)={0} and month(BillDate)={1}", year, month);
WhereClip where = WhereClip.Format(sql.ToString());
List<CwMonthKcInfo> listReturn = new List<CwMonthKcInfo>();
IDBAccessFacade accessFacade = this.GetDBAccessFacade(typeof(CwOutInOrderKc));
IResultAccess result = accessFacade.Select(0, "productNo,WaleNo,Kind,ProductShow,sum(productNum)", where, "productNo,WaleNo,Kind,ProductShow", null, null, 0, 0, false);
if (result.Table != null)
{
foreach (DataRow row in result.Table.Rows)
{
CwMonthKcInfo stat = new CwMonthKcInfo();
stat.productNo = row[0].ToString();
stat.waleNo = row[1].ToString();
stat.kind = short.Parse(row[2].ToString());
stat.productShow = row[3].ToString();
stat.prodcutNum = int.Parse(row[4].ToString());
listReturn.Add(stat);
}
}
return listReturn;
}