using DevExpress.XtraGrid.Columns;
|
using Gs.DevApp.DevFrm.JJGZ;
|
using Gs.DevApp.Entity;
|
using Gs.DevApp.ToolBox;
|
using Newtonsoft.Json;
|
using Newtonsoft.Json.Linq;
|
using System;
|
using System.Collections.Generic;
|
using System.Configuration;
|
using System.Data;
|
using System.Net;
|
using System.Threading.Tasks;
|
using System.Windows.Forms;
|
|
namespace Gs.DevApp.DevFrm.JJGZ
|
{
|
public partial class Frm_YDCQ : DevExpress.XtraEditors.XtraForm
|
{
|
private List<FilterEntity> _filterList = new List<FilterEntity>();
|
private readonly string _webServiceName = "MesJjgzReport/";
|
private string beginDate;
|
private string endDate;
|
private string lineNo;
|
|
public Frm_YDCQ()
|
{
|
InitializeComponent();
|
toolBarMenu1.btnLoadClick += ToolBarMenu1_btnLoadClick;
|
toolBarMenu1.btnQueryClick += ToolBarMenu1_btnQueryClick;
|
|
this.toolBarMenu1.getXmlConfig();
|
Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameter(gridView1, null, null, "", "", (value) =>
|
{
|
|
}, tips);
|
|
this.toolBarMenu1.btnOutClick += ToolBarMenu1_btnOutClick;
|
}
|
|
private void GridView1_ColumnFilterChanged(object sender, EventArgs e)
|
{
|
_filterList = Gs.DevApp.ToolBox.UtilityHelper.GetDilter(gridView1.Columns, gridView1);
|
Task.Delay(100);
|
getPageList();
|
}
|
|
|
/// <summary>
|
/// 查询事件
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
private void ToolBarMenu1_btnQueryClick(object sender, EventArgs e)
|
{
|
var frm = new YDCQCX(lineNo, beginDate, endDate);
|
//赋值给明细表
|
frm.UpdateParent += (ss, ee) =>
|
{
|
var lst = new List<string>();
|
lst = ee.StringList;
|
lineNo = string.IsNullOrEmpty(lst[0]) ? "0" : lst[0];
|
beginDate = string.IsNullOrEmpty(lst[1])? DateTime.Now.AddMonths(-1).ToString() : lst[1];
|
endDate = string.IsNullOrEmpty(lst[2]) ? DateTime.Now.ToString() : lst[2];
|
getPageList();
|
};
|
frm.ShowDialog();
|
}
|
|
/// <summary>
|
/// 刷新事件
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
private void ToolBarMenu1_btnLoadClick(object sender, EventArgs e)
|
{
|
|
//getPageList(1);
|
getPageList();
|
|
}
|
|
/// <summary>
|
/// </summary>
|
/// <param name="curPage">第几页</param>
|
/// <param name="pageSize">每页几条</param>
|
private void getPageList()
|
{
|
if (string.IsNullOrEmpty(lineNo) || string.IsNullOrEmpty(beginDate) || string.IsNullOrEmpty(endDate))
|
{
|
return;
|
}
|
|
gcMain1.DataSource = null; var _sbSqlWhere = UtilityHelper.GetSearchWhere(_filterList);
|
var _obj = new
|
{
|
lineNo = lineNo,//主建
|
beginDate = beginDate,
|
endDate = endDate
|
};
|
try
|
{
|
var strReturn = UtilityHelper.HttpPost("",
|
_webServiceName + "GetYQCQList", JsonConvert.SerializeObject(_obj));
|
ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strReturn);
|
if (_rtn.rtnCode > 0)
|
{
|
dynamic dy = _rtn.rtnData;
|
JObject _job = JObject.Parse(strReturn);
|
JArray array = new JArray();
|
foreach (var a in _job["rtnData"]["list"])
|
{
|
array.Add(a);
|
}
|
DataTable dt = JsonConvert.DeserializeObject<DataTable>(array.ToString());
|
|
|
List<DateTime> allDates = new List<DateTime>();
|
for (DateTime date = DateTime.Parse(beginDate); date < DateTime.Parse(endDate); date = date.AddDays(1))
|
{
|
allDates.Add(date);
|
}
|
gridView1.Columns.Clear();
|
|
// 添加固定列
|
AddFixedColumns();
|
|
// 添加日期列
|
foreach (DateTime date in allDates)
|
{
|
string columnName = date.ToString("yyyy-MM-dd");
|
|
// 如果数据表中存在该列
|
if (dt.Columns.Contains(columnName))
|
{
|
GridColumn colDate = new GridColumn();
|
colDate.FieldName = columnName;
|
colDate.Caption = date.ToString("MM-dd");
|
colDate.Visible = true;
|
colDate.OptionsColumn.AllowEdit = false;
|
colDate.Width = 60;
|
|
gridView1.Columns.Add(colDate);
|
}
|
}
|
|
|
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);
|
|
}
|
else
|
ToolBox.MsgHelper.Warning("提示：" + _rtn.rtnMsg);
|
}
|
catch (Exception ex)
|
{
|
MsgHelper.Warning("提示：" + ex.Message);
|
}
|
}
|
|
private void AddFixedColumns()
|
{
|
// 产线编码
|
GridColumn colMaterialCode = new GridColumn();
|
colMaterialCode.FieldName = "lineNo";
|
colMaterialCode.Caption = "产线编码";
|
colMaterialCode.Visible = true;
|
colMaterialCode.OptionsColumn.AllowEdit = false;
|
gridView1.Columns.Add(colMaterialCode);
|
|
// 产线名称
|
GridColumn colMaterialName = new GridColumn();
|
colMaterialName.FieldName = "lineName";
|
colMaterialName.Caption = "产线名称";
|
colMaterialName.Visible = true;
|
colMaterialName.OptionsColumn.AllowEdit = false;
|
gridView1.Columns.Add(colMaterialName);
|
|
// 员工编码
|
GridColumn colMaterialSpec = new GridColumn();
|
colMaterialSpec.FieldName = "staffNo";
|
colMaterialSpec.Caption = "员工编码";
|
colMaterialSpec.Visible = true;
|
colMaterialSpec.OptionsColumn.AllowEdit = false;
|
gridView1.Columns.Add(colMaterialSpec);
|
|
// 员工名称
|
GridColumn colTotalRequired = new GridColumn();
|
colTotalRequired.FieldName = "staffName";
|
colTotalRequired.Caption = "员工名称";
|
colTotalRequired.Visible = true;
|
colTotalRequired.OptionsColumn.AllowEdit = false;
|
gridView1.Columns.Add(colTotalRequired);
|
}
|
|
private void ToolBarMenu1_btnOutClick(object sender, EventArgs e)
|
{
|
using (FolderBrowserDialog folderBrowserDialog = new FolderBrowserDialog())
|
{
|
folderBrowserDialog.Description = "选择导出文件的保存路径";
|
DialogResult dialogResult = folderBrowserDialog.ShowDialog();
|
if (dialogResult == DialogResult.OK)
|
{
|
string _folder = folderBrowserDialog.SelectedPath;
|
var _params = new
|
{
|
LineNo = lineNo,//主建
|
beginDate = beginDate,
|
endDate = endDate
|
};
|
var _obj = new Gs.DevApp.Entity.XlsOutModel("xlsOut_YDCQ", "", "", "", _params);
|
try
|
{
|
string strJson = UtilityHelper.HttpPost("", "XlsInOut/XlsOutView_NEW", JsonConvert.SerializeObject(_obj));
|
ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson);
|
if (_rtn.rtnCode > 0)
|
{
|
string _file = _rtn.rtnData.fileUrl.ToString();
|
string _folderName = _folder + "\\" + _file.Replace("down/", "");
|
string _url = ConfigurationManager.AppSettings["WebApiUrl"].ToString() + _file;
|
using (WebClient client = new WebClient())
|
{
|
client.DownloadFile(_url, _folderName);
|
}
|
ToolBox.MsgHelper.ShowInformation("导出成功！");
|
}
|
else
|
{
|
ToolBox.MsgHelper.Warning("提示：" + _rtn.rtnMsg);
|
}
|
}
|
catch (Exception ex)
|
{
|
ToolBox.MsgHelper.Warning("提示：" + ex.Message);
|
}
|
}
|
}
|
}
|
}
|
}
|
