/// <summary> /// 加载订单内容数据 /// </summary> private void LoadDataSourceDetails() { try { int iOrderID = 0; string strBooksNo = string.Empty; if (this.myDataGridViewHead.CurrentRowNew != null) { if (this.myDataGridViewHead.Rows[this.myDataGridViewHead.CurrentRowNew.Index].Cells["Pid"].Value != DBNull.Value) { iOrderID = (int)this.myDataGridViewHead.Rows[this.myDataGridViewHead.CurrentRowNew.Index].Cells["Pid"].Value; } } IDataAccess dataAccess = DataAccessFactory.CreateDataAccess(DataAccessEnum.DataAccessName.DataAccessName_Uniquegrade); dataAccess.Open(); string strSQL = string.Format("exec 出口装箱单录入查询 {0}", iOrderID); DataTable dtDetails = dataAccess.GetTable(strSQL, null); dataAccess.Close(); DataTableTools.AddEmptyRow(dtDetails); this.myDataGridViewDetails.DataSource = dtDetails; } catch (Exception ex) { SysMessage.ErrorMsg(string.Format("加载【PACKING LIST】出错,错误信息如下:{0}{1}", Environment.NewLine, ex.Message)); } }
private void FormMaterialsOutQueryList_CheckQueryList_Load(object sender, EventArgs e) { string strSQL = string.Empty; if (InOutvalue == 1) { strSQL = string.Format("报关进口料件数量转换统计 @id={0},@电子帐册号='{1}',@类别={2}", InId, ManualCode, passvalue); } else { strSQL = string.Format("报关出口料件数量转换统计 @id={0},@电子帐册号='{1}',@类别={2}", InId, ManualCode, passvalue); } IDataAccess dataAccess = DataAccessFactory.CreateDataAccess(DataAccessEnum.DataAccessName.DataAccessName_Manufacture); dataAccess.Open(); DataTable dtData = dataAccess.GetTable(strSQL, null); dataAccess.Close(); DataTableTools.AddEmptyRow(dtData); this.myDataGridView1.DataSource = dtData; foreach (DataGridViewTextBoxColumn textBoxColumn in this.myDataGridView1.Columns) { textBoxColumn.ContextMenuStrip = this.myContextMenuStripCell1; } }
/// <summary> /// 加载订单内容数据 /// </summary> private void LoadDataSourceDetails() { try { int iManualID = 0; string strBooksNo = string.Empty; if (this.myDataGridViewHead.CurrentRowNew != null) { iManualID = (int)this.myDataGridViewHead.Rows[this.myDataGridViewHead.CurrentRowNew.Index].Cells["手册id"].Value; } IDataAccess dataAccess = DataAccessFactory.CreateDataAccess(DataAccessEnum.DataAccessName.DataAccessName_Uniquegrade); dataAccess.Open(); string strSQL = string.Format("exec 出口成品表录入查询 {0}" + Environment.NewLine, iManualID); strSQL += string.Format("exec 进口料件表录入查询 {0}", iManualID); DataSet ds = dataAccess.GetDataSet(strSQL, null); dataAccess.Close(); DataTable dtDetails = ds.Tables[0]; DataTable dtDetails2 = ds.Tables[1]; DataTableTools.AddEmptyRow(dtDetails); DataTableTools.AddEmptyRow(dtDetails2); this.myDataGridViewDetails.DataSource = dtDetails; this.myDataGridViewDetailsInput.DataSource = dtDetails2; } catch (Exception ex) { SysMessage.ErrorMsg(string.Format("加载【InvoiceOut】出错,错误信息如下:{0}{1}", Environment.NewLine, ex.Message)); } }
/// <summary> /// 加载表头数据 /// </summary> private void LoadDataSourceHead() { try { IDataAccess dataAccess = DataAccessFactory.CreateDataAccess(DataAccessEnum.DataAccessName.DataAccessName_Manufacture); dataAccess.Open(); string strSQL = string.Format("select * FROM 归并后料件清单 where 电子帐册号={0} ORDER BY 序号", StringTools.SqlQ(gstrManualNo)); DataTable dtHead = dataAccess.GetTable(strSQL, null); dataAccess.Close(); bTriggerGridViewHead_SelectionChanged = false; DataTableTools.AddEmptyRow(dtHead); this.myDataGridViewHead.DataSource = dtHead; bTriggerGridViewHead_SelectionChanged = true; //if (this.dataGridViewHead.RowCount > 0) //{ // this.dataGridViewHead.CurrentCell = this.dataGridViewHead.Rows[0].Cells["电子帐册号"]; // this.dataGridViewHead.Rows[0].Selected = true; //} this.myDataGridViewHead_SelectionChanged(null, null); } catch (Exception ex) { SysMessage.ErrorMsg(string.Format("加载数据出错LoadDataSourceHead,错误信息如下:{0}{1}", Environment.NewLine, ex.Message)); } }
/// <summary> /// 加载订单内容数据 /// </summary> private void LoadDataSourceDetails() { try { int iOrderID = 0; string strBooksNo = string.Empty; if (this.myDataGridViewHead.CurrentRowNew != null) { if (this.myDataGridViewHead.Rows[this.myDataGridViewHead.CurrentRowNew.Index].Cells["料件出库表id"].Value != DBNull.Value) { iOrderID = (int)this.myDataGridViewHead.Rows[this.myDataGridViewHead.CurrentRowNew.Index].Cells["料件出库表id"].Value; strBooksNo = this.myDataGridViewHead.CurrentRowNew.Cells["电子帐册号"].Value.ToString(); } } IDataAccess dataAccess = DataAccessFactory.CreateDataAccess(DataAccessEnum.DataAccessName.DataAccessName_Manufacture); dataAccess.Open(); //string strSQL = string.Format("select * from 报关预先订单明细表 where 订单id={0}", iOrderID); string strSQL = string.Format("exec 进口料件出库修改查询 {0},{1}", iOrderID, StringTools.SqlQ(strBooksNo)); DataTable dtDetails = dataAccess.GetTable(strSQL, null); dataAccess.Close(); DataTableTools.AddEmptyRow(dtDetails); this.myDataGridViewDetails.DataSource = dtDetails; } catch (Exception ex) { SysMessage.ErrorMsg(string.Format("加载【出库单明细】出错,错误信息如下:{0}{1}", Environment.NewLine, ex.Message)); } }
private void FormMaterialSheet_Load(object sender, EventArgs e) { StringBuilder strBuilder = new StringBuilder(); strBuilder.AppendLine(string.Format(@"select ltrim(case when PATINDEX('%-%',项号)=0 then 项号 else SUBSTRING(项号,1,PATINDEX('%-%',项号)-1) end) as 项号,left(ltrim(料号),3) as 料号, max(商品编码) as 商品编码, max(商品名称) as 商品名称, max(商品规格) as 商品规格, 单位, rtrim(str(sum(数量),10,5)) as 数量 FROM 装箱单料件明细表 where left(ltrim(料号),1)='A' and idv='{0}' group by ltrim(case when PATINDEX('%-%',项号)=0 then 项号 else SUBSTRING(项号,1,PATINDEX('%-%',项号)-1) end) , left(ltrim(料号),3), 单位 ORDER BY 项号", idvalue)); strBuilder.AppendLine(string.Format(@"select ltrim(case when PATINDEX('%-%',项号)=0 then 项号 else SUBSTRING(项号,1,PATINDEX('%-%',项号)-1) end) as 项号, left(ltrim(料号),5) as 料号, max(商品编码) as 商品编码, max(商品名称) as 商品名称, max(商品规格) as 商品规格, 单位, rtrim(str(sum(数量),10,5)) as 数量 FROM 装箱单料件明细表 where left(ltrim(料号),1)='A' and idv='{0}' group by ltrim(case when PATINDEX('%-%',项号)=0 then 项号 else SUBSTRING(项号,1,PATINDEX('%-%',项号)-1) end) , left(ltrim(料号),5),单位 ORDER BY 项号", idvalue)); strBuilder.AppendLine(string.Format(@"select ltrim(case when PATINDEX('%-%',项号)=0 then 项号 else SUBSTRING(项号,1,PATINDEX('%-%',项号)-1) end) as 项号, 料件编号, 料号, 料件名, max(商品编码) as 商品编码, max(商品名称) as 商品名称, max(商品规格) as 商品规格, 单位, rtrim(str(sum(数量),10,5)) as 数量 FROM 装箱单料件明细表 where left(ltrim(料号),1)='A' and idv='{0}' group by ltrim(case when PATINDEX('%-%',项号)=0 then 项号 else SUBSTRING(项号,1,PATINDEX('%-%',项号)-1) end) , 料件编号, 料号, 料件名, 单位 ORDER BY 项号", idvalue)); strBuilder.AppendLine(string.Format("DELETE FROM 装箱单料件明细表 where idv='{0}'", idvalue)); IDataAccess dataAccess = DataAccessFactory.CreateDataAccess(DataAccessEnum.DataAccessName.DataAccessName_Manufacture); dataAccess.Open(); DataSet ds = dataAccess.GetDataSet(strBuilder.ToString(), null); dataAccess.Close(); DataTable dt1 = ds.Tables[0]; DataTableTools.AddEmptyRow(dt1); DataTable dt2 = ds.Tables[1]; DataTableTools.AddEmptyRow(dt2); DataTable dt3 = ds.Tables[2]; DataTableTools.AddEmptyRow(dt3); this.myDataGridView1.DataSource = dt1; this.myDataGridView2.DataSource = dt2; this.myDataGridView3.DataSource = dt3; foreach (DataGridViewTextBoxColumn textBoxColumn in this.myDataGridView1.Columns) { textBoxColumn.ContextMenuStrip = this.myContextMenuStripCell1; } foreach (DataGridViewTextBoxColumn textBoxColumn in this.myDataGridView2.Columns) { textBoxColumn.ContextMenuStrip = this.myContextMenuStripCell2; } foreach (DataGridViewTextBoxColumn textBoxColumn in this.myDataGridView3.Columns) { textBoxColumn.ContextMenuStrip = this.myContextMenuStripCell3; } }
private void LoadDataSource() { IDataAccess dataAccess = DataAccessFactory.CreateDataAccess(DataAccessEnum.DataAccessName.DataAccessName_Uniquegrade); dataAccess.Open(); dtData = dataAccess.GetTable(string.Format("出口料件统计 {0}", mstrFilterString), null); dataAccess.Close(); if (!mstrFilterString.Contains("类别")) { this.myDataGridViewHead.Columns["成品名称及商编"].Visible = false; } DataTableTools.AddEmptyRow(dtData); this.myDataGridViewHead.DataSource = dtData; setTool1Enabled(); }
/// <summary> /// 加载订单内容数据 /// </summary> private void LoadDataSourceDetails() { //bool bShow = false; //if (formBaseLoading == null) //{ // formBaseLoading = new FormBaseLoading(); // bShow = true; // formBaseLoading.strLoadText =string.Format("加载【{0}】数据,请稍等。。。。。。", this.tabPage1.Text); // formBaseLoading.Show(); // formBaseLoading.Refresh(); //} try { int iOrderID = 0; if (this.myDataGridViewHead.CurrentRowNew != null && this.myDataGridViewHead.CurrentRowNew.Index >= 0) { if (this.myDataGridViewHead.Rows[this.myDataGridViewHead.CurrentRowNew.Index].Cells["归并后料件id"].Value != DBNull.Value) { iOrderID = (int)this.myDataGridViewHead.Rows[this.myDataGridViewHead.CurrentRowNew.Index].Cells["归并后料件id"].Value; } } IDataAccess dataAccess = DataAccessFactory.CreateDataAccess(DataAccessEnum.DataAccessName.DataAccessName_Manufacture); dataAccess.Open(); string strSQL = string.Format("exec 商品归并表录入查询 {0}", iOrderID); DataTable dtDetails = dataAccess.GetTable(strSQL, null); dataAccess.Close(); DataTableTools.AddEmptyRow(dtDetails); bTriggerGridViewDetails_SelectionChanged = false; this.myDataGridViewDetails.DataSource = dtDetails; bTriggerGridViewDetails_SelectionChanged = true; this.myDataGridViewDetails_SelectionChanged(null, null); } catch (Exception ex) { SysMessage.ErrorMsg(string.Format("加载数据出错LoadDataSourceDetails,错误信息如下:{0}{1}", Environment.NewLine, ex.Message)); } //finally //{ // if (bShow && formBaseLoading != null) // { // formBaseLoading.Close(); // formBaseLoading.Dispose(); // formBaseLoading = null; // } //} }
/// <summary> /// 加载归并后材料总用量表 /// </summary> private void LoadDataSourceMergeAfterSumCount() { //bool bShow = false; //if (formBaseLoading == null) //{ // formBaseLoading = new FormBaseLoading(); // bShow = true; // formBaseLoading.strLoadText = string.Format("加载【{0}】数据,请稍等。。。。。。", this.tabPage2.Text); // formBaseLoading.Show(); // formBaseLoading.Refresh(); //} try { int iOrderID = 0; string strBooksNo = string.Empty; if (this.dataGridViewHead.CurrentRowNew.Index >= 0) { if (this.dataGridViewHead.Rows[this.dataGridViewHead.CurrentRowNew.Index].Cells["订单id"].Value != DBNull.Value) { iOrderID = (int)this.dataGridViewHead.Rows[this.dataGridViewHead.CurrentRowNew.Index].Cells["订单id"].Value; strBooksNo = this.dataGridViewHead.CurrentRowNew.Cells["手册编号"].Value.ToString(); } } IDataAccess dataAccess = DataAccessFactory.CreateDataAccess(DataAccessEnum.DataAccessName.DataAccessName_Manufacture); dataAccess.Open(); string strSQL = string.Format("exec 预先订单用量明细 {0},{1}", iOrderID, strBooksNo); DataTable dtMergeAfterSumCount = dataAccess.GetTable(strSQL, null); dataAccess.Close(); DataTableTools.AddEmptyRow(dtMergeAfterSumCount); this.dataGridViewMergeAfterSumCount.DataSource = dtMergeAfterSumCount; //this.dataGridViewMergeAfterSumCount.Columns["单耗"].Visible = false; } catch (Exception ex) { SysMessage.ErrorMsg(string.Format("加载【{0}】数据出错,错误信息如下:{1}{2}", this.tabPage2.Text, Environment.NewLine, ex.Message)); } //finally //{ // if (bShow && formBaseLoading != null) // { // formBaseLoading.Close(); // formBaseLoading.Dispose(); // formBaseLoading = null; // } //} }
/// <summary> /// 加载订单内容数据 /// </summary> private void LoadDataSourceDetails() { //bool bShow = false; //if (formBaseLoading == null) //{ // formBaseLoading = new FormBaseLoading(); // bShow = true; // formBaseLoading.strLoadText =string.Format("加载【{0}】数据,请稍等。。。。。。", this.tabPage1.Text); // formBaseLoading.Show(); // formBaseLoading.Refresh(); //} try { int iOrderID = 0; string str手册编号 = string.Empty; if (this.dataGridViewHead.CurrentRowNew.Index >= 0) { if (this.dataGridViewHead.Rows[this.dataGridViewHead.CurrentRowNew.Index].Cells["制造通知单id"].Value != DBNull.Value) { iOrderID = (int)this.dataGridViewHead.Rows[this.dataGridViewHead.CurrentRowNew.Index].Cells["制造通知单id"].Value; str手册编号 = this.dataGridViewHead.Rows[this.dataGridViewHead.CurrentRowNew.Index].Cells["手册编号"].Value.ToString(); } } IDataAccess dataAccess = DataAccessFactory.CreateDataAccess(DataAccessEnum.DataAccessName.DataAccessName_Manufacture); dataAccess.Open(); //string strSQL = string.Format("select * from 报关预先订单明细表 where 订单id={0}", iOrderID); string strSQL = string.Format("exec 报关制造通知单录入查询 {0}", iOrderID); DataTable dtDetails = dataAccess.GetTable(strSQL, null); dataAccess.Close(); DataTableTools.AddEmptyRow(dtDetails); this.dataGridViewDetails.DataSource = dtDetails; } catch (Exception ex) { SysMessage.ErrorMsg(string.Format("加载【{0}】数据出错,错误信息如下:{1}{2}", this.tabPage1.Text, Environment.NewLine, ex.Message)); } //finally //{ // if (bShow && formBaseLoading != null) // { // formBaseLoading.Close(); // formBaseLoading.Dispose(); // formBaseLoading = null; // } //} }
/// <summary> /// 加载表头数据 /// </summary> private void LoadDataSourceHead() { //bool bShow = false; //if (formBaseLoading == null) //{ // formBaseLoading = new FormBaseLoading(); // bShow = true; // formBaseLoading.strLoadText = "加载【预先订单录入】数据,请稍等。。。。。。"; // formBaseLoading.Show(); // formBaseLoading.Refresh(); //} try { IDataAccess dataAccess = DataAccessFactory.CreateDataAccess(DataAccessEnum.DataAccessName.DataAccessName_Manufacture); dataAccess.Open(); string strSQL = @"SELECT 报关制造通知单表.*,case when 进口料件出库表.制造通知单号 is null then '' else '已导' end as 导单 FROM 报关制造通知单表 left outer join 进口料件出库表 on 报关制造通知单表.制造通知单号=进口料件出库表.制造通知单号 " + (gstrWhere.Length > 0 ? " where " : "") + gstrWhere + "ORDER BY 录入日期 DESC"; DataTable dtHead = dataAccess.GetTable(strSQL, null); dataAccess.Close(); bTriggerGridViewHead_SelectionChanged = false; DataTableTools.AddEmptyRow(dtHead); this.dataGridViewHead.DataSource = dtHead; bTriggerGridViewHead_SelectionChanged = true; //if (this.dataGridViewHead.RowCount > 0) //{ // this.dataGridViewHead.CurrentCell = this.dataGridViewHead.Rows[0].Cells["订单号码"]; // this.dataGridViewHead.Rows[0].Selected = true; //} this.dataGridViewHead_SelectionChanged(null, null); } catch (Exception ex) { SysMessage.ErrorMsg(string.Format("加载【制造通知单】数据出错,错误信息如下:{0}{1}", Environment.NewLine, ex.Message)); } //finally //{ // if (bShow && formBaseLoading != null) // { // formBaseLoading.Close(); // formBaseLoading.Dispose(); // formBaseLoading = null; // } //} }
/// <summary> /// 加载表头数据 /// </summary> private void LoadDataSourceHead() { try { IDataAccess dataAccess = DataAccessFactory.CreateDataAccess(DataAccessEnum.DataAccessName.DataAccessName_Uniquegrade); dataAccess.Open(); string strSQL = string.Format("select * FROM 手册资料表 {0}{1} ORDER BY 手册编号", gstrWhere.Length > 0 ? " where " : "", gstrWhere); DataTable dtHead = dataAccess.GetTable(strSQL, null); dataAccess.Close(); bTriggerGridViewHead_SelectionChanged = false; this.myDataGridViewHead.DataSource = dtHead; DataTableTools.AddEmptyRow(dtHead); bTriggerGridViewHead_SelectionChanged = true; this.myDataGridViewHead_SelectionChanged(null, null); } catch (Exception ex) { SysMessage.ErrorMsg(string.Format("加载【InvoiceOut】数据出错,错误信息如下:{0}{1}", Environment.NewLine, ex.Message)); } }
/// <summary> /// 加载表头数据 /// </summary> private void LoadDataSourceHead() { try { IDataAccess dataAccess = DataAccessFactory.CreateDataAccess(DataAccessEnum.DataAccessName.DataAccessName_Manufacture); dataAccess.Open(); string strSQL = "SELECT * from 进口料件出库表 " + (gstrWhere.Length > 0 ? " where " : "") + gstrWhere + " ORDER BY 出库时间 DESC"; DataTable dtHead = dataAccess.GetTable(strSQL, null); dataAccess.Close(); bTriggerGridViewHead_SelectionChanged = false; this.myDataGridViewHead.DataSource = dtHead; DataTableTools.AddEmptyRow(dtHead); bTriggerGridViewHead_SelectionChanged = true; this.myDataGridViewHead_SelectionChanged(null, null); } catch (Exception ex) { SysMessage.ErrorMsg(string.Format("加载【料件出库单】数据出错,错误信息如下:{0}{1}", Environment.NewLine, ex.Message)); } }
/// <summary> /// 加载资料 /// </summary> public virtual void LoadDataSource() { if (!this.DesignMode) { try { IDataAccess dataAccess = DataAccessFactory.CreateDataAccess(dataAccessName); dataAccess.Open(); dtHead = dataAccess.GetTable(string.Format(gstrSQL, (gstrWhere.Length > 0 ? " where " : "") + gstrWhere), null); dataAccess.Close(); DataTableTools.AddEmptyRow(dtHead); this.myDataGridViewHead.DataSource = dtHead; setTool1Enabled(); } catch (Exception ex) { SysMessage.ErrorMsg(string.Format("加载数据出错LoadDataSource,错误信息如下:{0}{1}", Environment.NewLine, ex.Message)); } } setToolStripStatusLabel2(); }
/// <summary> /// 加载表头数据 /// </summary> private void LoadDataSourceHead() { try { IDataAccess dataAccess = DataAccessFactory.CreateDataAccess(DataAccessEnum.DataAccessName.DataAccessName_Uniquegrade); dataAccess.Open(); string strSQL = @"select Packing1.*, Company.com_Abbr AS company, Customer.E_Name AS Messrs FROM Company right outer JOIN Packing1 ON Company.comid = Packing1.comid left outer JOIN Customer ON Packing1.custid = Customer.custId" + (gstrWhere.Length > 0 ? " where " : "") + gstrWhere + " ORDER BY inputdate DESC"; DataTable dtHead = dataAccess.GetTable(strSQL, null); dataAccess.Close(); bTriggerGridViewHead_SelectionChanged = false; this.myDataGridViewHead.DataSource = dtHead; DataTableTools.AddEmptyRow(dtHead); bTriggerGridViewHead_SelectionChanged = true; this.myDataGridViewHead_SelectionChanged(null, null); } catch (Exception ex) { SysMessage.ErrorMsg(string.Format("加载【出口装箱单】数据出错,错误信息如下:{0}{1}", Environment.NewLine, ex.Message)); } }
/// <summary> /// 加载订单内容数据 /// </summary> private void LoadDataSourceDetails() { try { int 报关产品表id = 0; if (this.myDataGridViewHead.CurrentRowNew != null) { 报关产品表id = (int)this.myDataGridViewHead.Rows[this.myDataGridViewHead.CurrentRowNew.Index].Cells["报关产品表id"].Value; } IDataAccess dataAccess = DataAccessFactory.CreateDataAccess(DataAccessEnum.DataAccessName.DataAccessName_Uniquegrade); dataAccess.Open(); string strSQL = string.Format("SELECT * from 报关产品组成明细表 where 报关产品表id={0} ORDER BY 料件项号", 报关产品表id); DataTable dtDetails = dataAccess.GetTable(strSQL, null); dataAccess.Close(); DataTableTools.AddEmptyRow(dtDetails); this.myDataGridViewDetails.DataSource = dtDetails; } catch (Exception ex) { SysMessage.ErrorMsg(string.Format("加载出错,错误信息如下:{0}{1}", Environment.NewLine, ex.Message)); } }
/// <summary> /// 加载表头数据 /// </summary> private void LoadDataSourceHead() { //bool bShow = false; //if (formBaseLoading == null) //{ // formBaseLoading = new FormBaseLoading(); // bShow = true; // formBaseLoading.strLoadText = "加载【预先订单录入】数据,请稍等。。。。。。"; // formBaseLoading.Show(); // formBaseLoading.Refresh(); //} try { IDataAccess dataAccess = DataAccessFactory.CreateDataAccess(DataAccessEnum.DataAccessName.DataAccessName_Manufacture); dataAccess.Open(); string strSQL = "SELECT 报关预先订单表.* FROM 报关预先订单表 " + (gstrWhere.Length > 0 ? " where " : "") + gstrWhere + "ORDER BY 录入日期 DESC"; DataTable dtHead = dataAccess.GetTable(strSQL, null); dataAccess.Close(); bTriggerGridViewHead_SelectionChanged = false; DataTableTools.AddEmptyRow(dtHead); this.dataGridViewHead.DataSource = dtHead; bTriggerGridViewHead_SelectionChanged = true; this.dataGridViewHead_SelectionChanged(null, null); } catch (Exception ex) { SysMessage.ErrorMsg(string.Format("加载【预先订单录入】数据出错,错误信息如下:{0}{1}", Environment.NewLine, ex.Message)); } //finally //{ // if (bShow && formBaseLoading != null) // { // formBaseLoading.Close(); // formBaseLoading.Dispose(); // formBaseLoading = null; // } //} }
public virtual void LoadDataSource() { IDataAccess dataAccess = DataAccessFactory.CreateDataAccess(DataAccessEnum.DataAccessName.DataAccessName_Manufacture); string strSQL = string.Empty; switch (mQueryWay) { case ReportsEnum.ReportsEnum_rpt剩余量: this.Text = "制造通知单剩余量查询"; dataAccess.Open(); dtData = dataAccess.GetTable(string.Format("报关制造通知单剩余量查询 '{0}','{1}'", ManualCode, mstrCode), null); dataAccess.Close(); this.myDataGridView1.DataSource = dtData; this.lab_Count.Text = string.Format("记录总数:{0}", dtData.Rows.Count); break; case ReportsEnum.ReportsEnum_rpt制造通知单在线量产品明细查询: this.Text = "制造通知单在线量产品明细查询"; dataAccess.Open(); dataAccess.ExecuteNonQuery("delete from 装箱单明细临时表", null); dataAccess.ExecuteNonQuery(string.Format(@"Insert into 装箱单明细临时表(手册编号,数量,归并前成品序号,日期,成品项号,订单号码) SELECT XM.手册编号,XM.数量,XM.归并前成品序号,X.录入日期,XM.成品项号,XM.订单号码 FROM OPENDATASOURCE('SQLOLEDB','Data Source=unique;User ID=SA;Password='******'SQLOLEDB','Data Source=unique;User ID=SA;Password='******'{0}'", ManualCode), null); dtData = dataAccess.GetTable(string.Format("制造通知单在线量产品明细查询 '{0}','{1}','{2}'", ManualCode, mstrCode, mstrOrderCode), null); dataAccess.Close(); this.myDataGridView1.DataSource = dtData; this.lab_Count.Text = string.Format("记录总数:{0}", dtData.Rows.Count); break; case ReportsEnum.ReportsEnum_rpt分组发货单: break; case ReportsEnum.ReportsEnum_rpt料件总单: break; case ReportsEnum.ReportsEnum_rpt料件进销存: this.Text = "料件进销存"; if (passvalue == 1) { strSQL = string.Format("进口料件归并前明细进销存 {0}", gstrWhere); } else if (passvalue == 2) { strSQL = string.Format("进口料件归并前进销存 {0}", gstrWhere); } else if (passvalue == 3) { strSQL = string.Format("进口料件归并后进销存 {0}", gstrWhere); } else { strSQL = string.Format("进口料件进销存明细查询 {0}", gstrWhere); } dataAccess.Open(); dtData = dataAccess.GetTable(strSQL, null); dataAccess.Close(); this.myDataGridView1.DataSource = dtData; DataTableTools.AddEmptyRow(dtData); this.lab_Count.Text = string.Format("记录总数:{0}", dtData.Rows.Count); this.lab_Date.Text = string.Format("日期从:{0} 到 {1}", mdFromDateString, mdToDateString); break; case ReportsEnum.ReportsEnum_rpt预先订单用量明细表: if (passvalue == 1) { dtData = dataAccess.GetTable(string.Format("预先订单归并前明细订单用量明细表查询 {0}", gstrWhere), null); } tool_Details.Visible = false; break; case ReportsEnum.ReportsEnum_rpt预先订单用量需求表: this.Text = "预先订单用量需求表"; if (passvalue == 1) { strSQL = string.Format("预先订单归并前明细用量需求表查询 {0}", gstrWhere); } else if (passvalue == 2) { strSQL = string.Format("预先订单归并前用量需求表查询 {0}", gstrWhere); tool_Details.Visible = false; } else if (passvalue == 3) { strSQL = string.Format("预先订单归并后用量需求表查询 {0}", gstrWhere); tool_Details.Visible = false; } dataAccess.Open(); dtData = dataAccess.GetTable(strSQL, null); dataAccess.Close(); this.myDataGridView1.DataSource = dtData; this.lab_Count.Text = string.Format("记录总数:{0}", dtData.Rows.Count); break; case ReportsEnum.ReportsEnum_rpt料件在线量查询: // this.Text = "料件库存表"; // DataTable drs = null; // DataTable crs = null; // if (passvalue == 1) // { // dataAccess.Open(); // dataAccess.ExecuteNonQuery("delete from 装箱单明细临时表", null); // dataAccess.ExecuteNonQuery(string.Format(@"Insert into 装箱单明细临时表(手册编号,数量,归并前成品序号,日期,成品项号,订单号码) // SELECT XM.手册编号,XM.数量, XM.归并前成品序号,X.录入日期,XM.成品项号,XM.订单号码 // FROM OPENDATASOURCE('SQLOLEDB','Data Source=unique;User ID=SA;Password='******'SQLOLEDB','Data Source=unique;User ID=SA;Password='******'{0}' and XM.手册编号='{1}'",mdEndDateTime,ManualCode),null); // dataAccess.Close(); // } break; } }
/// <summary> /// 加载归并前材料明细用量表 /// </summary> private void LoadDataSourceDetails2() { //bool bShow = false; //if (formBaseLoading == null) //{ // formBaseLoading = new FormBaseLoading(); // bShow = true; // formBaseLoading.strLoadText = string.Format("加载【{0}】数据,请稍等。。。。。。", this.tabPage4.Text); // formBaseLoading.Show(); // formBaseLoading.Refresh(); //} try { string 序号id = string.Empty; string 项号id = string.Empty; string 电子帐册号 = string.Empty; if (this.myDataGridViewHead.CurrentRowNew != null && this.myDataGridViewHead.CurrentRowNew.Index >= 0) { if (this.myDataGridViewHead.Rows[this.myDataGridViewHead.CurrentRowNew.Index].Cells["归并后料件id"].Value != DBNull.Value) { 序号id = this.myDataGridViewHead.Rows[this.myDataGridViewHead.CurrentRowNew.Index].Cells["序号"].Value.ToString().Trim(); if (序号id.Length == 1) { 序号id = string.Format("0{0}", 序号id); } 电子帐册号 = this.myDataGridViewHead.Rows[this.myDataGridViewHead.CurrentRowNew.Index].Cells["电子帐册号"].Value.ToString().Trim(); } } if (this.myDataGridViewDetails.CurrentRowNew != null && this.myDataGridViewDetails.CurrentRowNew.Index >= 0) { if (this.myDataGridViewDetails.Rows[this.myDataGridViewDetails.CurrentRowNew.Index].Cells["归并前料件id"].Value != DBNull.Value) { 项号id = this.myDataGridViewDetails.Rows[this.myDataGridViewDetails.CurrentRowNew.Index].Cells["序号"].Value.ToString().Trim(); if (项号id.Length == 1) { 项号id = string.Format("0{0}", 项号id); } } } IDataAccess dataAccess = DataAccessFactory.CreateDataAccess(DataAccessEnum.DataAccessName.DataAccessName_Manufacture); dataAccess.Open(); string strSQL = string.Format("exec 归并前料件清单明细查询 '{0}','{1}','{2}'", 序号id, 项号id, 电子帐册号); DataTable dtDetails2 = dataAccess.GetTable(strSQL, null); dataAccess.Close(); DataTableTools.AddEmptyRow(dtDetails2); this.myDataGridViewDetails2.DataSource = dtDetails2; } catch (Exception ex) { SysMessage.ErrorMsg(string.Format("加载数据出错LoadDataSourceDetails2,错误信息如下:{0}{1}", Environment.NewLine, ex.Message)); } //finally //{ // if (bShow && formBaseLoading != null) // { // formBaseLoading.Close(); // formBaseLoading.Dispose(); // formBaseLoading = null; // } //} }