/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TRC_ROLL_PDD_ITEM GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_YSDH,C_MATCODE,C_PCH,C_SX,C_ZCSL,C_FZCZL,C_FREE0,C_FREE1,C_FREE2,C_FREE3,C_FREE4,C_ID,D_INSERT,C_REMARK,N_STATUS,C_CK,C_MATDESC,C_SPEC,C_STL_GRD,C_NC_SL,C_NC_ZL,C_CAP_SL,C_CAP_ZL,C_RF_SL,C_RF_ZL,C_RF_SJ_SL,C_RF_SJ_ZL,C_NC_CAP_SL,C_NC_CAP_ZL,C_RF_CAP_SL,C_RF_CAP_ZL,C_CAP_SJ_SL,C_CAP_SJ_ZL from TRC_ROLL_PDD_ITEM ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TRC_ROLL_PDD_ITEM model = new Mod_TRC_ROLL_PDD_ITEM();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TB_LG_PLAN_LOG GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_IP,C_STOVE,C_PLAN_ID,C_ORDER_NO,C_MES_PLAN_ID,C_LD_DESC,C_LF_DESC,C_RH_DESC,C_CC_DESC,C_EMP_ID,D_MOD_DT,C_REMARK from TB_LG_PLAN_LOG ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TB_LG_PLAN_LOG model = new Mod_TB_LG_PLAN_LOG();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(Mod_TMB_AREA mod)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_CODE,C_NAME,N_PARENTID,N_SORT,N_DEPTH,C_REMARK,N_STATUS,N_ISGPS,C_EMP_ID,C_EMP_NAME,D_MOD_DT ");
strSql.Append(" FROM TMB_AREA where N_STATUS=1 ");
if (!string.IsNullOrEmpty(mod.C_CODE))
{
strSql.Append(" and C_CODE in(" + mod.C_CODE + ")");
}
if (!string.IsNullOrEmpty(mod.C_NAME))
{
strSql.Append(" and C_NAME like '%" + mod.C_NAME + "%'");
}
if (!string.IsNullOrEmpty(mod.N_PARENTID))
{
strSql.Append(" and N_PARENTID='" + mod.N_PARENTID + "'");
}
strSql.Append(" order by N_SORT asc");
return(DbHelperOra.Query(strSql.ToString()));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TQB_STD_CFXN GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_STD_MAIN_ID,C_CHARACTER_ID,C_TARGET_MIN,C_TARGET_INTERVAL,C_TARGET_MAX,C_PREWARNING_VALUE,C_TYPE,C_IS_DECIDE,C_IS_PRINT,N_PRINT_ORDER,N_SPEC_MIN,C_SPEC_INTERVAL,N_SPEC_MAX,C_FORMULA,C_UNIT,N_DIGIT,C_QUANTITATIVE,C_TEST_TEM,C_TEST_CONDITION,N_STATUS,C_REMARK,C_EMP_ID,D_MOD_DT,C_ITEM_NAME from TQB_STD_CFXN ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TQB_STD_CFXN model = new Mod_TQB_STD_CFXN();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TPB_N_GRD GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_STA_ID,C_STL_GRD,C_STD_CODE,N_LEVEL,C_REMARK,C_PROD_NAME,C_PROD_KIND,N_STATUS,C_EMP_ID,D_MOD_DT,C_SPEC from TPB_N_GRD ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TPB_N_GRD model = new Mod_TPB_N_GRD();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TB_MATRL_CONTRAST GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_SLAB_SIZE,N_SLAB_LENTH,C_KP_SIZE,N_KP_LENTH,C_EMP_ID,D_MOD_DT,C_REMARK1,C_REMARK2,C_REMARK3 from TB_MATRL_CONTRAST ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TB_MATRL_CONTRAST model = new Mod_TB_MATRL_CONTRAST();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TPB_GL_CAPACITY GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_PRO_ID,C_STA_ID,C_STA_DESC,C_STA_CODE,N_CAPACITY,D_START_DATE,D_END_DATE,N_STATUS,C_EMP_ID,D_MOD_DT from TPB_GL_CAPACITY ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TPB_GL_CAPACITY model = new Mod_TPB_GL_CAPACITY();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TQR_REJECTS GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_STOVE,C_BATCH_NO,C_STL_GRD,C_STL_GRD_TYPE,C_REASON_NAME,C_REASON_QUA,N_REASON_WGT from TQR_REJECTS ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TQR_REJECTS model = new Mod_TQR_REJECTS();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TRC_PLAN_REGROUND_ITEM GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_PLAN_REGROUND_ID,C_SLAB_MAIN_ID,C_REMARK,N_STEP,N_TOTALSTEP,N_STEPNAME,N_STATUS,C_EMP_ID,D_MOD_DT,C_STA_ID from TRC_PLAN_REGROUND_ITEM ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TRC_PLAN_REGROUND_ITEM model = new Mod_TRC_PLAN_REGROUND_ITEM();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TSP_CAST_PLAN_LOG GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_CCM_ID,C_CCM_CODE,N_GROUP,N_TOTAL_WGT,N_ZJCLS,N_ZJCLZL,N_MLZL,N_SORT,C_STL_GRD,N_PRODUCE_TIME,N_JSCN,C_BY1,C_BY2,C_BY3,C_RH,C_DFP_HL,C_HL,C_XM,N_ORDER_LS,D_DFPHL_START_TIME,D_DFPHL_END_TIME,D_KP_START_TIME,D_KP_END_TIME,D_HL_START_TIME,D_HL_END_TIME,D_PLAN_KY_TIME,C_PLAN_ROLL,D_ZZ_START_TIME,D_ZZ_END_TIME,D_XM_START_TIME,D_XM_END_TIME,C_STD_CODE,C_SLAB_TYPE,C_STL_GRD_TYPE,C_PROD_NAME,C_PROD_KIND,N_DFP_HL_TIME,N_HL_TIME,N_XM_TIME,N_GG,N_CCM_TIME,C_TJ_REMARK,C_TL,N_RH,N_TL,N_GZSL,C_REMARK,N_XM,N_DHL,N_HL,N_STATUS,D_P_START_TIME,D_P_END_TIME,N_DFP_RZ,N_RZP_RZ,C_RH_SFJS,C_TZ_REMARK,C_LOG_ID,C_LOG_REMARK,C_LOG_EMP,D_LOG_DT,C_LOG_IP from TSP_CAST_PLAN_LOG ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TSP_CAST_PLAN_LOG model = new Mod_TSP_CAST_PLAN_LOG();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TSC_SLAB_MAIN_KP GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_SLAN_PLAN_KP_ID,C_STA_ID,C_SPEC,N_LEN,N_QUA,N_WGT,D_ACT_START_TIME,D_ACT_END_TIME,N_STATUS,N_BFZS,N_KPSJ,C_BC,C_BZ,C_EMP_ID,D_MOD_DT,C_REMARK from TSC_SLAB_MAIN_KP ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TSC_SLAB_MAIN_KP model = new Mod_TSC_SLAB_MAIN_KP();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TRC_WARM_FURNACE_LOG GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_BATCH_NO,N_QUA_JOIN,N_WGT_JOIN,C_TRC_ROLL_MAIN_ID,N_ROLL_STATE,D_MOD_DT,C_EMP_ID,C_STA_ID,N_TYPE,C_SHIFT,C_GROUP,N_QUA_EXIT,N_WGT_EXIT,C_SLAB_MAIN_ID,C_STOVE,N_LEN,C_MAT_CODE,C_MAT_NAME from TRC_WARM_FURNACE_LOG ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TRC_WARM_FURNACE_LOG model = new Mod_TRC_WARM_FURNACE_LOG();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TQB_STD_MAIN GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_STD_TYPE,C_STD_CODE,C_STD_DESC,C_STL_GRD,C_PROD_NAME,C_PROD_KIND,C_USES,n_EDIT_NUM,C_EDITION,C_IS_LF,C_IS_RH,C_IS_HL,C_IS_XM,C_IRON_REQUIRE,C_STOCK_REQUIRE,C_DELIVERY_STATE,C_PHYSICS_TIME,N_IS_CHECK,N_STATUS,C_REMARK,C_EMP_ID,D_MOD_DT,C_IS_BXG from TQB_STD_MAIN ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TQB_STD_MAIN model = new Mod_TQB_STD_MAIN();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TQC_ZZS_INFO GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_FYDH,C_BATCH_NO,C_STOVE,C_SPEC,C_STL_GRD,C_STD_CODE,D_CKSJ,N_JZ,N_NUM,C_CH,C_PDF_NAME,C_PDF_PATCH,N_PRINT_NUM,C_ZSH,C_QZR,D_QZRQ,C_BY1,C_BY2,C_BY3,N_STATUS,C_REMARK from TQC_ZZS_INFO ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TQC_ZZS_INFO model = new Mod_TQC_ZZS_INFO();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TQC_SLAB_COMMUTE GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_SLAB_MAIN_ID,C_STA_ID,C_STOVE,N_WGT,N_LEN,C_STL_GRD_BEFORE,C_STD_CODE_BEFORE,C_SPEC_BEFORE,C_MAT_CODE_BEFORE,C_MAT_DESC_BEFORE,D_COMMUTE_DATE,C_STL_GRD_AFTER,C_STD_CODE_AFTER,C_SPEC_AFTER,C_MAT_CODE_AFTER,C_MAT_DESC_AFTER,C_REASON_DEPMT_ID,C_REASON_DEPMT_DESC,C_EMP_ID,C_REMARK,N_STATUS,C_SCUTCHEON,C_MASTER_ID,C_GP_BEFORE_ID,C_GP_AFTER_ID,C_GP_TYPE,C_ZYX1_BEFORE,C_ZYX2_BEFORE,C_ZYX1_AFTER,C_ZYX2_AFTER,C_JUDGE_LEV_BP_BEFORE,C_JUDGE_LEV_BP_AFTER,C_BATCH_NO,C_COMMUTE_REASON from TQC_SLAB_COMMUTE ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TQC_SLAB_COMMUTE model = new Mod_TQC_SLAB_COMMUTE();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TB_STD_CONFIG GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_STD_ID,C_CUST_TECH_PROT,C_ZYX1,C_ZYX2,C_STL_GRD,C_STD_CODE,C_STEEL_SIGN,C_EMP_ID,D_MOD_DT,C_REMARK,D_START_DATE,D_END_DATE,N_STATUS,C_CUST_NO,C_CUST_NAME from TB_STD_CONFIG ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TB_STD_CONFIG model = new Mod_TB_STD_CONFIG();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TPB_BXGXMGZ GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_EMP_ID,D_MOD_DT,C_STL_GRD,C_SLAB_SIZE,C_GZLX,N_JSCN,N_LTH,N_TOTAL_CN,C_IS_BXG,C_REMARK from TPB_BXGXMGZ ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TPB_BXGXMGZ model = new Mod_TPB_BXGXMGZ();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string grd, string xy, string zxbz, string lgjh)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_STD_ID,C_CUST_TECH_PROT,C_ZYX1,C_ZYX2,C_STL_GRD,C_STD_CODE,C_STEEL_SIGN,C_EMP_ID,D_MOD_DT,C_REMARK,D_START_DATE,D_END_DATE,N_STATUS,C_CUST_NO,C_CUST_NAME ");
strSql.Append(" FROM TB_STD_CONFIG WHERE N_STATUS=1");
if (grd.Trim() != "")
{
strSql.Append(" AND C_STL_GRD LIKE '%" + grd + "%' ");
}
if (xy.Trim() != "")
{
strSql.Append(" AND C_CUST_TECH_PROT LIKE '%" + xy + "%' ");
}
if (zxbz.Trim() != "")
{
strSql.Append(" AND C_STD_CODE LIKE '%" + zxbz + "%' ");
}
if (lgjh.Trim() != "")
{
strSql.Append(" AND C_STEEL_SIGN LIKE '%" + lgjh + "%' ");
}
return(DbHelperOra.Query(strSql.ToString()));
}
/// <summary>
/// 标记钢坯异常
/// </summary>
/// <param name="stove">炉号</param>
/// <param name="matCode">物料编码</param>
/// <param name="slabwhCode">货位</param>
/// <param name="remark">异常原因</param>
/// <param name="batchNo">开坯号</param>
/// <returns>标记是否成功</returns>
public bool UpdateSlabCancleYC(string stove, string matCode, string slabwhCode, string batchNo)
{
string sql = "";
if (string.IsNullOrWhiteSpace(batchNo))
{
sql = @"UPDATE TSC_SLAB_MAIN TSM SET TSM.C_KP_ID='' WHERE TSM.C_STOVE='" + stove + "' AND TSM.C_MAT_CODE='" + matCode + "' AND TSM.C_SLABWH_CODE='" + slabwhCode + "'";
}
else
{
sql = @"UPDATE TSC_SLAB_MAIN TSM SET TSM.C_KP_ID='' WHERE TSM.C_BATCH_NO='" + batchNo + "' AND TSM.C_MAT_CODE='" + matCode + "' AND TSM.C_SLABWH_CODE='" + slabwhCode + "'";
}
int rows = DbHelperOra.ExecuteSql(sql);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TQB_XN_CHECK_PROCEDURE GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_PHYSICS_GROUP_ID,C_NAME,N_STATUS,C_REMARK,C_EMP_ID,D_MOD_DT,C_CODE,N_ORDER,C_DESC,C_DESC_ITEM from TQB_XN_CHECK_PROCEDURE ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TQB_XN_CHECK_PROCEDURE model = new Mod_TQB_XN_CHECK_PROCEDURE();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TRC_ROLL_SPOT_CHECK_NAME GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_ROLL_SPOT_CHECK_ID,C_SAMPLES_NAME,N_SAM_NUM,N_STATUS,C_REMARK,C_EMP_ID,D_MOD_DT from TRC_ROLL_SPOT_CHECK_NAME ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TRC_ROLL_SPOT_CHECK_NAME model = new Mod_TRC_ROLL_SPOT_CHECK_NAME();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TQB_WAREHOUSE_CAUSE_OPINION GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_CAUSE_OPINION,N_STATUS,C_REMARK,C_EMP_ID,D_MOD_DT from TQB_WAREHOUSE_CAUSE_OPINION ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TQB_WAREHOUSE_CAUSE_OPINION model = new Mod_TQB_WAREHOUSE_CAUSE_OPINION();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TQC_SLAB_YC_LOG GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_STOVE,C_STL_GRD,C_STD_CODE,C_MAT_CODE,C_MAT_NAME,C_SPEC,N_LEN,C_REASON,C_TYPE,N_STATUS,C_EMP_ID,D_MOD_DT,C_REMARK from TQC_SLAB_YC_LOG ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TQC_SLAB_YC_LOG model = new Mod_TQC_SLAB_YC_LOG();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 根据顺序号得到一个对象实体
/// </summary>
public Mod_TB_PRO GetModelBySoft(string N_SORT)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_PRO_CODE,C_PRO_DESC,C_EMP_ID,D_MOD_DT,C_REMARK,D_START_DATE,D_END_DATE,N_STATUS,C_PRO_ERPCODE,C_PRO_MESCODE,N_SORT from TB_PRO ");
strSql.Append(" where N_STATUS=1 AND N_SORT=:N_SORT ");
OracleParameter[] parameters =
{
new OracleParameter(":N_SORT", OracleDbType.Decimal, 3)
};
parameters[0].Value = N_SORT;
Mod_TB_PRO model = new Mod_TB_PRO();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TPB_STA_HOOK_NO GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_STA_ID,N_NO,C_HOOK_NAME,C_REMARK,N_STATUS,C_EMP_ID,D_MOD_DT,D_START_DATE,D_END_DATE from TPB_STA_HOOK_NO ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TPB_STA_HOOK_NO model = new Mod_TPB_STA_HOOK_NO();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TQC_ROOL_CHECK_AFFIRM GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_WE_CHECK_ROOL_ID,C_SUGGESTION,N_STATUS,C_REMARK,C_CHECK_EMP_ID,D_CHECK_DT from TQC_ROOL_CHECK_AFFIRM ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TQC_ROOL_CHECK_AFFIRM model = new Mod_TQC_ROOL_CHECK_AFFIRM();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TMB_AREA GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_CODE,C_NAME,N_PARENTID,N_SORT,N_DEPTH,C_REMARK,N_STATUS,N_ISGPS,C_EMP_ID,C_EMP_NAME,D_MOD_DT from TMB_AREA ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TMB_AREA model = new Mod_TMB_AREA();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TQB_COOL_BASIC GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,N_COOL_DT,C_HEAT,C_TYPE,C_COOL_CRAFT_CODE,C_COOL_CRAFT,C_HOT_T,N_STATUS,C_REMARK,C_EMP_ID,D_MOD_DT from TQB_COOL_BASIC where N_STATUS=1");
strSql.Append(" and C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TQB_COOL_BASIC model = new Mod_TQB_COOL_BASIC();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 根据转库单号获取model
/// </summary>
/// <param name="C_ZKDH">转库单号</param>
/// <returns></returns>
public Mod_TSC_SLAB_MOVE GetModelbyDH(string C_ZKDH)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_MOVE_TYPE,C_SLAB_MAIN_ID,C_STA_ID,C_STOVE,C_STL_GRD,C_SPEC,N_LEN,C_STD_CODE,C_MAT_CODE,C_MAT_NAME,N_WGT,C_STOCK_CODE,C_STOCK_CODE_TO,C_AREA_CODE,C_KW_CODE,C_FLOOD_CODE,N_QUA,D_MOVE_DATE,C_MOVE_GROUP,C_MOVE_SHIFT,C_MOVE_EMP_ID,N_STATUS,C_REMARK,C_ZKDH, from TSC_SLAB_MOVE ");
strSql.Append(" where C_ZKDH=:C_ZKDH ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ZKDH", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ZKDH;
Mod_TSC_SLAB_MOVE model = new Mod_TSC_SLAB_MOVE();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TRC_ROLL_TIME GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_STA_ID,C_RQ,N_NUM_GRD,N_NUM_SPEC,C_TIME_SPEC from TRC_ROLL_TIME ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TRC_ROLL_TIME model = new Mod_TRC_ROLL_TIME();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}