/// <summary>
/// 绑定
/// </summary>
void BindInfo()
{
EyouSoft.BLL.FinanceStructure.CashierRegister bll = new EyouSoft.BLL.FinanceStructure.CashierRegister(SiteUserInfo);
int sumcount = 0;
EyouSoft.Model.FinanceStructure.QueryCashierRegisterInfo model = new EyouSoft.Model.FinanceStructure.QueryCashierRegisterInfo();
model.CompanyId = CurrentUserCompanyID;
model.CustomerId = Utils.GetInt(Utils.GetQueryStringValue("comid"));
//model.EndTime = Utils.GetDateTime( txt_date.Value);
model.PaymentBank = Utils.GetQueryStringValue("bank");
model.StartTime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("begin"));
txt_bank.Value = model.PaymentBank;
txt_com.Value = Utils.GetQueryStringValue("com");
hd_comId.Value = Utils.GetQueryStringValue("comid");
txt_date.Value = Utils.GetQueryStringValue("begin");
IList <EyouSoft.Model.FinanceStructure.CashierRegisterInfo> ilist = bll.GetList(model, 20, Utils.GetInt(Request.QueryString["page"], 1), ref sumcount);
rpt_list.DataSource = ilist;
rpt_list.DataBind();
//合计
bll.GetCashierRegisterMoney(model, ref paymentCount, ref totalAmount);
ExportPageInfo1.intPageSize = 20;
ExportPageInfo1.intRecordCount = sumcount;
ExportPageInfo1.PageLinkURL = Request.Path + "?";
ExportPageInfo1.UrlParams = Request.QueryString;
ExportPageInfo1.CurrencyPage = EyouSoft.Common.Utils.GetInt(Request.QueryString["page"], 1);
}
/// <summary>
/// 获取出纳登帐信息
/// </summary>
/// <param name="model">出纳登帐信息查询实体</param>
/// <param name="HaveUserIds">用户Id集合，半角逗号分割</param>
/// <param name="PageSize">每页条数</param>
/// <param name="PageIndex">当前页数</param>
/// <param name="RecordCount">总记录数</param>
/// <returns></returns>
public IList <EyouSoft.Model.FinanceStructure.CashierRegisterInfo> GetList(EyouSoft.Model.FinanceStructure.QueryCashierRegisterInfo model, string HaveUserIds, int PageSize, int PageIndex, ref int RecordCount)
{
IList <EyouSoft.Model.FinanceStructure.CashierRegisterInfo> list = new List <EyouSoft.Model.FinanceStructure.CashierRegisterInfo>();
string strFiles = " [ID],[PaymentTime],[PaymentCount],[PaymentBank],[Customer],[CustomerID],[Contacter],[ContactTel],[Remark],[CompanyID],[RegisterTime],[OperatorId],[TotalAmount] ";
string strOrder = string.Empty;
string strWhere = this.GetSqlWhere(model, HaveUserIds, ref strOrder);
using (IDataReader dr = DbHelper.ExecuteReader(_db, PageSize, PageIndex, ref RecordCount, "tbl_CashierRegister", "ID", strFiles, strWhere, strOrder))
{
EyouSoft.Model.FinanceStructure.CashierRegisterInfo tmpModel = null;
while (dr.Read())
{
tmpModel = new EyouSoft.Model.FinanceStructure.CashierRegisterInfo();
if (!dr.IsDBNull(dr.GetOrdinal("ID")))
{
tmpModel.RegisterId = int.Parse(dr["ID"].ToString());
}
if (!dr.IsDBNull(dr.GetOrdinal("PaymentTime")))
{
tmpModel.PaymentTime = DateTime.Parse(dr["PaymentTime"].ToString());
}
if (!dr.IsDBNull(dr.GetOrdinal("PaymentCount")))
{
tmpModel.PaymentCount = decimal.Parse(dr["PaymentCount"].ToString());
}
tmpModel.PaymentBank = dr["PaymentBank"].ToString();
tmpModel.CustomerName = dr["Customer"].ToString();
if (!dr.IsDBNull(dr.GetOrdinal("CustomerID")))
{
tmpModel.CustomerId = int.Parse(dr["CustomerID"].ToString());
}
tmpModel.Contacter = dr["Contacter"].ToString();
tmpModel.ContactTel = dr["ContactTel"].ToString();
tmpModel.Remark = dr["Remark"].ToString();
if (!dr.IsDBNull(dr.GetOrdinal("CompanyID")))
{
tmpModel.CompanyId = int.Parse(dr["CompanyID"].ToString());
}
if (!dr.IsDBNull(dr.GetOrdinal("RegisterTime")))
{
tmpModel.CreateTime = DateTime.Parse(dr["RegisterTime"].ToString());
}
if (!dr.IsDBNull(dr.GetOrdinal("OperatorId")))
{
tmpModel.OperatorId = int.Parse(dr["OperatorId"].ToString());
}
if (!dr.IsDBNull(dr.GetOrdinal("TotalAmount")))
{
tmpModel.TotalAmount = decimal.Parse(dr["TotalAmount"].ToString());
}
list.Add(tmpModel);
}
}
return(list);
}
/// <summary>
/// 根据查询实体获取SqlWhere条件
/// </summary>
/// <param name="model">查询实体</param>
/// <param name="HaveUserIds">用户Id集合，半角逗号分割</param>
/// <param name="strOrder">排序语句</param>
/// <returns>SqlWhere条件</returns>
private string GetSqlWhere(EyouSoft.Model.FinanceStructure.QueryCashierRegisterInfo model, string HaveUserIds
, ref string strOrder)
{
if (model == null)
{
return(string.Empty);
}
StringBuilder strWhere = new StringBuilder(" 1 = 1 ");
if (model.CompanyId > 0)
{
strWhere.AppendFormat(" and CompanyID = {0} ", model.CompanyId);
}
if (model.CustomerId > 0)
{
strWhere.AppendFormat(" and CustomerID = {0} ", model.CustomerId);
}
if (!string.IsNullOrEmpty(model.PaymentBank))
{
strWhere.AppendFormat(" and PaymentBank like '%{0}%' ", model.PaymentBank);
}
if (model.StartTime.HasValue)
{
strWhere.AppendFormat(" and datediff(dd,'{0}',PaymentTime) >= 0 ", model.StartTime.Value.ToShortDateString());
}
if (model.EndTime.HasValue)
{
strWhere.AppendFormat(" and datediff(dd,PaymentTime,'{0}') >= 0 ", model.EndTime.Value.ToShortDateString());
}
if (!string.IsNullOrEmpty(HaveUserIds))
{
strWhere.AppendFormat(" and OperatorId in ({0}) ", HaveUserIds);
}
switch (model.OrderIndex)
{
case 0:
strOrder = " PaymentTime asc ";
break;
case 1:
strOrder = " PaymentTime desc ";
break;
}
return(strWhere.ToString());
}
