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