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