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