/// <summary>
/// 获取发票已登记列表合计信息
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="crmId">客户单位编号</param>
/// <param name="searchInfo">查询实体</param>
/// <param name="kaiPiaoJinE">开票金额合计</param>
public void GetFaPiaosHeJi(int companyId, int crmId, EyouSoft.Model.FinanceStructure.MFaPiaoSearchInfo searchInfo, out decimal kaiPiaoJinE)
{
kaiPiaoJinE = 0;
if (companyId < 1 || crmId < 1)
{
return;
}
dal.GetFaPiaosHeJi(companyId, crmId, searchInfo, out kaiPiaoJinE);
}
/// <summary>
/// 初始化发票登记列表
/// </summary>
void InitLB()
{
int pageSize = 12;
int pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"), 1);
int recordCount = 0;
int keHuDanWeiId = Utils.GetInt(Utils.GetQueryStringValue("kehudanweiid"));
var searchInfo = new EyouSoft.Model.FinanceStructure.MFaPiaoSearchInfo();
searchInfo.KPETime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("kpetime"));
searchInfo.KPRen = Utils.GetQueryStringValue("kaipiaoren");
searchInfo.KPSTime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("kpstime"));
var bll = new EyouSoft.BLL.FinanceStructure.BFaPiao();
var items = bll.GetFaPiaos(CurrentUserCompanyID, keHuDanWeiId, pageSize, pageIndex, ref recordCount, searchInfo);
if (items != null && items.Count > 0)
{
phLB.Visible = true;
phEmpty.Visible = false;
rptLB.DataSource = items;
rptLB.DataBind();
paging.PageLinkURL = Request.ServerVariables["SCRIPT_NAME"].ToString() + "?";
paging.UrlParams = Request.QueryString;
paging.intPageSize = pageSize;
paging.CurrencyPage = pageIndex;
paging.intRecordCount = recordCount;
decimal kaiPiaoJinE;
bll.GetFaPiaosHeJi(CurrentUserCompanyID, keHuDanWeiId, searchInfo, out kaiPiaoJinE);
ltrKaiPiaoJinEHeJi.Text = kaiPiaoJinE.ToString("C2");
}
else
{
phLB.Visible = false;
phEmpty.Visible = true;
}
bll = null;
}
/// <summary>
/// 获取发票已登记列表合计信息
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="crmId">客户单位编号</param>
/// <param name="searchInfo">查询实体</param>
/// <param name="kaiPiaoJinE">开票金额合计</param>
public void GetFaPiaosHeJi(int companyId, int crmId, EyouSoft.Model.FinanceStructure.MFaPiaoSearchInfo searchInfo, out decimal kaiPiaoJinE)
{
kaiPiaoJinE = 0;
StringBuilder cmdText = new StringBuilder();
#region SQL
cmdText.Append(" SELECT SUM(JinE) AS KaiPiaoJinE FROM tbl_FinFaPiao WHERE IsDelete='0' ");
cmdText.AppendFormat(" AND CompanyId={0} ", companyId);
cmdText.AppendFormat(" AND CrmId={0} ", crmId);
if (searchInfo != null)
{
if (searchInfo.KPETime.HasValue)
{
cmdText.AppendFormat(" AND RiQi<'{0}' ", searchInfo.KPETime.Value.AddDays(1));
}
if (!string.IsNullOrEmpty(searchInfo.KPRen))
{
cmdText.AppendFormat(" AND KaiPiaoRen LIKE '%{0}%' ", searchInfo.KPRen);
}
if (searchInfo.KPSTime.HasValue)
{
cmdText.AppendFormat(" AND RiQi>'{0}' ", searchInfo.KPSTime.Value.AddDays(-1));
}
}
#endregion
DbCommand cmd = _db.GetSqlStringCommand(cmdText.ToString());
using (IDataReader rdr = DbHelper.ExecuteReader(cmd, _db))
{
if (rdr.Read())
{
if (!rdr.IsDBNull(0))
{
kaiPiaoJinE = rdr.GetDecimal(0);
}
}
}
}
/// <summary>
/// 获取发票已登记列表
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="crmId">客户单位编号</param>
/// <param name="pageSize">每页记录数</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="recordCount">总记录数</param>
/// <param name="searchInfo">查询信息</param>
/// <returns></returns>
public IList <EyouSoft.Model.FinanceStructure.MFaPiaoInfo> GetFaPiaos(int companyId, int crmId, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.FinanceStructure.MFaPiaoSearchInfo searchInfo)
{
IList <EyouSoft.Model.FinanceStructure.MFaPiaoInfo> items = new List <EyouSoft.Model.FinanceStructure.MFaPiaoInfo>();
StringBuilder cmdQuery = new StringBuilder();
string tableName = "tbl_FinFaPiao";
string primaryKey = "Id";
string orderByString = "RiQi DESC";
string fields = "*";
#region SQL
cmdQuery.AppendFormat(" IsDelete='0' AND CompanyId={0} AND CrmId={1} ", companyId, crmId);
if (searchInfo != null)
{
if (searchInfo.KPETime.HasValue)
{
cmdQuery.AppendFormat(" AND RiQi<'{0}' ", searchInfo.KPETime.Value.AddDays(1));
}
if (!string.IsNullOrEmpty(searchInfo.KPRen))
{
cmdQuery.AppendFormat(" AND KaiPiaoRen LIKE '%{0}%' ", searchInfo.KPRen);
}
if (searchInfo.KPSTime.HasValue)
{
cmdQuery.AppendFormat(" AND RiQi>'{0}' ", searchInfo.KPSTime.Value.AddDays(-1));
}
}
#endregion
using (IDataReader rdr = DbHelper.ExecuteReader(this._db, pageSize, pageIndex, ref recordCount, tableName, primaryKey, fields.ToString(), cmdQuery.ToString(), orderByString))
{
while (rdr.Read())
{
var item = new EyouSoft.Model.FinanceStructure.MFaPiaoInfo();
item.BeiZhu = rdr["BeiZhu"].ToString();
item.CaoZuoRenId = rdr.GetInt32(rdr.GetOrdinal("CaoZuoRenId"));
item.CompanyId = rdr.GetInt32(rdr.GetOrdinal("CompanyId"));
item.CrmId = rdr.GetInt32(rdr.GetOrdinal("CrmId"));
item.Id = rdr.GetString(rdr.GetOrdinal("Id"));
item.JinE = rdr.GetDecimal(rdr.GetOrdinal("JinE"));
item.KaiPiaoRen = rdr["KaiPiaoRen"].ToString();
item.KaiPiaoRenId = rdr.GetInt32(rdr.GetOrdinal("KaiPiaoRenId"));
item.PiaoHao = rdr["PiaoHao"].ToString();
item.RiQi = rdr.GetDateTime(rdr.GetOrdinal("RiQi"));
items.Add(item);
}
}
return(items);
}
/// <summary>
/// 获取发票已登记列表
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="crmId">客户单位编号</param>
/// <param name="pageSize">每页记录数</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="recordCount">总记录数</param>
/// <param name="searchInfo">查询信息</param>
/// <returns></returns>
public IList <EyouSoft.Model.FinanceStructure.MFaPiaoInfo> GetFaPiaos(int companyId, int crmId, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.FinanceStructure.MFaPiaoSearchInfo searchInfo)
{
if (companyId < 1 || crmId < 1)
{
return(null);
}
return(dal.GetFaPiaos(companyId, crmId, pageSize, pageIndex, ref recordCount, searchInfo));
}
