/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from TQ_MODULE ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2)
};
parameters[0].Value = C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(string C_CON_NO)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from TMO_CONRULES ");
strSql.Append(" where C_CON_NO=:C_CON_NO ");
OracleParameter[] parameters =
{
new OracleParameter(":C_CON_NO", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_CON_NO;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TQB_DESIGN model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TQB_DESIGN(");
strSql.Append("C_ID,C_DESIGN_NO,C_STD_MAIN_ID,N_STATUS,C_REMARK,C_EMP_ID,D_MOD_DT)");
strSql.Append(" values (");
strSql.Append(":C_ID,:C_DESIGN_NO,:C_STD_MAIN_ID,:N_STATUS,:C_REMARK,:C_EMP_ID,:D_MOD_DT)");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_DESIGN_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STD_MAIN_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 20),
new OracleParameter(":D_MOD_DT", OracleDbType.Date)
};
parameters[0].Value = model.C_ID;
parameters[1].Value = model.C_DESIGN_NO;
parameters[2].Value = model.C_STD_MAIN_ID;
parameters[3].Value = model.N_STATUS;
parameters[4].Value = model.C_REMARK;
parameters[5].Value = model.C_EMP_ID;
parameters[6].Value = model.D_MOD_DT;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TMC_QUESTION_DEPT model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TMC_QUESTION_DEPT(");
strSql.Append("C_ID,C_QUESTION_ID,C_DEPT_ID,C_REMARK,C_EMP_ID,C_EMP_NAME,D_MOD_DT)");
strSql.Append(" values (");
strSql.Append(":C_ID,:C_QUESTION_ID,:C_DEPT_ID,:C_REMARK,:C_EMP_ID,:C_EMP_NAME,:D_MOD_DT)");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_QUESTION_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_DEPT_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 200),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_NAME", OracleDbType.Varchar2, 20),
new OracleParameter(":D_MOD_DT", OracleDbType.Date)
};
parameters[0].Value = model.C_ID;
parameters[1].Value = model.C_QUESTION_ID;
parameters[2].Value = model.C_DEPT_ID;
parameters[3].Value = model.C_REMARK;
parameters[4].Value = model.C_EMP_ID;
parameters[5].Value = model.C_EMP_NAME;
parameters[6].Value = model.D_MOD_DT;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TQB_REMARKPRINT model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TQB_PRINT_REMARK set ");
strSql.Append("C_KEY=:C_KEY,");
strSql.Append("C_VALUE=:C_VALUE,");
strSql.Append("N_TYPE=:N_TYPE,");
strSql.Append("C_EMP_ID=:C_EMP_ID,");
strSql.Append("D_MOD_DT=:D_MOD_DT");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_KEY", OracleDbType.Varchar2, 200),
new OracleParameter(":C_VALUE", OracleDbType.Varchar2, 500),
new OracleParameter(":N_TYPE", OracleDbType.Decimal, 1),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 20),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_KEY;
parameters[1].Value = model.C_VALUE;
parameters[2].Value = model.N_TYPE;
parameters[3].Value = model.C_EMP_ID;
parameters[4].Value = model.D_MOD_DT;
parameters[5].Value = model.C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TQB_REMARKPRINT model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TQB_PRINT_REMARK(");
strSql.Append("C_ID,C_KEY,C_VALUE,N_STATUS,N_TYPE,C_EMP_ID,D_MOD_DT)");
strSql.Append(" values (");
strSql.Append(":C_ID,:C_KEY,:C_VALUE,:N_STATUS,:N_TYPE,:C_EMP_ID,:D_MOD_DT)");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_KEY", OracleDbType.Varchar2, 200),
new OracleParameter(":C_VALUE", OracleDbType.Varchar2, 500),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1),
new OracleParameter(":N_TYPE", OracleDbType.Decimal, 1),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 20),
new OracleParameter(":D_MOD_DT", OracleDbType.Date)
};
parameters[0].Value = model.C_ID;
parameters[1].Value = model.C_KEY;
parameters[2].Value = model.C_VALUE;
parameters[3].Value = model.N_STATUS;
parameters[4].Value = model.N_TYPE;
parameters[5].Value = model.C_EMP_ID;
parameters[6].Value = model.D_MOD_DT;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool UpdateProc(Mod_TMB_PROC mod)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TMB_PROC SET C_STLGRD=:C_STLGRD,C_SPEC=:C_SPEC,C_STDCODE=:C_STDCODE,C_DESC=:C_DESC,C_REMARK=:C_REMARK,C_PROCTYPE=:C_PROCTYPE,C_IMGURL=:C_IMGURL WHERE C_ID=:C_ID");
OracleParameter[] parameters =
{
new OracleParameter(":C_STLGRD", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SPEC", OracleDbType.Varchar2, 500),
new OracleParameter(":C_STDCODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_DESC", OracleDbType.Varchar2, 200),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500),
new OracleParameter(":C_PROCTYPE", OracleDbType.NVarchar2, 1000),
new OracleParameter(":C_IMGURL", OracleDbType.Varchar2, 200),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = mod.C_STLGRD;
parameters[1].Value = mod.C_SPEC;
parameters[2].Value = mod.C_STDCODE;
parameters[3].Value = mod.C_DESC;
parameters[4].Value = mod.C_REMARK;
parameters[5].Value = mod.C_PROCTYPE;
parameters[6].Value = mod.C_IMGURL;
parameters[7].Value = mod.C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TB_BCBZ model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TB_BCBZ(");
strSql.Append("D_START,D_END,C_BC,C_BZ,C_EMP_ID,D_MOD_DT,C_PRO_ID)");
strSql.Append(" values (");
strSql.Append(":D_START,:D_END,:C_BC,:C_BZ,:C_EMP_ID,:D_MOD_DT,:C_PRO_ID)");
OracleParameter[] parameters =
{
new OracleParameter(":D_START", OracleDbType.Date),
new OracleParameter(":D_END", OracleDbType.Date),
new OracleParameter(":C_BC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_BZ", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":C_PRO_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.D_START;
parameters[1].Value = model.D_END;
parameters[2].Value = model.C_BC;
parameters[3].Value = model.C_BZ;
parameters[4].Value = model.C_EMP_ID;
parameters[5].Value = model.D_MOD_DT;
parameters[6].Value = model.C_PRO_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TSC_SLAB_MAIN_LOG model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TSC_SLAB_MAIN_LOG(");
strSql.Append("C_MAIN_ID,C_CKDH,N_STATUS,D_DATE,C_BC,C_BZ,C_EMP_ID)");
strSql.Append(" values (");
strSql.Append(":C_MAIN_ID,:C_CKDH,:N_STATUS,:D_DATE,:C_BC,:C_BZ,:C_EMP_ID)");
OracleParameter[] parameters =
{
new OracleParameter(":C_MAIN_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CKDH", OracleDbType.Varchar2, 100),
new OracleParameter(":N_STATUS", OracleDbType.Int16, 1),
new OracleParameter(":D_DATE", OracleDbType.Date),
new OracleParameter(":C_BC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_BZ", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_MAIN_ID;
parameters[1].Value = model.C_CKDH;
parameters[2].Value = model.N_STATUS;
parameters[3].Value = model.D_DATE;
parameters[4].Value = model.C_BC;
parameters[5].Value = model.C_BZ;
parameters[6].Value = model.C_EMP_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TMP_DAYPLAN model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TMP_DAYPLAN set ");
strSql.Append("C_PLCODE=:C_PLCODE,");
strSql.Append("C_PKBILLB=:C_PKBILLB,");
strSql.Append("C_PKBILLH=:C_PKBILLH,");
strSql.Append("C_CONNO=:C_CONNO,");
strSql.Append("C_ORDERNO=:C_ORDERNO,");
strSql.Append("C_PKINV=:C_PKINV,");
strSql.Append("C_PKASSISTMEASURE=:C_PKASSISTMEASURE,");
strSql.Append("N_ASSISTNUM=:N_ASSISTNUM,");
strSql.Append("N_NUM=:N_NUM,");
strSql.Append("N_UNITPRICE=:N_UNITPRICE,");
strSql.Append("N_MONEY=:N_MONEY,");
strSql.Append("D_PLANDATE=:D_PLANDATE,");
strSql.Append("D_ORDSNDATE=:D_ORDSNDATE,");
strSql.Append("D_REQUIREDATE=:D_REQUIREDATE,");
strSql.Append("D_SNDDATE=:D_SNDDATE,");
strSql.Append("C_PKCUST=:C_PKCUST,");
strSql.Append("C_PKSENDTYPE=:C_PKSENDTYPE,");
strSql.Append("C_PKSALECORP=:C_PKSALECORP,");
strSql.Append("C_PKSALEORG=:C_PKSALEORG,");
strSql.Append("C_PKSENDSTOREORG=:C_PKSENDSTOREORG,");
strSql.Append("C_PKOPERATOR=:C_PKOPERATOR,");
strSql.Append("C_PKOPRDEPART=:C_PKOPRDEPART,");
strSql.Append("C_PKPLANPERSON=:C_PKPLANPERSON,");
strSql.Append("C_PKAPPRPERSON=:C_PKAPPRPERSON,");
strSql.Append("D_APPRDATE=:D_APPRDATE,");
strSql.Append("C_PKARRIVEAREA=:C_PKARRIVEAREA,");
strSql.Append("C_DESTADDRESS=:C_DESTADDRESS,");
strSql.Append("C_RECEIPTCORPID=:C_RECEIPTCORPID,");
strSql.Append("C_BIZTYPE=:C_BIZTYPE,");
strSql.Append("C_REMARK=:C_REMARK,");
strSql.Append("C_PKSENDAREA=:C_PKSENDAREA,");
strSql.Append("C_PKDELIVORG=:C_PKDELIVORG,");
strSql.Append("C_UNITID=:C_UNITID,");
strSql.Append("C_VFREE1=:C_VFREE1,");
strSql.Append("C_VFREE2=:C_VFREE2,");
strSql.Append("C_VFREE3=:C_VFREE3,");
strSql.Append("C_VFREE4=:C_VFREE4");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_PLCODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PKBILLB", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PKBILLH", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CONNO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ORDERNO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PKINV", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PKASSISTMEASURE", OracleDbType.Varchar2, 100),
new OracleParameter(":N_ASSISTNUM", OracleDbType.Decimal, 15),
new OracleParameter(":N_NUM", OracleDbType.Decimal, 15),
new OracleParameter(":N_UNITPRICE", OracleDbType.Decimal, 15),
new OracleParameter(":N_MONEY", OracleDbType.Decimal, 15),
new OracleParameter(":D_PLANDATE", OracleDbType.Date),
new OracleParameter(":D_ORDSNDATE", OracleDbType.Date),
new OracleParameter(":D_REQUIREDATE", OracleDbType.Date),
new OracleParameter(":D_SNDDATE", OracleDbType.Date),
new OracleParameter(":C_PKCUST", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PKSENDTYPE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PKSALECORP", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PKSALEORG", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PKSENDSTOREORG", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PKOPERATOR", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PKOPRDEPART", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PKPLANPERSON", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PKAPPRPERSON", OracleDbType.Varchar2, 100),
new OracleParameter(":D_APPRDATE", OracleDbType.Date),
new OracleParameter(":C_PKARRIVEAREA", OracleDbType.Varchar2, 100),
new OracleParameter(":C_DESTADDRESS", OracleDbType.Varchar2, 100),
new OracleParameter(":C_RECEIPTCORPID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_BIZTYPE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500),
new OracleParameter(":C_PKSENDAREA", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PKDELIVORG", OracleDbType.Varchar2, 100),
new OracleParameter(":C_UNITID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_VFREE1", OracleDbType.Varchar2, 200),
new OracleParameter(":C_VFREE2", OracleDbType.Varchar2, 200),
new OracleParameter(":C_VFREE3", OracleDbType.Varchar2, 200),
new OracleParameter(":C_VFREE4", OracleDbType.Varchar2, 200),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_PLCODE;
parameters[1].Value = model.C_PKBILLB;
parameters[2].Value = model.C_PKBILLH;
parameters[3].Value = model.C_CONNO;
parameters[4].Value = model.C_ORDERNO;
parameters[5].Value = model.C_PKINV;
parameters[6].Value = model.C_PKASSISTMEASURE;
parameters[7].Value = model.N_ASSISTNUM;
parameters[8].Value = model.N_NUM;
parameters[9].Value = model.N_UNITPRICE;
parameters[10].Value = model.N_MONEY;
parameters[11].Value = model.D_PLANDATE;
parameters[12].Value = model.D_ORDSNDATE;
parameters[13].Value = model.D_REQUIREDATE;
parameters[14].Value = model.D_SNDDATE;
parameters[15].Value = model.C_PKCUST;
parameters[16].Value = model.C_PKSENDTYPE;
parameters[17].Value = model.C_PKSALECORP;
parameters[18].Value = model.C_PKSALEORG;
parameters[19].Value = model.C_PKSENDSTOREORG;
parameters[20].Value = model.C_PKOPERATOR;
parameters[21].Value = model.C_PKOPRDEPART;
parameters[22].Value = model.C_PKPLANPERSON;
parameters[23].Value = model.C_PKAPPRPERSON;
parameters[24].Value = model.D_APPRDATE;
parameters[25].Value = model.C_PKARRIVEAREA;
parameters[26].Value = model.C_DESTADDRESS;
parameters[27].Value = model.C_RECEIPTCORPID;
parameters[28].Value = model.C_BIZTYPE;
parameters[29].Value = model.C_REMARK;
parameters[30].Value = model.C_PKSENDAREA;
parameters[31].Value = model.C_PKDELIVORG;
parameters[32].Value = model.C_UNITID;
parameters[33].Value = model.C_VFREE1;
parameters[34].Value = model.C_VFREE2;
parameters[35].Value = model.C_VFREE3;
parameters[36].Value = model.C_VFREE4;
parameters[37].Value = model.C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TMC_TECH_CONSULT_RESULT model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TMC_TECH_CONSULT_RESULT set ");
strSql.Append("C_TECH_CONSULT_ID=:C_TECH_CONSULT_ID,");
strSql.Append("C_DEPT=:C_DEPT,");
strSql.Append("C_EMP_ID=:C_EMP_ID,");
strSql.Append("D_PLAN_DT=:D_PLAN_DT,");
strSql.Append("D_FINISH_DT=:D_FINISH_DT,");
strSql.Append("C_REAL_TIME=:C_REAL_TIME,");
strSql.Append("C_RESULT=:C_RESULT,");
strSql.Append("C_LEAVE_Q=:C_LEAVE_Q,");
strSql.Append("C_REMARK=:C_REMARK,");
strSql.Append("N_CUST_EVAL=:N_CUST_EVAL,");
strSql.Append("D_CUST_EVAL_DT=:D_CUST_EVAL_DT,");
strSql.Append("N_XG_EVAL=:N_XG_EVAL,");
strSql.Append("C_XG_EVAL_EMP=:C_XG_EVAL_EMP,");
strSql.Append("D_XG_EVAL_DT=:D_XG_EVAL_DT");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_TECH_CONSULT_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_DEPT", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":D_PLAN_DT", OracleDbType.Date),
new OracleParameter(":D_FINISH_DT", OracleDbType.Date),
new OracleParameter(":C_REAL_TIME", OracleDbType.Varchar2, 300),
new OracleParameter(":C_RESULT", OracleDbType.Varchar2, 300),
new OracleParameter(":C_LEAVE_Q", OracleDbType.Varchar2, 300),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 300),
new OracleParameter(":N_CUST_EVAL", OracleDbType.Decimal, 2),
new OracleParameter(":D_CUST_EVAL_DT", OracleDbType.Date),
new OracleParameter(":N_XG_EVAL", OracleDbType.Decimal, 2),
new OracleParameter(":C_XG_EVAL_EMP", OracleDbType.Varchar2, 100),
new OracleParameter(":D_XG_EVAL_DT", OracleDbType.Date),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_TECH_CONSULT_ID;
parameters[1].Value = model.C_DEPT;
parameters[2].Value = model.C_EMP_ID;
parameters[3].Value = model.D_PLAN_DT;
parameters[4].Value = model.D_FINISH_DT;
parameters[5].Value = model.C_REAL_TIME;
parameters[6].Value = model.C_RESULT;
parameters[7].Value = model.C_LEAVE_Q;
parameters[8].Value = model.C_REMARK;
parameters[9].Value = model.N_CUST_EVAL;
parameters[10].Value = model.D_CUST_EVAL_DT;
parameters[11].Value = model.N_XG_EVAL;
parameters[12].Value = model.C_XG_EVAL_EMP;
parameters[13].Value = model.D_XG_EVAL_DT;
parameters[14].Value = model.C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TMB_XG model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TMB_XG set ");
strSql.Append("C_NAME=:C_NAME,");
strSql.Append("C_FR=:C_FR,");
strSql.Append("C_WT=:C_WT,");
strSql.Append("C_JB=:C_JB,");
strSql.Append("C_TEL=:C_TEL,");
strSql.Append("C_FAX=:C_FAX,");
strSql.Append("C_BANK_NAME=:C_BANK_NAME,");
strSql.Append("C_BANK_NO=:C_BANK_NO,");
strSql.Append("C_REMARK=:C_REMARK,");
strSql.Append("C_EXTEND1=:C_EXTEND1,");
strSql.Append("C_EXTEND2=:C_EXTEND2,");
strSql.Append("C_EXTEND3=:C_EXTEND3,");
strSql.Append("C_EXTEND4=:C_EXTEND4");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_NAME", OracleDbType.Varchar2, 100),
new OracleParameter(":C_FR", OracleDbType.Varchar2, 100),
new OracleParameter(":C_WT", OracleDbType.Varchar2, 100),
new OracleParameter(":C_JB", OracleDbType.Varchar2, 100),
new OracleParameter(":C_TEL", OracleDbType.Varchar2, 15),
new OracleParameter(":C_FAX", OracleDbType.Varchar2, 15),
new OracleParameter(":C_BANK_NAME", OracleDbType.Varchar2, 100),
new OracleParameter(":C_BANK_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 200),
new OracleParameter(":C_EXTEND1", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EXTEND2", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EXTEND3", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EXTEND4", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_NAME;
parameters[1].Value = model.C_FR;
parameters[2].Value = model.C_WT;
parameters[3].Value = model.C_JB;
parameters[4].Value = model.C_TEL;
parameters[5].Value = model.C_FAX;
parameters[6].Value = model.C_BANK_NAME;
parameters[7].Value = model.C_BANK_NO;
parameters[8].Value = model.C_REMARK;
parameters[9].Value = model.C_EXTEND1;
parameters[10].Value = model.C_EXTEND2;
parameters[11].Value = model.C_EXTEND3;
parameters[12].Value = model.C_EXTEND4;
parameters[13].Value = model.C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TMQ_QUALITY_MAIN model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TMQ_QUALITY_MAIN(");
strSql.Append("C_ID,C_QUEST_ID,C_PROD_KIND_ID,C_SHIPVIA,D_SHIP_START_DT,D_SHIP_END_DT,N_PARENT_REMAIN_WGT,N_MIDDLE_REMAIN_WGT,C_AREA,C_CUST_NAME,C_CUST_TYPE,C_CUST_NO,C_TEL,C_NAME,C_STL_GRD_CLASS,C_PROD_USE,N_OBJECT_COUNT_WGT,C_OBJECT_CONTENT,C_TECH_DESC,C_SITE_SURVEY_CONTENT,N_PARENT_QUA,N_QUEST_QUA,N_MIDDLE_QUA,N_ELSE_QUA,C_SITE_SURVEY_EMP,C_DEPT,C_REMARK,C_CUST_MAKING,C_CUST_MAKING_DT,C_XG_MODIFY,C_XG_MODEIFY_DT,C_APPROVER,D_APPROVER_DT,C_FLOW_ID,N_STATUS,N_FLAG,C_EMP_ID,C_EMP_NAME,D_MOD_DT,C_DEPT2,C_DEPT3,C_DEPT4)");
strSql.Append(" values (");
strSql.Append(":C_ID,:C_QUEST_ID,:C_PROD_KIND_ID,:C_SHIPVIA,:D_SHIP_START_DT,:D_SHIP_END_DT,:N_PARENT_REMAIN_WGT,:N_MIDDLE_REMAIN_WGT,:C_AREA,:C_CUST_NAME,:C_CUST_TYPE,:C_CUST_NO,:C_TEL,:C_NAME,:C_STL_GRD_CLASS,:C_PROD_USE,:N_OBJECT_COUNT_WGT,:C_OBJECT_CONTENT,:C_TECH_DESC,:C_SITE_SURVEY_CONTENT,:N_PARENT_QUA,:N_QUEST_QUA,:N_MIDDLE_QUA,:N_ELSE_QUA,:C_SITE_SURVEY_EMP,:C_DEPT,:C_REMARK,:C_CUST_MAKING,:C_CUST_MAKING_DT,:C_XG_MODIFY,:C_XG_MODEIFY_DT,:C_APPROVER,:D_APPROVER_DT,:C_FLOW_ID,:N_STATUS,:N_FLAG,:C_EMP_ID,:C_EMP_NAME,:D_MOD_DT,:C_DEPT2,:C_DEPT3,:C_DEPT4)");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_QUEST_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PROD_KIND_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SHIPVIA", OracleDbType.Varchar2, 100),
new OracleParameter(":D_SHIP_START_DT", OracleDbType.Date),
new OracleParameter(":D_SHIP_END_DT", OracleDbType.Date),
new OracleParameter(":N_PARENT_REMAIN_WGT", OracleDbType.Decimal, 15),
new OracleParameter(":N_MIDDLE_REMAIN_WGT", OracleDbType.Decimal, 15),
new OracleParameter(":C_AREA", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CUST_NAME", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CUST_TYPE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CUST_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_TEL", OracleDbType.Varchar2, 20),
new OracleParameter(":C_NAME", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STL_GRD_CLASS", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PROD_USE", OracleDbType.Varchar2, 100),
new OracleParameter(":N_OBJECT_COUNT_WGT", OracleDbType.Decimal, 15),
new OracleParameter(":C_OBJECT_CONTENT", OracleDbType.Varchar2, 200),
new OracleParameter(":C_TECH_DESC", OracleDbType.Varchar2, 200),
new OracleParameter(":C_SITE_SURVEY_CONTENT", OracleDbType.Varchar2, 200),
new OracleParameter(":N_PARENT_QUA", OracleDbType.Decimal, 2),
new OracleParameter(":N_QUEST_QUA", OracleDbType.Decimal, 2),
new OracleParameter(":N_MIDDLE_QUA", OracleDbType.Decimal, 2),
new OracleParameter(":N_ELSE_QUA", OracleDbType.Decimal, 2),
new OracleParameter(":C_SITE_SURVEY_EMP", OracleDbType.Varchar2, 100),
new OracleParameter(":C_DEPT", OracleDbType.Varchar2, 100),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 200),
new OracleParameter(":C_CUST_MAKING", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CUST_MAKING_DT", OracleDbType.Date),
new OracleParameter(":C_XG_MODIFY", OracleDbType.Varchar2, 100),
new OracleParameter(":C_XG_MODEIFY_DT", OracleDbType.Date),
new OracleParameter(":C_APPROVER", OracleDbType.Varchar2, 100),
new OracleParameter(":D_APPROVER_DT", OracleDbType.Date),
new OracleParameter(":C_FLOW_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1),
new OracleParameter(":N_FLAG", OracleDbType.Decimal, 1),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_NAME", OracleDbType.Varchar2, 20),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":C_DEPT2", OracleDbType.Varchar2, 100),
new OracleParameter(":C_DEPT3", OracleDbType.Varchar2, 100),
new OracleParameter(":C_DEPT4", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_ID;
parameters[1].Value = model.C_QUEST_ID;
parameters[2].Value = model.C_PROD_KIND_ID;
parameters[3].Value = model.C_SHIPVIA;
parameters[4].Value = model.D_SHIP_START_DT;
parameters[5].Value = model.D_SHIP_END_DT;
parameters[6].Value = model.N_PARENT_REMAIN_WGT;
parameters[7].Value = model.N_MIDDLE_REMAIN_WGT;
parameters[8].Value = model.C_AREA;
parameters[9].Value = model.C_CUST_NAME;
parameters[10].Value = model.C_CUST_TYPE;
parameters[11].Value = model.C_CUST_NO;
parameters[12].Value = model.C_TEL;
parameters[13].Value = model.C_NAME;
parameters[14].Value = model.C_STL_GRD_CLASS;
parameters[15].Value = model.C_PROD_USE;
parameters[16].Value = model.N_OBJECT_COUNT_WGT;
parameters[17].Value = model.C_OBJECT_CONTENT;
parameters[18].Value = model.C_TECH_DESC;
parameters[19].Value = model.C_SITE_SURVEY_CONTENT;
parameters[20].Value = model.N_PARENT_QUA;
parameters[21].Value = model.N_QUEST_QUA;
parameters[22].Value = model.N_MIDDLE_QUA;
parameters[23].Value = model.N_ELSE_QUA;
parameters[24].Value = model.C_SITE_SURVEY_EMP;
parameters[25].Value = model.C_DEPT;
parameters[26].Value = model.C_REMARK;
parameters[27].Value = model.C_CUST_MAKING;
parameters[28].Value = model.C_CUST_MAKING_DT;
parameters[29].Value = model.C_XG_MODIFY;
parameters[30].Value = model.C_XG_MODEIFY_DT;
parameters[31].Value = model.C_APPROVER;
parameters[32].Value = model.D_APPROVER_DT;
parameters[33].Value = model.C_FLOW_ID;
parameters[34].Value = model.N_STATUS;
parameters[35].Value = model.N_FLAG;
parameters[36].Value = model.C_EMP_ID;
parameters[37].Value = model.C_EMP_NAME;
parameters[38].Value = model.D_MOD_DT;
parameters[39].Value = model.C_DEPT2;
parameters[40].Value = model.C_DEPT3;
parameters[41].Value = model.C_DEPT4;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TMQ_QUALITY_MAIN model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TMQ_QUALITY_MAIN set ");
strSql.Append("C_QUEST_ID=:C_QUEST_ID,");
strSql.Append("C_PROD_KIND_ID=:C_PROD_KIND_ID,");
strSql.Append("C_SHIPVIA=:C_SHIPVIA,");
strSql.Append("D_SHIP_START_DT=:D_SHIP_START_DT,");
strSql.Append("D_SHIP_END_DT=:D_SHIP_END_DT,");
strSql.Append("N_PARENT_REMAIN_WGT=:N_PARENT_REMAIN_WGT,");
strSql.Append("N_MIDDLE_REMAIN_WGT=:N_MIDDLE_REMAIN_WGT,");
strSql.Append("C_AREA=:C_AREA,");
strSql.Append("C_CUST_NAME=:C_CUST_NAME,");
strSql.Append("C_CUST_TYPE=:C_CUST_TYPE,");
strSql.Append("C_CUST_NO=:C_CUST_NO,");
strSql.Append("C_TEL=:C_TEL,");
strSql.Append("C_NAME=:C_NAME,");
strSql.Append("C_STL_GRD_CLASS=:C_STL_GRD_CLASS,");
strSql.Append("C_PROD_USE=:C_PROD_USE,");
strSql.Append("N_OBJECT_COUNT_WGT=:N_OBJECT_COUNT_WGT,");
strSql.Append("C_OBJECT_CONTENT=:C_OBJECT_CONTENT,");
strSql.Append("C_TECH_DESC=:C_TECH_DESC,");
strSql.Append("C_SITE_SURVEY_CONTENT=:C_SITE_SURVEY_CONTENT,");
strSql.Append("N_PARENT_QUA=:N_PARENT_QUA,");
strSql.Append("N_QUEST_QUA=:N_QUEST_QUA,");
strSql.Append("N_MIDDLE_QUA=:N_MIDDLE_QUA,");
strSql.Append("N_ELSE_QUA=:N_ELSE_QUA,");
strSql.Append("C_SITE_SURVEY_EMP=:C_SITE_SURVEY_EMP,");
strSql.Append("C_DEPT=:C_DEPT,");
strSql.Append("C_REMARK=:C_REMARK,");
strSql.Append("C_CUST_MAKING=:C_CUST_MAKING,");
strSql.Append("C_CUST_MAKING_DT=:C_CUST_MAKING_DT,");
strSql.Append("C_XG_MODIFY=:C_XG_MODIFY,");
strSql.Append("C_XG_MODEIFY_DT=:C_XG_MODEIFY_DT,");
strSql.Append("C_APPROVER=:C_APPROVER,");
strSql.Append("D_APPROVER_DT=:D_APPROVER_DT,");
strSql.Append("C_FLOW_ID=:C_FLOW_ID,");
strSql.Append("N_STATUS=:N_STATUS,");
strSql.Append("N_FLAG=:N_FLAG,");
strSql.Append("C_EMP_ID=:C_EMP_ID,");
strSql.Append("C_EMP_NAME=:C_EMP_NAME,");
strSql.Append("D_MOD_DT=:D_MOD_DT,");
strSql.Append("C_DEPT2=:C_DEPT2,");
strSql.Append("C_DEPT3=:C_DEPT3,");
strSql.Append("C_DEPT4=:C_DEPT4");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_QUEST_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PROD_KIND_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SHIPVIA", OracleDbType.Varchar2, 100),
new OracleParameter(":D_SHIP_START_DT", OracleDbType.Date),
new OracleParameter(":D_SHIP_END_DT", OracleDbType.Date),
new OracleParameter(":N_PARENT_REMAIN_WGT", OracleDbType.Decimal, 15),
new OracleParameter(":N_MIDDLE_REMAIN_WGT", OracleDbType.Decimal, 15),
new OracleParameter(":C_AREA", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CUST_NAME", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CUST_TYPE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CUST_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_TEL", OracleDbType.Varchar2, 20),
new OracleParameter(":C_NAME", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STL_GRD_CLASS", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PROD_USE", OracleDbType.Varchar2, 100),
new OracleParameter(":N_OBJECT_COUNT_WGT", OracleDbType.Decimal, 15),
new OracleParameter(":C_OBJECT_CONTENT", OracleDbType.Varchar2, 200),
new OracleParameter(":C_TECH_DESC", OracleDbType.Varchar2, 200),
new OracleParameter(":C_SITE_SURVEY_CONTENT", OracleDbType.Varchar2, 200),
new OracleParameter(":N_PARENT_QUA", OracleDbType.Decimal, 2),
new OracleParameter(":N_QUEST_QUA", OracleDbType.Decimal, 2),
new OracleParameter(":N_MIDDLE_QUA", OracleDbType.Decimal, 2),
new OracleParameter(":N_ELSE_QUA", OracleDbType.Decimal, 2),
new OracleParameter(":C_SITE_SURVEY_EMP", OracleDbType.Varchar2, 100),
new OracleParameter(":C_DEPT", OracleDbType.Varchar2, 100),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 200),
new OracleParameter(":C_CUST_MAKING", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CUST_MAKING_DT", OracleDbType.Date),
new OracleParameter(":C_XG_MODIFY", OracleDbType.Varchar2, 100),
new OracleParameter(":C_XG_MODEIFY_DT", OracleDbType.Date),
new OracleParameter(":C_APPROVER", OracleDbType.Varchar2, 100),
new OracleParameter(":D_APPROVER_DT", OracleDbType.Date),
new OracleParameter(":C_FLOW_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1),
new OracleParameter(":N_FLAG", OracleDbType.Decimal, 1),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_NAME", OracleDbType.Varchar2, 20),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":C_DEPT2", OracleDbType.Varchar2, 100),
new OracleParameter(":C_DEPT3", OracleDbType.Varchar2, 100),
new OracleParameter(":C_DEPT4", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_QUEST_ID;
parameters[1].Value = model.C_PROD_KIND_ID;
parameters[2].Value = model.C_SHIPVIA;
parameters[3].Value = model.D_SHIP_START_DT;
parameters[4].Value = model.D_SHIP_END_DT;
parameters[5].Value = model.N_PARENT_REMAIN_WGT;
parameters[6].Value = model.N_MIDDLE_REMAIN_WGT;
parameters[7].Value = model.C_AREA;
parameters[8].Value = model.C_CUST_NAME;
parameters[9].Value = model.C_CUST_TYPE;
parameters[10].Value = model.C_CUST_NO;
parameters[11].Value = model.C_TEL;
parameters[12].Value = model.C_NAME;
parameters[13].Value = model.C_STL_GRD_CLASS;
parameters[14].Value = model.C_PROD_USE;
parameters[15].Value = model.N_OBJECT_COUNT_WGT;
parameters[16].Value = model.C_OBJECT_CONTENT;
parameters[17].Value = model.C_TECH_DESC;
parameters[18].Value = model.C_SITE_SURVEY_CONTENT;
parameters[19].Value = model.N_PARENT_QUA;
parameters[20].Value = model.N_QUEST_QUA;
parameters[21].Value = model.N_MIDDLE_QUA;
parameters[22].Value = model.N_ELSE_QUA;
parameters[23].Value = model.C_SITE_SURVEY_EMP;
parameters[24].Value = model.C_DEPT;
parameters[25].Value = model.C_REMARK;
parameters[26].Value = model.C_CUST_MAKING;
parameters[27].Value = model.C_CUST_MAKING_DT;
parameters[28].Value = model.C_XG_MODIFY;
parameters[29].Value = model.C_XG_MODEIFY_DT;
parameters[30].Value = model.C_APPROVER;
parameters[31].Value = model.D_APPROVER_DT;
parameters[32].Value = model.C_FLOW_ID;
parameters[33].Value = model.N_STATUS;
parameters[34].Value = model.N_FLAG;
parameters[35].Value = model.C_EMP_ID;
parameters[36].Value = model.C_EMP_NAME;
parameters[37].Value = model.D_MOD_DT;
parameters[38].Value = model.C_DEPT2;
parameters[39].Value = model.C_DEPT3;
parameters[40].Value = model.C_DEPT4;
parameters[41].Value = model.C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TB_STA model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TB_STA set ");
strSql.Append("C_PRO_ID=:C_PRO_ID,");
strSql.Append("C_STA_CODE=:C_STA_CODE,");
strSql.Append("C_STA_DESC=:C_STA_DESC,");
strSql.Append("C_EMP_ID=:C_EMP_ID,");
strSql.Append("D_MOD_DT=:D_MOD_DT,");
strSql.Append("C_REMARK=:C_REMARK,");
strSql.Append("D_START_DATE=:D_START_DATE,");
strSql.Append("D_END_DATE=:D_END_DATE,");
strSql.Append("N_STATUS=:N_STATUS,");
strSql.Append("C_STA_ERPCODE=:C_STA_ERPCODE,");
strSql.Append("C_STA_MESCODE=:C_STA_MESCODE,");
strSql.Append("N_SORT=:N_SORT,");
strSql.Append("C_ERP_PK=:C_ERP_PK");
strSql.Append(" WHERE C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_PRO_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STA_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STA_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, 200),
new OracleParameter(":D_START_DATE", OracleDbType.Date),
new OracleParameter(":D_END_DATE", OracleDbType.Date),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1),
new OracleParameter(":C_STA_ERPCODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STA_MESCODE", OracleDbType.Varchar2, 100),
new OracleParameter(":N_SORT", OracleDbType.Decimal, 3),
new OracleParameter(":C_ERP_PK", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_PRO_ID;
parameters[1].Value = model.C_STA_CODE;
parameters[2].Value = model.C_STA_DESC;
parameters[3].Value = model.C_EMP_ID;
parameters[4].Value = model.D_MOD_DT;
parameters[5].Value = model.C_REMARK;
parameters[6].Value = model.D_START_DATE;
parameters[7].Value = model.D_END_DATE;
parameters[8].Value = model.N_STATUS;
parameters[9].Value = model.C_STA_ERPCODE;
parameters[10].Value = model.C_STA_MESCODE;
parameters[11].Value = model.N_SORT;
parameters[12].Value = model.C_ERP_PK;
parameters[13].Value = model.C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TRC_ROLL_QTCKD model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TRC_ROLL_QTCKD set ");
strSql.Append("C_QTCKD_NO=:C_QTCKD_NO,");
strSql.Append("C_LIC_PLA_NO=:C_LIC_PLA_NO,");
strSql.Append("C_ADDRESS=:C_ADDRESS,");
strSql.Append("C_CREATE_ID=:C_CREATE_ID,");
strSql.Append("D_CREATE_DT=:D_CREATE_DT,");
strSql.Append("C_CHANGE_ID=:C_CHANGE_ID,");
strSql.Append("D_CHANGE_DT=:D_CHANGE_DT,");
strSql.Append("N_STATUS=:N_STATUS,");
strSql.Append("C_TYPE=:C_TYPE,");
strSql.Append("C_NCDJ=:C_NCDJ,");
strSql.Append("C_CYS=:C_CYS,");
strSql.Append("C_SHDW=:C_SHDW,");
strSql.Append("D_FYSJ=:D_FYSJ,");
strSql.Append("C_MBWH_ID=:C_MBWH_ID,");
strSql.Append("C_MBWH_NAME=:C_MBWH_NAME");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_QTCKD_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_LIC_PLA_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ADDRESS", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CREATE_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":D_CREATE_DT", OracleDbType.Date),
new OracleParameter(":C_CHANGE_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":D_CHANGE_DT", OracleDbType.Date),
new OracleParameter(":N_STATUS", OracleDbType.Int16, 1),
new OracleParameter(":C_TYPE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_NCDJ", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CYS", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SHDW", OracleDbType.Varchar2, 100),
new OracleParameter(":D_FYSJ", OracleDbType.Date),
new OracleParameter(":C_MBWH_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_MBWH_NAME", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_QTCKD_NO;
parameters[1].Value = model.C_LIC_PLA_NO;
parameters[2].Value = model.C_ADDRESS;
parameters[3].Value = model.C_CREATE_ID;
parameters[4].Value = model.D_CREATE_DT;
parameters[5].Value = model.C_CHANGE_ID;
parameters[6].Value = model.D_CHANGE_DT;
parameters[7].Value = model.N_STATUS;
parameters[8].Value = model.C_TYPE;
parameters[9].Value = model.C_NCDJ;
parameters[10].Value = model.C_CYS;
parameters[11].Value = model.C_SHDW;
parameters[12].Value = model.D_FYSJ;
parameters[13].Value = model.C_MBWH_ID;
parameters[14].Value = model.C_MBWH_NAME;
parameters[15].Value = model.C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 添加火运日计划单据号
/// </summary>
/// <param name="mod"></param>
/// <returns></returns>
public bool Insert(Mod_TMC_TRAIN_MAIN mod)
{
string strSql = $@"INSERT INTO TMC_TRAIN_MAIN(C_ID,C_EMPID,C_EMPNAME,C_SHIPVIA)VALUES('{mod.C_ID}','{mod.C_EMPID}','{mod.C_EMPNAME}','火运代垫（销售）')";
return(DbHelperOra.ExecuteSql(strSql) > 0 ? true : false);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TRC_ROLL_QTCKD_ITEM model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TRC_ROLL_QTCKD_ITEM(");
strSql.Append("C_QTCKD_NO,C_BATCH_NO,C_JUDGE_LEV_ZH,C_MAT_CODE,C_MAT_DESC,C_STL_GRD,C_SPEC,N_NUM,N_WGT,C_Z_DW,C_F_DW,C_STOVE,C_ZYX1,C_ZYX2,C_BZYQ,C_ZYX4,N_STATUS,C_LINEWH_CODE,D_PRODUCE_DATE,C_JUDGE_LEV_BP,C_STD_CODE,N_SJNUM,N_SJWGT)");
strSql.Append(" values (");
strSql.Append(":C_QTCKD_NO,:C_BATCH_NO,:C_JUDGE_LEV_ZH,:C_MAT_CODE,:C_MAT_DESC,:C_STL_GRD,:C_SPEC,:N_NUM,:N_WGT,:C_Z_DW,:C_F_DW,:C_STOVE,:C_ZYX1,:C_ZYX2,:C_BZYQ,:C_ZYX4,:N_STATUS,:C_LINEWH_CODE,:D_PRODUCE_DATE,:C_JUDGE_LEV_BP,:C_STD_CODE,:N_SJNUM,:N_SJWGT)");
OracleParameter[] parameters =
{
new OracleParameter(":C_QTCKD_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_BATCH_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_JUDGE_LEV_ZH", OracleDbType.Varchar2, 100),
new OracleParameter(":C_MAT_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_MAT_DESC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SPEC", OracleDbType.Varchar2, 100),
new OracleParameter(":N_NUM", OracleDbType.Int16, 15),
new OracleParameter(":N_WGT", OracleDbType.Int16, 15),
new OracleParameter(":C_Z_DW", OracleDbType.Varchar2, 100),
new OracleParameter(":C_F_DW", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STOVE", 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_ZYX4", OracleDbType.Varchar2, 100),
new OracleParameter(":N_STATUS", OracleDbType.Int16, 1),
new OracleParameter(":C_LINEWH_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":D_PRODUCE_DATE", OracleDbType.Date),
new OracleParameter(":C_JUDGE_LEV_BP", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STD_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":N_SJNUM", OracleDbType.Int16, 15),
new OracleParameter(":N_SJWGT", OracleDbType.Int16, 15)
};
parameters[0].Value = model.C_QTCKD_NO;
parameters[1].Value = model.C_BATCH_NO;
parameters[2].Value = model.C_JUDGE_LEV_ZH;
parameters[3].Value = model.C_MAT_CODE;
parameters[4].Value = model.C_MAT_DESC;
parameters[5].Value = model.C_STL_GRD;
parameters[6].Value = model.C_SPEC;
parameters[7].Value = model.N_NUM;
parameters[8].Value = model.N_WGT;
parameters[9].Value = model.C_Z_DW;
parameters[10].Value = model.C_F_DW;
parameters[11].Value = model.C_STOVE;
parameters[12].Value = model.C_ZYX1;
parameters[13].Value = model.C_ZYX2;
parameters[14].Value = model.C_BZYQ;
parameters[15].Value = model.C_ZYX4;
parameters[16].Value = model.N_STATUS;
parameters[17].Value = model.C_LINEWH_CODE;
parameters[18].Value = model.D_PRODUCE_DATE;
parameters[19].Value = model.C_JUDGE_LEV_BP;
parameters[20].Value = model.C_STD_CODE;
parameters[21].Value = model.N_SJNUM;
parameters[22].Value = model.N_SJWGT;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除计划号
/// </summary>
/// <param name="C_ID"></param>
/// <returns></returns>
public bool DelTrainPlan(string C_ID)
{
string strSql = $"DELETE FROM TMC_TRAIN WHERE C_ID='{C_ID}'";
return(DbHelperOra.ExecuteSql(strSql) > 0 ? true : false);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TPB_STEEL_PRO_CONDITION model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TPB_STEEL_PRO_CONDITION set ");
strSql.Append("C_STL_GRD_TYPE=:C_STL_GRD_TYPE,");
strSql.Append("C_STL_GRD_RANK=:C_STL_GRD_RANK,");
strSql.Append("C_STL_GRD=:C_STL_GRD,");
strSql.Append("C_STD_CODE=:C_STD_CODE,");
strSql.Append("C_STL_SCRAP_TYPE=:C_STL_SCRAP_TYPE,");
strSql.Append("C_STL_SCRAP_FLIJ=:C_STL_SCRAP_FLIJ,");
strSql.Append("C_GOUTE=:C_GOUTE,");
strSql.Append("C_TEASE_PERSON=:C_TEASE_PERSON,");
strSql.Append("C_ADV_PRO_REQUIRE=:C_ADV_PRO_REQUIRE,");
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(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_STL_GRD_TYPE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STL_GRD_RANK", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STD_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STL_SCRAP_TYPE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STL_SCRAP_FLIJ", OracleDbType.Varchar2, 100),
new OracleParameter(":C_GOUTE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_TEASE_PERSON", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ADV_PRO_REQUIRE", OracleDbType.Varchar2, 200),
new OracleParameter(":N_STATUS", OracleDbType.Int16, 1),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 200),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 20),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_STL_GRD_TYPE;
parameters[1].Value = model.C_STL_GRD_RANK;
parameters[2].Value = model.C_STL_GRD;
parameters[3].Value = model.C_STD_CODE;
parameters[4].Value = model.C_STL_SCRAP_TYPE;
parameters[5].Value = model.C_STL_SCRAP_FLIJ;
parameters[6].Value = model.C_GOUTE;
parameters[7].Value = model.C_TEASE_PERSON;
parameters[8].Value = model.C_ADV_PRO_REQUIRE;
parameters[9].Value = model.N_STATUS;
parameters[10].Value = model.C_REMARK;
parameters[11].Value = model.C_EMP_ID;
parameters[12].Value = model.D_MOD_DT;
parameters[13].Value = model.C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TMB_ACTIVITY_LOG model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TMB_ACTIVITY_LOG set ");
strSql.Append("C_MAT_CODE=:C_MAT_CODE,");
strSql.Append("C_MAT_NAME=:C_MAT_NAME,");
strSql.Append("C_STL_GRD=:C_STL_GRD,");
strSql.Append("C_SPEC=:C_SPEC,");
strSql.Append("N_PRICE=:N_PRICE,");
strSql.Append("N_DISCOUNT=:N_DISCOUNT,");
strSql.Append("N_RATE=:N_RATE,");
strSql.Append("N_ORIMOTO=:N_ORIMOTO,");
strSql.Append("C_STATUS=:C_STATUS,");
strSql.Append("C_REMARK=:C_REMARK,");
strSql.Append("C_EMP_ID=:C_EMP_ID,");
strSql.Append("C_EMP_NAME=:C_EMP_NAME,");
strSql.Append("D_MOD_DT=:D_MOD_DT");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_MAT_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_MAT_NAME", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SPEC", OracleDbType.Varchar2, 100),
new OracleParameter(":N_PRICE", OracleDbType.Decimal, 15),
new OracleParameter(":N_DISCOUNT", OracleDbType.Decimal, 15),
new OracleParameter(":N_RATE", OracleDbType.Decimal, 15),
new OracleParameter(":N_ORIMOTO", OracleDbType.Decimal, 15),
new OracleParameter(":C_STATUS", OracleDbType.Decimal, 1),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 200),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_NAME", OracleDbType.Varchar2, 20),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_MAT_CODE;
parameters[1].Value = model.C_MAT_NAME;
parameters[2].Value = model.C_STL_GRD;
parameters[3].Value = model.C_SPEC;
parameters[4].Value = model.N_PRICE;
parameters[5].Value = model.N_DISCOUNT;
parameters[6].Value = model.N_RATE;
parameters[7].Value = model.N_ORIMOTO;
parameters[8].Value = model.C_STATUS;
parameters[9].Value = model.C_REMARK;
parameters[10].Value = model.C_EMP_ID;
parameters[11].Value = model.C_EMP_NAME;
parameters[12].Value = model.D_MOD_DT;
parameters[13].Value = model.C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TB_STD_CONFIG model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TB_STD_CONFIG set ");
strSql.Append("C_ID=:C_ID,");
strSql.Append("C_STD_ID=:C_STD_ID,");
strSql.Append("C_CUST_TECH_PROT=:C_CUST_TECH_PROT,");
strSql.Append("C_ZYX1=:C_ZYX1,");
strSql.Append("C_ZYX2=:C_ZYX2,");
strSql.Append("C_STL_GRD=:C_STL_GRD,");
strSql.Append("C_STD_CODE=:C_STD_CODE,");
strSql.Append("C_STEEL_SIGN=:C_STEEL_SIGN,");
strSql.Append("C_EMP_ID=:C_EMP_ID,");
strSql.Append("D_MOD_DT=:D_MOD_DT,");
strSql.Append("C_REMARK=:C_REMARK,");
strSql.Append("D_START_DATE=:D_START_DATE,");
strSql.Append("D_END_DATE=:D_END_DATE,");
strSql.Append("N_STATUS=:N_STATUS");
strSql.Append(" where ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STD_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CUST_TECH_PROT", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ZYX1", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ZYX2", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STD_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STEEL_SIGN", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 20),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 200),
new OracleParameter(":D_START_DATE", OracleDbType.Date),
new OracleParameter(":D_END_DATE", OracleDbType.Date),
new OracleParameter(":N_STATUS", OracleDbType.Int32, 1)
};
parameters[0].Value = model.C_ID;
parameters[1].Value = model.C_STD_ID;
parameters[2].Value = model.C_CUST_TECH_PROT;
parameters[3].Value = model.C_ZYX1;
parameters[4].Value = model.C_ZYX2;
parameters[5].Value = model.C_STL_GRD;
parameters[6].Value = model.C_STD_CODE;
parameters[7].Value = model.C_STEEL_SIGN;
parameters[8].Value = model.C_EMP_ID;
parameters[9].Value = model.D_MOD_DT;
parameters[10].Value = model.C_REMARK;
parameters[11].Value = model.D_START_DATE;
parameters[12].Value = model.D_END_DATE;
parameters[13].Value = model.N_STATUS;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 修改低毛利限量指标
/// </summary>
/// <param name="id"></param>
/// <param name="wgt"></param>
/// <param name="empid"></param>
/// <param name="empname"></param>
/// <returns></returns>
public bool UpdateMonthWgt(string id, string wgt, string empid, string empname)
{
string strsql = $"UPDATE TMB_STLGRD_PRICE_WGT SET N_WGT={wgt},C_EMPID='{empid}',C_EMPNAME='{empname}' WHERE C_ID='{id}'";
return(DbHelperOra.ExecuteSql(strsql) > 0 ? true : false);
}
public bool UpdateItem(Mod_TQC_ZZS_FILE mod)
{
string strSql = $@"UPDATE TQC_ZZS_FILE SET C_PDF_PATCH='{mod.C_PDF_PATCH}' WHERE C_BATCH_NO='{mod.C_BATCH_NO}' AND C_STOVE='{mod.C_STOVE}' AND C_STL_GRD='{mod.C_STL_GRD}' AND C_STD_CODE='{mod.C_STD_CODE}'";
return(DbHelperOra.ExecuteSql(strSql) > 0 ? true : false);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TRC_ROLL_QTCKD_ITEM model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TRC_ROLL_QTCKD_ITEM set ");
strSql.Append("C_QTCKD_NO=:C_QTCKD_NO,");
strSql.Append("C_BATCH_NO=:C_BATCH_NO,");
strSql.Append("C_JUDGE_LEV_ZH=:C_JUDGE_LEV_ZH,");
strSql.Append("C_MAT_CODE=:C_MAT_CODE,");
strSql.Append("C_MAT_DESC=:C_MAT_DESC,");
strSql.Append("C_STL_GRD=:C_STL_GRD,");
strSql.Append("C_SPEC=:C_SPEC,");
strSql.Append("N_NUM=:N_NUM,");
strSql.Append("N_WGT=:N_WGT,");
strSql.Append("C_Z_DW=:C_Z_DW,");
strSql.Append("C_F_DW=:C_F_DW,");
strSql.Append("C_STOVE=:C_STOVE,");
strSql.Append("C_ZYX1=:C_ZYX1,");
strSql.Append("C_ZYX2=:C_ZYX2,");
strSql.Append("C_BZYQ=:C_BZYQ,");
strSql.Append("C_ZYX4=:C_ZYX4,");
strSql.Append("N_STATUS=:N_STATUS,");
strSql.Append("C_LINEWH_CODE=:C_LINEWH_CODE,");
strSql.Append("D_PRODUCE_DATE=:D_PRODUCE_DATE,");
strSql.Append("C_JUDGE_LEV_BP=:C_JUDGE_LEV_BP,");
strSql.Append("C_STD_CODE=:C_STD_CODE,");
strSql.Append("N_SJNUM=:N_SJNUM,");
strSql.Append("N_SJWGT=:N_SJWGT");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_QTCKD_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_BATCH_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_JUDGE_LEV_ZH", OracleDbType.Varchar2, 100),
new OracleParameter(":C_MAT_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_MAT_DESC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SPEC", OracleDbType.Varchar2, 100),
new OracleParameter(":N_NUM", OracleDbType.Int16, 15),
new OracleParameter(":N_WGT", OracleDbType.Int16, 15),
new OracleParameter(":C_Z_DW", OracleDbType.Varchar2, 100),
new OracleParameter(":C_F_DW", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STOVE", 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_ZYX4", OracleDbType.Varchar2, 100),
new OracleParameter(":N_STATUS", OracleDbType.Int16, 1),
new OracleParameter(":C_LINEWH_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":D_PRODUCE_DATE", OracleDbType.Date),
new OracleParameter(":C_JUDGE_LEV_BP", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STD_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":N_SJNUM", OracleDbType.Int16, 15),
new OracleParameter(":N_SJWGT", OracleDbType.Int16, 15),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_QTCKD_NO;
parameters[1].Value = model.C_BATCH_NO;
parameters[2].Value = model.C_JUDGE_LEV_ZH;
parameters[3].Value = model.C_MAT_CODE;
parameters[4].Value = model.C_MAT_DESC;
parameters[5].Value = model.C_STL_GRD;
parameters[6].Value = model.C_SPEC;
parameters[7].Value = model.N_NUM;
parameters[8].Value = model.N_WGT;
parameters[9].Value = model.C_Z_DW;
parameters[10].Value = model.C_F_DW;
parameters[11].Value = model.C_STOVE;
parameters[12].Value = model.C_ZYX1;
parameters[13].Value = model.C_ZYX2;
parameters[14].Value = model.C_BZYQ;
parameters[15].Value = model.C_ZYX4;
parameters[16].Value = model.N_STATUS;
parameters[17].Value = model.C_LINEWH_CODE;
parameters[18].Value = model.D_PRODUCE_DATE;
parameters[19].Value = model.C_JUDGE_LEV_BP;
parameters[20].Value = model.C_STD_CODE;
parameters[21].Value = model.N_SJNUM;
parameters[22].Value = model.N_SJWGT;
parameters[23].Value = model.C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TMP_DAYPLAN model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TMP_DAYPLAN(");
strSql.Append("C_ID,C_PLCODE,C_PKBILLB,C_PKBILLH,C_CONNO,C_ORDERNO,C_PKINV,C_PKASSISTMEASURE,N_ASSISTNUM,N_NUM,N_UNITPRICE,N_MONEY,D_PLANDATE,D_ORDSNDATE,D_REQUIREDATE,D_SNDDATE,C_PKCUST,C_PKSENDTYPE,C_PKSALECORP,C_PKSALEORG,C_PKSENDSTOREORG,C_PKOPERATOR,C_PKOPRDEPART,C_PKPLANPERSON,C_PKAPPRPERSON,D_APPRDATE,C_PKARRIVEAREA,C_DESTADDRESS,C_RECEIPTCORPID,C_BIZTYPE,C_REMARK,C_PKSENDAREA,C_PKDELIVORG,C_UNITID,C_VFREE1,C_VFREE2,C_VFREE3,C_VFREE4)");
strSql.Append(" values (");
strSql.Append(":C_ID,:C_PLCODE,:C_PKBILLB,:C_PKBILLH,:C_CONNO,:C_ORDERNO,:C_PKINV,:C_PKASSISTMEASURE,:N_ASSISTNUM,:N_NUM,:N_UNITPRICE,:N_MONEY,:D_PLANDATE,:D_ORDSNDATE,:D_REQUIREDATE,:D_SNDDATE,:C_PKCUST,:C_PKSENDTYPE,:C_PKSALECORP,:C_PKSALEORG,:C_PKSENDSTOREORG,:C_PKOPERATOR,:C_PKOPRDEPART,:C_PKPLANPERSON,:C_PKAPPRPERSON,:D_APPRDATE,:C_PKARRIVEAREA,:C_DESTADDRESS,:C_RECEIPTCORPID,:C_BIZTYPE,:C_REMARK,:C_PKSENDAREA,:C_PKDELIVORG,:C_UNITID,:C_VFREE1,:C_VFREE2,:C_VFREE3,:C_VFREE4)");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PLCODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PKBILLB", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PKBILLH", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CONNO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ORDERNO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PKINV", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PKASSISTMEASURE", OracleDbType.Varchar2, 100),
new OracleParameter(":N_ASSISTNUM", OracleDbType.Decimal, 15),
new OracleParameter(":N_NUM", OracleDbType.Decimal, 15),
new OracleParameter(":N_UNITPRICE", OracleDbType.Decimal, 15),
new OracleParameter(":N_MONEY", OracleDbType.Decimal, 15),
new OracleParameter(":D_PLANDATE", OracleDbType.Date),
new OracleParameter(":D_ORDSNDATE", OracleDbType.Date),
new OracleParameter(":D_REQUIREDATE", OracleDbType.Date),
new OracleParameter(":D_SNDDATE", OracleDbType.Date),
new OracleParameter(":C_PKCUST", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PKSENDTYPE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PKSALECORP", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PKSALEORG", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PKSENDSTOREORG", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PKOPERATOR", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PKOPRDEPART", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PKPLANPERSON", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PKAPPRPERSON", OracleDbType.Varchar2, 100),
new OracleParameter(":D_APPRDATE", OracleDbType.Date),
new OracleParameter(":C_PKARRIVEAREA", OracleDbType.Varchar2, 100),
new OracleParameter(":C_DESTADDRESS", OracleDbType.Varchar2, 100),
new OracleParameter(":C_RECEIPTCORPID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_BIZTYPE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500),
new OracleParameter(":C_PKSENDAREA", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PKDELIVORG", OracleDbType.Varchar2, 100),
new OracleParameter(":C_UNITID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_VFREE1", OracleDbType.Varchar2, 200),
new OracleParameter(":C_VFREE2", OracleDbType.Varchar2, 200),
new OracleParameter(":C_VFREE3", OracleDbType.Varchar2, 200),
new OracleParameter(":C_VFREE4", OracleDbType.Varchar2, 200)
};
parameters[0].Value = model.C_ID;
parameters[1].Value = model.C_PLCODE;
parameters[2].Value = model.C_PKBILLB;
parameters[3].Value = model.C_PKBILLH;
parameters[4].Value = model.C_CONNO;
parameters[5].Value = model.C_ORDERNO;
parameters[6].Value = model.C_PKINV;
parameters[7].Value = model.C_PKASSISTMEASURE;
parameters[8].Value = model.N_ASSISTNUM;
parameters[9].Value = model.N_NUM;
parameters[10].Value = model.N_UNITPRICE;
parameters[11].Value = model.N_MONEY;
parameters[12].Value = model.D_PLANDATE;
parameters[13].Value = model.D_ORDSNDATE;
parameters[14].Value = model.D_REQUIREDATE;
parameters[15].Value = model.D_SNDDATE;
parameters[16].Value = model.C_PKCUST;
parameters[17].Value = model.C_PKSENDTYPE;
parameters[18].Value = model.C_PKSALECORP;
parameters[19].Value = model.C_PKSALEORG;
parameters[20].Value = model.C_PKSENDSTOREORG;
parameters[21].Value = model.C_PKOPERATOR;
parameters[22].Value = model.C_PKOPRDEPART;
parameters[23].Value = model.C_PKPLANPERSON;
parameters[24].Value = model.C_PKAPPRPERSON;
parameters[25].Value = model.D_APPRDATE;
parameters[26].Value = model.C_PKARRIVEAREA;
parameters[27].Value = model.C_DESTADDRESS;
parameters[28].Value = model.C_RECEIPTCORPID;
parameters[29].Value = model.C_BIZTYPE;
parameters[30].Value = model.C_REMARK;
parameters[31].Value = model.C_PKSENDAREA;
parameters[32].Value = model.C_PKDELIVORG;
parameters[33].Value = model.C_UNITID;
parameters[34].Value = model.C_VFREE1;
parameters[35].Value = model.C_VFREE2;
parameters[36].Value = model.C_VFREE3;
parameters[37].Value = model.C_VFREE4;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除火运计划
/// </summary>
/// <param name="mod"></param>
/// <returns></returns>
public bool Del(Mod_TMC_TRAIN_ITEM mod)
{
string strSql = $"DELETE FROM TMC_TRAIN_ITEM WHERE C_ID='{mod.C_ID}'";
return(DbHelperOra.ExecuteSql(strSql) > 0 ? true : false);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TPP_INITIALIZE_ORDER model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TPP_INITIALIZE_ORDER set ");
strSql.Append("C_INITIALIZE_ID=:C_INITIALIZE_ID,");
strSql.Append("C_ORDER_ID=:C_ORDER_ID,");
strSql.Append("N_WGT=:N_WGT,");
strSql.Append("N_MACH_WGT=:N_MACH_WGT,");
strSql.Append("C_DESIGN_NO=:C_DESIGN_NO,");
strSql.Append("N_STATUS=:N_STATUS,");
strSql.Append("N_FLAG=:N_FLAG,");
strSql.Append("C_REMARK=:C_REMARK,");
strSql.Append("C_EMP_ID=:C_EMP_ID,");
strSql.Append("C_EMP_NAME=:C_EMP_NAME,");
strSql.Append("D_MOD_DT=:D_MOD_DT,");
strSql.Append("C_RH=:C_RH,");
strSql.Append("C_LF=:C_LF,");
strSql.Append("C_KP=:C_KP,");
strSql.Append("N_HL_TIME=:N_HL_TIME,");
strSql.Append("C_HL=:C_HL,");
strSql.Append("N_DFP_HL_TIME=:N_DFP_HL_TIME,");
strSql.Append("C_DFP_HL=:C_DFP_HL,");
strSql.Append("C_XM=:C_XM,");
strSql.Append("C_ROLL_STA_ID=:C_ROLL_STA_ID,");
strSql.Append("C_CCM_STA_ID=:C_CCM_STA_ID,");
strSql.Append("N_MACH_WGT_CCM=:N_MACH_WGT_CCM,");
strSql.Append("N_LGPC_STATUS=:N_LGPC_STATUS,");
strSql.Append("N_EXEC_STATUS=:N_EXEC_STATUS,");
strSql.Append("N_ROLL_PROD_WGT=:N_ROLL_PROD_WGT,");
strSql.Append("N_SMS_PROD_WGT=:N_SMS_PROD_WGT");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_INITIALIZE_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ORDER_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":N_WGT", OracleDbType.Int16, 15),
new OracleParameter(":N_MACH_WGT", OracleDbType.Int16, 15),
new OracleParameter(":C_DESIGN_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":N_STATUS", OracleDbType.Int16, 2),
new OracleParameter(":N_FLAG", OracleDbType.Int16, 2),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 200),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_NAME", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":C_RH", OracleDbType.Varchar2, 100),
new OracleParameter(":C_LF", OracleDbType.Varchar2, 100),
new OracleParameter(":C_KP", OracleDbType.Varchar2, 100),
new OracleParameter(":N_HL_TIME", OracleDbType.Int16, 10),
new OracleParameter(":C_HL", OracleDbType.Varchar2, 100),
new OracleParameter(":N_DFP_HL_TIME", OracleDbType.Int16, 10),
new OracleParameter(":C_DFP_HL", OracleDbType.Varchar2, 100),
new OracleParameter(":C_XM", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ROLL_STA_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CCM_STA_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":N_MACH_WGT_CCM", OracleDbType.Int16, 15),
new OracleParameter(":N_LGPC_STATUS", OracleDbType.Int16, 2),
new OracleParameter(":N_EXEC_STATUS", OracleDbType.Int16, 2),
new OracleParameter(":N_ROLL_PROD_WGT", OracleDbType.Int16, 15),
new OracleParameter(":N_SMS_PROD_WGT", OracleDbType.Int16, 15),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_INITIALIZE_ID;
parameters[1].Value = model.C_ORDER_ID;
parameters[2].Value = model.N_WGT;
parameters[3].Value = model.N_MACH_WGT;
parameters[4].Value = model.C_DESIGN_NO;
parameters[5].Value = model.N_STATUS;
parameters[6].Value = model.N_FLAG;
parameters[7].Value = model.C_REMARK;
parameters[8].Value = model.C_EMP_ID;
parameters[9].Value = model.C_EMP_NAME;
parameters[10].Value = model.D_MOD_DT;
parameters[11].Value = model.C_RH;
parameters[12].Value = model.C_LF;
parameters[13].Value = model.C_KP;
parameters[14].Value = model.N_HL_TIME;
parameters[15].Value = model.C_HL;
parameters[16].Value = model.N_DFP_HL_TIME;
parameters[17].Value = model.C_DFP_HL;
parameters[18].Value = model.C_XM;
parameters[19].Value = model.C_ROLL_STA_ID;
parameters[20].Value = model.C_CCM_STA_ID;
parameters[21].Value = model.N_MACH_WGT_CCM;
parameters[22].Value = model.N_LGPC_STATUS;
parameters[23].Value = model.N_EXEC_STATUS;
parameters[24].Value = model.N_ROLL_PROD_WGT;
parameters[25].Value = model.N_SMS_PROD_WGT;
parameters[26].Value = model.C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public void AddExportLog(string empName)
{
string strSql = $"INSERT INTO TMC_TRAIN_EXPORT_LOG(C_EMPNAME)VALUES('{empName}')";
DbHelperOra.ExecuteSql(strSql);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TPP_INITIALIZE_ORDER model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TPP_INITIALIZE_ORDER(");
strSql.Append("C_INITIALIZE_ID,C_ORDER_ID,N_WGT,N_MACH_WGT,C_DESIGN_NO,N_STATUS,N_FLAG,C_REMARK,C_EMP_ID,C_EMP_NAME,D_MOD_DT,C_RH,C_LF,C_KP,N_HL_TIME,C_HL,N_DFP_HL_TIME,C_DFP_HL,C_XM,C_ROLL_STA_ID,C_CCM_STA_ID,N_MACH_WGT_CCM,N_LGPC_STATUS,N_EXEC_STATUS,N_ROLL_PROD_WGT,N_SMS_PROD_WGT)");
strSql.Append(" values (");
strSql.Append(":C_INITIALIZE_ID,:C_ORDER_ID,:N_WGT,:N_MACH_WGT,:C_DESIGN_NO,:N_STATUS,:N_FLAG,:C_REMARK,:C_EMP_ID,:C_EMP_NAME,:D_MOD_DT,:C_RH,:C_LF,:C_KP,:N_HL_TIME,:C_HL,:N_DFP_HL_TIME,:C_DFP_HL,:C_XM,:C_ROLL_STA_ID,:C_CCM_STA_ID,:N_MACH_WGT_CCM,:N_LGPC_STATUS,:N_EXEC_STATUS,:N_ROLL_PROD_WGT,:N_SMS_PROD_WGT)");
OracleParameter[] parameters =
{
new OracleParameter(":C_INITIALIZE_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ORDER_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":N_WGT", OracleDbType.Int16, 15),
new OracleParameter(":N_MACH_WGT", OracleDbType.Int16, 15),
new OracleParameter(":C_DESIGN_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":N_STATUS", OracleDbType.Int16, 2),
new OracleParameter(":N_FLAG", OracleDbType.Int16, 2),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 200),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_NAME", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":C_RH", OracleDbType.Varchar2, 100),
new OracleParameter(":C_LF", OracleDbType.Varchar2, 100),
new OracleParameter(":C_KP", OracleDbType.Varchar2, 100),
new OracleParameter(":N_HL_TIME", OracleDbType.Int16, 10),
new OracleParameter(":C_HL", OracleDbType.Varchar2, 100),
new OracleParameter(":N_DFP_HL_TIME", OracleDbType.Int16, 10),
new OracleParameter(":C_DFP_HL", OracleDbType.Varchar2, 100),
new OracleParameter(":C_XM", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ROLL_STA_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CCM_STA_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":N_MACH_WGT_CCM", OracleDbType.Int16, 15),
new OracleParameter(":N_LGPC_STATUS", OracleDbType.Int16, 2),
new OracleParameter(":N_EXEC_STATUS", OracleDbType.Int16, 2),
new OracleParameter(":N_ROLL_PROD_WGT", OracleDbType.Int16, 15),
new OracleParameter(":N_SMS_PROD_WGT", OracleDbType.Int16, 15)
};
parameters[0].Value = model.C_INITIALIZE_ID;
parameters[1].Value = model.C_ORDER_ID;
parameters[2].Value = model.N_WGT;
parameters[3].Value = model.N_MACH_WGT;
parameters[4].Value = model.C_DESIGN_NO;
parameters[5].Value = model.N_STATUS;
parameters[6].Value = model.N_FLAG;
parameters[7].Value = model.C_REMARK;
parameters[8].Value = model.C_EMP_ID;
parameters[9].Value = model.C_EMP_NAME;
parameters[10].Value = model.D_MOD_DT;
parameters[11].Value = model.C_RH;
parameters[12].Value = model.C_LF;
parameters[13].Value = model.C_KP;
parameters[14].Value = model.N_HL_TIME;
parameters[15].Value = model.C_HL;
parameters[16].Value = model.N_DFP_HL_TIME;
parameters[17].Value = model.C_DFP_HL;
parameters[18].Value = model.C_XM;
parameters[19].Value = model.C_ROLL_STA_ID;
parameters[20].Value = model.C_CCM_STA_ID;
parameters[21].Value = model.N_MACH_WGT_CCM;
parameters[22].Value = model.N_LGPC_STATUS;
parameters[23].Value = model.N_EXEC_STATUS;
parameters[24].Value = model.N_ROLL_PROD_WGT;
parameters[25].Value = model.N_SMS_PROD_WGT;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
