/// <summary> /// 获取记录总数 /// </summary> public int GetRecordCount(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) FROM TB_BC "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } object obj = DbHelperOra.GetSingle(strSql.ToString()); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 获取最新的转库单号 /// </summary> /// <param name="C_ZKD_NO">转库单</param> /// <returns></returns> public long GetZKDNO(string C_ZKD_NO) { StringBuilder strSql = new StringBuilder(); strSql.Append("select MAX(C_ZKD_NO) "); strSql.Append(" FROM TRC_ROLL_ZKD WHERE N_STATUS=1 "); if (C_ZKD_NO.Trim() != "") { strSql.Append(" AND C_ZKD_NO LIKE '" + C_ZKD_NO + "%' "); } object obj = DbHelperOra.GetSingle(strSql.ToString()); if (obj == null) { return(0); } else { return(Convert.ToInt64(obj)); } }
/// <summary> /// 根据发运单号获取发运单状态 /// </summary> /// <param name="fydh">发运单</param> /// <returns></returns> public string GetFYDZT(string fydh) { StringBuilder strSql = new StringBuilder(); strSql.Append("select C_STATUS "); strSql.Append(" FROM TMD_DISPATCH WHERE 1=1 "); if (fydh.Trim() != "") { strSql.Append(" AND C_ID = '" + fydh + "' "); } object obj = DbHelperOra.GetSingle(strSql.ToString()); if (obj == null) { return(""); } else { return(obj.ToString()); } }
/// <summary> /// 获得当前层支数 /// </summary> public int GetListByC(string strc) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) FROM TSC_SLAB_MAIN "); strSql.Append(" WHERE C_SC_STATE ='E' "); if (strc.Trim() != "") { strSql.Append(" AND C_SLABWH_LOC_CODE='" + strc + "'"); } object obj = DbHelperOra.GetSingle(strSql.ToString()); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
///// <summary> ///// 获得数据列表-库位号 ///// </summary> ///// <param name="C_LINEWH_LOC_CODE">库位号</param> ///// <param name="C_LINEWH_AREA_ID">外键</param> ///// <returns></returns> //public DataSet GetList_KW(string C_LINEWH_LOC_CODE, string C_LINEWH_AREA_ID) //{ // StringBuilder strSql = new StringBuilder(); // strSql.Append("select C_ID,C_LINEWH_AREA_ID,C_LINEWH_LOC_CODE,C_LINEWH_LOC_NAME,D_START_DATE,D_END_DATE,DECODE(N_STATUS,1,'启用','停用') N_STATUS,C_REMARK,C_EMP_ID,D_MOD_DT,C_ISOUT,C_LOADING_MODE,N_QTY "); // strSql.Append(" FROM TPB_LINEWH_LOC where 1=1 "); // if (C_LINEWH_LOC_CODE.Trim() != "") // { // strSql.Append(" and C_LINEWH_LOC_CODE = '" + C_LINEWH_LOC_CODE + "'"); // } // if (C_LINEWH_AREA_ID.Trim() != "") // { // strSql.Append(" and C_LINEWH_AREA_ID = '" + C_LINEWH_AREA_ID + "'"); // } // return DbHelperOra.Query(strSql.ToString()); //} /// <summary> /// 获得数据列表-数量总和 /// </summary> /// <param name="begin">起始库位</param> /// <param name="end">截止库位</param> /// <returns></returns> public int GetList_SUM(string begin, string end) { StringBuilder strSql = new StringBuilder(); strSql.Append("select sum(N_QTY) FROM TPB_LINEWH_LOC "); if (begin.Trim() != "" && end.Trim() != "") { strSql.Append(" where C_LINEWH_LOC_CODE between " + begin + " and " + end + " "); } object obj = DbHelperOra.GetSingle(strSql.ToString()); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 根据项目ID /// </summary> /// <param name="c_name">成分/性能 名称</param> /// <returns></returns> public string GetItemID(string c_name) { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT Max(C_ID) FROM TQB_CHARACTER "); if (!string.IsNullOrEmpty(c_name)) { strSql.Append(" where upper(C_NAME) = upper('" + c_name + "' ) "); } object obj = DbHelperOra.GetSingle(strSql.ToString()); if (obj == null) { return(""); } else { return(obj.ToString()); } }
/// <summary> /// 根据工位代码获取工序主键 /// </summary> /// <param name="C_STA_CODE">工位代码</param> /// <returns></returns> public string GetproIdByCode(string C_STA_CODE) { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT C_PRO_ID from TB_STA "); strSql.Append(" where C_STA_CODE=:C_STA_CODE AND N_STATUS=1"); OracleParameter[] parameters = { new OracleParameter(":C_STA_CODE", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_STA_CODE; object obj = DbHelperOra.GetSingle(strSql.ToString(), parameters); if (obj == null) { return("0"); } else { return(obj.ToString()); } }
/// <summary> /// 获取记录总数 /// </summary> public int Get_Max_EditNum(string C_STOVE, string C_ANANO, string C_COMMISSIONID, string C_SAMPID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select max(to_number(C_EDIT_NUM)) FROM TQC_QUA_RESULT_LOG t where 1=1 "); if (!string.IsNullOrEmpty(C_STOVE)) { strSql.Append(" AND T.C_STOVE='" + C_STOVE + "' "); } if (!string.IsNullOrEmpty(C_ANANO)) { strSql.Append(" AND T.C_ANANO='" + C_ANANO + "' "); } if (!string.IsNullOrEmpty(C_COMMISSIONID)) { strSql.Append(" AND T.C_COMMISSIONID='" + C_COMMISSIONID + "' "); } if (!string.IsNullOrEmpty(C_SAMPID)) { strSql.Append(" AND T.C_SAMPID='" + C_SAMPID + "' "); } object obj = DbHelperOra.GetSingle(strSql.ToString()); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 获取记录总数 /// </summary> public int GetRecordCount(string C_NO, string C_NAME) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) FROM TS_CUSTFILE where 1=1"); if (!string.IsNullOrEmpty(C_NO)) { strSql.Append("and C_NO='" + C_NO + "'"); } if (!string.IsNullOrEmpty(C_NAME)) { strSql.Append("and C_NAME like '%" + C_NAME + "%'"); } object obj = DbHelperOra.GetSingle(strSql.ToString()); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
public string GetWarningData() { string strWarning = ""; try { string sql = "select W_CONTENT from(select W_CONTENT,CITY,W_TYPE,W_LEVEL,DDATETIME from t_hk_warning t ORDER BY DDATETIME DESC) where rownum<2"; string sql4 = "select W_LEVEL from(select W_CONTENT,CITY,W_TYPE,W_LEVEL,DDATETIME from t_hk_warning t ORDER BY DDATETIME DESC) where rownum<2"; string sql2 = "select W_TYPE from(select W_CONTENT,CITY,W_TYPE,W_LEVEL,DDATETIME from t_hk_warning t ORDER BY DDATETIME DESC) where rownum<2"; var resobj = DbHelperOra.GetSingle(sql, CommonClass.GetconnectionStringsValue("ConnectionEJETDB247Idcty")); var resobj4 = DbHelperOra.GetSingle(sql4, CommonClass.GetconnectionStringsValue("ConnectionEJETDB247Idcty")); var resobj2 = DbHelperOra.GetSingle(sql2, CommonClass.GetconnectionStringsValue("ConnectionEJETDB247Idcty")); if (resobj != null) { strWarning = resobj.ToString() + "!" + resobj4.ToString() + "#" + resobj2.ToString(); } } catch (Exception ex) { CommonClass.ErrWriter(ex.ToString()); } return(strWarning); }
/// <summary> /// 通过库位编码获取数据 /// </summary> /// <param name="locCode">库位编码</param> /// <param name="iStatus">状态</param> /// <returns></returns> public object GetListByLocID(string locCode, int iStatus) { StringBuilder strSql = new StringBuilder(); strSql.Append("select C_ID "); strSql.Append(" FROM TPB_SLABWH_LOC "); if (locCode.Trim() != "") { strSql.Append(" where C_SLABWH_LOC_CODE=:C_SLABWH_LOC_CODE"); } if (iStatus.ToString().Trim() != "") { strSql.Append(" AND N_STATUS=:N_STATUS"); } OracleParameter[] parameters = { new OracleParameter(":C_SLABWH_LOC_CODE", OracleDbType.Varchar2, 100), new OracleParameter(":N_STATUS", OracleDbType.Decimal, 3) }; parameters[0].Value = locCode; parameters[1].Value = iStatus; return(DbHelperOra.GetSingle(strSql.ToString(), parameters)); }
/// <summary> /// 获取组坯限制量 /// </summary> /// <param name="id"></param> /// <returns></returns> public object GetLimitNum(string id) { return(DbHelperOra.GetSingle("SELECT N_NUM FROM TB_CONFIG_LIMIT T WHERE T.C_ID='" + id + "'").ToString()); }