private void RefreshTextBoxes() { this.ClearTextBoxes(); var worksheet = this.reoGridControlPutaway.Worksheets[0]; int[] ids = Utilities.GetSelectedIDs(this.reoGridControlPutaway); if (ids.Length == 0) { this.putawayTicketID = -1; return; } int id = ids[0]; PutawayTicketView putawayTicketView = (from s in this.wmsEntities.PutawayTicketView where s.ID == id select s).FirstOrDefault(); if (putawayTicketView == null) { MessageBox.Show("系统错误,未找到相应送检单项目", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } //putawayTicketView.ReceiptTicketID = this.receiptTicketID; //this.putawayTicketID = int.Parse(submissionTicketItemView.SubmissionTicketID.ToString()); Utilities.CopyPropertiesToTextBoxes(putawayTicketView, this); //this.Controls.Find("textBoxReceiptTicketID", true)[0].Text = this.receiptTicketID.ToString(); //Utilities.CopyPropertiesToComboBoxes(shipmentTicketItemView, this); }
private void Search() { this.labelStatus.Text = "搜索中..."; new Thread(new ThreadStart(() => { var wmsEntities = new WMSEntities(); //ReceiptTicketView[] receiptTicketViews = null; PutawayTicketView[] putawayTicketView = null; try { putawayTicketView = wmsEntities.Database.SqlQuery <PutawayTicketView>(String.Format("SELECT * FROM PutawayTicketView WHERE ReceiptTicketID={0}", receiptTicketID)).ToArray(); } catch { MessageBox.Show("无法连接到数据库,请查看网络连接!", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Error); return; } this.reoGridControlPutaway.Invoke(new Action(() => { this.labelStatus.Text = "搜索完成"; var worksheet = this.reoGridControlPutaway.Worksheets[0]; worksheet.DeleteRangeData(RangePosition.EntireRange); int n = 0; for (int i = 0; i < putawayTicketView.Length; i++) { if (putawayTicketView[i].State == "作废") { continue; } PutawayTicketView curPutawayTicketView = putawayTicketView[i]; object[] columns = Utilities.GetValuesByPropertieNames(curPutawayTicketView, (from kn in ReceiptMetaData.putawayTicketKeyName select kn.Key).ToArray()); for (int j = 0; j < worksheet.Columns; j++) { if (columns[j] == null) { worksheet[n, j] = columns[j]; } else { worksheet[n, j] = columns[j].ToString(); } } n++; } })); this.Invoke(new Action(this.RefreshTextBoxes)); })).Start(); }
private void FormPutwayTicketModify_Load(object sender, EventArgs e) { InitComponent(); if (this.formMode == FormMode.ALTER) { PutawayTicketView putawayTicketView = (from pt in wmsEntities.PutawayTicketView where pt.ID == this.putawayTicketID select pt).FirstOrDefault(); if (putawayTicketView != null) { Utilities.CopyPropertiesToTextBoxes(putawayTicketView, this); } } else { TextBox textBoxReceiptTicketID = (TextBox)this.Controls.Find("textBoxReceiptTicketID", true)[0]; textBoxReceiptTicketID.Text = this.receiptTicketID.ToString(); textBoxReceiptTicketID.Enabled = false; } }
private void FormPutawayModify_Load(object sender, EventArgs e) { //InitComponent(); Utilities.CreateEditPanel(this.tableLayoutPanelTextBoxes, ReceiptMetaData.putawayTicketKeyName); this.PersonIDGetter = Utilities.BindTextBoxSelect <FormSelectPerson, Person>(this, "textBoxPersonName", "Name"); putawayTicket = (from pt in wmsEntities.PutawayTicket where pt.ID == this.putawayTicketID select pt).FirstOrDefault(); PutawayTicketView putawayTicketView = (from ptv in wmsEntities.PutawayTicketView where ptv.ID == this.putawayTicketID select ptv).FirstOrDefault(); if (putawayTicketView == null) { MessageBox.Show("找不到该上架单", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } else { Utilities.CopyPropertiesToTextBoxes(putawayTicketView, this); Utilities.CopyPropertiesToComboBoxes(putawayTicketView, this); } }
private void toolStripButton1_Click(object sender, EventArgs e) { var worksheet = this.reoGridControlUser.Worksheets[0]; StandardFormPreviewExcel formPreview = new StandardFormPreviewExcel("上架单预览"); WMSEntities wmsEntities = new WMSEntities(); int[] ids = Utilities.GetSelectedIDs(this.reoGridControlUser); if (ids.Length == 0) { MessageBox.Show("请选择一项预览", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } foreach (int id in ids) { try { PutawayTicketView putawayTicketView = (from ptv in wmsEntities.PutawayTicketView where ptv.ID == id select ptv).FirstOrDefault(); PutawayTicketItemView[] putawayTicketItemView = (from ptiv in wmsEntities.PutawayTicketItemView where ptiv.PutawayTicketID == putawayTicketView.ID select ptiv).ToArray <PutawayTicketItemView>(); string worksheetName = id.ToString(); if (putawayTicketView == null) { MessageBox.Show("上架单不存在,请重新查询!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } //ReceiptTicketView receiptTicketView = (from rtv in wmsEntities.ReceiptTicketView where rtv.ID == submissionTicketView.ReceiptTicketID select rtv).FirstOrDefault(); if (formPreview.AddPatternTable(@"Excel\PutawayTicket.xlsx", worksheetName) == false) { this.Close(); return; } if (putawayTicketView != null) { formPreview.AddData("PutawayTicket", putawayTicketView, worksheetName); } formPreview.AddData("PutawayTicketItem", putawayTicketItemView, worksheetName); formPreview.SetPrintScale(1.0F, worksheetName); } catch { MessageBox.Show("搜索失败,请检查网络连接!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } formPreview.SetPrintedCallback(new Action(() => { WMSEntities wmsEntities2 = new WMSEntities(); foreach (int id in ids) { PutawayTicket putawayTicket = (from pt in wmsEntities2.PutawayTicket where pt.ID == id select pt).FirstOrDefault(); if (putawayTicket != null) { if (putawayTicket.PrintTimes == null) { putawayTicket.PrintTimes = 0; } putawayTicket.PrintTimes++; } } new Thread(() => { wmsEntities2.SaveChanges(); Search(); }).Start(); })); //formPreview.AddData("SubmissionTicketItem", submissionTicketItemView); formPreview.Show(); }
private void Search(string key, string value) { this.lableStatus.Text = "搜索中..."; new Thread(new ThreadStart(() => { var wmsEntities = new WMSEntities(); PutawayTicketView[] putawayTicketView = null; if (key == null || value == null) //搜索所有 { try { putawayTicketView = wmsEntities.Database.SqlQuery <PutawayTicketView>("SELECT * FROM PutawayTicketView WHERE WarehouseID = @warehouseID AND ProjectID = @projectID ORDER BY ID DESC", new SqlParameter[] { new SqlParameter("warehouseID", this.warehouseID), new SqlParameter("projectID", this.projectID) }).ToArray(); } catch { MessageBox.Show("无法连接到数据库,请查看网络连接!", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Error); return; } } else { double tmp; //if (Double.TryParse(value, out tmp) == false) //不是数字则加上单引号 //{ // value = "'" + value + "'"; //} try { putawayTicketView = wmsEntities.Database.SqlQuery <PutawayTicketView>(String.Format("SELECT * FROM PutawayTicketView WHERE {0} = @key AND WarehouseID = @warehouseID AND ProjectID = @projectID ORDER BY ID DESC", key), new SqlParameter[] { new SqlParameter("@key", value), new SqlParameter("@warehouseID", this.warehouseID), new SqlParameter("@projectID", this.projectID) }).ToArray(); } catch (EntityException) { MessageBox.Show("查询的值不合法,请输入正确的值!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } catch (Exception) { MessageBox.Show("无法连接到数据库,请查看网络连接!", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Error); return; } } this.reoGridControlUser.Invoke(new Action(() => { this.lableStatus.Text = "搜索完成"; var worksheet = this.reoGridControlUser.Worksheets[0]; worksheet.DeleteRangeData(RangePosition.EntireRange); int n = 0; for (int i = 0; i < putawayTicketView.Length; i++) { PutawayTicketView curReceiptTicketView = putawayTicketView[i]; if (curReceiptTicketView.State == "作废") { continue; } object[] columns = Utilities.GetValuesByPropertieNames(curReceiptTicketView, (from kn in ReceiptMetaData.putawayTicketKeyName select kn.Key).ToArray()); for (int j = 0; j < worksheet.Columns; j++) { if (columns[j] == null) { worksheet[n, j] = columns[j]; } else { worksheet[n, j] = columns[j].ToString(); } } n++; } })); if (putawayTicketView.Length == 0) { int m = ReceiptUtilities.GetFirstColumnIndex(ReceiptMetaData.submissionTicketKeyName); //this.reoGridControl1.Worksheets[0][6, 8] = "32323"; this.reoGridControlUser.Worksheets[0][0, m] = "没有查询到符合条件的记录"; } })).Start(); }