| | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_QCCheckProjectList order by hmainid desc ", "h_v_Gy_QCCheckProjectList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_QCCheckProjectList order by 日期 desc ", "h_v_Gy_QCCheckProjectList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Gy_QCCheckProjectList where 1=1"; |
| | | string sql = sql1 + sWhere+ " order by hmainid desc "; |
| | | string sql = sql1 + sWhere+ " order by 日期 desc "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Gy_QCCheckProjectList"); |
| | | } |
| | | } |
| | |
| | | oItemSub.HRelationQty = 0; |
| | | oItemSub.HRelationMoney = 0; |
| | | oItemSub.HCloseMan = ""; |
| | | oItemSub.HDestructInspect = Convert.ToInt32(oItemSub.HDestructInspect); |
| | | oItemSub.HKeyInspect = Convert.ToInt32(oItemSub.HKeyInspect); |
| | | oBill.DetailColl.Add(oItemSub); |
| | | |
| | | } |