/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TRC_ROLL_MAIN_ITEM model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TRC_ROLL_MAIN_ITEM("); strSql.Append("C_ROLL_MAIN_ID,C_SLAB_MAIN_ID)"); strSql.Append(" values ("); strSql.Append(":C_ROLL_MAIN_ID,:C_SLAB_MAIN_ID)"); OracleParameter[] parameters = { new OracleParameter(":C_ROLL_MAIN_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_SLAB_MAIN_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = model.C_ROLL_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 Delete_Trans(string C_PHYSICS_GROUP_ID, string C_PRESENT_SAMPLES_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from TQC_PHYSICS_RESULT "); strSql.Append(" where C_PHYSICS_GROUP_ID=:C_PHYSICS_GROUP_ID and C_PRESENT_SAMPLES_ID=:C_PRESENT_SAMPLES_ID "); OracleParameter[] parameters = { new OracleParameter(":C_PHYSICS_GROUP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_PRESENT_SAMPLES_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_PHYSICS_GROUP_ID; parameters[1].Value = C_PRESENT_SAMPLES_ID; int rows = TransactionHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除连铸计划 /// </summary> /// <param name="smsPlans"></param> public bool DelSms(List <Mod_TSP_PLAN_SMS> smsPlans) { int rows = 0; if (smsPlans != null && smsPlans.Count > 0) { string sql = @"DELETE TSP_PLAN_SMS "; for (int i = 0; i < smsPlans.Count; i++) { if (i == 0) { sql += @" WHERE C_ID='" + smsPlans[i].C_ID + "' "; } else { sql += @" OR C_ID='" + smsPlans[i].C_ID + "' "; } } rows = TransactionHelper.ExecuteSql(sql); } if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 重置顺序 /// </summary> public int CZSORT() { DataTable dt = GetListByStatus(1, "", "").Tables[0]; if (dt.Rows.Count > 0) { int sort = 1; TransactionHelper.BeginTransaction(); foreach (DataRow item in dt.Rows) { string sql = ""; sql = "UPDATE TB_PRO SET N_SORT='" + sort + "' WHERE C_ID='" + item["C_ID"] + "' "; if (TransactionHelper.ExecuteSql(sql) == 1) { sort++; } else { TransactionHelper.RollBack(); return(0); } } } TransactionHelper.Commit(); return(1); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TRC_ROLL_MAIN_CLOSE_LOG model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TRC_ROLL_MAIN_CLOSE_LOG("); strSql.Append("C_ORDER_NO,C_REMARK,C_EMP_ID,C_EMP_NAME,D_MOD_DT)"); strSql.Append(" values ("); strSql.Append(":C_ORDER_NO,:C_REMARK,:C_EMP_ID,:C_EMP_NAME,:D_MOD_DT)"); OracleParameter[] parameters = { new OracleParameter(":C_ORDER_NO", OracleDbType.Varchar2, 100), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500), new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_EMP_NAME", OracleDbType.Varchar2, 100), new OracleParameter(":D_MOD_DT", OracleDbType.Date) }; parameters[0].Value = model.C_ORDER_NO; parameters[1].Value = model.C_REMARK; parameters[2].Value = model.C_EMP_ID; parameters[3].Value = model.C_EMP_NAME; parameters[4].Value = model.D_MOD_DT; int rows = TransactionHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool AddTran(Mod_TRC_ROLL_TIME model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TRC_ROLL_TIME("); strSql.Append("C_STA_ID,C_RQ,N_NUM_GRD,N_NUM_SPEC,C_TIME_SPEC)"); strSql.Append(" values ("); strSql.Append(":C_STA_ID,:C_RQ,:N_NUM_GRD,:N_NUM_SPEC,:C_TIME_SPEC)"); OracleParameter[] parameters = { new OracleParameter(":C_STA_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_RQ", OracleDbType.Varchar2, 100), new OracleParameter(":N_NUM_GRD", OracleDbType.Decimal, 10), new OracleParameter(":N_NUM_SPEC", OracleDbType.Decimal, 10), new OracleParameter(":C_TIME_SPEC", OracleDbType.Varchar2, 100) }; parameters[0].Value = model.C_STA_ID; parameters[1].Value = model.C_RQ; parameters[2].Value = model.N_NUM_GRD; parameters[3].Value = model.N_NUM_SPEC; parameters[4].Value = model.C_TIME_SPEC; 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> /// <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> /// <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 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> 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> /// 更新一条数据 /// </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> /// <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_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> 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 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 update_Trans(string c_std_code, string c_stl_grd, string c_spec_min, string c_spec_max) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TQB_SAMP_MODLE_JSZX t set t.n_status=0 where t.c_std_code='" + c_std_code + "' and t.c_stl_grd='" + c_stl_grd + "' and nvl(t.c_spec_min,' ')=nvl('" + c_spec_min + "',' ') and nvl(t.c_spec_max,' ')=nvl('" + c_spec_max + "',' ') "); int rows = TransactionHelper.ExecuteSql(strSql.ToString()); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update_CF_Trans(string APPID, string SAMPLE_CODE, string HEATID) { StringBuilder strSql = new StringBuilder(); strSql.Append("UPDATE CQA_LAB_ELEMENT@cap_mes T SET T.FINALJUDGEFLAG='1' WHERE UNITTYPEID='6' and APPID='" + APPID + "' and SAMPLE_CODE='" + SAMPLE_CODE + "' and HEATID='" + HEATID + "' "); int rows = TransactionHelper.ExecuteSql(strSql.ToString()); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update_LGJH_Trans(string strLGJH, string stove) { StringBuilder strSql = new StringBuilder(); strSql.Append("update CBLOOM_DATA@cap_mes set FINAL_STEELGRADEINDEX='" + strLGJH + "',STATUS='9' WHERE MATERIALID='" + stove + "' "); int rows = TransactionHelper.ExecuteSql(strSql.ToString()); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete_MES_ZP_Trans(string stove) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from CQA_BLOOM_FINJUDGE_DATA@cap_mes where HEATID='" + stove + "' "); int rows = TransactionHelper.ExecuteSql(strSql.ToString()); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Delete_Trans() { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from TPP_LGPC_LSB_TEST t where t.c_id not in(select ta.c_fk from Tpp_Lgpc_Lclsb_Test ta where ta.c_fk is not null) and t.c_ccm_code<>'5#CC' "); int rows = TransactionHelper.ExecuteSql(strSql.ToString()); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update_PD_Trans(string c_batch_no) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tqc_physics_result_main t set t.c_is_pd='1' where t.c_batch_no='" + c_batch_no + "' "); int rows = TransactionHelper.ExecuteSql(strSql.ToString()); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(string id) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from TRC_ROLL_MAIN_ITEM "); strSql.Append(" where C_ROLL_MAIN_ID='" + id + "'"); int rows = TransactionHelper.ExecuteSql(strSql.ToString()); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新可用量 /// </summary> public bool Update_Trans() { StringBuilder strSql = new StringBuilder(); strSql.Append("UPDATE TSP_PLAN_SMS_TEST T SET T.N_USE_WGT=round(T.N_SLAB_WGT),t.C_ORDER_NO='' where T.N_STATUS = 1 AND T.N_SLAB_WGT>0 "); int rows = TransactionHelper.ExecuteSql(strSql.ToString()); 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); } }
/// <summary> /// 批量删除数据 /// </summary> public bool Delete_Trans(string C_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from TSP_PLAN_SMS_TEST "); strSql.Append(" where C_ID ='" + C_ID + "' "); int rows = TransactionHelper.ExecuteSql(strSql.ToString()); if (rows > 0) { return(true); } else { return(false); } }