/// <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;
// }
//}
}
