using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using CoreFS.CA06;using Pur.Entity; using Core.Mes.Client.Comm.Control; using Pur.Entity.configureEntity; using Infragistics.Win.UltraWinGrid; using System.Collections; using com.hnshituo.pur.vo; using Pur.Entity.require_planEntiy; using Core.Mes.Client.Comm.Tool; using Pur.configure; using Pur.Pop_upWindow; namespace Pur.ck { public partial class FrmPurOutPlan : FrmPmsBase { public FrmPurOutPlan() { InitializeComponent(); } private void FrmPurOutPlan_Load(object sender, EventArgs e) { Init(); } DateTime? NullTime = null; double? NullDouble = null; #region toolbar菜单 public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": Get_PurUsePlan(); break; case "OutWithUse": doOutWithUse(); break; case "OutWithoutUse": doOutWithoutUse(); break; } } #endregion #region toolbar事件 /// /// 非领用出库 /// private void doOutWithoutUse() { MessageBox.Show("开发中,暂无数据", "提示"); return; } /// /// 领用出库 /// private void doOutWithUse() { //DataTable dt=new DataTable(); //DataSet ds=new DataSet(); //ultraGrid2.UpdateData(); ////扫描grid2,获取选择的数据 //DataTable table; //IQueryable checkRows = ultraGrid2.Rows.AsQueryable().Where("isSelect = 'True' "); //foreach (UltraGridRow row1 in checkRows) //{ // DataRow row; // row = table.NewRow(); // string strMrLineID = row1.Cells["mrLineId"].Value.ToString().Trim(); // row = dataTable2.Select("mrLineId=strMrLineId")[0]; // table.Rows.Add(row); //} //IQueryable checkRows = ultraGrid2.Rows.AsQueryable().Where("isSelect = 'True' "); // DataRow[] rows = dataTable3.Select("Songqty<>'' or Songqty is not null or Songqty <>'0'"); //foreach (DataRow row in rows) //{ // dt_b.ImportRow(row);//复制行数据 //} try { if (ultraGrid1.ActiveRow != null) { ultraGrid2.UpdateData(); ArrayList list = new ArrayList(); IQueryable checkRows = ultraGrid2.Rows.AsQueryable().Where("isSelect = 'True' "); if (checkRows == null || checkRows.Count() < 1) { MessageBox.Show("请选择需要生成送货单的领用单明细", "提示"); return; } foreach (UltraGridRow row in checkRows) { string strMrLineID = row.Cells["mrLineId"].Value.ToString().Trim(); list.Add(strMrLineID); } FrmPurOutBill bfrm = new FrmPurOutBill(this.ob); bfrm.CheckList = list; bfrm.ShowDialog(); Get_PurUsePlan(); } else { MessageBox.Show("操作失败:未选择领用计划", "提示"); } } catch (Exception ex) { MessageBox.Show("操作失败:"+ex.Message, "提示"); } } /// /// 查询 /// private void Get_PurUsePlan() { try { dataTable2.Clear(); dataTable1.Clear(); UsePlanM Upm = new UsePlanM(); Upm.Status = Qstatus.Value == null ? null : Qstatus.Value.ToString(); Upm.Classes = Qclasses.Value == null ? null : Qclasses.Value.ToString(); Upm.PlanType = QplanType.Value == null ? null : QplanType.Value.ToString(); Upm.MrId = QusePlanId.Text; Upm.CreateName = QmatName.Text; Upm.ApplyName = QmatName.Text; if (isTodayPlan.Checked == true) { string start = DateTime.Now.ToString("yyyy-MM-dd ") + "00:00:00"; string end = DateTime.Now.ToString("yyyy-MM-dd ") + "23:59:59"; Upm.UpdateTime = Convert.ToDateTime(start); Upm.DeleteTime = Convert.ToDateTime(end); } else { if (Qtimebegin.Value == null || QtimeEnd.Value == null) { MessageBox.Show("时间为空,请输入有效的查询时间", "提示"); } DateTime start = (DateTime)Qtimebegin.Value; DateTime end = (DateTime)QtimeEnd.Value; Upm.UpdateTime = start; Upm.DeleteTime = end; } DataTable dt = this.execute("com.hnshituo.pur.requireplan.service.UsePlanMService", "find_UsePlanM", new object[] { Upm }); GridHelper.CopyDataToDatatable(dt, dataTable1, true); } catch (Exception ex) { MessageUtil.ShowTips("查询失败:"+ex); } } #endregion #region 界面事件 private void ultraGrid1_AfterCellActivate(object sender, EventArgs e) { dataTable2.Clear(); UltraGridRow ugr = ultraGrid1.ActiveRow; UsePlanD Upd = new UsePlanD(); Upd.Validflag = "1"; Upd.MrId = ugr.Cells["MrId"].Value.ToString(); DataTable dt = this.execute("com.hnshituo.pur.requireplan.service.UsePlanDService", "find_UsePlanD", new object[] { Upd}); GridHelper.CopyDataToDatatable(dt, dataTable2, true); } private void Init() { isTodayPlan.Checked = true; Qtimebegin.Enabled = false; QtimeEnd.Enabled = false; String end = DateTime.Now.ToString("yyyy-MM-dd ") + "23:59:59"; String start = DateTime.Now.AddDays(-30).ToString("yyyy-MM-dd ") + "00:00:00"; Qtimebegin.Value = Convert.ToDateTime(start); QtimeEnd.Value = Convert.ToDateTime(end); } private void isTodayPlan_CheckedChanged(object sender, EventArgs e) { if (isTodayPlan.Checked) { Qtimebegin.Enabled = false; QtimeEnd.Enabled = false; } else { Qtimebegin.Enabled = true; QtimeEnd.Enabled = true; } } #endregion private void ultraPanel1_PaintClient(object sender, PaintEventArgs e) { } } }