using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Data.Linq; using System.Linq; using System.Drawing; using System.Text; using System.Windows.Forms; using DevExpress.XtraEditors; using DevExpress.XtraGrid.Views.BandedGrid; using DevExpress.XtraGrid.Columns; using DevExpress.XtraGrid; using System.IO; using System.Threading; using ICSSoft.Base.Language.Tool; using ICSSoft.Base.Config.AppConfig; using ICSSoft.Base.UserControl.MessageControl; using ICSSoft.Base.Report.Filter; using ICSSoft.Base.Config.DBHelper; using ICSSoft.Base.UserControl.FormControl; using ICSSoft.Base.Report.GridReport; using ICSSoft.Base.ReferForm.AppReferForm; using ICSSoft.Base.Lable.PrintTool; using ICSSoft.Frame.APP; namespace ICSSoft.Frame.APP { public partial class FormICSDispatchLists : DevExpress.XtraEditors.XtraForm { private string sqltxt = ""; private string sqlconn = ""; String guid = AppConfig.GetGuid(); private DataTable dataSource = null; #region 构造函数 public FormICSDispatchLists() { InitializeComponent(); this.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height); this.WindowState = FormWindowState.Maximized; } #endregion #region SystemOptition /// /// 操作权限 /// /// public DataTable RightOfExute() { DataTable rData = new DataTable(); rData.Columns.Add("BtnName"); rData.Columns.Add("ActionName"); //查看权限(必须有) DataRow seeRow = rData.NewRow(); seeRow["BtnName"] = "see"; seeRow["ActionName"] = "查看"; rData.Rows.Add(seeRow); List ControlList = new List(); ControlList.Add(btnOutPut); ControlList.Add(btnSynchro); // foreach (Control ctr in ControlList) { if (ctr.GetType() == typeof(SimpleButton)) { DataRow dr = rData.NewRow(); dr["BtnName"] = ctr.Name; dr["ActionName"] = ctr.Text; rData.Rows.Add(dr); } } rData.AcceptChanges(); return rData; } /// /// 数据权限 /// /// public DataTable RightOfData() { DataTable rData = new DataTable(); rData.Columns.Add("BodyName"); rData.Columns.Add("ControlName"); rData.Columns.Add("ControlCaption"); rData.AcceptChanges(); return rData; } #endregion #region 退出 private void btnClose_Click(object sender, EventArgs e) { AppConfig.CloseFormShow(this.Text); this.Close(); } private void btnExit_Click(object sender, EventArgs e) { AppConfig.CloseFormShow(this.Text); this.Close(); } #endregion #region 移动窗体 private const int WM_NCHITTEST = 0x84; private const int HTCLIENT = 0x1; private const int HTCAPTION = 0x2; //首先必须了解Windows的消息传递机制,当有鼠标活动消息时, //系统发送WM_NCHITTEST 消息给窗体作为判断消息发生地的根据。 nchittest //假如你点击的是标题栏,窗体收到的消息值就是 HTCAPTION , //同样地,若接受到的消息是 HTCLIENT,说明用户点击的是客户区,也就是鼠标消息发生在客户区。 //重写窗体,使窗体可以不通过自带标题栏实现移动 protected override void WndProc(ref Message m) { //当重载窗体的 WndProc 方法时,可以截获 WM_NCHITTEST 消息并改些该消息, //当判断鼠标事件发生在客户区时,改写改消息,发送 HTCAPTION 给窗体, //这样,窗体收到的消息就时 HTCAPTION ,在客户区通过鼠标来拖动窗体就如同通过标题栏来拖动一样。 //注意:当你重载 WndProc 并改写鼠标事件后,整个窗体的鼠标事件也就随之改变了。 switch (m.Msg) { case WM_NCHITTEST: base.WndProc(ref m); if ((int)m.Result == HTCLIENT) m.Result = (IntPtr)HTCAPTION; return; } //拦截双击标题栏、移动窗体的系统消息 if (m.Msg != 0xA3) { base.WndProc(ref m); } } #endregion #region 列表 private void grvDetail_CustomDrawRowIndicator(object sender, DevExpress.XtraGrid.Views.Grid.RowIndicatorCustomDrawEventArgs e) { if (e.Info.IsRowIndicator && e.RowHandle >= 0) e.Info.DisplayText = (e.RowHandle + 1).ToString(); } #endregion #region 过滤 private string tempTableName = ""; private void btnFilter_Click(object sender, EventArgs e) { FormFilter filter = new FormFilter(AppConfig.GetSourceId(this.Tag.ToString(), btnConfig.Name)); filter.OldTempTableName = tempTableName; if (filter.ShowDialog() == DialogResult.OK) { DevExpress.Utils.WaitDialogForm _wait = new DevExpress.Utils.WaitDialogForm("正在查找...请稍等..."); try { _wait.Show(); tempTableName = filter.NewTempTableName; sqltxt = filter.SqlText; sqlconn = filter.FilterConnectString; dataSource = filter.FilterData.Tables[0]; grdDetail.DataSource = dataSource; grvDetail.BestFitColumns(); rptPage.RecordNum = dataSource.Rows.Count; rptPage.PageSize = 499; rptPage.PageIndex = 1; rptPage.ReLoad(); rptPage.PageSize = 500; rptPage.PageIndex = 1; rptPage.ReLoad(); _wait.Close(); } catch (Exception ex) { MessageBox.Show("异常:" + ex.Message, "异常", MessageBoxButtons.OK, MessageBoxIcon.Error); _wait.Close(); } } } #endregion #region 绑定数据源 private void btnConfig_Click(object sender, EventArgs e) { if (AppConfig.UserCode.ToLower() != "demo") { ICSBaseSimpleCode.AppshowMessageBox("您没有权限设置数据源,请联系软件提供商!"); return; } FormDataSource fdata = new FormDataSource(AppConfig.GetMenuId(this.Tag.ToString()), btnConfig.Name); fdata.ShowDialog(); } #endregion #region 分页 private void rptPage_PageIndexChanged(object Sender, EventArgs e) { //DataTable data = AppConfig.GetPageData(dataSource, rptPage.PageIndex, rptPage.PageSize).Copy(); DataTable data = AppConfig.GetPageDataByDb(tempTableName, "pagerowindex", rptPage.PageSize, rptPage.PageIndex, dataSource.Rows.Count); grdDetail.DataSource = data; } #endregion #region 过滤方法 private void FormContainerManager_FormClosing(object sender, FormClosingEventArgs e) { AppConfig.DropTemTable(tempTableName); } #endregion #region 导出 private void btnOutPut_Click(object sender, EventArgs e) { SimpleButton btntemp = (SimpleButton)sender; if (AppConfig.GetUserExcuteRight(this.Tag.ToString(), btntemp.Name) == false) { ICSBaseSimpleCode.AppshowMessageBox("对不起您没有:" + btntemp.Text + "权限,请联系系统管理员!"); return; } FormOutExcel foe = new FormOutExcel(this.Tag.ToString(), grdDetail); foe.ShowDialog(); } #endregion #region 刷新 private void btnRefresh_Click(object sender, EventArgs e) { if (sqlconn == null || sqlconn == "") { return; } DevExpress.Utils.WaitDialogForm _wait = new DevExpress.Utils.WaitDialogForm("正在查找...请稍等..."); try { _wait.Show(); FormFilter filter = new FormFilter(AppConfig.GetSourceId(this.Tag.ToString(), btnConfig.Name), false); dataSource = DBHelper.ExecuteDataset(sqlconn, CommandType.Text, sqltxt).Tables[0]; grdDetail.DataSource = dataSource; grvDetail.BestFitColumns(); rptPage.RecordNum = dataSource.Rows.Count; rptPage.PageIndex = 1; _wait.Close(); } catch (Exception ex) { MessageBox.Show("异常:" + ex.Message, "异常", MessageBoxButtons.OK, MessageBoxIcon.Error); _wait.Close(); } } #endregion #region 新增 private void btnCreate_Click(object sender, EventArgs e) { SimpleButton btntemp = (SimpleButton)sender; if (AppConfig.GetUserExcuteRight(this.Tag.ToString(), btntemp.Name) == false) { ICSBaseSimpleCode.AppshowMessageBox("对不起您没有:" + btntemp.Text + "权限,请联系系统管理员!"); return; } string sql = @"SELECT rd01.dDate AS 到货日期,rd01.cVenCode AS 供应商编码,ven.cVenName AS 供应商名称, rd01s.cInvCode AS 存货编码,inv.cInvName AS 存货名称,inv.cInvStd AS 规格型号,rd01s.AutoID,cBatch as 批号, CASE WHEN ISNULL(rd01s.iNum,0)=0 THEN rd01s.iQuantity ELSE rd01s.iNum END AS 到货数量, unit.cComUnitName AS 主计量单位, rd01s.cUnitID AS 辅计量单位编码, units.cComUnitName AS 辅计量单位 FROM {0}.dbo.PU_ArrivalVouch rd01 INNER JOIN {0}.dbo.PU_ArrivalVouchs rd01s ON rd01s.ID = rd01.ID LEFT JOIN {0}.dbo.Inventory inv ON rd01s.cInvCode =inv.cInvCode LEFT JOIN {0}.dbo.Vendor ven ON rd01.cVenCode=ven.cVenCode LEFT JOIN {0}.dbo.ComputationUnit unit ON inv.cComUnitCode=unit.cComunitCode LEFT JOIN {0}.dbo.ComputationUnit units ON rd01s.cUnitID=units.cComunitCode left join dbo.ICSPurchasingStorage pu on rd01s.AutoID=pu.Rd01AutoID WHERE (rd01.cverifier<>'' OR rd01.cverifier IS NOT NULL) and pu.Rd01AutoID is NULL"; sql = string.Format(sql, ICSBaseSimpleCode.GetWorkPointErpData()); DataTable data = DBHelper.ExecuteDataset(AppConfig.AppConnectString,CommandType.Text,sql).Tables[0]; FormDataRefer reForm = new FormDataRefer(); reForm.FormTitle = "库房列表"; reForm.HideCols.Add("AutoID"); reForm.HideCols.Add("辅计量单位编码"); DataTable menuData = data; reForm.DataSource = menuData; reForm.MSelectFlag = false; reForm.RowIndexWidth = 35; reForm.Width = 850; reForm.Height = 550; if (reForm.ShowDialog() == DialogResult.OK) { string batch = ""; DataTable retData = reForm.ReturnData; //FormPurchasingAdd add = new FormPurchasingAdd(retData); //if (add.ShowDialog() == DialogResult.OK) //{ // batch = add.batch; //} //else { // return; //} try { //FormPurchasingStorageBLL.save(retData, batch); }catch(Exception ex){ ICSBaseSimpleCode.AppshowMessageBox(ex.Message); return; } } btnRefresh_Click(null, null); } #endregion private void FormICSItemLot_Load(object sender, EventArgs e) { FormFilter filter = new FormFilter(AppConfig.GetSourceId(this.Tag.ToString(), btnConfig.Name)); filter.OldTempTableName = tempTableName; if (filter.ShowDialog() == DialogResult.OK) { DevExpress.Utils.WaitDialogForm _wait = new DevExpress.Utils.WaitDialogForm("正在查找...请稍等..."); try { _wait.Show(); tempTableName = filter.NewTempTableName; sqltxt = filter.SqlText; sqlconn = filter.FilterConnectString; dataSource = filter.FilterData.Tables[0]; grdDetail.DataSource = dataSource; grvDetail.BestFitColumns(); rptPage.RecordNum = dataSource.Rows.Count; rptPage.PageSize = 499; rptPage.PageIndex = 1; rptPage.ReLoad(); rptPage.PageSize = 500; rptPage.PageIndex = 1; rptPage.ReLoad(); _wait.Close(); } catch (Exception ex) { MessageBox.Show("异常:" + ex.Message, "异常", MessageBoxButtons.OK, MessageBoxIcon.Error); _wait.Close(); } } } //private void btnImportData_Click(object sender, EventArgs e) //{ // SimpleButton btntemp = (SimpleButton)sender; // if (AppConfig.GetUserExcuteRight(this.Tag.ToString(), btntemp.Name) == false) // { // ICSBaseSimpleCode.AppshowMessageBox("对不起您没有:" + btntemp.Text + "权限,请联系系统管理员!"); // return; // } // DevExpress.Utils.WaitDialogForm _wait = new DevExpress.Utils.WaitDialogForm(); // _wait.Hide(); // try // { // FormReadExcel fre = new FormReadExcel(); // if (fre.ShowDialog() != DialogResult.OK) // { // return; // } // DataTable dataSource = fre._excelData; // if (dataSource == null) // { // throw new Exception("excel数据取得失败"); // } // _wait.Show(); // _wait.Caption = "判断模版是否正确......"; // #region 判断模版是否正确 // List colNameList = new List(); // colNameList.Add("存货编码"); // colNameList.Add("批号"); // colNameList.Add("数量"); // colNameList.Add("供应商编码"); // colNameList.Add("仓库编码"); // for (int i = 0; i < colNameList.Count;i++ ) // { // if (!dataSource.Columns.Contains(colNameList[i])) // { // throw new Exception("模版不正确,缺少列" + colNameList[i]); // } // } // #endregion // _wait.Caption = "数据整理中......"; // List initList = new List(); // foreach (DataRow dr in dataSource.Rows) // { // ///判断必输项目是否为空 // foreach (string colName in colNameList) // { // if (string.IsNullOrWhiteSpace(dr[colName].ToString()) == true && colName != "批号") // { // throw new Exception("列" + colName + "没有输入值"); // } // } // InitialInvtory InitInvInfo = new InitialInvtory(); // InitInvInfo.ItemCode = dr["存货编码"].ToString(); // InitInvInfo.BatchCode = dr["批号"].ToString(); // InitInvInfo.Qty = dr["数量"].ToString(); // InitInvInfo.VenCode = dr["供应商编码"].ToString(); // InitInvInfo.WhCode = dr["仓库编码"].ToString(); // initList.Add(InitInvInfo); // } // _wait.Caption = "导入期初数据......"; // string erpName = ICSSoft.AoMy.BLL.ICSBaseSimpleCode.GetWorkPointErpData(); // StockBarCodeBLL.ImportData(initList, erpName); // _wait.Close(); // btnRefresh_Click(null, null); // } // catch (Exception ex) // { // _wait.Close(); // MessageBox.Show("期初数据导入失败。" + ex.Message); // } //} private void btnbeginAdd_Click(object sender, EventArgs e) { SimpleButton btntemp = (SimpleButton)sender; if (AppConfig.GetUserExcuteRight(this.Tag.ToString(), btntemp.Name) == false) { ICSBaseSimpleCode.AppshowMessageBox("对不起您没有:" + btntemp.Text + "权限,请联系系统管理员!"); return; } try { //FormPurchasingBeginningAdd edit = new FormPurchasingBeginningAdd(); //edit.ShowDialog(); //btnRefresh_Click(null, null); } catch (Exception ex) { ICSBaseSimpleCode.AppshowMessageBox(ex.Message); } } private void btnQcCheck_Click(object sender, EventArgs e) { SimpleButton btntemp = (SimpleButton)sender; if (AppConfig.GetUserExcuteRight(this.Tag.ToString(), btntemp.Name) == false) { ICSBaseSimpleCode.AppshowMessageBox("对不起您没有:" + btntemp.Text + "权限,请联系系统管理员!"); return; } } private void btnSynchro_Click(object sender, EventArgs e) { SimpleButton btntemp = (SimpleButton)sender; if (AppConfig.GetUserExcuteRight(this.Tag.ToString(), btntemp.Name) == false) { ICSBaseSimpleCode.AppshowMessageBox("对不起您没有:" + btntemp.Text + "权限,请联系系统管理员!"); return; } DevExpress.Utils.WaitDialogForm _wait = new DevExpress.Utils.WaitDialogForm("正在同步请稍等..."); try { _wait.Show(); SAP.ASPWebSoapClient srv = new SAP.ASPWebSoapClient(); srv.initSODispatch(); _wait.Close(); ICSBaseSimpleCode.AppshowMessageBox("同步成功"); } catch (Exception ex) { _wait.Close(); ICSBaseSimpleCode.AppshowMessageBox(ex.Message); } } } }