/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TB_STD_CONFIG GetModel_Interface_Trans(string C_STD_CODE, string C_STL_GRD) { 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_STD_CODE=:C_STD_CODE and C_STL_GRD=:C_STL_GRD "); OracleParameter[] parameters = { new OracleParameter(":C_STD_CODE", OracleDbType.Varchar2, 100), new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_STD_CODE; parameters[1].Value = C_STL_GRD; Mod_TB_STD_CONFIG model = new Mod_TB_STD_CONFIG(); DataSet ds = TransactionHelper.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_ROLL_COMMUTE GetModel_Interface_Trans(string C_MASTER_ID, string C_GP_BEFORE_ID, string C_GP_AFTER_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select C_ID,C_ROLL_ID,C_STA_ID,C_STA_DESC,C_STOVE,C_BATCH_NO,C_TICK_NO,N_WGT,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_GP_TYPE,C_SCUTCHEON,N_STATUS,C_REMARK,C_EMP_ID,D_MOD_DT,C_MASTER_ID,C_GP_BEFORE_ID,C_GP_AFTER_ID,C_ZYX1_BEFORE,C_ZYX2_BEFORE,C_ZYX1_AFTER,C_ZYX2_AFTER,C_JUDGE_LEV_BP_BEFORE,C_JUDGE_LEV_BP_AFTER,C_BZYQ_BEFORE,C_BZYQ_AFTER,C_COMMUTE_REASON from TQC_ROLL_COMMUTE "); strSql.Append(" where C_MASTER_ID=:C_MASTER_ID "); strSql.Append(" and C_GP_BEFORE_ID=:C_GP_BEFORE_ID "); strSql.Append(" and C_GP_AFTER_ID=:C_GP_AFTER_ID "); OracleParameter[] parameters = { new OracleParameter(":C_MASTER_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_GP_BEFORE_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_GP_AFTER_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_MASTER_ID; parameters[1].Value = C_GP_BEFORE_ID; parameters[2].Value = C_GP_AFTER_ID; Mod_TQC_ROLL_COMMUTE model = new Mod_TQC_ROLL_COMMUTE(); DataSet ds = TransactionHelper.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_CHECKSTATE_NAME">判定等级名称</param> /// <returns></returns> public Mod_TQB_CHECKSTATE GetModelByName_Trans(string C_CHECKSTATE_NAME, string C_REMARK) { StringBuilder strSql = new StringBuilder(); strSql.Append("select C_ID,C_CHECKSTATE_CODE,C_CHECKSTATE_NAME,C_CHECKSTATE_TYPE,N_STATUS,C_REMARK,C_EMP_ID,D_MOD_DT from TQB_CHECKSTATE "); strSql.Append(" where C_CHECKSTATE_NAME=:C_CHECKSTATE_NAME AND C_REMARK=:C_REMARK "); OracleParameter[] parameters = { new OracleParameter(":C_CHECKSTATE_NAME", OracleDbType.Varchar2, 100), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_CHECKSTATE_NAME; parameters[1].Value = C_REMARK; Mod_TQB_CHECKSTATE model = new Mod_TQB_CHECKSTATE(); DataSet ds = TransactionHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <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_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> 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(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_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> 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> 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> /// <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 DataSet Get_Slab_List_Trans(string C_STL_GRD, string C_STD_CODE) { StringBuilder strSql = new StringBuilder(); strSql.Append("select T.C_ID,T.C_ORDER_NO,T.C_DESIGN_NO,T.N_SLAB_WGT,T.C_CTRL_NO,T.C_CCM_ID,T.C_CCM_DESC,T.C_PROD_NAME,T.C_STL_GRD,T.C_SPEC_CODE,T.C_LENGTH,T.C_MATRL_NO,T.C_MATRL_NAME,T.C_SLAB_SIZE,T.C_SLAB_LENGTH,T.C_STATE,T.C_STD_CODE,T.C_INITIALIZE_ITEM_ID,T.D_P_START_TIME,T.D_P_END_TIME,T.N_PROD_TIME,T.N_SORT,T.C_CAST_NO,T.N_STATUS,T.C_EMP_ID,T.D_MOD_DT,T.C_REMARK,T.N_CREAT_PLAN,T.N_CREAT_ZG_PLAN,T.N_PRODUCE_TIME,T.C_ZL_ID,T.C_LF_ID,T.C_RH_ID,T.C_LGJH,T.C_QUA,T.D_ARRIVE_ZG_TIME,T.C_BY1,T.C_BY2,T.C_BY3,T.C_RH,T.C_DFP_HL,T.C_HL,T.C_XM,T.D_DFPHL_START_TIME,T.D_DFPHL_END_TIME,T.D_KP_START_TIME,T.D_KP_END_TIME,T.D_HL_START_TIME,T.D_HL_END_TIME,T.D_PLAN_KY_TIME,T.C_PLAN_ROLL,T.D_ZZ_START_TIME,T.D_ZZ_END_TIME,T.D_XM_START_TIME,T.D_XM_END_TIME,T.C_STOVE_NO,T.D_DFPHL_START_TIME_SJ,T.D_DFPHL_END_TIME_SJ,T.D_KP_START_TIME_SJ,T.D_KP_END_TIME_SJ,T.D_HL_START_TIME_SJ,T.D_HL_END_TIME_SJ,T.D_XM_START_TIME_SJ,T.D_XM_END_TIME_SJ,T.N_SJ_WGT,T.D_START_TIME_SJ,T.D_END_TIME_SJ,T.N_DFP_HL_TIME,T.N_HL_TIME,T.C_ROUTE,T.N_SLAB_PW,T.C_MATRL_CODE_KP,T.C_MATRL_NAME_KP,T.C_KP_SIZE,T.N_KP_LENGTH,T.N_KP_PW,T.N_USE_WGT,T.D_USE_START_TIME_SJ,T.D_USE_END_TIME_SJ,T.D_CAN_USE_TIME,T.N_RH_NUM,T.N_KP_WGT,T.N_XM_WGT,T.C_DFP_RZ,T.C_RZP_RZ,T.C_DFP_YQ,T.C_RZP_YQ,T.C_STL_GRD_TYPE,T.C_PROD_KIND,T.C_TL,T.N_JSCN,T.C_FREE1,T.C_FREE2,T.N_GROUP,T.C_FK,T.N_ZJCLS,T.N_ZJCLS_MIN,T.N_ZJCLS_MAX,T.C_SL,T.C_WL,T.C_SLAB_TYPE,T.N_JC_SORT from TSP_PLAN_SMS_TEST T WHERE t.N_STATUS=1 and T.N_USE_WGT > 0 "); if (!string.IsNullOrEmpty(C_STL_GRD)) { strSql.Append(" AND T.C_STL_GRD='" + C_STL_GRD + "' "); } if (!string.IsNullOrEmpty(C_STD_CODE)) { strSql.Append(" AND T.C_STD_CODE='" + C_STD_CODE + "' "); } return(TransactionHelper.Query(strSql.ToString())); }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TRP_PLAN_SLAB_TIME GetModel_BySpec_Trans(string c_spec, string d_p_end_time) { 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 from ( select * from trp_plan_slab_time t where t.C_STATE is null and t.c_spec='" + c_spec + "' and t.d_p_start_time<to_date('" + d_p_end_time + "','yyyy-mm-dd hh24:mi:ss') order by t.d_p_start_time asc)where rownum=1 "); Mod_TRP_PLAN_SLAB_TIME model = new Mod_TRP_PLAN_SLAB_TIME(); DataSet ds = TransactionHelper.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TRP_PLAN_SLAB_TIME GetModel_Trans(string C_ID) { 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 from TRP_PLAN_SLAB_TIME where C_STATE is null and C_ID='" + C_ID + "' "); Mod_TRP_PLAN_SLAB_TIME model = new Mod_TRP_PLAN_SLAB_TIME(); DataSet ds = TransactionHelper.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public bool Update_OrderSort() { // return true; string sql1 = "SELECT T.C_CCM_ID FROM TPP_LGPC_LSB T "; DataTable dtOrder = TransactionHelper.Query(sql1).Tables[0]; if (dtOrder.Rows.Count > 0) { for (int i = 0; i < dtOrder.Rows.Count; i++) { string sql2 = "SELECT ROWNUM RNO, T.C_ID, T.C_CCM_ID, T.C_CCM_CODE, T.N_GROUP, T.N_TOTAL_WGT, T.N_ZJCLS, T.N_ZJCLZL, T.N_MLZL, T.N_SORT, T.C_STL_GRD, T.N_PRODUCE_TIME, T.N_ORDER_LS, T.N_JSCN, T.C_BY1, T.C_BY2, T.C_BY3,C_RH,C_DFP_HL,C_HL,C_XM FROM TPP_LGPC_LSB T WHERE T.C_CCM_ID = '" + dtOrder.Rows[i]["C_CCM_ID"].ToString() + "' "; DataTable dtByCCM = TransactionHelper.Query(sql2).Tables[0]; DataTable dtByCCM2 = dtByCCM.Copy(); dtByCCM2.Clear(); for (int j = 0; j < dtByCCM.Rows.Count; j++) { dtByCCM2.Rows.Add(dtByCCM.Rows[j].ItemArray); } dtByCCM2.DefaultView.Sort = " "; //将选中的订单按照排产目标进行排序 dtByCCM2 = dtByCCM2.DefaultView.ToTable(); //获取的需要初始化的表 DataRow[] dr = dtByCCM2.Select(" C_BY3='酱色' "); if (dr.Length > 0) { for (int l = 0; l < dr.Length; l++) { if (dtByCCM2.Rows.Count > l * 4) { } } } //int jcs = 0; //for (int k = 0; k < dtByCCM2.Rows.Count; k ++) //{ //} } } return(true); }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TS_USER GetModel_Interface_Trans(string C_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select C_ID,C_NAME,C_ACCOUNT,C_PASSWORD,C_EMAIL,C_MOBILE,N_TYPE,N_STATUS,C_DESC,D_LASTLOGINTIME,C_EMP_ID,C_EMP_NAME,D_MOD_DT,C_MOBILE2,C_PHONE,C_SHORTNAME,C_CUST_ID,C_TOKEN_ID,C_CJNAME,C_CJINTRO,C_STL_GRD,C_LEGALREPRES,C_CGJCR,C_JOB,C_JCTEL,C_ADDRESS,C_AREA,C_MANAGER from TS_USER "); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_ID; Mod_TS_USER model = new Mod_TS_USER(); DataSet ds = TransactionHelper.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_PRESENT_SAMPLES_JSZX GetModel_Trans(string C_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select C_ID,C_BATCH_NO,C_TICK_NO,C_STL_GRD,C_SPEC,N_ENTRUST_TYPE,N_STATUS,C_REMARK,C_EMP_ID_SY,D_MOD_DT_SY,C_EMP_ID_JS,D_MOD_DT_JS,C_EMP_ID_ZY,D_MOD_DT_ZY,C_EQ_NAME,C_EQ_NUMBER,C_EQ_CODE,N_SAMPLES_NUM,D_MOD_DT from TQC_PRESENT_SAMPLES_JSZX "); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_ID; Mod_TQC_PRESENT_SAMPLES_JSZX model = new Mod_TQC_PRESENT_SAMPLES_JSZX(); DataSet ds = TransactionHelper.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_LINEWH GetModel_Interface_Trans(string C_LINEWH_CODE) { StringBuilder strSql = new StringBuilder(); strSql.Append("select C_ID,C_LINEWH_CODE,C_LINEWH_NAME,N_STATUS,C_EMP_ID,D_MOD_DT,C_REMARK,D_START_DATE,D_END_DATE,C_NC_CODE,C_RF_CODE,C_NC_PK from TPB_LINEWH "); strSql.Append(" where C_LINEWH_CODE=:C_LINEWH_CODE "); OracleParameter[] parameters = { new OracleParameter(":C_LINEWH_CODE", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_LINEWH_CODE; Mod_TPB_LINEWH model = new Mod_TPB_LINEWH(); DataSet ds = TransactionHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 发送发运单到中间表 /// </summary> /// <param name="fydid">要发送的发运单号</param> /// <returns>返回int类型 1转入成功-1发送失败</returns> public string ADDFYDToZJB(string fydid, DateTime dateTime) { TransactionHelper.BeginTransaction(); #region MyRegion string rjhsql = "SELECT C_PLAN_ID,C_ID,C_MAT_CODE,C_STD_CODE,C_SEND_STOCK_CODE,c_Judge_Lev_Zh,C_PACK,N_FYZS FROM TMD_DISPATCHDETAILS WHERE C_DISPATCH_ID='" + fydid + "'"; DataTable plandt = TransactionHelper.Query(rjhsql).Tables[0]; if (plandt.Rows.Count < 1) { TransactionHelper.RollBack(); return("未查询到发运单子表数据!"); } foreach (DataRow planrow in plandt.Rows) { int plannum = Convert.ToInt32(planrow["N_FYZS"]); #region 获取出库单 string no = RV.UI.ServerTime.timeNow().Year.ToString() + (Convert.ToInt32(RV.UI.ServerTime.timeNow().Month) > 9 ? RV.UI.ServerTime.timeNow().Month.ToString() : ("0" + RV.UI.ServerTime.timeNow().Month.ToString())) + (Convert.ToInt32(RV.UI.ServerTime.timeNow().Day) > 9 ? RV.UI.ServerTime.timeNow().Day.ToString() : ("0" + RV.UI.ServerTime.timeNow().Day.ToString())); //转库单号 string maxckd = GetCKDNO(no); //查询当天最大转库单 if (maxckd == "0") { no = no + "0001"; } else { no = (Convert.ToInt64(maxckd.Substring(2, maxckd.Length - 2)) + 1).ToString(); } no = "GP" + no; #endregion #region 获取线材实绩 DataTable dt1 = GetListByidstr(fydid, planrow["C_MAT_CODE"].ToString(), planrow["C_STD_CODE"].ToString(), planrow["C_SEND_STOCK_CODE"].ToString(), planrow["c_Judge_Lev_Zh"].ToString(), "1").Tables[0];//要传输的发运单数据 if (dt1.Rows.Count < 1) { TransactionHelper.RollBack(); return("根据发运单子表查询线材实绩错误!"); } int fpnum = 0; string idstr = ""; foreach (DataRow xqitem in dt1.Rows) { if (plannum == fpnum) { break; } idstr += "'" + xqitem["C_ID"] + "',"; fpnum++; } idstr = idstr.Substring(0, idstr.Length - 1); #region 变更线材实绩 if (BJBynum(plannum, fydid) == 0) { TransactionHelper.RollBack(); return("根据发运单子表变更线材实绩错误!"); } #endregion DataTable sjdt = GetListByidstr(idstr).Tables[0];//要传输的发运单数据 foreach (DataRow item1 in sjdt.Rows) { #region 添加中间表 string sql = ""; sql += "insert into TMD_DISPATCH_SJZJB(C_DISPATCH_ID,N_NUM,N_STATUS,C_CKDH,N_JZ,C_SEND_STOCK,C_STOVE,C_BATCH_NO,C_PLAN_ID,C_STL_GRD,C_STD_CODE,C_SPEC,C_PK_NCID,C_ZLDJ,C_BZYQ,D_CKSJ,C_MAT_CODE,C_MAT_NAME,C_TICK_STR) values('" + fydid + "','" + item1["N_NUM"] + "','8','" + no + "','" + item1["N_WGT"] + "','" + item1["C_SLABWH_CODE"] + "','" + item1["C_STOVE"] + "','" + item1["C_BATCH_NO"] + "','" + planrow["C_PLAN_ID"].ToString() + "','" + item1["C_STL_GRD"] + "','" + item1["C_STD_CODE"] + "','" + item1["C_SPEC"] + "','" + planrow["C_ID"].ToString() + "','" + item1["C_JUDGE_LEV_ZH"].ToString() + "','',to_date('" + dateTime + "', 'yyyy-mm-dd hh24:mi:ss'),'" + item1["C_MAT_CODE"].ToString() + "','" + item1["C_MAT_NAME"].ToString() + "','')"; if (TransactionHelper.ExecuteSql(sql) == 0) { TransactionHelper.RollBack(); return("条件发运单中间表错误!"); } #endregion } #endregion } #endregion TransactionHelper.Commit(); return("1"); }