| | |
|---|
| | | List<object> columnNameList = new List<object>(); |
|---|
| | | //得到信息（委外标记为0时，流转标记为1时） |
|---|
| | | //ds = oCN.RunProcReturn("select * from h_v_Sc_ProcessExchangeBillList_Sec where 下道流转工序<>'转' and 委外标记=0 and 流转标记=1 and 工序号='" + sProcNo + "' and 序列号='" + HSEQNumber + "'", "h_v_Sc_ProcessExchangeBillList_Sec"); |
|---|
| | | ds = oCN.RunProcReturn("select * from h_v_Sc_ProcessExchangeArrangementHEmpList where 1=1 " + sWhere, "h_v_Sc_ProcessExchangeArrangementHEmpList"); |
|---|
| | | ds = oCN.RunProcReturn("select Top 1000 * from h_v_Sc_ProcessExchangeArrangementHEmpList where 1=1 " + sWhere, "h_v_Sc_ProcessExchangeArrangementHEmpList"); |
|---|
| | | |
|---|
| | | //添加列名 |
|---|
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
|---|
