/// <summary>
/// get chaxun info
/// </summary>
/// <returns></returns>
EyouSoft.Model.FinStructure.MDaiShouChaXunInfo GetChaXunInfo()
{
var info = new EyouSoft.Model.FinStructure.MDaiShouChaXunInfo();
info.OrderCode = Utils.GetQueryStringValue("txtOrderCode");
info.GysId = Utils.GetQueryStringValue(txtGys.GysIdClientID);
info.GysName = Utils.GetQueryStringValue(txtGys.GysNameClientID);
info.Status = (EyouSoft.Model.EnumType.FinStructure.DaiShouStatus?)Utils.GetEnumValueNull(typeof(EyouSoft.Model.EnumType.FinStructure.DaiShouStatus), Utils.GetQueryStringValue("txtStatus"));
return(info);
}
/// <summary>
/// 获取代收信息集合
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="pageSize">页记录数</param>
/// <param name="pageIndex">页索引</param>
/// <param name="recordCount">总记录数</param>
/// <param name="chaXun">查询实体</param>
/// <returns></returns>
public IList <EyouSoft.Model.FinStructure.MDaiShouInfo> GetDaiShous(string companyId, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.FinStructure.MDaiShouChaXunInfo chaXun)
{
if (string.IsNullOrEmpty(companyId))
{
return(null);
}
bool isOnlySelf = false;
int[] depts = null;
depts = GetDataPrivs(EyouSoft.Model.EnumType.PrivsStructure.Menu2.财务管理_代收管理, out isOnlySelf);
return(dal.GetDaiShous(companyId, LoginUserId, depts, pageSize, pageIndex, ref recordCount, chaXun));
}
/// <summary>
/// 获取代收信息集合
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="userId">数据级浏览权限控制-用户编号</param>
/// <param name="depts">数据级浏览权限控制-部门编号</param>
/// <param name="pageSize">页记录数</param>
/// <param name="pageIndex">页索引</param>
/// <param name="recordCount">总记录数</param>
/// <param name="chaXun">查询实体</param>
/// <returns></returns>
public IList <EyouSoft.Model.FinStructure.MDaiShouInfo> GetDaiShous(string companyId, string userId, int[] depts, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.FinStructure.MDaiShouChaXunInfo chaXun)
{
IList <EyouSoft.Model.FinStructure.MDaiShouInfo> items = new List <EyouSoft.Model.FinStructure.MDaiShouInfo>();
string tableName = "view_FinDaiShou";
string fields = "*";
string orderByString = "IdentityId DESC";
string sumString = string.Empty;
StringBuilder sql = new StringBuilder();
sql.AppendFormat(" CompanyId='{0}' ", companyId);
#region privs sql
if (depts != null && depts.Length == 1 && depts[0] == -1)//查看自己
{
sql.AppendFormat(" AND TourSellerId='{0}' ", userId);
}
else
{
if (depts != null && depts.Length > 0)
{
sql.AppendFormat(" AND( TourSellerDeptId IN({0}) ", GetIdsByArr(depts));
if (!string.IsNullOrEmpty(userId))
{
sql.AppendFormat(" OR TourSellerId='{0}' ", userId);
}
sql.Append(" ) ");
}
}
#endregion
#region sql
if (chaXun != null)
{
if (!string.IsNullOrEmpty(chaXun.CrmId))
{
sql.AppendFormat(" AND CrmId='{0}' ", chaXun.CrmId);
}
else if (!string.IsNullOrEmpty(chaXun.CrmName))
{
sql.AppendFormat(" AND CrmName LIKE'%{0}%' ", chaXun.CrmName);
}
if (!string.IsNullOrEmpty(chaXun.GysId))
{
sql.AppendFormat(" AND GysId='{0}' ", chaXun.GysId);
}
else if (!string.IsNullOrEmpty(chaXun.GysName))
{
sql.AppendFormat(" AND GysName='{0}' ", chaXun.GysName);
}
if (!string.IsNullOrEmpty(chaXun.OrderCode))
{
sql.AppendFormat(" AND OrderCode LIKE '%{0}%' ", chaXun.OrderCode);
}
if (chaXun.Status.HasValue)
{
sql.AppendFormat(" AND Status={0} ", (int)chaXun.Status.Value);
}
}
#endregion
using (IDataReader rdr = DbHelper.ExecuteReader1(_db, pageSize, pageIndex, ref recordCount, tableName, fields.ToString(), sql.ToString(), orderByString, sumString))
{
while (rdr.Read())
{
var info = new EyouSoft.Model.FinStructure.MDaiShouInfo();
info.AnPaiId = rdr.GetString(rdr.GetOrdinal("AnPaiId"));
info.BeiZhu = rdr["BeiZhu"].ToString();
info.CompanyId = rdr.GetString(rdr.GetOrdinal("CompanyId"));
info.CrmId = rdr.GetString(rdr.GetOrdinal("CrmId"));
info.CrmName = rdr["CrmName"].ToString();
info.DaiShouId = rdr.GetString(rdr.GetOrdinal("DaiShouId"));
info.GysId = rdr.GetString(rdr.GetOrdinal("GysId"));
info.GysName = rdr["GysName"].ToString();
info.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
info.JinE = rdr.GetDecimal(rdr.GetOrdinal("JinE"));
info.OperatorId = rdr.GetString(rdr.GetOrdinal("OperatorId"));
info.OperatorName = rdr["OperatorName"].ToString();
info.OrderCode = rdr["OrderCode"].ToString();
info.OrderId = rdr.GetString(rdr.GetOrdinal("OrderId"));
info.Status = (EyouSoft.Model.EnumType.FinStructure.DaiShouStatus)rdr.GetByte(rdr.GetOrdinal("Status"));
info.Time = rdr.GetDateTime(rdr.GetOrdinal("Time"));
info.TourId = rdr.GetString(rdr.GetOrdinal("TourId"));
info.OrderSellerName = rdr["OrderSellerName"].ToString();
info.OrderXiaDanRenName = rdr["OrderXiaDanRenName"].ToString();
items.Add(info);
}
}
return(items);
}
