/// <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());
}
}
