| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Xt_BillTypeList " + sWhere, "h_v_Xt_BillTypeList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Xt_BillTypeList " + sWhere+ " order by hitemid desc", "h_v_Xt_BillTypeList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Xt_BillTypeList where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by hitemid desc"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Xt_BillTypeList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Xt_SystemLogList " + sWhere + " order by æ¥æ desc", "h_v_Xt_SystemLogList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Xt_SystemLogList " + sWhere + " order by hid desc", "h_v_Xt_SystemLogList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Xt_SystemLogList where 1 = 1 "; |
| | | string sql = sql1 + sWhere + " order by æ¥æ desc"; |
| | | string sql = sql1 + sWhere + " order by hid desc"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Xt_SystemLogList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Xt_SystemParameterList " + sWhere, "h_v_Xt_SystemParameterList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Xt_SystemParameterList " + sWhere+ " order by hitemid desc", "h_v_Xt_SystemParameterList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Xt_SystemParameterList where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by hitemid desc"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_Proh_v_Xt_SystemParameterListpertyList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Xt_XtgnbList " + sWhere, "h_v_Xt_XtgnbList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Xt_XtgnbList " + sWhere+ " order by hitemid desc", "h_v_Xt_XtgnbList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Xt_XtgnbList where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by hitemid desc"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Xt_XtgnbList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_BadReasonList " + sWhere+ " order by HItemID desc", "h_v_IF_BadReasonList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_BadReasonList " + sWhere+ " order by ä¸è¯åå 代ç ", "h_v_IF_BadReasonList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_IF_BadReasonList where 1 = 1"; |
| | | string sql = sql1 + sWhere+ " order by HItemID desc"; |
| | | string sql = sql1 + sWhere+ " order by ä¸è¯åå 代ç "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_BadReasonList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_QCCheckItemList " + sWhere, "h_v_IF_QCCheckItemList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_QCCheckItemList order by 代ç ", "h_v_IF_QCCheckItemList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_IF_QCCheckItemList where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by 代ç "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_QCCheckItemList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_CurrencyList where ç¦ç¨æ è®°=''" + sWhere, "h_v_Gy_CurrencyList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_CurrencyList where ç¦ç¨æ è®°=''" + sWhere+ " order by è´§å¸ä»£ç ", "h_v_Gy_CurrencyList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Gy_CurrencyList where ç¦ç¨æ è®°='' "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by è´§å¸ä»£ç "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Gy_CurrencyList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | string sql1 = string.Format(@"select * from h_v_Gy_CustomerList where ç»ç»åç§°='" + Organization + "'"); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn(sql1 + sWhere + " order by HItemID desc", "h_v_Gy_CustomerList"); |
| | | ds = oCN.RunProcReturn(sql1 + sWhere + " order by 客æ·ä»£ç ", "h_v_Gy_CustomerList"); |
| | | } |
| | | else |
| | | { |
| | | string sql = sql1 + sWhere + " order by HItemID desc"; |
| | | string sql = sql1 + sWhere + " order by 客æ·ä»£ç "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Gy_CustomerList"); |
| | | } |
| | | objJsonResult.code = "1"; |
| | |
| | | string sql1 = string.Format(@"select * from h_v_IF_DepartmentList where ç»ç»åç§°='" + Organization + "'"); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn(sql1 + sWhere + "order by HItemID desc", "h_v_IF_DepartmentList"); |
| | | ds = oCN.RunProcReturn(sql1 + sWhere + "order by é¨é¨ä»£ç ", "h_v_IF_DepartmentList"); |
| | | } |
| | | else |
| | | { |
| | | string sql = sql1 + sWhere + "order by HItemID desc"; |
| | | string sql = sql1 + sWhere + "order by é¨é¨ä»£ç "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_DepartmentList"); |
| | | } |
| | | |
| | |
| | | string sql1 = string.Format(@"select * from h_v_IF_EmployeeList where ç»ç»åç§°='" + Organization + "'"); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn(sql1 + sWhere + "order by HItemID desc", "h_v_IF_EmployeeList"); |
| | | ds = oCN.RunProcReturn(sql1 + sWhere + " order by èå代ç ", "h_v_IF_EmployeeList"); |
| | | } |
| | | else |
| | | { |
| | | string sql = sql1 + sWhere + "order by HItemID desc"; |
| | | string sql = sql1 + sWhere + " order by èå代ç "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_EmployeeList"); |
| | | } |
| | | objJsonResult.code = "1"; |
| | |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_GroupList " + sWhere+ " order by HItemID ", "h_v_GroupList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_GroupList " + sWhere+ " order by çç»ä»£ç ", "h_v_GroupList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_GroupList where 1 = 1 "; |
| | | string sql = sql1 + sWhere+ " order by HItemID "; |
| | | string sql = sql1 + sWhere+ " order by çç»ä»£ç "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_GroupList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | string sql1 = string.Format(@"select * from h_v_Gy_MaterialList where ç»ç»åç§°='" + Organization + "'"); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn(sql1 + sWhere + "order by HItemID desc", "h_v_Gy_MaterialList"); |
| | | ds = oCN.RunProcReturn(sql1 + sWhere + " order by ç©æä»£ç ", "h_v_Gy_MaterialList"); |
| | | } |
| | | else |
| | | { |
| | | string sql = sql1 + sWhere + "order by HItemID desc"; |
| | | string sql = sql1 + sWhere + " order by ç©æä»£ç "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Gy_MaterialList"); |
| | | } |
| | | |
| | |
| | | } |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_MouldFileList " + sWhere + "order by æ¥æ desc", "h_v_Gy_MouldFileList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_MouldFileList " + sWhere + "order by hmainid desc", "h_v_Gy_MouldFileList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Gy_MouldFileList where 1 = 1 "; |
| | | string sql = sql1 + sWhere + "order by æ¥æ desc"; |
| | | string sql = sql1 + sWhere + "order by hmainid desc"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Gy_MouldFileList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_BarCodeBillList " + sWhere + "order by æ¥æ desc", "h_v_IF_BarCodeBillList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_BarCodeBillList order by hmainid desc", "h_v_IF_BarCodeBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_IF_BarCodeBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere + "order by æ¥æ desc"; |
| | | string sql = sql1 + sWhere + "order by hmainid desc"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_BarCodeBillList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | ds = oCN.RunProcReturn("select HItemID,HParentID,HNumber,HName,HLevel, case when HEndFlag<>0 then 'Y'else ' 'end HEndFlag,case when HStopFlag <> 0 then 'Y'else ' 'end HStopFlag, HRemark, HUseFlag from Gy_MouldType where 1=1 " + sWhere, "Gy_MouldType"); |
| | | ds = oCN.RunProcReturn("select HItemID,HParentID,HNumber,HName,HLevel, case when HEndFlag<>0 then 'Y'else ' 'end HEndFlag,case when HStopFlag <> 0 then 'Y'else ' 'end HStopFlag, HRemark, HUseFlag from Gy_MouldType where 1=1 " + sWhere+ " order by HNumber", "Gy_MouldType"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_OrderBackInfoList " + sWhere, "h_v_Gy_OrderBackInfoList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_OrderBackInfoList " + sWhere+ " order by åé¦ç¶æä»£ç ", "h_v_Gy_OrderBackInfoList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Gy_OrderBackInfoList where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by åé¦ç¶æä»£ç "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Gy_OrderBackInfoList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_OrderLevList " + sWhere, "h_v_Gy_OrderLevList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_OrderLevList " + sWhere+ " order by 订åç级代ç ", "h_v_Gy_OrderLevList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Gy_OrderLevList where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by 订åç级代ç "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Gy_OrderLevList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_ProcessList " + sWhere, "h_v_Gy_ProcessList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_ProcessList order by å·¥åºä»£ç ", "h_v_Gy_ProcessList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Gy_ProcessList where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by å·¥åºä»£ç "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Gy_ProcessList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_PropertyList " + sWhere, "h_v_IF_PropertyList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_PropertyList order by è¾
å©å±æ§ä»£ç ", "h_v_IF_PropertyList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_IF_PropertyList where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by è¾
å©å±æ§ä»£ç "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_PropertyList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_QCCheckClassList " + sWhere, "h_v_IF_QCCheckClassList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_QCCheckClassList order by 代ç ", "h_v_IF_QCCheckClassList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_IF_QCCheckClassList where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by 代ç "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_QCCheckClassList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from Gy_RoutingGroup where 1=1", "Gy_RoutingGroup"); |
| | | ds = oCN.RunProcReturn("select * from Gy_RoutingGroup where 1=1 order by HItemID ", "Gy_RoutingGroup"); |
| | | } |
| | | else |
| | | { |
| | | string sql = "select * from Gy_RoutingGroup where 1 = 1 " + sWhere; |
| | | string sql = "select * from Gy_RoutingGroup where 1 = 1 " + sWhere+ " order by HItemID "; |
| | | ds = oCN.RunProcReturn(sql, "Gy_RoutingGroup"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_SourceList where 1=1 ", "h_v_IF_SourceList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_SourceList where 1=1 order by çäº§èµæºä»£ç ", "h_v_IF_SourceList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_IF_SourceList where 1=1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by çäº§èµæºä»£ç "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_SourceList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | string sql1 = string.Format(@"select * from h_v_Gy_SupplierList where ç»ç»åç§°='" + Organization + "'"); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn(sql1 + sWhere + " order by HItemID desc", "h_v_Gy_SupplierList"); |
| | | ds = oCN.RunProcReturn(sql1 + sWhere + " order by ä¾åºå代ç ", "h_v_Gy_SupplierList"); |
| | | } |
| | | else |
| | | { |
| | | string sql = sql1 + sWhere + " order by HItemID desc"; |
| | | string sql = sql1 + sWhere + " order by ä¾åºå代ç "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Gy_SupplierList"); |
| | | } |
| | | |
| | |
| | | string sql1 = string.Format(@"select * from h_v_Gy_UnitList where ç¦ç¨æ è®°='' and ç»ç»åç§°='" + Organization + "'"); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn(sql1 + sWhere + "order by HItemID desc", "h_v_Gy_UnitList"); |
| | | ds = oCN.RunProcReturn(sql1 + sWhere + "order by 计éåä½ä»£ç ", "h_v_Gy_UnitList"); |
| | | } |
| | | else |
| | | { |
| | | string sql = sql1 + sWhere + "order by HItemID desc"; |
| | | string sql = sql1 + sWhere + "order by 计éåä½ä»£ç "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Gy_UnitList"); |
| | | } |
| | | objJsonResult.code = "1"; |
| | |
| | | string sql1 = string.Format(@"select * from h_v_IF_WareHouseList where ç»ç»åç§°='" + Organization + "'"); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn(sql1 + sWhere + "order by HItemID desc", "h_v_IF_WareHouseList"); |
| | | ds = oCN.RunProcReturn(sql1 + sWhere + " order by ä»åºä»£ç ", "h_v_IF_WareHouseList"); |
| | | } |
| | | else |
| | | { |
| | | string sql = sql1 + sWhere + "order by HItemID desc"; |
| | | string sql = sql1 + sWhere + " order by ä»åºä»£ç "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_WareHouseList"); |
| | | } |
| | | //if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_WorkCenterList " + sWhere, "h_v_WorkCenterList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_WorkCenterList order by å·¥ä½ä¸å¿ä»£ç ", "h_v_WorkCenterList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_WorkCenterList where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by å·¥ä½ä¸å¿ä»£ç "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_WorkCenterList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_DataDictionary_Proc where 1=1 ", "h_v_IF_DataDictionary_Proc"); |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_DataDictionary_Proc where 1=1 order by HItemID desc", "h_v_IF_DataDictionary_Proc"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_IF_DataDictionary_Proc where 1=1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by HItemID desc"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_DataDictionary_Proc"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_DataDictionary_Table where 1=1 ", "h_v_IF_DataDictionary_Table"); |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_DataDictionary_Table where 1=1 order by HItemID desc", "h_v_IF_DataDictionary_Table"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_IF_DataDictionary_Table where 1=1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by HItemID desc"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_DataDictionary_Table"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_DataDictionary_View where 1=1 ", "h_v_IF_DataDictionary_View"); |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_DataDictionary_View where 1=1 order by HItemID desc", "h_v_IF_DataDictionary_View"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_IF_DataDictionary_View where 1=1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by HItemID desc"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_DataDictionary_View"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | string sql1 = string.Format(@"select * from h_v_IF_ORGANIZATIONSList where ç»ç»åç§°='" + Organization + "'"); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn(sql1 + sWhere + "order by HItemID desc", "h_v_IF_ORGANIZATIONSList"); |
| | | ds = oCN.RunProcReturn(sql1 + sWhere + " order by ç»ç»ä»£ç ", "h_v_IF_ORGANIZATIONSList"); |
| | | } |
| | | else |
| | | { |
| | | string sql = sql1 + sWhere + "order by HItemID desc"; |
| | | string sql = sql1 + sWhere + " order by ç»ç»ä»£ç "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_ORGANIZATIONSList"); |
| | | } |
| | | objJsonResult.code = "1"; |
| | |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_MES_StationEntrustInBillList " + sWhere+ " order by ååºæ¶é´ desc", "h_v_MES_StationEntrustInBillList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_MES_StationEntrustInBillList order by hmainid desc", "h_v_MES_StationEntrustInBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_MES_StationEntrustInBillList where 1 = 1 order by ååºæ¶é´ desc"; |
| | | string sql = sql1 + sWhere; |
| | | string sql1 = "select * from h_v_MES_StationEntrustInBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere+ " order by hmainid desc"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_MES_StationEntrustInBillList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_MES_StationEntrustOutBillList " + sWhere+ " order by æ¥æ¶æ¶é´ desc", "h_v_MES_StationEntrustOutBillList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_MES_StationEntrustOutBillList order by hmainid desc", "h_v_MES_StationEntrustOutBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_MES_StationEntrustOutBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by hmainid desc"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_MES_StationEntrustOutBillList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_MES_StationInBillList " + sWhere+ " order by è¿ç«æ¶é´ desc", "h_v_MES_StationInBillList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_MES_StationInBillList order by hmainid desc", "h_v_MES_StationInBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_MES_StationInBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by hmainid desc"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_MES_StationInBillList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¥è¯¢æ°æ®å¼å¸¸ï¼è¯·ä¸ç®¡çåèç³»ï¼"; |
| | | objJsonResult.Message = "æ è®°å½ï¼è¯·ä¸ç®¡çåèç³»ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_MES_StationOutBillList " + sWhere + " order by åºç«æ¶é´ desc", "h_v_MES_StationOutBillList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_MES_StationOutBillList order by hmainid desc", "h_v_MES_StationOutBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_MES_StationOutBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by hmainid desc"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_MES_StationOutBillList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "falseï¼"; |
| | | objJsonResult.Message = "æ è®°å½ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | public static DataSet Get_GG_NoticeBillList(string sWhere) |
| | | { |
| | | var sql = "select A.HInterID,b.HEntryID,A.HBillNo,A.HContext,A.HDeptID,D.HName HDeptName, A.HSendMan, B.HReceiveMan,A.HLevel,A.HDescription,case when B.HReadFlag=0 then 'æªé
' when B.HReadFlag=1 then 'å·²é
' end HReadFlag, A.HMaker,A.HMakeDate,A.HUpDater,A.HUpDateDate" + |
| | | " from OA_InformBillMain A inner join OA_InformBillSub B on A.HInterID=B.HInterID left join Gy_Department D on A.HDeptID=D.HItemID where 1=1 " + sWhere; |
| | | " from OA_InformBillMain A inner join OA_InformBillSub B on A.HInterID=B.HInterID left join Gy_Department D on A.HDeptID=D.HItemID where 1=1 " + sWhere+ " order by HInterID desc"; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "OA_InformBillMain"); |
| | | } |
| | | |
| | |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_DuSubsidyItemList " + sWhere, "h_v_Gy_DuSubsidyItemList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_DuSubsidyItemList order by æ£è¡¥èµæä»£ç ", "h_v_Gy_DuSubsidyItemList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Gy_DuSubsidyItemList where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by æ£è¡¥èµæä»£ç "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Gy_DuSubsidyItemList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | } |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_WorkPayTypeList " + sWhere, "h_v_Gy_WorkPayTypeList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_WorkPayTypeList order by å·¥èµç±»å代ç ", "h_v_Gy_WorkPayTypeList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Gy_WorkPayTypeList where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by å·¥èµç±»å代ç "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Gy_WorkPayTypeList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_WorkTypeList " + sWhere, "h_v_Gy_WorkTypeList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_WorkTypeList order by å·¥ç§ä»£ç ", "h_v_Gy_WorkTypeList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Gy_WorkTypeList where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by å·¥ç§ä»£ç "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Gy_WorkTypeList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | } |
| | | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | ds = oCN.RunProcReturn("select * from h_v_Sc_ProcessExchangeBillQuery where 1 = 1 " + sWhere, "h_v_Sc_ProcessExchangeBillQuery"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Sc_ProcessExchangeBillQuery where 1 = 1 " + sWhere+ " order by hmainid desc ", "h_v_Sc_ProcessExchangeBillQuery"); |
| | | if (ds == null || ds.Tables[0].Rows.Count <= 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | string sql1 = string.Format(@"select * from h_v_Sc_MouldMoveStockStepInBillListDetail where (è°å
¥ç»ç»='" + Organization + "' or è°åºç»ç»='" + Organization + "' )"); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql1 + "order by æ¥æ desc", "h_v_Sc_MouldMoveStockStepInBillListDetail"); |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql1 + "order by hmainid desc", "h_v_Sc_MouldMoveStockStepInBillListDetail"); |
| | | } |
| | | else |
| | | { |
| | | string sql = sql1 + sWhere + "order by æ¥æ desc"; |
| | | string sql = sql1 + sWhere + "order by hmainid desc"; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldMoveStockStepInBillListDetail"); |
| | | } |
| | | |
| | |
| | | string sql1 = string.Format(@"select * from h_v_Sc_MouldMoveStockStepOutBill where (è°åºç»ç»='" + Organization + "' or è°å
¥ç»ç»='" + Organization + "')"); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql1+ "order by æ¥æ desc", "h_v_Sc_MouldMoveStockStepOutBill"); |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql1+ "order by hmainid desc", "h_v_Sc_MouldMoveStockStepOutBill"); |
| | | } |
| | | else |
| | | { |
| | | string sql = sql1 + sWhere+ "order by æ¥æ desc"; |
| | | string sql = sql1 + sWhere+ "order by hmainid desc"; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldMoveStockStepOutBill"); |
| | | } |
| | | |
| | |
| | | string sql1 = string.Format(@"select * from h_v_Sc_MouldOtherOutBillList where åºåç»ç»='" + Organization + "'"); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql1+ "order by æ¥æ desc", "h_v_Sc_MouldOtherOutBillList"); |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql1+ "order by hmainid desc", "h_v_Sc_MouldOtherOutBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql = sql1 + sWhere+ "order by æ¥æ desc"; |
| | | string sql = sql1 + sWhere+ "order by hmainid desc"; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldOtherOutBillList"); |
| | | } |
| | | |
| | |
| | | string sql1 = string.Format(@"select * from h_v_Sc_MouldProdInHouseBillList where åºåç»ç»='" + Organization + "'"); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql1+ sWhere + "order by æ¥æ desc", "h_v_Sc_MouldProdInHouseBillList"); |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql1+ sWhere + "order by hmainid desc", "h_v_Sc_MouldProdInHouseBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql = sql1 + sWhere+ "order by æ¥æ desc"; |
| | | string sql = sql1 + sWhere+ "order by hmainid desc"; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldProdInHouseBillList"); |
| | | } |
| | | } |
| | |
| | | string sql1 = string.Format(@"select * from h_v_Sc_MouldProdMoveBillList where (è°å
¥ç»ç»='" + Organization + "' or è°åºç»ç»='" + Organization + "')"); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql1+ "order by æ¥æ desc", "h_v_Sc_MouldProdMoveBillList"); |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql1+ "order by hmainid desc", "h_v_Sc_MouldProdMoveBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql = sql1 + sWhere+ "order by æ¥æ desc"; |
| | | string sql = sql1 + sWhere+ "order by hmainid desc"; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldProdMoveBillList"); |
| | | } |
| | | |
| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldRepairChangeBillList " + sWhere + "order by æ¥æ desc", "h_v_Sc_MouldRepairChangeBillList"); |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldRepairChangeBillList " + sWhere + "order by hmainid desc", "h_v_Sc_MouldRepairChangeBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Sc_MouldRepairChangeBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere+ "order by æ¥æ desc"; |
| | | string sql = sql1 + sWhere+ "order by hmainid desc"; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldRepairChangeBillList"); |
| | | } |
| | | |
| | |
| | | string sql1 = string.Format(@"select * from h_v_Sc_MouldRepairOutBillList where åºåç»ç»='" + Organization + "'"); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql1+ "order by æ¥æ desc", "h_v_Sc_MouldRepairOutBillList"); |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql1+ "order by hmainid desc", "h_v_Sc_MouldRepairOutBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql = sql1 + sWhere+ "order by æ¥æ desc"; |
| | | string sql = sql1 + sWhere+ "order by hmainid desc"; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldRepairOutBillList"); |
| | | } |
| | | |
| | |
| | | string sql1 = string.Format(@"select * from h_v_Sc_MouldScrapInHouseBillList where åºåç»ç»='" + Organization + "'"); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql1 + sWhere + "order by æ¥æ desc", "h_v_Sc_MouldScrapInHouseBillList"); |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql1 + sWhere + "order by hmainid desc", "h_v_Sc_MouldScrapInHouseBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql = sql1 + sWhere + "order by æ¥æ desc"; |
| | | string sql = sql1 + sWhere + "order by hmainid desc"; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldScrapInHouseBillList"); |
| | | } |
| | | |
| | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_QCCheckProjectList", "h_v_Gy_QCCheckProjectList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_QCCheckProjectList order by hmainid desc ", "h_v_Gy_QCCheckProjectList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Gy_QCCheckProjectList where 1=1"; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by hmainid desc "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Gy_QCCheckProjectList"); |
| | | } |
| | | } |
| | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (sqlWhere == null || sqlWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select top 500 * from h_v_QC_FirstPieceCheckBillList where å
³é人='' ", "h_v_QC_FirstPieceCheckBillList"); |
| | | ds = oCN.RunProcReturn("select top 500 * from h_v_QC_FirstPieceCheckBillList where å
³é人='' order by hmainid desc ", "h_v_QC_FirstPieceCheckBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_QC_FirstPieceCheckBillList where å
³é人='' "; |
| | | string sql = sql1 + sqlWhere; |
| | | string sql = sql1 + sqlWhere+ " order by hmainid desc "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_QC_FirstPieceCheckBillList"); |
| | | } |
| | | } |
| | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (sqlWhere == null || sqlWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select top 500 * from h_v_QC_PatrolProcCheckBillList where å
³é人=''", "h_v_QC_PatrolProcCheckBillList"); |
| | | ds = oCN.RunProcReturn("select top 500 * from h_v_QC_PatrolProcCheckBillList where å
³é人='' order by hmainid desc ", "h_v_QC_PatrolProcCheckBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_QC_PatrolProcCheckBillList where å
³é人='' "; |
| | | string sql = sql1 + sqlWhere; |
| | | string sql = sql1 + sqlWhere+ " order by hmainid desc "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_QC_PatrolProcCheckBillList"); |
| | | } |
| | | } |
| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_QC_Edit_POStockInCheckBillList order by æ¥æ desc", "h_v_QC_Edit_POStockInCheckBillList"); |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_QC_Edit_POStockInCheckBillList order by hmainid desc", "h_v_QC_Edit_POStockInCheckBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_QC_Edit_POStockInCheckBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere + "order by æ¥æ desc"; |
| | | string sql = sql1 + sWhere + "order by hmainid desc"; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_QC_Edit_POStockInCheckBillList"); |
| | | } |
| | | |
| | |
| | | } |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select *from h_v_Gy_EquipFileMainList " + sWhere + "order by æ¥æ desc", "h_v_Gy_EquipFileMainList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_EquipFileMainList " + sWhere + " order by hmainid desc", "h_v_Gy_EquipFileMainList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Gy_EquipFileMainList where 1 = 1 "; |
| | | string sql = sql1 + sWhere + "order by æ¥æ desc"; |
| | | string sql = sql1 + sWhere + " order by hmainid desc"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Gy_EquipFileMainList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | return objJsonResult; |
| | | } |
| | | |
| | | ds = oCN.RunProcReturn("select HItemID,HParentID,HNumber,HName,HLevel, case when HEndFlag<>0 then 'Y'else ' 'end HEndFlag,case when HStopFlag <> 0 then 'Y'else ' 'end HStopFlag, HRemark, HUseFlag from Gy_EquipFileType where 1=1 " + sWhere, "Gy_EquipFileType"); |
| | | ds = oCN.RunProcReturn("select HItemID,HParentID,HNumber,HName,HLevel, case when HEndFlag<>0 then 'Y'else ' 'end HEndFlag,case when HStopFlag <> 0 then 'Y'else ' 'end HStopFlag, HRemark, HUseFlag from Gy_EquipFileType where 1=1 " + sWhere+ " order by HItemID ", "Gy_EquipFileType"); |
| | | if (ds == null) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¥è¯¢æ°æ®å¼å¸¸ï¼è¯·ä¸ç®¡çåèç³»ï¼"; |
| | | objJsonResult.Message = "æ è®°å½ï¼è¯·ä¸ç®¡çåèç³»ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | string sql = "select * from h_v_Sb_EquipRepairSendWorkBillList where 1=1 "; |
| | | if (sWhere == "" || sWhere == null) |
| | | { |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sb_EquipRepairSendWorkBillList"); |
| | | ds = oCN.RunProcReturn(sql+ " order by hmainid desc ", "h_v_Sb_EquipRepairSendWorkBillList"); |
| | | } |
| | | else |
| | | { |
| | | ds = oCN.RunProcReturn(sql + sWhere, "h_v_Sb_EquipRepairSendWorkBillList"); |
| | | ds = oCN.RunProcReturn(sql + sWhere+ " order by hmainid desc ", "h_v_Sb_EquipRepairSendWorkBillList"); |
| | | } |
| | | |
| | | if (ds.Tables[0].Rows.Count == 0 || ds == null) |
| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_QC_LastPieceCheckBillListDetail " + sWhere, "h_v_QC_LastPieceCheckBillListDetail"); |
| | | ds = oCN.RunProcReturn("select * from h_v_QC_LastPieceCheckBillListDetail order by hmainid desc ", "h_v_QC_LastPieceCheckBillListDetail"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_QC_LastPieceCheckBillListDetail where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by hmainid desc "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_QC_LastPieceCheckBillListDetail"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_QC_OutCompCheckBillList " + sWhere, "h_v_QC_OutCompCheckBillList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_QC_OutCompCheckBillList order by hmainid desc ", "h_v_QC_OutCompCheckBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_QC_OutCompCheckBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by hmainid desc "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_QC_OutCompCheckBillList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_ICBomBillList " + sWhere, "h_v_Gy_ICBomBillList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_ICBomBillList order by hmainid desc ", "h_v_Gy_ICBomBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Gy_ICBomBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by hmainid desc "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Gy_ICBomBillList"); |
| | | } |
| | | |
| | |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_ICMOReportBillList_Edit " + sWhere, "h_v_IF_ICMOReportBillList_Edit"); |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_ICMOReportBillList_Edit order by hmainid desc ", "h_v_IF_ICMOReportBillList_Edit"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_IF_ICMOReportBillList_Edit where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by hmainid desc "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_ICMOReportBillList_Edit"); |
| | | } |
| | | |
| | |
| | | A.HSourceInterID,A.HSourceEntryID,A.HSourceBillNo,A.HSourceBillType |
| | | from OA_ErrMsgBackBillMain A |
| | | inner join OA_ErrMsgBackBillSub2 B on A.HInterID=B.HInterID |
| | | left join Gy_Department D on A.HDeptID=D.HItemID where 1=1 " + sWhere + ""); |
| | | left join Gy_Department D on A.HDeptID=D.HItemID where 1=1 " + sWhere + " order by HItemID desc "); |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "OA_ErrMsgBackBillMain"); |
| | | } |
| | | |
| | |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_PPBomBillList " + sWhere, "h_v_IF_PPBomBillList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_PPBomBillList order by hmainid desc ", "h_v_IF_PPBomBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_IF_PPBomBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by hmainid desc "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_PPBomBillList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | int pageSize = limit; |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | sWhere = " where 1=1"; |
| | | sWhere = " where 1=1 order by hmainid desc "; |
| | | } |
| | | else |
| | | { |
| | | sWhere = " where 1=1" + sWhere; |
| | | sWhere = " where 1=1" + sWhere+ " order by hmainid desc "; |
| | | } |
| | | |
| | | DataSet ds0 = oCn.RunProcReturn("select count(*) CountNum from h_v_PackUnionBillList "+sWhere+"", "h_v_PackUnionBillList"); |
| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sb_EquipRepairWorkBillList "+sWhere+ "order by hmainid desc", "h_v_Sb_EquipRepairWorkBillList"); |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sb_EquipRepairWorkBillList "+sWhere+ " order by hmainid desc", "h_v_Sb_EquipRepairWorkBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Sb_EquipRepairWorkBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere+ "order by hmainid desc"; |
| | | string sql = sql1 + sWhere+ " order by hmainid desc"; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sb_EquipRepairWorkBillList"); |
| | | } |
| | | |
| | |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Sb_EquipRepairCheckBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere+ "order by hmainid desc"; |
| | | string sql = sql1 + sWhere+ " order by hmainid desc"; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sb_EquipRepairCheckBillList"); |
| | | } |
| | | |
| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sb_EquipConkBookBillList order by hmainid desc" + sWhere, "h_v_Sb_EquipConkBookBillList"); |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sb_EquipConkBookBillList order by hmainid desc" , "h_v_Sb_EquipConkBookBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Sb_EquipConkBookBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere+ "order by hmainid desc"; |
| | | string sql = sql1 + sWhere+ " order by hmainid desc"; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sb_EquipConkBookBillList"); |
| | | } |
| | | } |
| | |
| | | string sql1 = string.Format(@"select * from h_v_Sc_MouldRepairInBillList where åºåç»ç»='" + Organization + "'"); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql1 + "order by æ¥æ desc", "h_v_Sc_MouldRepairInBillList"); |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql1 + "order by hmainid desc", "h_v_Sc_MouldRepairInBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql = sql1 + sWhere+ "order by æ¥æ desc"; |
| | | string sql = sql1 + sWhere+ "order by hmainid desc"; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldRepairInBillList"); |
| | | } |
| | | |
| | |
| | | /// <returns>object</returns> |
| | | [Route("GroupOrderBill/List")] |
| | | [HttpGet] |
| | | public object List(string sWhere) |
| | | public object List(string sWhere,string user) |
| | | { |
| | | DataSet ds; |
| | | try |
| | | { |
| | | //夿æ¯å¦ææ¥è¯¢æé |
| | | //if (!DBUtility.ClsPub.Security_Log("Sc_GroupOrderBillList_Query", 1, false, user)) |
| | | //{ |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "æ æ¥è¯¢æé!"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | |
| | | string sql1 = string.Format(@"select * from h_v_Sc_MouldOtherInBillList where åºåç»ç»='" + Organization + "'"); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql1 + "order by å¶åæ¥æ desc", "h_v_Sc_MouldOtherInBillList"); |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql1 + "order by hmainid desc", "h_v_Sc_MouldOtherInBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql = sql1 + sWhere+ "order by å¶åæ¥æ desc"; |
| | | string sql = sql1 + sWhere+ "order by hmainid desc"; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldOtherInBillList"); |
| | | } |
| | | |
| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldMaintain order by æ¥æ desc", "h_v_Sc_MouldMaintain"); |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldMaintain order by hmainid desc", "h_v_Sc_MouldMaintain"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Sc_MouldMaintain where 1 = 1 "; |
| | | string sql = sql1 + sWhere + "order by æ¥æ desc"; |
| | | string sql = sql1 + sWhere + "order by hmainid desc"; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldMaintain"); |
| | | |
| | | } |
| | |
| | | |
| | | public static DataSet Sc_MouldDotCheckPlanBillList_s(string sWhere) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldDotCheckPlanBillList order by æ¥æ desc", "h_v_Sc_MouldDotCheckPlanBillList"); |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldDotCheckPlanBillList where 1=1 "+sWhere+ " order by hmainid desc", "h_v_Sc_MouldDotCheckPlanBillList"); |
| | | } |
| | | #endregion |
| | | |
| | |
| | | |
| | | public static DataSet Sc_MouldDotCheckBillList_s(string sWhere) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldDotCheckBillList where 1=1 " + sWhere + "order by æ¥æ desc", "h_v_Sc_MouldDotCheckBillList"); |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldDotCheckBillList where 1=1 " + sWhere + "order by hmainid desc", "h_v_Sc_MouldDotCheckBillList"); |
| | | } |
| | | #endregion |
| | | |
| | |
| | | |
| | | public static DataSet Sc_MouldMaintainPlanBillList_s(string sWhere) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldMaintainPlanBillList where 1=1 "+sWhere+" order by æ¥æ desc", "h_v_Sc_MouldMaintainPlanBillList"); |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldMaintainPlanBillList where 1=1 "+sWhere+ " order by hmainid desc", "h_v_Sc_MouldMaintainPlanBillList"); |
| | | } |
| | | #endregion |
| | | |
| | |
| | | DataSet ds; |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldConkBookBillList order by æ¥æ desc" + sWhere, "h_v_Sc_MouldConkBookBillList"); |
| | | ds = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldConkBookBillList where 1=1 " + sWhere+ " order by hmainid desc", "h_v_Sc_MouldConkBookBillList"); |
| | | } |
| | | else |
| | | { |
| | |
| | | DataSet ds; |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldRepairCheckBillList_Edit order by æ¥æ desc" + sWhere, "h_v_Sc_MouldRepairCheckBillList_Edit"); |
| | | ds = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldRepairCheckBillList_Edit where 1=1" + sWhere+ " order by hmainid desc", "h_v_Sc_MouldRepairCheckBillList_Edit"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Sc_MouldRepairCheckBillList_Edit where 1 = 1 "; |
| | | string sql = sql1 + sWhere + "order by æ¥æ desc"; |
| | | string sql = sql1 + sWhere + "order by hmainid desc"; |
| | | ds = new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldRepairCheckBillList_Edit"); |
| | | } |
| | | return ds; |
| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldRepairWorkBillList order by æ¥æ desc" + sWhere, "h_v_Sc_MouldRepairWorkBillList"); |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldRepairWorkBillList where 1=1 " + sWhere+ " order by hmainid desc", "h_v_Sc_MouldRepairWorkBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Sc_MouldRepairWorkBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere + "order by æ¥æ desc"; |
| | | string sql = sql1 + sWhere + "order by hmainid desc"; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldRepairWorkBillList"); |
| | | } |
| | | } |
| | |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_MoveStockBillList order by æ¥æ desc", "h_v_IF_MoveStockBillList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_MoveStockBillList order by hmainid desc", "h_v_IF_MoveStockBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql = "select * from h_v_IF_MoveStockBillList where 1=1 " + sWhere+ "order by æ¥æ desc"; |
| | | string sql = "select * from h_v_IF_MoveStockBillList where 1=1 " + sWhere+ "order by hmainid desc"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_MoveStockBillList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count <= 0) |
| | |
| | | string sql1 = string.Format(@"select * from h_v_Sc_MouldScrapOutHouseBillList where åºåç»ç»='" + Organization + "'"); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql1 + "order by å¶åæ¥æ desc", "h_v_Sc_MouldScrapOutHouseBillList"); |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql1 + "order by hmainid desc", "h_v_Sc_MouldScrapOutHouseBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql = sql1 + sWhere + "order by å¶åæ¥æ desc"; |
| | | string sql = sql1 + sWhere + "order by hmainid desc"; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldScrapOutHouseBillList"); |
| | | } |
| | | } |
| | |
| | | string sql1 = string.Format(@"select * from h_v_Sc_MouldProdBackBillList where åºåç»ç»='" + Organization + "'"); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql1 + "order by å¶åæ¥æ desc", "h_v_Sc_MouldProdBackBillList"); |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql1 + "order by hmainid desc", "h_v_Sc_MouldProdBackBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql = sql1 + sWhere + "order by å¶åæ¥æ desc"; |
| | | string sql = sql1 + sWhere + "order by hmainid desc"; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldProdBackBillList"); |
| | | } |
| | | |
| | |
| | | string sql1 = string.Format(@"select * from h_v_Sc_MouldProdOutHouseBillList where åºåç»ç»='" + Organization + "'"); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql1 + "order by å¶åæ¥æ desc", "h_v_Sc_MouldProdOutHouseBillList"); |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql1 + "order by hmainid desc", "h_v_Sc_MouldProdOutHouseBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql = sql1 + sWhere + "order by å¶åæ¥æ desc"; |
| | | string sql = sql1 + sWhere + "order by hmainid desc"; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldProdOutHouseBillList"); |
| | | } |
| | | |
| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldLifeChangeBillList order by æ¥æ desc", "h_v_Sc_MouldLifeChangeBillList"); |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldLifeChangeBillList order by hmainid desc", "h_v_Sc_MouldLifeChangeBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Sc_MouldLifeChangeBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere + "order by æ¥æ desc"; |
| | | string sql = sql1 + sWhere + "order by hmainid desc"; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldLifeChangeBillList"); |
| | | } |
| | | |
| | |
| | | } |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Sc_MouldRepairSendWorkBill ", "h_v_Sc_MouldRepairSendWorkBill"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Sc_MouldRepairSendWorkBill order by hmainid desc ", "h_v_Sc_MouldRepairSendWorkBill"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Sc_MouldRepairSendWorkBill where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by hmainid desc "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldRepairSendWorkBill"); |
| | | } |
| | | |
| | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select top 500 * from h_v_Sc_ProcessReportList ", "h_v_Sc_ProcessReportList"); |
| | | ds = oCN.RunProcReturn("select top 500 * from h_v_Sc_ProcessReportList order by hmainid desc", "h_v_Sc_ProcessReportList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Sc_ProcessReportList where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by hmainid desc"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_ProcessReportList"); |
| | | } |
| | | } |
| | |
| | | DataSet ds; |
| | | try |
| | | { |
| | | //if (!DBUtility.ClsPub.Security_Log("Sc_ProcessPlan_Query", 1, false, user)) |
| | | //{ |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "æ æéæ¥è¯¢!"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | if (!DBUtility.ClsPub.Security_Log("Sc_ProcessPlan_Query", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ æéæ¥è¯¢!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select top 500 * from h_v_Sc_ProcessPlanList ", "h_v_Sc_ProcessPlanList"); |
| | | ds = oCN.RunProcReturn("select top 500 * from h_v_Sc_ProcessPlanList order by hmainid desc ", "h_v_Sc_ProcessPlanList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Sc_ProcessPlanList where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by hmainid desc "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_ProcessPlanList"); |
| | | } |
| | | } |
| | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select top 500 * from h_v_Sc_ProcessSendWorkList ", "h_v_Sc_ProcessSendWorkList"); |
| | | ds = oCN.RunProcReturn("select top 500 * from h_v_Sc_ProcessSendWorkList order by hmainid desc ", "h_v_Sc_ProcessSendWorkList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Sc_ProcessSendWorkList where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by hmainid desc "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_ProcessSendWorkList"); |
| | | } |
| | | } |
| | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select top 500 * from h_v_QC_NoPassProdCheckBillList ", "h_v_QC_NoPassProdCheckBillList"); |
| | | ds = oCN.RunProcReturn("select top 500 * from h_v_QC_NoPassProdCheckBillList order by hmainid desc ", "h_v_QC_NoPassProdCheckBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_QC_NoPassProdCheckBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by hmainid desc "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_QC_NoPassProdCheckBillList"); |
| | | } |
| | | } |
| | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (sqlWhere == null || sqlWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select top 500 * from h_v_WW_EntrustProcSendWorkBillList ", "h_v_WW_EntrustProcSendWorkBillList"); |
| | | ds = oCN.RunProcReturn("select top 500 * from h_v_WW_EntrustProcSendWorkBillList order by hmainid desc ", "h_v_WW_EntrustProcSendWorkBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_WW_EntrustProcSendWorkBillList where 1 = 1 "; |
| | | string sql = sql1 + sqlWhere; |
| | | string sql = sql1 + sqlWhere+ " order by hmainid desc "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_WW_EntrustProcSendWorkBillList"); |
| | | } |
| | | } |
| | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (sqlWhere == null || sqlWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select top 500 * from h_v_WW_EntrustProcessSendOutBillList ", "h_v_WW_EntrustProcessSendOutBillList"); |
| | | ds = oCN.RunProcReturn("select top 500 * from h_v_WW_EntrustProcessSendOutBillList order by hmainid desc ", "h_v_WW_EntrustProcessSendOutBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_WW_EntrustProcessSendOutBillList where 1 = 1 "; |
| | | string sql = sql1 + sqlWhere; |
| | | string sql = sql1 + sqlWhere+ " order by hmainid desc "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_WW_EntrustProcessSendOutBillList"); |
| | | } |
| | | } |
| | |
| | | try |
| | | { |
| | | ds = oCN.RunProcReturn("exec h_p_WMS_BarCodeStatusQuery '" + HbarCode + "'", "h_p_WMS_BarCodeStatusQuery"); |
| | | |
| | | |
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
| | | { |
| | | |
| | | Type dataType = col.DataType; |
| | | string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; |
| | | columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//è·åå°DataColumnå对象çåå |
| | |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn(sql, "h_v_KF_ICInventoryList_WMS"); |
| | | ds = oCN.RunProcReturn(sql+ " order by æ¡ç ç¼å· desc", "h_v_KF_ICInventoryList_WMS"); |
| | | } |
| | | else |
| | | { |
| | | ds = oCN.RunProcReturn(sql + sWhere, "h_v_KF_ICInventoryList_WMS"); |
| | | ds = oCN.RunProcReturn(sql + sWhere+ " order by æ¡ç ç¼å· desc", "h_v_KF_ICInventoryList_WMS"); |
| | | } |
| | | |
| | | //è·åè¡¨å¤´åæ®µåç§° |
| | |
| | | string sql1 = string.Format("select * from h_v_IF_MoveStockRequestBillList_Litee where 1=1 "); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCn.RunProcReturn(sql1 + " order by æ¥æ desc", "h_v_IF_MoveStockRequestBillList_Litee"); |
| | | ds = oCn.RunProcReturn(sql1 + " order by hmainid desc", "h_v_IF_MoveStockRequestBillList_Litee"); |
| | | } |
| | | else |
| | | { |
| | | string sql = sql1 + sWhere ; |
| | | string sql = sql1 + sWhere + " order by hmainid desc"; |
| | | ds = oCn.RunProcReturn(sql, "h_v_IF_MoveStockRequestBillList_Litee"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_QC_ProcessCheckBillListDetail " + sWhere, "h_v_QC_ProcessCheckBillListDetail"); |
| | | ds = oCN.RunProcReturn("select * from h_v_QC_ProcessCheckBillListDetail order by hmainid desc ", "h_v_QC_ProcessCheckBillListDetail"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_QC_ProcessCheckBillListDetail where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by hmainid desc "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_QC_ProcessCheckBillListDetail"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | string sql1 = string.Format(@"select * from h_v_Gy_ConkReasonList"); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql1 + sWhere + " order by hitemid desc", "h_v_Gy_ConkReasonList"); |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql1 + sWhere + " order by æ
éåå 代ç ", "h_v_Gy_ConkReasonList"); |
| | | } |
| | | else |
| | | { |
| | | string sql = sql1 + sWhere + "order by hitemid desc"; |
| | | string sql = sql1 + sWhere + "order by æ
éåå 代ç "; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Gy_ConkReasonList"); |
| | | } |
| | | } |
| | |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | ds = oCN.RunProcReturn("select HItemID,HNumber,HName,HLevel, case when HEndFlag<>0 then 'Y'else ' 'end HEndFlag,case when HStopFlag <> 0 then 'Y'else ' 'end HStopFlag, HRemark, HUseFlag from Gy_DotCheck where 1=1 " + sWhere, "Gy_DotCheck"); |
| | | ds = oCN.RunProcReturn("select HItemID,HNumber,HName,HLevel, case when HEndFlag<>0 then 'Y'else ' 'end HEndFlag,case when HStopFlag <> 0 then 'Y'else ' 'end HStopFlag, HRemark, HUseFlag from Gy_DotCheck where 1=1 " + sWhere+ " order by HNumber", "Gy_DotCheck"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | ds = oCN.RunProcReturn("select HItemID,HNumber,HName,HLevel, case when HEndFlag<>0 then 'Y'else ' 'end HEndFlag,case when HStopFlag <> 0 then 'Y'else ' 'end HStopFlag, HRemark, HUseFlag from Gy_Maintain where 1=1 " + sWhere, "Gy_Maintain"); |
| | | ds = oCN.RunProcReturn("select HItemID,HNumber,HName,HLevel, case when HEndFlag<>0 then 'Y'else ' 'end HEndFlag,case when HStopFlag <> 0 then 'Y'else ' 'end HStopFlag, HRemark, HUseFlag from Gy_Maintain where 1=1 " + sWhere+ " order by HNumber", "Gy_Maintain"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | ds = oCN.RunProcReturn("select HItemID,HNumber,HName,HLevel, case when HEndFlag<>0 then 'Y'else ' 'end HEndFlag,case when HStopFlag <> 0 then 'Y'else ' 'end HStopFlag, HRemark, HUseFlag from Gy_Repair where 1=1 " + sWhere, "Gy_Repair"); |
| | | ds = oCN.RunProcReturn("select HItemID,HNumber,HName,HLevel, case when HEndFlag<>0 then 'Y'else ' 'end HEndFlag,case when HStopFlag <> 0 then 'Y'else ' 'end HStopFlag, HRemark, HUseFlag from Gy_Repair where 1=1 " + sWhere+ " order by HNumber", "Gy_Repair"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | ds = oCN.RunProcReturn("select HItemID,HNumber,HName,HLevel, case when HEndFlag<>0 then 'Y'else ' 'end HEndFlag,case when HStopFlag <> 0 then 'Y'else ' 'end HStopFlag, HRemark, HUseFlag from Gy_RepairCheck where 1=1 " + sWhere, "Gy_RepairCheck"); |
| | | ds = oCN.RunProcReturn("select HItemID,HNumber,HName,HLevel, case when HEndFlag<>0 then 'Y'else ' 'end HEndFlag,case when HStopFlag <> 0 then 'Y'else ' 'end HStopFlag, HRemark, HUseFlag from Gy_RepairCheck where 1=1 " + sWhere+ " order by HNumber", "Gy_RepairCheck"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (sID == null || sID == "") |
| | | { |
| | | sql = string.Format(@"select * from h_v_Sc_MouldInventoryAnalysisList where " + sWhere); |
| | | sql = string.Format(@"select * from h_v_Sc_MouldInventoryAnalysisList where " + sWhere+ " order by HItemID desc "); |
| | | } |
| | | else |
| | | { |
| | | sql = string.Format(@"select * from h_v_Sc_MouldInventoryAnalysisList where " + sWhere + " and HSourceInterID=(select HItemID from Gy_StockCheckItem where HItemID=" + sID + ") and HMakeDate<=(select HEndDate from Gy_StockCheckItem where HItemID=" + sID + ")"); |
| | | sql = string.Format(@"select * from h_v_Sc_MouldInventoryAnalysisList where " + sWhere + " and HSourceInterID=(select HItemID from Gy_StockCheckItem where HItemID=" + sID + ") and HMakeDate<=(select HEndDate from Gy_StockCheckItem where HItemID=" + sID + ") order by HItemID desc "); |
| | | } |
| | | ds = oCN.RunProcReturn(sql, "Sc_MouldStockBillMain_Temp"); |
| | | list.Add(ds.Tables[0]); |
| | |
| | | string sql1 = string.Format(@"select * from h_v_Gy_MouldStockBillMainTempList where 1=1 "); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql1 + sWhere + " order by å¶åæ¥æ desc", "h_v_Gy_MouldStockBillMainTempList"); |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql1 + sWhere + " order by hitemid desc", "h_v_Gy_MouldStockBillMainTempList"); |
| | | } |
| | | else |
| | | { |
| | | string sql = sql1 + sWhere + "order by å¶åæ¥æ desc"; |
| | | string sql = sql1 + sWhere + "order by hitemid desc"; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Gy_MouldStockBillMainTempList"); |
| | | } |
| | | } |
| | |
| | | { |
| | | try |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_ProcPriceList where 1 = 1 " + sWhere, "h_v_Gy_ProcPriceList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_ProcPriceList where 1 = 1 " + sWhere+ " order by å·¥åºå·¥ä»·èµæä»£ç ", "h_v_Gy_ProcPriceList"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | } |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_ClassTimePrjList " + sWhere, "h_v_Gy_ClassTimePrjList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_ClassTimePrjList order by æ ¸ç®æ¹å¼ä»£ç ", "h_v_Gy_ClassTimePrjList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Gy_ClassTimePrjList where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by æ ¸ç®æ¹å¼ä»£ç "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Gy_ClassTimePrjList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_ClassTimePrjSubList where 1=1 ", "h_v_Gy_ClassTimePrjSubList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_ClassTimePrjSubList where 1=1 order by HInterID desc", "h_v_Gy_ClassTimePrjSubList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Gy_ClassTimePrjSubList where 1=1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by HInterID desc"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Gy_ClassTimePrjSubList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Gy_GroupEmpBillList order by æ¥æ desc", "h_v_Gy_GroupEmpBillList"); |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Gy_GroupEmpBillList order by hmainid desc", "h_v_Gy_GroupEmpBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Gy_GroupEmpBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere + " order by æ¥æ desc"; |
| | | string sql = sql1 + sWhere + " order by hmainid desc"; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Gy_GroupEmpBillList"); |
| | | } |
| | | |
| | |
| | | |
| | | |
| | | /// <summary> |
| | | /// è¿åå·¥èµç»ç®ä¸ªäººå表 |
| | | /// è¿åå·¥èµç»ç®ä¸ªäººå表(éä½) |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Pay_GroupBalBillList order by æ¥æ desc", "h_v_Pay_GroupBalBillList"); |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Pay_GroupBalBillList order by hmainid desc", "h_v_Pay_GroupBalBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Pay_GroupBalBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere + "order by æ¥æ desc"; |
| | | string sql = sql1 + sWhere + " order by hmainid desc"; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Pay_GroupBalBillList"); |
| | | } |
| | | |
| | |
| | | public DLL.ClsPay_OtherBalBill BillOld0 = new DLL.ClsPay_OtherBalBill(); // |
| | | |
| | | /// <summary> |
| | | /// è¿åå·¥èµç»ç®ä¸ªäººå表 |
| | | /// è¿åå·¥èµç»ç®ä¸ªäººå表(å
¶ä») |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Pay_OtherBalBillList order by æ¥æ desc", "h_v_Pay_OtherBalBillList"); |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Pay_OtherBalBillList order by hmainid desc", "h_v_Pay_OtherBalBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Pay_OtherBalBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere + "order by æ¥æ desc"; |
| | | string sql = sql1 + sWhere + " order by hmainid desc"; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Pay_OtherBalBillList"); |
| | | } |
| | | |
| | |
| | | public DLL.ClsPay_SingleBalBill BillOld0 = new DLL.ClsPay_SingleBalBill(); // |
| | | |
| | | /// <summary> |
| | | /// è¿åå·¥èµç»ç®ä¸ªäººå表 |
| | | /// è¿åå·¥èµç»ç®ä¸ªäººå表(个人) |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Pay_SingleBalBillList order by æ¥æ desc", "h_v_Pay_SingleBalBillList"); |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Pay_SingleBalBillList order by hmainid desc", "h_v_Pay_SingleBalBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Pay_SingleBalBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere + "order by æ¥æ desc"; |
| | | string sql = sql1 + sWhere + " order by hmainid desc"; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Pay_SingleBalBillList"); |
| | | } |
| | | |
| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Pay_WorkTimesBillList order by æ¥æ desc", "h_v_Pay_WorkTimesBillList"); |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Pay_WorkTimesBillList order by hmainid desc", "h_v_Pay_WorkTimesBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Pay_WorkTimesBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere + "order by æ¥æ desc"; |
| | | string sql = sql1 + sWhere + " order by hmainid desc"; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Pay_WorkTimesBillList"); |
| | | } |
| | | |
| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MESBeginWorkBillList_NEW ", "h_v_Sc_MESBeginWorkBillList_NEW"); |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MESBeginWorkBillList_NEW order by hmainid desc ", "h_v_Sc_MESBeginWorkBillList_NEW"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Sc_MESBeginWorkBillList_NEW where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by hmainid desc "; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MESBeginWorkBillList_NEW"); |
| | | } |
| | | |
| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MESEndWorkBillList_NEW ", "h_v_Sc_MESEndWorkBillList_NEW"); |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MESEndWorkBillList_NEW order by hmainid desc ", "h_v_Sc_MESEndWorkBillList_NEW"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Sc_MESEndWorkBillList_NEW where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by hmainid desc "; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MESEndWorkBillList_NEW"); |
| | | } |
| | | |
| | |
| | | } |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillWorkQtyStatus_Tmp " + sWhere + "order by åæ®å· desc", "h_v_IF_ICMOBillWorkQtyStatus_Tmp"); |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillWorkQtyStatus_Tmp order by HInterID desc", "h_v_IF_ICMOBillWorkQtyStatus_Tmp"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_IF_ICMOBillWorkQtyStatus_Tmp where 1 = 1 "; |
| | | string sql = sql1 + sWhere + " order by åæ®å· desc"; |
| | | string sql = sql1 + sWhere + " order by HInterID desc"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_ICMOBillWorkQtyStatus_Tmp"); |
| | | } |
| | | objJsonResult.code = "1"; |
| | |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MESReturnWorkBillList_NEW ", "h_v_Sc_MESReturnWorkBillList_NEW"); |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MESReturnWorkBillList_NEW order by hmainid desc ", "h_v_Sc_MESReturnWorkBillList_NEW"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Sc_MESReturnWorkBillList_NEW where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by hmainid desc "; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MESReturnWorkBillList_NEW"); |
| | | } |
| | | |
| | |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Sc_MESStopWorkBillList_NEW " + sWhere, "h_v_Sc_MESStopWorkBillList_NEW"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Sc_MESStopWorkBillList_NEW order by hmainid desc ", "h_v_Sc_MESStopWorkBillList_NEW"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Sc_MESStopWorkBillList_NEW where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by hmainid desc "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_MESStopWorkBillList_NEW"); |
| | | } |
| | | objJsonResult.code = "1"; |
| | |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Sc_MaterToSourceBillMain " + sWhere, "h_v_Sc_MaterToSourceBillMain"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Sc_MaterToSourceBillMain order by hmainid desc ", "h_v_Sc_MaterToSourceBillMain"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Sc_MaterToSourceBillMain where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by hmainid desc "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_MaterToSourceBillMain"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Sc_QualityReportBillListDetail " + sWhere, "h_v_Sc_QualityReportBillListDetail"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Sc_QualityReportBillListDetail order by hmainid desc ", "h_v_Sc_QualityReportBillListDetail"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Sc_QualityReportBillListDetail where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | string sql = sql1 + sWhere+ " order by hmainid desc "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_QualityReportBillListDetail"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |