| | |
|---|
| | | string selectedFolderPath = folderBrowserDialog.SelectedPath; |
|---|
| | | // 使用 selectedFolderPath 进行后续操作，例如显示在文本框中 |
|---|
| | | this.txtLj.Text = selectedFolderPath; |
|---|
| | | GetCSV_Read(selectedFolderPath); |
|---|
| | | //GetExcel_Read(selectedFolderPath); |
|---|
| | | //GetCSV_Read(selectedFolderPath); |
|---|
| | | GetExcel_Read(selectedFolderPath); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | } |
|---|
| | |
|---|
| | | DataSet dataSet = oCN.RunProcReturn(@"select a.HInterID HQCSchemeID,b.HQCCheckItemID, ch.HNumber HQCCheckItemNumber,m.HNumber,HUpLimit,HDownLimit,HTargetVal |
|---|
| | | from Sc_ProcessExchangeBillMain pr with(nolock) |
|---|
| | | inner join Gy_QCCheckProjectMain a with(nolock) on pr.HMaterID=a.HMaterID |
|---|
| | | inner join Gy_QCCheckProjectSub b with(nolock) on a.HInterID=b.HInterID and b.HInspectInstruMentID=2 |
|---|
| | | inner join Gy_QCCheckProjectSub b with(nolock) on a.HInterID=b.HInterID and b.HInspectInstruMentID=1 |
|---|
| | | left join Gy_Material m with(nolock) on a.HMaterID=m.HItemID |
|---|
| | | left join Gy_QCCheckItem ch with(nolock) on b.HQCCheckItemID=ch.HItemID |
|---|
| | | where pr.HBillNo='" + this.txtLzk.Text + "'", "Gy_QCCheckProjectMain"); |
|---|
