/// <summary>
/// 重置顺序
/// </summary>
public int CZSORT(string pro)
{
DataTable dt = GetListByStatus(1, pro, "").Tables[0];
TransactionHelper.BeginTransaction();
if (dt.Rows.Count > 0)
{
int sort = 1;
foreach (DataRow item in dt.Rows)
{
string sql = "";
sql = "UPDATE TB_STA SET N_SORT='" + sort + "' WHERE C_ID='" + item["C_ID"] + "' AND C_PRO_ID='" + pro + "' ";
if (TransactionHelper.ExecuteSql(sql) == 1)
{
sort++;
}
else
{
TransactionHelper.RollBack();
return(0);
}
}
}
TransactionHelper.Commit();
return(1);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TRC_COGDOWN_MAIN_ITEM model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TRC_COGDOWN_MAIN_ITEM(");
strSql.Append("C_COGDOWN_MAIN_ID,C_SLAB_MAIN_ID)");
strSql.Append(" values (");
strSql.Append(":C_COGDOWN_MAIN_ID,:C_SLAB_MAIN_ID)");
OracleParameter[] parameters =
{
new OracleParameter(":C_COGDOWN_MAIN_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SLAB_MAIN_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_COGDOWN_MAIN_ID;
parameters[1].Value = model.C_SLAB_MAIN_ID;
int rows = TransactionHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add_Trans(Mod_TQC_QUA_RESULT model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TQC_QUA_RESULT(");
strSql.Append("N_STATUS,C_REMARK,C_EMP_ID,D_MOD_DT,N_SPLIT,N_TYPE,C_STOVE,D_CREATETIME,C_ANANO,C_COMMISSIONID,C_ANAITEM,N_ORIGINALVALUE,C_GROUP,C_SHIFT,D_SHIFTDATE,C_SAMPID,C_SAMPSORT,C_IS_PD)");
strSql.Append(" values (");
strSql.Append(":N_STATUS,:C_REMARK,:C_EMP_ID,:D_MOD_DT,:N_SPLIT,:N_TYPE,:C_STOVE,:D_CREATETIME,:C_ANANO,:C_COMMISSIONID,:C_ANAITEM,:N_ORIGINALVALUE,:C_GROUP,:C_SHIFT,:D_SHIFTDATE,:C_SAMPID,:C_SAMPSORT,:C_IS_PD)");
OracleParameter[] parameters =
{
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":N_SPLIT", OracleDbType.Decimal, 1),
new OracleParameter(":N_TYPE", OracleDbType.Decimal, 1),
new OracleParameter(":C_STOVE", OracleDbType.Varchar2, 100),
new OracleParameter(":D_CREATETIME", OracleDbType.Date),
new OracleParameter(":C_ANANO", OracleDbType.Decimal, 10),
new OracleParameter(":C_COMMISSIONID", OracleDbType.Varchar2, 250),
new OracleParameter(":C_ANAITEM", OracleDbType.Varchar2, 250),
new OracleParameter(":N_ORIGINALVALUE", OracleDbType.Decimal, 8),
new OracleParameter(":C_GROUP", OracleDbType.Varchar2, 250),
new OracleParameter(":C_SHIFT", OracleDbType.Varchar2, 250),
new OracleParameter(":D_SHIFTDATE", OracleDbType.Date),
new OracleParameter(":C_SAMPID", OracleDbType.Varchar2, 250),
new OracleParameter(":C_SAMPSORT", OracleDbType.Varchar2, 250),
new OracleParameter(":C_IS_PD", OracleDbType.Varchar2, 10)
};
parameters[0].Value = model.N_STATUS;
parameters[1].Value = model.C_REMARK;
parameters[2].Value = model.C_EMP_ID;
parameters[3].Value = model.D_MOD_DT;
parameters[4].Value = model.N_SPLIT;
parameters[5].Value = model.N_TYPE;
parameters[6].Value = model.C_STOVE;
parameters[7].Value = model.D_CREATETIME;
parameters[8].Value = model.C_ANANO;
parameters[9].Value = model.C_COMMISSIONID;
parameters[10].Value = model.C_ANAITEM;
parameters[11].Value = model.N_ORIGINALVALUE;
parameters[12].Value = model.C_GROUP;
parameters[13].Value = model.C_SHIFT;
parameters[14].Value = model.D_SHIFTDATE;
parameters[15].Value = model.C_SAMPID;
parameters[16].Value = model.C_SAMPSORT;
parameters[17].Value = model.C_IS_PD;
int rows = TransactionHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool TranAdd(Mod_TPA_XM_PLAN model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TPA_XM_PLAN(");
strSql.Append("C_STOVE_NO,C_STL_GRD,C_STD_CODE,N_WGT,N_ACT_WGT,D_START_TIME,D_END_TIME,N_CN,D_PLAN_DATE,C_XMYQ,C_XM_TYPE,C_REMARK,N_STATUS,C_CCM,D_START_TIME_SJ,D_END_TIME_SJ,C_FK,N_SORT)");
strSql.Append(" values (");
strSql.Append(":C_STOVE_NO,:C_STL_GRD,:C_STD_CODE,:N_WGT,:N_ACT_WGT,:D_START_TIME,:D_END_TIME,:N_CN,:D_PLAN_DATE,:C_XMYQ,:C_XM_TYPE,:C_REMARK,:N_STATUS,:C_CCM,:D_START_TIME_SJ,:D_END_TIME_SJ,:C_FK,:N_SORT)");
OracleParameter[] parameters =
{
new OracleParameter(":C_STOVE_NO", OracleDbType.Varchar2, 50),
new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 50),
new OracleParameter(":C_STD_CODE", OracleDbType.Varchar2, 50),
new OracleParameter(":N_WGT", OracleDbType.Decimal, 10),
new OracleParameter(":N_ACT_WGT", OracleDbType.Decimal, 10),
new OracleParameter(":D_START_TIME", OracleDbType.Date),
new OracleParameter(":D_END_TIME", OracleDbType.Date),
new OracleParameter(":N_CN", OracleDbType.Decimal, 10),
new OracleParameter(":D_PLAN_DATE", OracleDbType.Date),
new OracleParameter(":C_XMYQ", OracleDbType.Varchar2, 500),
new OracleParameter(":C_XM_TYPE", OracleDbType.Varchar2, 50),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 3),
new OracleParameter(":C_CCM", OracleDbType.Varchar2, 50),
new OracleParameter(":D_START_TIME_SJ", OracleDbType.Date),
new OracleParameter(":D_END_TIME_SJ", OracleDbType.Date),
new OracleParameter(":C_FK", OracleDbType.Varchar2, 50),
new OracleParameter(":N_SORT", OracleDbType.Decimal, 4)
};
parameters[0].Value = model.C_STOVE_NO;
parameters[1].Value = model.C_STL_GRD;
parameters[2].Value = model.C_STD_CODE;
parameters[3].Value = model.N_WGT;
parameters[4].Value = model.N_ACT_WGT;
parameters[5].Value = model.D_START_TIME;
parameters[6].Value = model.D_END_TIME;
parameters[7].Value = model.N_CN;
parameters[8].Value = model.D_PLAN_DATE;
parameters[9].Value = model.C_XMYQ;
parameters[10].Value = model.C_XM_TYPE;
parameters[11].Value = model.C_REMARK;
parameters[12].Value = model.N_STATUS;
parameters[13].Value = model.C_CCM;
parameters[14].Value = model.D_START_TIME_SJ;
parameters[15].Value = model.D_END_TIME_SJ;
parameters[16].Value = model.C_FK;
parameters[17].Value = model.N_SORT;
int rows = TransactionHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add_Trans(Mod_TQC_RESULT_MAIN_ZJB model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TQC_RESULT_MAIN_ZJB(");
strSql.Append("C_BATCH_NO,C_TICK_NO,C_STL_GRD,C_SPEC,C_EMP_ID,D_MOD_DT,C_EMP_ID_ZY,D_MOD_DT_ZY,C_EMP_ID_JS,D_MOD_DT_JS,C_PHYSICS_GROUP_ID,C_CHECK_STATE,N_RECHECK,N_STATUS,C_REMARK,C_DISPOSAL ,C_QRZT,C_ITEM_NAME)");
strSql.Append(" values (");
strSql.Append(":C_BATCH_NO,:C_TICK_NO,:C_STL_GRD,:C_SPEC,:C_EMP_ID,:D_MOD_DT,:C_EMP_ID_ZY,:D_MOD_DT_ZY,:C_EMP_ID_JS,:D_MOD_DT_JS,:C_PHYSICS_GROUP_ID,:C_CHECK_STATE,:N_RECHECK,:N_STATUS,:C_REMARK,:C_DISPOSAL ,:C_QRZT,:C_ITEM_NAME)");
OracleParameter[] parameters =
{
new OracleParameter(":C_BATCH_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_TICK_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SPEC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":C_EMP_ID_ZY", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD_DT_ZY", OracleDbType.Date),
new OracleParameter(":C_EMP_ID_JS", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD_DT_JS", OracleDbType.Date),
new OracleParameter(":C_PHYSICS_GROUP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CHECK_STATE", OracleDbType.Varchar2, 10),
new OracleParameter(":N_RECHECK", OracleDbType.Decimal, 2),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500),
new OracleParameter(":C_DISPOSAL", OracleDbType.Varchar2, 100),
new OracleParameter(":C_QRZT", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ITEM_NAME", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_BATCH_NO;
parameters[1].Value = model.C_TICK_NO;
parameters[2].Value = model.C_STL_GRD;
parameters[3].Value = model.C_SPEC;
parameters[4].Value = model.C_EMP_ID;
parameters[5].Value = model.D_MOD_DT;
parameters[6].Value = model.C_EMP_ID_ZY;
parameters[7].Value = model.D_MOD_DT_ZY;
parameters[8].Value = model.C_EMP_ID_JS;
parameters[9].Value = model.D_MOD_DT_JS;
parameters[10].Value = model.C_PHYSICS_GROUP_ID;
parameters[11].Value = model.C_CHECK_STATE;
parameters[12].Value = model.N_RECHECK;
parameters[13].Value = model.N_STATUS;
parameters[14].Value = model.C_REMARK;
parameters[15].Value = model.C_DISPOSAL;
parameters[16].Value = model.C_QRZT;
parameters[17].Value = model.C_ITEM_NAME;
int rows = TransactionHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获取前两个计划
/// </summary>
public DataSet Get_Up_Plan_Trans(string c_line_code, int rowNum)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from( select * from TRP_PLAN_ROLL_TEST t where t.c_line_code='" + c_line_code + "' AND T.D_P_END_TIME IS NOT NULL order by t.d_p_End_Time desc) where rownum<=" + rowNum + " ");
return(TransactionHelper.Query(strSql.ToString()));
}
/// <summary>
/// 获取浇次列表
/// </summary>
/// <returns></returns>
public DataSet Get_JC_List_Trans()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from TPP_LGPC_LSB_TEST t where t.c_ccm_code<>'5#CC' ");
return(TransactionHelper.Query(strSql.ToString()));
}
/// <summary>
/// 按钢种和执行标准查询未下发计划的轧线
/// </summary>
public DataSet Get_Line_Lsit_Trans()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT T.C_LINE_CODE,T.C_STA_ID FROM TRP_PLAN_ROLL_TEST T WHERE t.c_line_code is not null and T.N_STATUS in (0,1) AND T.N_ISSUE_WGT < T.N_WGT GROUP BY T.C_LINE_CODE,T.C_STA_ID ORDER BY T.C_LINE_CODE ");
return(TransactionHelper.Query(strSql.ToString()));
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList_Interface_Trans(string c_master_id, string c_gp_before_id, string c_gp_after_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_STOVE,sum(N_WGT) wgt ");
strSql.Append(" from tsc_slab_main where C_MASTER_ID='" + c_master_id + "' and C_GP_BEFORE_ID='" + c_gp_before_id + "' and C_GP_AFTER_ID='" + c_gp_after_id + "' ");
strSql.Append(" group by C_STOVE ");
return(TransactionHelper.Query(strSql.ToString()));
}
/*
* /// <summary>
* /// 分页获取数据列表
* /// </summary>
* public DataSet GetList(int PageSize,int PageIndex,string strWhere)
* {
* OracleParameter[] parameters = {
* new OracleParameter(":tblName", OracleDbType.Varchar2, 255),
* new OracleParameter(":fldName", OracleDbType.Varchar2, 255),
* new OracleParameter(":PageSize", OracleDbType.Number),
* new OracleParameter(":PageIndex", OracleDbType.Number),
* new OracleParameter(":IsReCount", OracleDbType.Clob),
* new OracleParameter(":OrderType", OracleDbType.Clob),
* new OracleParameter(":strWhere", OracleDbType.Varchar2,1000),
* };
* parameters[0].Value = "TQC_SLAB_COMMUTE";
* parameters[1].Value = "C_ID";
* parameters[2].Value = PageSize;
* parameters[3].Value = PageIndex;
* parameters[4].Value = 0;
* parameters[5].Value = 0;
* parameters[6].Value = strWhere;
* return DbHelperOra.RunProcedure("UP_GetRecordByPage",parameters,"ds");
* }*/
#endregion BasicMethod
#region ExtensionMethod
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList_Interface(string c_master_id, string c_gp_before_id, string c_gp_after_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(C_ID) cou,C_STOVE,sum(N_WGT) wgt,C_STL_GRD_BEFORE,C_STD_CODE_BEFORE,C_MAT_CODE_BEFORE,C_MAT_DESC_BEFORE ,C_STL_GRD_AFTER,C_STD_CODE_AFTER,C_SPEC_AFTER,C_MAT_CODE_AFTER,C_MAT_DESC_AFTER ");
strSql.Append(" from tqc_slab_commute where C_MASTER_ID='" + c_master_id + "' and C_GP_BEFORE_ID='" + c_gp_before_id + "' and C_GP_AFTER_ID='" + c_gp_after_id + "' ");
strSql.Append(" group by C_STOVE, C_STL_GRD_BEFORE,C_STD_CODE_BEFORE,C_MAT_CODE_BEFORE,C_MAT_DESC_BEFORE ,C_STL_GRD_AFTER,C_STD_CODE_AFTER,C_SPEC_AFTER,C_MAT_CODE_AFTER,C_MAT_DESC_AFTER ,C_MASTER_ID,C_GP_BEFORE_ID,C_GP_AFTER_ID ");
return(TransactionHelper.Query(strSql.ToString()));
}
/// <summary>
/// 根据发运单号更新线材实绩
/// </summary>
/// <param name="num">数量</param>
/// <returns></returns>
public int BJBynum(int num, string fydh)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE TSC_SLAB_MAIN SET");
strSql.Append(" C_FRFLAG='1'");
strSql.Append(" where C_FYDH='" + fydh + "' AND rownum<='" + num + "'");
return(TransactionHelper.ExecuteSql(strSql.ToString()));
}
/*
* /// <summary>
* /// 分页获取数据列表
* /// </summary>
* public DataSet GetList(int PageSize,int PageIndex,string strWhere)
* {
* OracleParameter[] parameters = {
* new OracleParameter(":tblName", OracleDbType.Varchar2, 255),
* new OracleParameter(":fldName", OracleDbType.Varchar2, 255),
* new OracleParameter(":PageSize", OracleDbType.Number),
* new OracleParameter(":PageIndex", OracleDbType.Number),
* new OracleParameter(":IsReCount", OracleDbType.Clob),
* new OracleParameter(":OrderType", OracleDbType.Clob),
* new OracleParameter(":strWhere", OracleDbType.Varchar2,1000),
* };
* parameters[0].Value = "TQC_ROLL_COMMUTE";
* parameters[1].Value = "C_ID";
* parameters[2].Value = PageSize;
* parameters[3].Value = PageIndex;
* parameters[4].Value = 0;
* parameters[5].Value = 0;
* parameters[6].Value = strWhere;
* return DbHelperOra.RunProcedure("UP_GetRecordByPage",parameters,"ds");
* }*/
#endregion BasicMethod
#region ExtensionMethod
/// <summary>
/// 获得数据列表
/// </summary>
/// <param name="c_master_id">实绩主键</param>
/// <param name="c_gp_before_id">改判前主键</param>
/// <param name="c_gp_after_id">改判后主键</param>
/// <returns></returns>
public DataSet GetList_Interface_Trans(string c_master_id, string c_gp_before_id, string c_gp_after_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(C_ID)cou,C_STA_ID,C_STOVE,C_BATCH_NO,sum(N_WGT) wgt,C_STL_GRD_BEFORE,C_STD_CODE_BEFORE,C_SPEC_BEFORE,C_MAT_CODE_BEFORE,C_MAT_DESC_BEFORE,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_REMARK,N_STATUS,C_SCUTCHEON ,c_master_id,c_gp_before_id,c_gp_after_id,C_BZYQ_BEFORE,C_BZYQ_AFTER ");
strSql.Append(" FROM TQC_ROLL_COMMUTE where c_master_id='" + c_master_id + "' and c_gp_before_id='" + c_gp_before_id + "' and c_gp_after_id='" + c_gp_after_id + "' ");
strSql.Append(" group by C_STA_ID,C_STOVE,C_BATCH_NO,C_STL_GRD_BEFORE,C_STD_CODE_BEFORE,C_SPEC_BEFORE,C_MAT_CODE_BEFORE,C_MAT_DESC_BEFORE,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_REMARK,N_STATUS,C_SCUTCHEON ,c_master_id,c_gp_before_id,c_gp_after_id,C_BZYQ_BEFORE,C_BZYQ_AFTER");
return(TransactionHelper.Query(strSql.ToString()));
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList_Trans()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_PLAN_ROLL_ID,N_WGT,D_P_START_TIME,D_P_END_TIME,C_STL_GRD,C_STD_CODE,C_SPEC,C_STATE ");
strSql.Append(" FROM TRP_PLAN_SLAB_TIME where C_STATE is null order by D_P_START_TIME asc");
return(TransactionHelper.Query(strSql.ToString()));
}
/// <summary>
/// 更新发运单状态
/// </summary>
/// <param name="dh">发运单号</param>
/// <param name="status">状态</param>
/// <returns></returns>
public int UPFYDSTATUS_Tran(string dh, string status)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE TMD_DISPATCH SET");
strSql.Append(" C_STATUS='" + status + "'");
strSql.Append(" WHERE C_ID ='" + dh + "'");
return(TransactionHelper.ExecuteSql(strSql.ToString()));
}
/// <summary>
/// 根据idstr更新钢坯库存状态
/// </summary>
/// <param name="idstr">库存钢坯id字符串</param>
/// <param name="type">状态</param>
/// <param name="status">要变更的状态</param>
/// <returns></returns>
public int UPSLABSTATUS_Tran(string dh, string status)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE TSC_SLAB_MAIN SET");
strSql.Append(" C_MOVE_TYPE='" + status + "'");
strSql.Append(" WHERE C_FYDH ='" + dh + "' ");
return(TransactionHelper.ExecuteSql(strSql.ToString()));
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList_max_MasterID_Trans()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select max(（substr(C_MASTER_ID,3))) as C_MASTER_ID,max(（substr(C_GP_BEFORE_ID,3))) as C_GP_BEFORE_ID ");
strSql.Append(" FROM TRC_ROLL_PRODCUT where C_MASTER_ID like '%'||to_char(sysdate,'yymmdd')||'%'");
return(TransactionHelper.Query(strSql.ToString()));
}
/// <summary>
/// 获取炉次列表
/// </summary>
/// <param name="c_fk">浇次主键集合</param>
/// <returns></returns>
public DataSet Get_LC_List_Trans()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ta.* from TPP_LGPC_LCLSB_TEST ta inner join tpp_lgpc_lsb_test tb on ta.c_fk=tb.c_id where ta.N_STATUS=1 and tb.C_CCM_CODE<> '5#CC' ");
strSql.Append(" order by tb.d_p_start_time,ta.n_sort ");
return(TransactionHelper.Query(strSql.ToString()));
}
/// <summary>
/// 获取待轧的轧钢计划
/// </summary>
public DataSet Get_Plan_Roll_Trans()
{
StringBuilder strSql = new StringBuilder();
//strSql.Append("select * from TRP_PLAN_ROLL_TEST WHERE N_TYPE=8 and N_STATUS in (0, 1) AND N_ROLL_PROD_WGT<N_WGT and n_mach_wgt<>0 and c_line_code is not null ");
strSql.Append("select * from TRP_PLAN_ROLL_TEST WHERE N_TYPE=8 and N_STATUS in (0, 1) and n_mach_wgt<>0 and c_line_code is not null ");
strSql.Append(" ORDER BY (N_WGT-N_ROLL_PROD_WGT)DESC,C_STL_GRD,C_STD_CODE DESC ");
return(TransactionHelper.Query(strSql.ToString()));
}
/// <summary>
/// 根据发运单号获取中间表数据
/// </summary>
/// <param name="dhstr">发运单号</param>
/// <returns></returns>
public DataSet GetZJBList(string dhstr)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_DISPATCH_ID,C_SEND_STOCK,N_NUM,C_CKDH,N_WGT,N_JZ,C_STOVE,C_BATCH_NO,C_PLAN_ID,C_STL_GRD,C_STD_CODE,C_SPEC,C_PK_NCID,C_MZDATE,N_MWGT,N_PWGT,N_MZTIME,N_PZTIME,C_PZDATE,C_ZLDJ,C_BZYQ");
strSql.Append(" FROM TMD_DISPATCH_SJZJB WHERE 1=1 ");
if (dhstr.Trim() != "")
{
strSql.Append(" AND C_DISPATCH_ID='" + dhstr + "'");
}
return(TransactionHelper.Query(strSql.ToString()));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add_Trans(Mod_TQC_PHYSICS_RESULT_LOG model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TQC_PHYSICS_RESULT_LOG(");
strSql.Append("C_PHYSICS_GROUP_ID,C_PRESENT_SAMPLES_ID,C_CHARACTER_ID,C_CHARACTER_CODE,C_CHARACTER_NAME,C_VALUE,N_STATUS,C_REMARK,C_EMP_ID,N_SPLIT,N_TYPE,C_CHECK_STATE,C_TICK_NO,C_GROUP,C_EDIT_NUM)");
strSql.Append(" values (");
strSql.Append(":C_PHYSICS_GROUP_ID,:C_PRESENT_SAMPLES_ID,:C_CHARACTER_ID,:C_CHARACTER_CODE,:C_CHARACTER_NAME,:C_VALUE,:N_STATUS,:C_REMARK,:C_EMP_ID,:N_SPLIT,:N_TYPE,:C_CHECK_STATE,:C_TICK_NO,:C_GROUP,:C_EDIT_NUM)");
OracleParameter[] parameters =
{
new OracleParameter(":C_PHYSICS_GROUP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PRESENT_SAMPLES_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CHARACTER_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CHARACTER_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CHARACTER_NAME", OracleDbType.Varchar2, 100),
new OracleParameter(":C_VALUE", OracleDbType.Varchar2, 100),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":N_SPLIT", OracleDbType.Decimal, 1),
new OracleParameter(":N_TYPE", OracleDbType.Decimal, 1),
new OracleParameter(":C_CHECK_STATE", OracleDbType.Varchar2, 10),
new OracleParameter(":C_TICK_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_GROUP", OracleDbType.Varchar2, 10),
new OracleParameter(":C_EDIT_NUM", OracleDbType.Varchar2, 10)
};
parameters[0].Value = model.C_PHYSICS_GROUP_ID;
parameters[1].Value = model.C_PRESENT_SAMPLES_ID;
parameters[2].Value = model.C_CHARACTER_ID;
parameters[3].Value = model.C_CHARACTER_CODE;
parameters[4].Value = model.C_CHARACTER_NAME;
parameters[5].Value = model.C_VALUE;
parameters[6].Value = model.N_STATUS;
parameters[7].Value = model.C_REMARK;
parameters[8].Value = model.C_EMP_ID;
parameters[9].Value = model.N_SPLIT;
parameters[10].Value = model.N_TYPE;
parameters[11].Value = model.C_CHECK_STATE;
parameters[12].Value = model.C_TICK_NO;
parameters[13].Value = model.C_GROUP;
parameters[14].Value = model.C_EDIT_NUM;
int rows = TransactionHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add_Mes_Trans(string strSql)
{
int rows = TransactionHelper.ExecuteSql(strSql);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 通过出库单号获得出库单详情数据
/// </summary>
/// <param name="dh">出库单号</param>
/// <returns></returns>
public DataSet GetQTCKXQByDH(string dh)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_QTCKD_NO,C_MAT_CODE,C_MAT_DESC,C_STL_GRD,C_JUDGE_LEV_ZH,N_NUM,N_WGT,C_Z_DW,C_F_DW,C_BATCH_NO,C_SPEC,C_STOVE,C_ZYX1,C_ZYX2,C_BZYQ,C_ZYX4,N_STATUS,C_LINEWH_CODE ");
strSql.Append(" FROM TRC_ROLL_QTCKD_ITEM WHERE N_STATUS=1");
if (dh.Trim() != "")
{
strSql.Append(" AND C_QTCKD_NO ='" + dh + "' ");
}
return(TransactionHelper.Query(strSql.ToString()));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TRC_ROLL_WGD_ITEM model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TRC_ROLL_WGD_ITEM(");
strSql.Append("C_MAIN_ID,C_ROLL_WGD_ID,C_BATCH_NO,N_STATUS,C_STD_CODE,C_STL_GRD,C_SPEC,C_MAT_CODE,C_MAT_DESC,C_SALE_AREA,C_ZYX1,C_ZYX2,C_BZYQ,C_MRSX)");
strSql.Append(" values (");
strSql.Append(":C_MAIN_ID,:C_ROLL_WGD_ID,:C_BATCH_NO,:N_STATUS,:C_STD_CODE,:C_STL_GRD,:C_SPEC,:C_MAT_CODE,:C_MAT_DESC,:C_SALE_AREA,:C_ZYX1,:C_ZYX2,:C_BZYQ,:C_MRSX)");
OracleParameter[] parameters =
{
new OracleParameter(":C_MAIN_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ROLL_WGD_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_BATCH_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 15),
new OracleParameter(":C_STD_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SPEC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_MAT_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_MAT_DESC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SALE_AREA", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ZYX1", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ZYX2", OracleDbType.Varchar2, 100),
new OracleParameter(":C_BZYQ", OracleDbType.Varchar2, 100),
new OracleParameter(":C_MRSX", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_MAIN_ID;
parameters[1].Value = model.C_ROLL_WGD_ID;
parameters[2].Value = model.C_BATCH_NO;
parameters[3].Value = model.N_STATUS;
parameters[4].Value = model.C_STD_CODE;
parameters[5].Value = model.C_STL_GRD;
parameters[6].Value = model.C_SPEC;
parameters[7].Value = model.C_MAT_CODE;
parameters[8].Value = model.C_MAT_DESC;
parameters[9].Value = model.C_SALE_AREA;
parameters[10].Value = model.C_ZYX1;
parameters[11].Value = model.C_ZYX2;
parameters[12].Value = model.C_BZYQ;
parameters[13].Value = model.C_MRSX;
int rows = TransactionHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 根据idstr更新钢坯库存状态
/// </summary>
/// <param name="idstr">库存钢坯id字符串</param>
/// <returns></returns>
public string GPFY(string dh)
{
TransactionHelper.BeginTransaction();
if (UPSLABSTATUS_Tran(dh, "S") == 0)
{
return("变更钢坯状态错误！");
}
if (UPFYDSTATUS_Tran(dh, "8") == 0)
{
return("变更发运单状态错误！");
}
TransactionHelper.Commit();
return("1");
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update_Trans(Mod_TQC_UPDATE_MATERIAL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TQC_UPDATE_MATERIAL set ");
strSql.Append("C_ROLL_PRODUCT_ID=:C_ROLL_PRODUCT_ID,");
strSql.Append("C_TYPE=:C_TYPE,");
strSql.Append("N_STATUS=:N_STATUS,");
strSql.Append("C_REMARK=:C_REMARK,");
strSql.Append("C_EMP_ID=:C_EMP_ID,");
strSql.Append("D_MOD_DT=:D_MOD_DT,");
strSql.Append("N_WGT=:N_WGT,");
strSql.Append("N_WGT_DIFFERENCE=:N_WGT_DIFFERENCE,");
strSql.Append("C_SFHG=:C_SFHG");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ROLL_PRODUCT_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_TYPE", OracleDbType.Varchar2, 100),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":N_WGT", OracleDbType.Decimal, 6),
new OracleParameter(":N_WGT_DIFFERENCE", OracleDbType.Decimal, 6),
new OracleParameter(":C_SFHG", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_ROLL_PRODUCT_ID;
parameters[1].Value = model.C_TYPE;
parameters[2].Value = model.N_STATUS;
parameters[3].Value = model.C_REMARK;
parameters[4].Value = model.C_EMP_ID;
parameters[5].Value = model.D_MOD_DT;
parameters[6].Value = model.N_WGT;
parameters[7].Value = model.N_WGT_DIFFERENCE;
parameters[8].Value = model.C_SFHG;
parameters[9].Value = model.C_ID;
int rows = TransactionHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update_BATCH_NO_Trans(string C_BATCH_NO)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE TQC_UPD_MATERIAL_MAIN T SET T.N_STATUS = 0 WHERE T.C_BATCH_NO='" + C_BATCH_NO + "' AND T.N_STATUS=1 ");
int rows = TransactionHelper.ExecuteSql(strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 修改组批量
/// </summary>
/// <returns></returns>
public int UpdateGroupWgt(string id, decimal wgt)
{
string sql = @"UPDATE TRP_PLAN_COGDOWN TPR
SET TPR.N_GROUP_WGT=TPR.N_GROUP_WGT+:wgt
WHERE TPR.C_ID=:id ";
OracleParameter[] parameters =
{
new OracleParameter(":wgt", OracleDbType.Decimal, 5),
new OracleParameter(":id", OracleDbType.Varchar2, 100),
};
parameters[0].Value = wgt;
parameters[1].Value = id;
return(TransactionHelper.ExecuteSql(sql, parameters));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update_Trans(Mod_TRP_PLAN_SLAB_TIME model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TRP_PLAN_SLAB_TIME set ");
strSql.Append("C_PLAN_ROLL_ID=:C_PLAN_ROLL_ID,");
strSql.Append("N_WGT=:N_WGT,");
strSql.Append("D_P_START_TIME=:D_P_START_TIME,");
strSql.Append("D_P_END_TIME=:D_P_END_TIME,");
strSql.Append("C_STL_GRD=:C_STL_GRD,");
strSql.Append("C_STD_CODE=:C_STD_CODE,");
strSql.Append("C_SPEC=:C_SPEC,");
strSql.Append("C_STATE=:C_STATE");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_PLAN_ROLL_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":N_WGT", OracleDbType.Decimal, 15),
new OracleParameter(":D_P_START_TIME", OracleDbType.Date),
new OracleParameter(":D_P_END_TIME", OracleDbType.Date),
new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STD_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SPEC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STATE", OracleDbType.Varchar2, 10),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_PLAN_ROLL_ID;
parameters[1].Value = model.N_WGT;
parameters[2].Value = model.D_P_START_TIME;
parameters[3].Value = model.D_P_END_TIME;
parameters[4].Value = model.C_STL_GRD;
parameters[5].Value = model.C_STD_CODE;
parameters[6].Value = model.C_SPEC;
parameters[7].Value = model.C_STATE;
parameters[8].Value = model.C_ID;
int rows = TransactionHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add_Trans(Mod_TB_LG_PLAN_LOG model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TB_LG_PLAN_LOG(");
strSql.Append("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)");
strSql.Append(" values (");
strSql.Append(":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)");
OracleParameter[] parameters =
{
new OracleParameter(":C_IP", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STOVE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PLAN_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ORDER_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_MES_PLAN_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_LD_DESC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_LF_DESC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_RH_DESC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CC_DESC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500)
};
parameters[0].Value = model.C_IP;
parameters[1].Value = model.C_STOVE;
parameters[2].Value = model.C_PLAN_ID;
parameters[3].Value = model.C_ORDER_NO;
parameters[4].Value = model.C_MES_PLAN_ID;
parameters[5].Value = model.C_LD_DESC;
parameters[6].Value = model.C_LF_DESC;
parameters[7].Value = model.C_RH_DESC;
parameters[8].Value = model.C_CC_DESC;
parameters[9].Value = model.C_EMP_ID;
parameters[10].Value = model.D_MOD_DT;
parameters[11].Value = model.C_REMARK;
int rows = TransactionHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete_Trans()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from TRP_PLAN_SLAB_TIME ");
int rows = TransactionHelper.ExecuteSql(strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
