| | |
|---|
| | | |
|---|
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
|---|
| | | List<object> columnNameList = new List<object>(); |
|---|
| | | if(sWhere!=null) |
|---|
| | | { |
|---|
| | | sWhere = sWhere.Replace("'", "''"); |
|---|
| | | } |
|---|
| | | DataSet ds = oCN.RunProcReturn("exec h_p_KF_WorkShopICStockBillList '" + HBillType + "','" + HCarBarCode + "','" + HProcExBillNo + "','" + HMaterNumber + "'," + HWHID + "," + HSPID + ",'" + sWhere + "'", "h_p_KF_WorkShopICStockBillList"); |
|---|
| | | //添加列名 |
|---|
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
|---|
| | |
|---|
| | | objJsonResult.code = "0"; |
|---|
| | | objJsonResult.count = 0; |
|---|
| | | objJsonResult.Message = "没有返回任何记录！"; |
|---|
| | | objJsonResult.data = null; |
|---|
| | | objJsonResult.data = ds.Tables[0]; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | else |
|---|
