using DevExpress.XtraTreeList.Data;
|
using Gs.DevApp.Entity;
|
using Gs.DevApp.ToolBox;
|
using Gs.DevApp.UserControl;
|
using Newtonsoft.Json;
|
using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Runtime.Remoting.Metadata.W3cXsd2001;
|
using System.Threading.Tasks;
|
using System.Web.UI.WebControls;
|
using System.Windows.Forms;
|
|
namespace Gs.DevApp.DevFrm
|
{
|
public partial class YS_iqcdjy : DevExpress.XtraEditors.XtraForm
|
{
|
//入库检报表
|
string _webServiceName = "YS_rkjreport/";
|
List<FilterEntity> _filterList = new List<FilterEntity>();
|
public YS_iqcdjy()
|
{
|
InitializeComponent();
|
this.toolBarMenu1.btnLoadClick += ToolBarMenu1_btnLoadClick;
|
this.toolBarMenu1.btnQueryClick += ToolBarMenu1_btnQueryClick;
|
this.toolBarMenu1.getXmlConfig();
|
Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameter(gridView1, null, this, "", "", (value) =>
|
{
|
|
});
|
Gs.DevApp.ToolBox.UtilityHelper.SetTabParameter(gridView1, xtraTabControl1, pageBar1, (value) =>
|
{
|
}, (value) =>
|
{
|
getPageList(this.pageBar1.CurrentPage);
|
});
|
getPageList(1);
|
pageBar1.PagerEvent += PageBar1_PagerEvent;
|
}
|
private async void GridView1_ColumnFilterChanged(object sender, EventArgs e)
|
{
|
_filterList = Gs.DevApp.ToolBox.UtilityHelper.GetDilter(gridView1.Columns, gridView1);
|
await Task.Delay(100);
|
getPageList(1);
|
}
|
|
/// <summary>
|
/// 分页事件
|
/// </summary>
|
/// <param name="curPage"></param>
|
/// <param name="pageSize"></param>
|
private void PageBar1_PagerEvent(int curPage, int pageSize)
|
{
|
getPageList(curPage);
|
}
|
/// <summary>
|
/// 查询事件
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
private void ToolBarMenu1_btnQueryClick(object sender, EventArgs e)
|
{
|
gridView1.ColumnFilterChanged -= GridView1_ColumnFilterChanged;
|
gridView1.ActiveFilter.Clear();
|
gridView1.ColumnFilterChanged += GridView1_ColumnFilterChanged;
|
var frm = new ShowFilter(gridView1.Columns, _filterList, this.GetType().FullName);
|
frm.UpdateParent += Frm_UpdateParent;
|
frm.ShowDialog();
|
}
|
/// <summary>
|
/// 查询回调
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
private void Frm_UpdateParent(object sender, UpdateParentEventArgs e)
|
{
|
_filterList = e.FilterList;
|
getPageList(1);
|
}
|
|
/// <summary>
|
/// 刷新事件
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
private void ToolBarMenu1_btnLoadClick(object sender, EventArgs e)
|
{
|
getPageList(this.pageBar1.CurrentPage);
|
}
|
|
/// <summary>
|
///
|
/// </summary>
|
/// <param name="curPage">第几页</param>
|
/// <param name="pageSize">每页几条</param>
|
private void getPageList(int curPage)
|
{
|
gcMain1.DataSource = null; var _sbSqlWhere = UtilityHelper.GetSearchWhere(_filterList);
|
PageQueryModel pgq = new PageQueryModel(curPage, this.pageBar1.RowsCount, "a.INDEP_DATE", "asc", "", _sbSqlWhere.ToString());
|
string json = JsonConvert.SerializeObject(pgq);
|
try
|
{
|
var strReturn = UtilityHelper.HttpPost("", _webServiceName + "GetListPageDJY", json);
|
ReturnModel<PageListModel> dd = UtilityHelper.ReturnToTablePage(strReturn);
|
if (dd.rtnCode > 0)
|
{
|
DataTable dt = dd.rtnData.list;
|
// 转换isOverdue字段为布尔值
|
if (dt.Columns.Contains("isOverdue"))
|
{
|
// 创建新的布尔类型列
|
DataColumn newColumn = new DataColumn("isOverdue_temp", typeof(bool));
|
dt.Columns.Add(newColumn);
|
|
// 转换数据
|
foreach (DataRow row in dt.Rows)
|
{
|
if (row["isOverdue"] != DBNull.Value)
|
{
|
var value = row["isOverdue"].ToString();
|
row["isOverdue_temp"] = (value == "1" || value.ToLower() == "true");
|
}
|
else
|
{
|
row["isOverdue_temp"] = false;
|
}
|
}
|
|
// 删除旧列,重命名新列
|
dt.Columns.Remove("isOverdue");
|
newColumn.ColumnName = "isOverdue";
|
}
|
gcMain1.BindingContext = new BindingContext();
|
gridView1.ColumnFilterChanged -= GridView1_ColumnFilterChanged;
|
if (dt.Rows.Count > 0)
|
{
|
gcMain1.DataSource = dt;
|
gcMain1.ForceInitialize();
|
gridView1.BestFitColumns(); Gs.DevApp.ToolBox.UtilityHelper.SetGridLayout(gridView1);
|
|
}
|
else
|
UtilityHelper.SetDefaultTable(gcMain1, gridView1);
|
gridView1.ColumnFilterChanged += GridView1_ColumnFilterChanged;
|
pageBar1.TotalPages = dd.rtnData.pages;//总页
|
pageBar1.CurrentPage = curPage;//当前页
|
pageBar1.RecordCount = dd.rtnData.total;//总记录数
|
}
|
else
|
{
|
ToolBox.MsgHelper.ShowError("提示：" + dd.rtnMsg);
|
}
|
}
|
catch (Exception ex)
|
{
|
ToolBox.MsgHelper.ShowError("提示：" + ex.Message);
|
}
|
}
|
}
|
}
|
