/// <summary> /// 获取成分记录 /// </summary> public int Get_MES_CF_Count(string APPID, string SAMPLE_CODE, string HEATID) { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT count(1) FROM CQA_LAB_ELEMENT@cap_mes T WHERE UNITTYPEID='6' and APPID='" + APPID + "' and SAMPLE_CODE='" + SAMPLE_CODE + "' and HEATID='" + HEATID + "' "); object obj = TransactionHelper.GetSingle(strSql.ToString()); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 获取最大主键 /// </summary> public Int64 Get_Max_ID_Trans() { StringBuilder strSql = new StringBuilder(); strSql.Append("select max(C_ID) FROM TQB_SAMP_MODLE_JSZX "); object obj = TransactionHelper.GetSingle(strSql.ToString()); if (obj == null) { return(0); } else { return(Convert.ToInt64(obj)); } }
/// <summary> /// 获取表判记录 /// </summary> public int Get_MES_ZP_Count(string stove) { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT COUNT(1) FROM CQA_BLOOM_FINJUDGE_DATA@cap_mes T WHERE T.HEATID='" + stove + "' "); object obj = TransactionHelper.GetSingle(strSql.ToString()); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 获取记录总数 /// </summary> public int Get_Stove_Count(string C_STOVE) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) FROM TQC_QUA_RESULT where C_STOVE='" + C_STOVE + "' "); object obj = TransactionHelper.GetSingle(strSql.ToString()); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 获取最大盘点单号 /// </summary> public string Get_Max_PDDH(string strTime) { StringBuilder strSql = new StringBuilder(); strSql.Append("select max(substr(t.c_ysdh,3)) from TRC_ROLL_PDD t where to_char(t.d_pdrq,'yyyy-mm-dd')=to_char(to_date('" + strTime + "','yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd') "); object obj = TransactionHelper.GetSingle(strSql.ToString()); if (obj == null) { return(""); } else { return(obj.ToString()); } }
/// <summary> /// 获取盘点单号 /// </summary> public string Get_PDDH(string strTime, string strCK) { StringBuilder strSql = new StringBuilder(); strSql.Append("select max(t.c_ysdh) from TRC_ROLL_PDD t where t.d_pdrq=to_date('" + strTime + "','yyyy-mm-dd hh24:mi:ss') and t.c_ck='" + strCK + "' "); object obj = TransactionHelper.GetSingle(strSql.ToString()); if (obj == null) { return(""); } else { return(obj.ToString()); } }
/// <summary> /// 获取最新的钢坯出库单号 /// </summary> /// <param name="ckdh">出库单号</param> /// <returns></returns> public string GetCKDNO(string ckdh) { StringBuilder strSql = new StringBuilder(); strSql.Append("select MAX(C_CKDH) "); strSql.Append(" FROM TMD_DISPATCH_SJZJB WHERE 1=1 "); if (ckdh.Trim() != "") { strSql.Append(" AND C_CKDH LIKE 'GP" + ckdh + "%' "); } object obj = TransactionHelper.GetSingle(strSql.ToString()); if (obj == null) { return("0"); } else { return(obj.ToString()); } }