/// <summary> /// 新增甘肃报表 /// </summary> /// <param name="model"></param> /// <param name="errMsg"></param> /// <returns></returns> public DataTable Insert(clsReportGS model, out string errMsg) { DataTable dt = null; errMsg = string.Empty; try { sql.Length = 0; sql.Append("Insert Into tReportGS (Title,FoodName,FoodType,ProductionDate,CheckedCompanyName,"); sql.Append("CheckedCompanyAddress,CheckedCompanyPhone,LabelProducerName,LabelProducerAddress,LabelProducerPhone,"); sql.Append("SamplingData,SamplingPerson,SampleNum,SamplingBase,SamplingAddress,"); sql.Append("SamplingOrderCode,Standard,InspectionConclusion,Notes,Audit,Surveyor) "); sql.Append("VALUES("); sql.AppendFormat("'{0}',", model.Title); sql.AppendFormat("'{0}',", model.FoodName); sql.AppendFormat("'{0}',", model.FoodType); sql.AppendFormat("'{0}',", model.ProductionDate); sql.AppendFormat("'{0}',", model.CheckedCompanyName); sql.AppendFormat("'{0}',", model.CheckedCompanyAddress); sql.AppendFormat("'{0}',", model.CheckedCompanyPhone); sql.AppendFormat("'{0}',", model.LabelProducerName); sql.AppendFormat("'{0}',", model.LabelProducerAddress); sql.AppendFormat("'{0}',", model.LabelProducerPhone); sql.AppendFormat("'{0}',", model.SamplingData); sql.AppendFormat("'{0}',", model.SamplingPerson); sql.AppendFormat("'{0}',", model.SampleNum); sql.AppendFormat("'{0}',", model.SamplingBase); sql.AppendFormat("'{0}',", model.SamplingAddress); sql.AppendFormat("'{0}',", model.SamplingOrderCode); sql.AppendFormat("'{0}',", model.Standard); sql.AppendFormat("'{0}',", model.InspectionConclusion); sql.AppendFormat("'{0}',", model.Notes); sql.AppendFormat("'{0}',", model.Audit); sql.AppendFormat("'{0}')", model.Surveyor); DataBase.ExecuteCommand(sql.ToString(), out errMsg); sql.Length = 0; sql.Append("Select Top 1 * From tReportGS Order By ID Desc"); string[] cmd = new string[1] { sql.ToString() }; string[] names = new string[1] { "Result" }; dt = DataBase.GetDataSet(cmd, names, out errMsg).Tables["Result"]; sql.Length = 0; } catch (Exception e) { errMsg = e.Message; } return(dt); }
/// <summary> /// 保存报表 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSave_Click(object sender, RoutedEventArgs e) { string error = string.Empty; clsReportGS report = new clsReportGS(); try { report.ID = _id; report.Title = this.textBoxTitle.Text.Trim(); report.FoodName = this.textBoxFoodName.Text.Trim(); report.FoodType = this.textBoxFoodType.Text.Trim(); report.ProductionDate = this.textBoxProductionDate.Text.Trim(); report.CheckedCompanyName = this.textBoxCheckedCompanyName.Text.Trim(); report.CheckedCompanyAddress = this.textBoxCheckedCompanyAddress.Text.Trim(); report.CheckedCompanyPhone = this.textBoxCheckedCompanyPhone.Text.Trim(); report.CheckedCompanyName = this.textBoxCheckedCompanyName.Text.Trim(); report.CheckedCompanyPhone = this.textBoxCheckedCompanyPhone.Text.Trim(); report.LabelProducerName = this.textBoxLabelProducerName.Text.Trim(); report.LabelProducerAddress = this.textBoxLabelProducerAddress.Text.Trim(); report.LabelProducerPhone = this.textBoxLabelProducerPhone.Text.Trim(); report.SamplingData = this.textBoxSamplingData.Text.Trim(); report.SamplingPerson = this.textBoxSamplingPerson.Text.Trim(); report.SampleNum = this.textBoxSampleNum.Text.Trim(); report.SamplingOrderCode = this.textBoxSamplingOrderCode.Text.Trim(); report.Standard = this.textBoxStandard.Text.Trim(); report.InspectionConclusion = this.textBoxTInspectionConclusion.Text.Trim(); new tlsttResultSecondOpr().Update(report, out error); } catch (Exception ex) { MessageBox.Show("出现异常!\n" + ex.Message.ToString()); } finally { if (error.Equals(string.Empty)) { if (MessageBox.Show("保存成功!是否返回【报表界面】?", "操作提示", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes) { this.Close(); } } else { MessageBox.Show("保存失败!\n" + error); } } }
/// <summary> /// 删除报表 甘肃 /// </summary> private void DeletdGS() { string error = string.Empty; try { if (dataGridGS.SelectedItems.Count <= 0) { MessageBox.Show("请选择删除条目!"); return; } if (MessageBox.Show("确定要删除吗!?", "操作提示", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes) { try { clsReportGS report = (clsReportGS)dataGridGS.SelectedItems[0]; if (report != null && report.ID > 0) { _resultTable.DeletedGS(report.ID, out error); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (!error.Equals(string.Empty)) { MessageBox.Show("删除时出现异常!\n" + error); } else { MessageBox.Show("删除报表数据成功!"); } SearchReportGS(); } } } catch (Exception ex) { MessageBox.Show("异常(Deletd):\n" + ex.Message); } }
public void GetValues(clsReportGS report) { if (report != null) { try { _id = report.ID; if (report.Title != null && !report.Title.Equals(string.Empty)) { this.textBoxTitle.Text = report.Title; } this.textBoxFoodName.Text = report.FoodName;; this.textBoxFoodType.Text = report.FoodType; this.textBoxCheckedCompanyName.Text = report.CheckedCompanyName; this.textBoxCheckedCompanyAddress.Text = report.CheckedCompanyAddress; this.textBoxCheckedCompanyPhone.Text = report.CheckedCompanyPhone; this.textBoxLabelProducerName.Text = report.LabelProducerName; this.textBoxLabelProducerAddress.Text = report.LabelProducerAddress; this.textBoxLabelProducerPhone.Text = report.LabelProducerPhone; this.textBoxSamplingData.Text = report.SamplingData; this.textBoxSamplingPerson.Text = report.SamplingPerson; this.textBoxSampleNum.Text = report.SampleNum; //this.textBoxSamplingBase.Text = report.SamplingOrderCode; this.textBoxStandard.Text = report.Standard; this.textBoxTInspectionConclusion.Text = report.InspectionConclusion; if (report.reportList != null && report.reportList.Count > 0) { DataGridRecord.DataContext = report.reportList; } else { DataGridRecord.DataContext = null; } } catch (Exception ex) { MessageBox.Show("异常(GetValues):\n" + ex.Message); } } }
/// <summary> /// 修改报表记录 GS /// </summary> /// <param name="model"></param> /// <returns></returns> public int Update(clsReportGS model, out string errMsg) { int rtn = 0; errMsg = string.Empty; try { sql.Length = 0; sql.Append("Update tReportGS Set "); sql.AppendFormat("Title='{0}',", model.Title == null ? string.Empty : model.Title); sql.AppendFormat("FoodName='{0}',", model.FoodName == null ? string.Empty : model.FoodName); sql.AppendFormat("FoodType='{0}',", model.FoodType == null ? string.Empty : model.FoodType); sql.AppendFormat("ProductionDate='{0}',", model.ProductionDate == null ? string.Empty : model.ProductionDate); sql.AppendFormat("CheckedCompanyName='{0}',", model.CheckedCompanyName == null ? string.Empty : model.CheckedCompanyName); sql.AppendFormat("CheckedCompanyAddress='{0}',", model.CheckedCompanyAddress == null ? string.Empty : model.CheckedCompanyAddress); sql.AppendFormat("CheckedCompanyPhone='{0}',", model.CheckedCompanyPhone == null ? string.Empty : model.CheckedCompanyPhone); sql.AppendFormat("LabelProducerName='{0}',", model.LabelProducerName == null ? string.Empty : model.LabelProducerName); sql.AppendFormat("LabelProducerAddress='{0}',", model.LabelProducerAddress == null ? string.Empty : model.LabelProducerAddress); sql.AppendFormat("LabelProducerPhone='{0}',", model.LabelProducerPhone == null ? string.Empty : model.LabelProducerPhone); sql.AppendFormat("SamplingData='{0}',", model.SamplingData == null ? string.Empty : model.SamplingData); sql.AppendFormat("SamplingPerson='{0}',", model.SamplingPerson == null ? string.Empty : model.SamplingPerson); sql.AppendFormat("SampleNum='{0}',", model.SampleNum == null ? string.Empty : model.SampleNum); sql.AppendFormat("SamplingBase='{0}',", model.SamplingBase == null ? string.Empty : model.SamplingBase); sql.AppendFormat("SamplingAddress='{0}',", model.SamplingAddress == null ? string.Empty : model.SamplingAddress); sql.AppendFormat("SamplingOrderCode='{0}',", model.SamplingOrderCode == null ? string.Empty : model.SamplingOrderCode); sql.AppendFormat("Standard='{0}',", model.Standard == null ? string.Empty : model.Standard); sql.AppendFormat("InspectionConclusion='{0}' ", model.InspectionConclusion == null ? string.Empty : model.InspectionConclusion); sql.AppendFormat("Where ID={0}", model.ID); DataBase.ExecuteCommand(sql.ToString(), out errMsg); sql.Length = 0; rtn = 1; } catch (Exception e) { errMsg = e.Message; } return(rtn); }
/// <summary> /// 打印甘肃报表 /// </summary> private void PrintGS() { Global.GSType = string.Empty; clsReportGS record; try { if (dataGridGS.SelectedItems.Count > 0) { record = (clsReportGS)dataGridGS.SelectedItems[0]; clsReportGS report = null; if (record != null) { report = new clsReportGS(); report.Title = record.Title; report.FoodName = record.FoodName; report.FoodType = record.FoodType; report.ProductionDate = record.ProductionDate; report.CheckedCompanyName = record.CheckedCompanyName; report.CheckedCompanyAddress = record.CheckedCompanyAddress; report.CheckedCompanyPhone = record.CheckedCompanyPhone; report.LabelProducerName = record.LabelProducerName; report.LabelProducerAddress = record.LabelProducerAddress; report.LabelProducerPhone = record.LabelProducerPhone; report.SamplingData = record.SamplingData; report.SamplingPerson = record.SamplingPerson; report.SampleNum = record.SampleNum; report.SamplingBase = record.SamplingBase; report.SamplingAddress = record.SamplingAddress; report.SamplingOrderCode = record.SamplingOrderCode; report.Standard = record.Standard; report.InspectionConclusion = record.InspectionConclusion; report.Notes = record.Notes; report.Surveyor = record.Surveyor; //根据主表ID查询子表样品信息集合 DataTable dt = _resultTable.GetReportDetailGS(record.ID); if (dt != null && dt.Rows.Count > 0) { List <clsReportGSDetail> ItemNames = (List <clsReportGSDetail>)IListDataSet.DataTableToIList <clsReportGSDetail>(dt, 1); for (int i = 0; i < ItemNames.Count; i++) { clsReportGS.ReportDetail reportDetail = new clsReportGS.ReportDetail(); reportDetail.ProjectName = ItemNames[i].ProjectName; reportDetail.Unit = ItemNames[i].Unit; reportDetail.InspectionStandard = ItemNames[i].InspectionStandard; reportDetail.IndividualResults = ItemNames[i].IndividualResults; reportDetail.IndividualDecision = ItemNames[i].IndividualDecision; report.reportDetailList.Add(reportDetail); } } } //甘肃打印模板 PrintPreviewWindow print = new PrintPreviewWindow("xaml\\Print\\PrintModel\\GSDocument.xaml", report, new OrderDocumentRenderer()); print._resultGS = record; print.Owner = this; print.ShowInTaskbar = false; print.ShowDialog(); } else { MessageBox.Show("请选择打印条目!", "操作提示"); } } catch (Exception ex) { MessageBox.Show("异常(Print):\n" + ex.Message); } }
/// <summary> /// 打印甘肃回执 /// </summary> private void PrintGSHZ() { Global.GSType = "HZ"; clsReportGS record; try { if (dataGridGS.SelectedItems.Count > 0) { IDictionary <string, string> dicItems = new Dictionary <string, string>(); IDictionary <string, string> dicSample = new Dictionary <string, string>(); record = (clsReportGS)dataGridGS.SelectedItems[0]; clsReportGS report = null; if (record != null) { report = new clsReportGS(); report.Title = record.Title; report.FoodName = record.FoodName; report.FoodType = record.FoodType; report.ProductionDate = record.ProductionDate; report.CheckedCompanyName = record.CheckedCompanyName == null ? "______" : record.CheckedCompanyName; report.CheckedCompanyAddress = record.CheckedCompanyAddress == null ? "______" : record.CheckedCompanyAddress; report.CheckedCompanyPhone = record.CheckedCompanyPhone; report.LabelProducerName = record.LabelProducerName; report.LabelProducerAddress = record.LabelProducerAddress == null ? "______" : record.LabelProducerAddress; report.LabelProducerPhone = record.LabelProducerPhone; if (record.SamplingData != null) { report.SamplingData = record.SamplingData == null ? "____年__月__日" : record.SamplingData; string str = record.SamplingData; string[] s = str.Split(new char[] { '-' }); report.SamplingData = s[0] + "年" + s[1] + "月" + s[2] + "日"; } else { report.SamplingData = "____年__月__日"; } report.SamplingPerson = record.SamplingPerson; report.SampleNum = record.SampleNum; report.SamplingBase = record.SamplingBase; report.SamplingAddress = record.SamplingAddress; report.SamplingOrderCode = record.SamplingOrderCode; report.Standard = record.Standard; report.InspectionConclusion = record.InspectionConclusion; report.Notes = record.Notes; report.Surveyor = record.Surveyor; report.ItemsList = report.UnqualifiedItemsList = report.SampleList = string.Empty; //根据主表ID查询子表样品信息集合 DataTable dt = _resultTable.GetReportDetailGS(record.ID); if (dt != null && dt.Rows.Count > 0) { List <clsReportGSDetail> ItemNames = (List <clsReportGSDetail>)IListDataSet.DataTableToIList <clsReportGSDetail>(dt, 1); for (int i = 0; i < ItemNames.Count; i++) { clsReportGS.ReportDetail reportDetail = new clsReportGS.ReportDetail(); reportDetail.ProjectName = ItemNames[i].ProjectName; reportDetail.Unit = ItemNames[i].Unit; reportDetail.InspectionStandard = ItemNames[i].InspectionStandard; reportDetail.IndividualResults = ItemNames[i].IndividualResults; reportDetail.IndividualDecision = ItemNames[i].IndividualDecision; report.reportDetailList.Add(reportDetail); if (!dicItems.ContainsKey(ItemNames[i].ProjectName)) { if (i + 1 < ItemNames.Count) { report.ItemsList += ItemNames[i].ProjectName + ","; } else { report.ItemsList += ItemNames[i].ProjectName; } dicItems.Add(ItemNames[i].ProjectName, ItemNames[i].ProjectName); } if (!dicSample.ContainsKey(ItemNames[i].ProjectName)) { if (ItemNames[i].IndividualDecision.Equals("不合格")) { if (i + 1 < ItemNames.Count) { report.UnqualifiedItemsList += ItemNames[i].ProjectName + ","; } else { report.UnqualifiedItemsList += ItemNames[i].ProjectName; } dicSample.Add(ItemNames[i].ProjectName, ItemNames[i].ProjectName); } } } if (report.UnqualifiedItemsList.Equals(string.Empty)) { report.UnqualifiedItemsList = "____________________"; } if (report.ItemsList.Equals(string.Empty)) { report.ItemsList = "____________________"; } } } //甘肃打印回执 PrintPreviewWindow print = new PrintPreviewWindow("xaml\\Print\\PrintModel\\GSHZDocument.xaml", report, new OrderDocumentRenderer()); print._resultGS = record; print.Owner = this; print.ShowInTaskbar = false; print.ShowDialog(); } else { MessageBox.Show("请选择打印条目!", "操作提示"); } } catch (Exception ex) { MessageBox.Show("异常(Print):\n" + ex.Message); } }