| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.ComponentModel; |
| | | using System.Configuration; |
| | | using System.Data; |
| | | using System.Drawing; |
| | | using System.Linq; |
| | | using System.Net; |
| | | using System.Text; |
| | | using System.Threading.Tasks; |
| | | using System.Windows.Forms; |
| | |
| | | List<FilterEntity> _filterList = new List<FilterEntity>(); |
| | | string date; |
| | | string lineNo; |
| | | string orgId; |
| | | |
| | | // 用于跟踪原始值的字典 |
| | | private Dictionary<string, Dictionary<string, object>> _originalValues = new Dictionary<string, Dictionary<string, object>>(); |
| | |
| | | this.toolBarMenu1.btnQueryClick += ToolBarMenu1_btnQueryClick; |
| | | this.toolBarMenu1.btnGongZiClick += ToolBarMenu1_btnGongZiClick; |
| | | this.toolBarMenu1.btnLianBanClick += ToolBarMenu1_btnLianBanClick; |
| | | this.toolBarMenu1.btnOutClick += ToolBarMenu1_btnOutClick; |
| | | toolBarMenu1.btnChkClick += ToolBarMenu1_btnChkClick; |
| | | toolBarMenu1.btnFChkClick += ToolBarMenu1_btnFChkClick; |
| | | Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameterMx(gridView2); |
| | |
| | | /// <param name="e"></param> |
| | | private void ToolBarMenu1_btnQueryClick(object sender, EventArgs e) |
| | | { |
| | | var frm = new KQCX(lineNo, date); |
| | | var frm = new KQCX(lineNo, date, orgId); |
| | | //赋值给明细表 |
| | | frm.UpdateParent += (ss, ee) => |
| | | { |
| | |
| | | lst = ee.StringList; |
| | | lineNo = string.IsNullOrEmpty(lst[0]) ? "0" : lst[0]; |
| | | date = string.IsNullOrEmpty(lst[1]) ? DateTime.Now.AddMonths(-1).ToString() : lst[1]; |
| | | orgId = string.IsNullOrEmpty(lst[2]) ? "1" : lst[2]; |
| | | getPageList(); |
| | | }; |
| | | frm.ShowDialog(); |
| | |
| | | var _obj = new |
| | | { |
| | | date = date, |
| | | lineNo = lineNo |
| | | lineNo = lineNo, |
| | | orgId = orgId |
| | | }; |
| | | // gcMain1.DataSource = null; |
| | | var _sbSqlWhere = UtilityHelper.GetSearchWhere(_filterList); |
| | |
| | | var _obj = new |
| | | { |
| | | date = date, |
| | | lineNo = lineNo |
| | | lineNo = lineNo, |
| | | orgId = orgId |
| | | }; |
| | | try |
| | | { |
| | |
| | | { |
| | | lineNo = lineNo, |
| | | date = date, |
| | | list = list |
| | | list = list, |
| | | orgId = orgId |
| | | }; |
| | | |
| | | try |
| | |
| | | { |
| | | lineNo = lineNo, |
| | | date = date, |
| | | list = list |
| | | list = list, |
| | | orgId = orgId |
| | | }; |
| | | |
| | | try |
| | |
| | | MsgHelper.ShowError("提示:" + ex.Message); |
| | | } |
| | | } |
| | | |
| | | 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 |
| | | { |
| | | inLineNo = lineNo,//主建 |
| | | inDate = date, |
| | | inOrgId = orgId |
| | | }; |
| | | var _obj = new Gs.DevApp.Entity.XlsOutModel("xlsOut_AttanCon", "", "", "", _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); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | } |
| | | } |