public ActionResult BaoXianListProvide(BaoXianDTO baoDanDTO)
{
if (!base.HasPermission("BaoXian", PermissionOperate.manager))
{
return(null);
}
int isAll = 1;
if (!base.HasPermission("BaoXianAll", PermissionOperate.manager))
{
baoDanDTO.MpUserId = base.LoginAdmin.MpUserId.HasValue ? base.LoginAdmin.MpUserId : Guid.Empty;
isAll = 0;
}
OceanDynamicList <object> list = _baodanService.GetPageDynamicList(PageIndex, PageSize, baoDanDTO, isAll);
if (list != null)
{
return(Content(list.ToJson(), "text/javascript"));
}
else
{
return(Content("{\"rows\":[],\"total\":0}", "text/javascript"));
}
}
public OceanDynamicList <object> GetPageDynamicList(int pageIndex, int pageSize, BaoXianDTO baodanDTO, int isAll)
{
string condition = "";
Dictionary <string, object> parms = new Dictionary <string, object>();
if (!string.IsNullOrEmpty(baodanDTO.TouBaoGongSi))
{
parms.Add("TouBaoGongSi", baodanDTO.TouBaoGongSi);
if (!string.IsNullOrEmpty(condition))
{
condition += " and ";
}
else
{
condition += " where ";
}
condition += "TouBaoGongSi=@TouBaoGongSi";
}
if (!string.IsNullOrEmpty(baodanDTO.TouBaoRen))
{
parms.Add("TouBaoRen", baodanDTO.TouBaoRen);
if (!string.IsNullOrEmpty(condition))
{
condition += " and ";
}
else
{
condition += " where ";
}
condition += "TouBaoRen like '%'+@TouBaoRen+'%'";
}
if (baodanDTO.StartDate.HasValue)
{
parms.Add("StartDate", baodanDTO.StartDate);
if (!string.IsNullOrEmpty(condition))
{
condition += " and ";
}
else
{
condition += " where ";
}
condition += "f.QiBaoDate >= @StartDate";
}
if (baodanDTO.EndDate.HasValue)
{
parms.Add("EndDate", baodanDTO.EndDate);
if (!string.IsNullOrEmpty(condition))
{
condition += " and ";
}
else
{
condition += " where ";
}
condition += "f.QiBaoDate <= @EndDate";
}
if (!string.IsNullOrEmpty(baodanDTO.ChePai))
{
parms.Add("ChePai", baodanDTO.ChePai);
if (!string.IsNullOrEmpty(condition))
{
condition += " and ";
}
else
{
condition += " where ";
}
condition += "ChePai like '%'+@ChePai+'%'";
}
if (baodanDTO.BaoXianQiXian.HasValue)
{
parms.Add("BaoXianQiXian", baodanDTO.BaoXianQiXian);
if (!string.IsNullOrEmpty(condition))
{
condition += " and ";
}
else
{
condition += " where ";
}
condition += "BaoXianQiXian = @BaoXianQiXian'";
}
if (!string.IsNullOrEmpty(baodanDTO.HouSiWei))
{
parms.Add("HouSiWei", baodanDTO.HouSiWei);
if (!string.IsNullOrEmpty(condition))
{
condition += " and ";
}
else
{
condition += " where ";
}
condition += "HouSiWei like '%'+@HouSiWei+'%'";
}
if (!string.IsNullOrEmpty(baodanDTO.LaiYuan))
{
parms.Add("LaiYuan", baodanDTO.LaiYuan);
if (!string.IsNullOrEmpty(condition))
{
condition += " and ";
}
else
{
condition += " where ";
}
condition += "LaiYuan like '%'+@LaiYuan+'%'";
}
if (baodanDTO.XianZhong.HasValue)
{
parms.Add("XianZhong", baodanDTO.XianZhong);
if (!string.IsNullOrEmpty(condition))
{
condition += " and ";
}
else
{
condition += " where ";
}
condition += "XianZhong = @XianZhong'";
}
if (isAll == 0)
{
parms.Add("MpUserId", baodanDTO.MpUserId);
if (!string.IsNullOrEmpty(condition))
{
condition += " and ";
}
else
{
condition += " where ";
}
condition += "MpUserId = @MpUserId";
}
return(this.GetDynamicList("SELECT f.Id,f.MpUserId MpUserId,f.TouBaoGongSi,f.TouBaoRen,f.ChePai,f.QiBaoDate,f.BaoXianQiXian,f.HouSiWei,f.DengJiDate,f.BaoXianFei,f.CheChuanSui,f.LaiYuan,f.XianZhong,f.CreateDate CreateDate FROM BaoDan f " + condition + " order by f.CreateDate desc", pageIndex, pageSize, parms));
}
