public BsTableDataSource <PositionViewModel> GetPositionList(GetPositionList request)
{
using (var db = DbFactory.Open())
{
var builder = db.From <Model.Position.Position>();
switch (request.typeId)
{
//0:行政村信息，1：行政村防汛防台工作组，2：行政村网格责任人，3：行政村危险区人员转移清单，4：镇级防汛防台责任人
case 0:
break;
case 1: //行政村防汛防台工作组
builder.Where(x => x.PositionType == GrassrootsFloodCtrlEnums.ZZTXEnums.行政村防汛防台工作组.ToString());
break;
case 2: //行政村网格责任人
builder.Where(x => x.PositionType == GrassrootsFloodCtrlEnums.ZZTXEnums.行政村网格责任人.ToString());
break;
case 3: //行政村危险区人员转移清单
builder.Where(x => x.PositionType == GrassrootsFloodCtrlEnums.ZZTXEnums.行政村危险区人员转移清单.ToString());
break;
case 4: //镇级防汛防台责任人
builder.Where(x => x.PositionType == GrassrootsFloodCtrlEnums.ZZTXEnums.镇级防汛防台责任人.ToString());
break;
case 5: //镇级防汛防台责任人
builder.Where(x => x.PositionType == GrassrootsFloodCtrlEnums.ZZTXEnums.县级防汛防台责任人.ToString());
break;
default:
throw new Exception("类型不正确");
}
var count = db.Select(builder).Count;
if (!string.IsNullOrEmpty(request.Sort) && !string.IsNullOrEmpty(request.Order) && request.Order == "asc")
{
builder.OrderBy(o => request.Sort);
}
else if (!string.IsNullOrEmpty(request.Sort) && !string.IsNullOrEmpty(request.Order) && request.Order == "desc")
{
builder.OrderByDescending(o => request.Sort);
}
else
{
builder.OrderBy(o => o.orderId);
}
var PageSize = request.PageSize == 0 ? 15 : request.PageSize;
var PageIndex = request.PageIndex == 0 ? 0 : (request.PageIndex - 1) * PageSize;
builder.Limit(PageIndex, PageSize);
var RList = db.Select <PositionViewModel>(builder);
return(new BsTableDataSource <PositionViewModel>()
{
rows = RList, total = count
});
}
}
private void AssignPositions_Load(object sender, EventArgs e)
{
GetPositionList positionList = new GetPositionList(-1);
//load available positions to the available lists
try
{
positionList.Send();
}
catch (Exception ex)
{
Utilities.Log(Properties.Resources.errorFailedToGetData + " " + ex.Message, LoggerLevel.Severe);
MessageForm.Show(this, Properties.Resources.errorFailedToGetData, Properties.Resources.securityCenter);
return;
}
mAvailablePositions = positionList.Positions;
LoadPositionsToLists();
}
//START RALLY DE 6739
private void CheckPositionsCount()
{
GetPositionList positionList = new GetPositionList(Constants.GETALL_INSERT);
try
{
positionList.Send();
}
catch (Exception ex)
{
MessageForm.Show(Properties.Resources.errorFailedToGetData + " " + ex.Message, Properties.Resources.securityCenter);
return;
}
DataView mPositionsView = new DataView(positionList.Positions.PositionTable);
if (mPositionsView.Count > 0)
{
EnablePositionEditMenu(true);
}
else
{
EnablePositionEditMenu(false);
}
}
public BsTableDataSource <PositionViewModel> Get(GetPositionList request)
{
return(PositionManager.GetPositionList(request));
}
