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