//static constants
#endregion
#region private members
/// <summary>
/// 获取财务管理-团款支出-按计调项显示支出列表查询条件SQL
/// </summary>
/// <param name="searchInfo"></param>
/// <returns></returns>
string SQLWhere_GetJiDiaoZhiChuLB(EyouSoft.Model.FinanceStructure.MLBJiDiaoZhiChuSearchInfo searchInfo)
{
if (searchInfo == null)
{
return(string.Empty);
}
StringBuilder s = new StringBuilder();
if (searchInfo.CTETime.HasValue)
{
s.AppendFormat(" AND LeaveDate<'{0}' ", searchInfo.CTETime.Value.AddDays(1));
}
if (searchInfo.CTSTime.HasValue)
{
s.AppendFormat(" AND LeaveDate>'{0}' ", searchInfo.CTSTime.Value.AddDays(-1));
}
if (!string.IsNullOrEmpty(searchInfo.GYSName))
{
s.AppendFormat(" AND GYSName LIKE '%{0}%' ", searchInfo.GYSName);
}
if (!string.IsNullOrEmpty(searchInfo.TourCode))
{
s.AppendFormat(" AND TourCode LIKE '%{0}%' ", searchInfo.TourCode);
}
if (searchInfo.TourType.HasValue)
{
s.AppendFormat(" AND TourType={0} ", (int)searchInfo.TourType.Value);
}
if (searchInfo.ZhiChuLeiBie.HasValue)
{
s.AppendFormat(" AND ZhiChuLeiBie={0} ", (int)searchInfo.ZhiChuLeiBie.Value);
}
return(s.ToString());
}
/// <summary>
/// 获取财务管理-团款支出-按计调项显示支出列表合计
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="searchInfo">查询信息</param>
/// <param name="zhiChuJinE">支出金额</param>
/// <param name="yiDengJiJinE">已登记金额</param>
/// <param name="yiZhiFuJinE">已支付金额</param>
public void GetJiDiaoZhiChuLBHeJi(int companyId, EyouSoft.Model.FinanceStructure.MLBJiDiaoZhiChuSearchInfo searchInfo, out decimal zhiChuJinE, out decimal yiDengJiJinE, out decimal yiZhiFuJinE)
{
zhiChuJinE = 0; yiDengJiJinE = 0; yiZhiFuJinE = 0;
if (companyId < 1)
{
return;
}
dal.GetJiDiaoZhiChuLBHeJi(companyId, searchInfo, out zhiChuJinE, out yiDengJiJinE, out yiZhiFuJinE);
}
/// <summary>
/// 获取财务管理-团款支出-按计调项显示支出列表合计
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="searchInfo">查询信息</param>
/// <param name="zhiChuJinE">支出金额</param>
/// <param name="yiDengJiJinE">已登记金额</param>
/// <param name="yiZhiFuJinE">已支付金额</param>
public void GetJiDiaoZhiChuLBHeJi(int companyId, EyouSoft.Model.FinanceStructure.MLBJiDiaoZhiChuSearchInfo searchInfo, out decimal zhiChuJinE, out decimal yiDengJiJinE, out decimal yiZhiFuJinE)
{
zhiChuJinE = 0; yiDengJiJinE = 0; yiZhiFuJinE = 0;
StringBuilder cmdText = new StringBuilder();
#region SQL
cmdText.Append(" SELECT SUM(ZhiChuJinE) AS ZhiChuJinE, ");
cmdText.Append(" SUM(YiDengJiJinE) AS YiDengJiJinE, ");
cmdText.Append(" SUM(YiZhiFuJinE) AS YiZhiFuJinE ");
cmdText.Append(" FROM view_FinJiDiaoZhiChu ");
cmdText.AppendFormat(" WHERE CompanyId={0} ", companyId);
cmdText.Append(SQLWhere_GetJiDiaoZhiChuLB(searchInfo));
#endregion
DbCommand cmd = _db.GetSqlStringCommand(cmdText.ToString());
using (IDataReader rdr = DbHelper.ExecuteReader(cmd, _db))
{
if (rdr.Read())
{
if (!rdr.IsDBNull(0))
{
zhiChuJinE = rdr.GetDecimal(0);
}
if (!rdr.IsDBNull(1))
{
yiDengJiJinE = rdr.GetDecimal(1);
}
if (!rdr.IsDBNull(2))
{
yiZhiFuJinE = rdr.GetDecimal(2);
}
}
}
}
/// <summary>
/// 获取财务管理-团款支出-按计调项显示支出列表
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="pageSize">每页记录数</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="recordCount">总记录数</param>
/// <param name="searchInfo">查询信息</param>
/// <returns></returns>
public IList <EyouSoft.Model.FinanceStructure.MLBJiDiaoZhiChuInfo> GetJiDiaoZhiChuLB(int companyId, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.FinanceStructure.MLBJiDiaoZhiChuSearchInfo searchInfo)
{
IList <EyouSoft.Model.FinanceStructure.MLBJiDiaoZhiChuInfo> items = new List <EyouSoft.Model.FinanceStructure.MLBJiDiaoZhiChuInfo>();
StringBuilder cmdQuery = new StringBuilder();
string tableName = "view_FinJiDiaoZhiChu";
string primaryKey = "AnPaiId";
string orderByString = "AnPaiTime DESC";
string fields = "*";
#region SQL
cmdQuery.AppendFormat(" CompanyId={0} ", companyId);
cmdQuery.Append(SQLWhere_GetJiDiaoZhiChuLB(searchInfo));
#endregion
using (IDataReader rdr = DbHelper.ExecuteReader(_db, pageSize, pageIndex, ref recordCount, tableName, primaryKey, fields.ToString(), cmdQuery.ToString(), orderByString))
{
while (rdr.Read())
{
var item = new EyouSoft.Model.FinanceStructure.MLBJiDiaoZhiChuInfo();
item.AnPaiId = rdr.GetString(rdr.GetOrdinal("AnPaiId"));
item.CTTime = rdr.GetDateTime(rdr.GetOrdinal("LeaveDate"));
item.GYSName = rdr["GYSName"].ToString();
item.RouteName = rdr["RouteName"].ToString();
item.TourCode = rdr["TourCode"].ToString();
item.TourType = (EyouSoft.Model.EnumType.TourStructure.TourType)rdr.GetByte(rdr.GetOrdinal("TourType"));
item.YiDengJiJinE = rdr.GetDecimal(rdr.GetOrdinal("YiDengJiJinE"));
item.YiZhiFuJinE = rdr.GetDecimal(rdr.GetOrdinal("YiZhiFuJinE"));
item.ZhiChuJinE = rdr.GetDecimal(rdr.GetOrdinal("ZhiChuJinE"));
item.ZhiChuLeiBie = (EyouSoft.Model.EnumType.CompanyStructure.SupplierType)rdr.GetInt32(rdr.GetOrdinal("ZhiChuLeiBie"));
item.TourId = rdr.GetString(rdr.GetOrdinal("TourId"));
item.GYSId = rdr.GetInt32(rdr.GetOrdinal("GYSId"));
items.Add(item);
}
}
return(items);
}
/// <summary>
/// 获取财务管理-团款支出-按计调项显示支出列表
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="pageSize">每页记录数</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="recordCount">总记录数</param>
/// <param name="searchInfo">查询信息</param>
/// <returns></returns>
public IList <EyouSoft.Model.FinanceStructure.MLBJiDiaoZhiChuInfo> GetJiDiaoZhiChuLB(int companyId, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.FinanceStructure.MLBJiDiaoZhiChuSearchInfo searchInfo)
{
if (companyId < 1)
{
return(null);
}
return(dal.GetJiDiaoZhiChuLB(companyId, pageSize, pageIndex, ref recordCount, searchInfo));
}
/// <summary>
/// 绑定列表
/// </summary>
void BindInfo()
{
int count = 0;
EyouSoft.BLL.TourStructure.Tour bll = new EyouSoft.BLL.TourStructure.Tour(SiteUserInfo);
EyouSoft.Model.FinanceStructure.MLBJiDiaoZhiChuSearchInfo SearchInfo = new EyouSoft.Model.FinanceStructure.MLBJiDiaoZhiChuSearchInfo();
#region 查询参数
string ddltype = Utils.GetQueryStringValue("tourtype");
string teamNum = Utils.GetQueryStringValue("tourCode");
txt_teamNum.Value = teamNum;
string com = Utils.GetQueryStringValue("companyName");
txt_com.Value = com;
string comtype = Utils.GetQueryStringValue("comType");
string goDate = Utils.GetQueryStringValue("beginDate");
txt_godate.Value = goDate;
if (ddltype != "-1" && ddltype != "")
{
select.Value = ddltype;
SearchInfo.TourType = (EyouSoft.Model.EnumType.TourStructure.TourType)Utils.GetInt(ddltype);
}
if (teamNum != "")
{
SearchInfo.TourCode = teamNum;
}
if (com != "")
{
SearchInfo.GYSName = com;
}
if (comtype != "-1" && comtype != "")
{
ddl_comType.SelectedValue = comtype;
SearchInfo.ZhiChuLeiBie = (EyouSoft.Model.EnumType.CompanyStructure.SupplierType)Utils.GetInt(comtype);
}
SearchInfo.CTSTime = Utils.GetDateTimeNullable(goDate);
SearchInfo.CTETime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("rdate"));
#endregion
EyouSoft.BLL.FinanceStructure.BZhiChu newbll = new EyouSoft.BLL.FinanceStructure.BZhiChu();
IList <EyouSoft.Model.FinanceStructure.MLBJiDiaoZhiChuInfo> List = newbll.GetJiDiaoZhiChuLB(CurrentUserCompanyID, 20, Utils.GetInt(Utils.GetQueryStringValue("page")), ref count, SearchInfo);
if (List != null && List.Count > 0)
{
rpt_list1.DataSource = List;
rpt_list1.DataBind();
}
//合计
decimal ZhichuMoney, yidengjiMoney, yizhifuMoney = 0;
newbll.GetJiDiaoZhiChuLBHeJi(CurrentUserCompanyID, SearchInfo, out ZhichuMoney, out yidengjiMoney, out yizhifuMoney);
this.lbyidengjimoney.Text = yidengjiMoney.ToString("c2");
this.lbyizhifumoney.Text = yizhifuMoney.ToString("c2");
this.lbzhichumoney.Text = ZhichuMoney.ToString("c2");
//未登记=支出金额-已登记
//未支付=支出金额-已支付
this.lbweizhifumoney.Text = (ZhichuMoney - yizhifuMoney).ToString("c2");
this.lbweidengjimoney.Text = (ZhichuMoney - yidengjiMoney).ToString("c2");
this.rpt_list1.EmptyText = "<tr><td height='30px' bgcolor='#e3f1fc' colspan='11' align='center'>暂时没有数据！</td></tr>";
#region 分页
ExportPageInfo1.intPageSize = 20;
ExportPageInfo1.intRecordCount = count;
ExportPageInfo1.PageLinkURL = Request.Path + "?";
ExportPageInfo1.UrlParams = Request.QueryString;
ExportPageInfo1.CurrencyPage = EyouSoft.Common.Utils.GetInt(Request.QueryString["page"], 1);
#endregion
}
