| | |
|---|
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
|---|
| | | if (sqlWhere == null || sqlWhere.Equals("")) |
|---|
| | | { |
|---|
| | | ds = oCN.RunProcReturn("select top 500 * from h_v_QC_PatrolProcCheckBillList where 关闭人='' order by hmainid desc ", "h_v_QC_PatrolProcCheckBillList"); |
|---|
| | | ds = oCN.RunProcReturn("select top 500 * from h_v_QC_PatrolProcCheckBillMainList where 关闭人='' order by hmainid desc ", "h_v_QC_PatrolProcCheckBillMainList"); |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | string sql1 = "select * from h_v_QC_PatrolProcCheckBillList where 关闭人='' "; |
|---|
| | | string sql1 = "select * from h_v_QC_PatrolProcCheckBillMainList where 关闭人='' "; |
|---|
| | | string sql = sql1 + sqlWhere+ " order by 制单日期 desc "; |
|---|
| | | ds = oCN.RunProcReturn(sql, "h_v_QC_PatrolProcCheckBillList"); |
|---|
| | | ds = oCN.RunProcReturn(sql, "h_v_QC_PatrolProcCheckBillMainList"); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | catch (Exception e) |
|---|
| | |
|---|
| | | UserName = oItem.HMaker; |
|---|
| | | oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd")); |
|---|
| | | oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); |
|---|
| | | oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd")); |
|---|
| | | oItem.HDate=oItem.HDate.ToString()==""? DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd")) : oItem.HDate; |
|---|
| | | oItem.HBillType = "7506"; |
|---|
| | | oItem.HBillSubType = "7506"; |
|---|
| | | oItem.HBillStatus = 0; |
|---|
