/// <summary> /// 更新工序 /// </summary> /// <param name="model">工序实体类</param> /// <returns></returns> public bool UpdateDALPROCESS_TEMP(Model.PROCESS model) { bool bl = true; StringBuilder strSql = new StringBuilder(); strSql.Append("update PROCESS_TEMP set "); strSql.Append("NAME=:NAME"); strSql.Append(" where PROCESSID=:PROCESSID "); OracleParameter[] parameters = { new OracleParameter(":NAME", OracleType.NVarChar, 600), new OracleParameter(":PROCESSID", OracleType.Number, 9), }; parameters[0].Value = model.NAME; parameters[1].Value = model.PROCESSID; if (OracleHelper.ExecuteSql(strSql.ToString(), parameters) >= 1) { bl = true; } else { bl = false; } return(bl); }
/// <summary> /// 增加一个工序 /// </summary> /// <param name="model">工序实体类</param> /// <returns></returns> public bool CreateDALPROCESS(Model.PROCESS model) { //传参-专业与工作任务 int gzrw = int.Parse(System.Web.HttpContext.Current.Session["gzrwID"].ToString()); int zy = int.Parse(System.Web.HttpContext.Current.Session["zyID"].ToString()); //获取数据库中已经存在的SERIALNUMBER的最大值 DataSet ds = OracleHelper.Query("select SERIALNUMBER from (select SERIALNUMBER from PROCESS where WORKTASKID='" + gzrw + "' order by SERIALNUMBER desc nulls last) where ROWNUM = 1"); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into PROCESS("); strSql.Append("NAME,WORKTASKID,PROFESSIONALID,DANWEIID,ISOMUX,SERIALNUMBER)"); strSql.Append(" values("); strSql.Append(":NAME,:WORKTASKID,:PROFESSIONALID,:DANWEIID,:ISOMUX,:SERIALNUMBER)"); OracleParameter[] parameters = { new OracleParameter(":NAME", OracleType.NVarChar, 200), new OracleParameter(":WORKTASKID", OracleType.Number, 9), new OracleParameter(":PROFESSIONALID", OracleType.Number, 9), new OracleParameter(":DANWEIID", OracleType.Number, 10), new OracleParameter(":ISOMUX", OracleType.NVarChar, 18), new OracleParameter(":SERIALNUMBER", OracleType.Number, 9) }; parameters[0].Value = model.NAME; parameters[1].Value = gzrw; parameters[2].Value = zy; parameters[3].Value = 200000000; parameters[4].Value = PublicMethod.GetPROCESSNO(gzrw.ToString()); try { parameters[5].Value = int.Parse(ds.Tables[0].Rows[0]["SERIALNUMBER"].ToString()) + 1; } catch { parameters[5].Value = 1; } if (OracleHelper.ExecuteSql(strSql.ToString(), parameters) >= 1) { return(true); } else { return(false); } }
/// <summary> /// 增加一个工序 /// </summary> /// <param name="model">工序实体类</param> /// <returns></returns> public bool CreateDALPROCESS_TEMP(Model.PROCESS model) { //传参-专业与工作任务 int gzrw = int.Parse(System.Web.HttpContext.Current.Session["gzrwID"].ToString()); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into PROCESS_TEMP ("); strSql.Append("NAME,WORKTASKID,STATUS,DEPTNUMBER,DATEINPUT,PERSONID)"); strSql.Append(" values("); strSql.Append(":NAME,:WORKTASKID,:STATUS,:DEPTNUMBER,:DATEINPUT,:PERSONID)"); OracleParameter[] parameters = { new OracleParameter(":NAME", OracleType.NVarChar, 600), new OracleParameter(":WORKTASKID", OracleType.Number, 9), new OracleParameter(":STATUS", OracleType.NVarChar, 10), new OracleParameter(":DEPTNUMBER", OracleType.NVarChar, 20), new OracleParameter(":DATEINPUT", OracleType.DateTime), new OracleParameter(":PERSONID", OracleType.Number, 9) }; parameters[0].Value = model.NAME; parameters[1].Value = gzrw; parameters[2].Value = "保存"; parameters[3].Value = "000000000"; parameters[4].Value = System.DateTime.Now; parameters[5].Value = "343"; if (OracleHelper.ExecuteSql(strSql.ToString(), parameters) >= 1) { return(true); } else { return(false); } }
/// <summary> /// 删除/禁用一个工序 /// </summary> /// <param name="OperatorID">工序ID</param> /// <returns></returns> public bool DeleteDALPROCESS_TEMP(Model.PROCESS model) { bool bl = true; StringBuilder strSql = new StringBuilder(); strSql.Append("delete PROCESS_TEMP"); strSql.Append(" where PROCESSID=:PROCESSID "); OracleParameter[] parameters = { new OracleParameter(":PROCESSID", OracleType.Number, 9) }; parameters[0].Value = model.PROCESSID; if (OracleHelper.ExecuteSql(strSql.ToString(), parameters) >= 1) { bl = true; } else { bl = false; } return(bl); }