public List <MODEL.risk_project> getProjectList() { string sql = @"select * from RISK_PROJECT"; OracleParameter parameter = null; try { using (OracleDataReader myReader = SqlHelper.ExecuteQuery(sql, parameter)) { List <MODEL.risk_project> PrjList = new List <MODEL.risk_project>(); while (myReader.Read()) { MODEL.risk_project project = new MODEL.risk_project(); project.Prj_id = Int32.Parse(myReader["PRJ_ID"].ToString()); project.Prj_name = myReader["PRJ_NAME"].ToString(); project.Prj_describe = myReader["PRJ_DESCRIBE"].ToString(); project.Prj_date = myReader.GetDateTime(3); OracleBlob PrjXML = myReader.GetOracleBlob(4); project.Prj_xml = Encoding.Default.GetString(PrjXML.Value); PrjList.Add(project); } return(PrjList); } } catch (System.Exception ex) { throw ex; } }
private static bool checkProject(XmlReader xml, string prjDesc) { while (xml.Read()) { if (xml.NodeType == XmlNodeType.Element) { if (xml.Name == "project") { try { string projectName = xml.GetAttribute("name"); if (!CommonArugment.getProject.checkProjectName(projectName)) { CommonMsg.errMsg = "该项目名称已经存在"; return(false); } MODEL.risk_project project = new MODEL.risk_project(); project.Prj_name = projectName; project.Prj_date = DateTime.Now; project.Prj_xml = xml.ReadOuterXml(); project.Prj_describe = prjDesc; projectId = CommonArugment.getProject.saveProject(project); return(true); } catch (System.Exception ex) { throw ex; } } } } return(false); }
public static bool addProject(XmlDocument xmlDoc, string prjDesc) { List <MODEL.risk_task> taskList = new List <MODEL.risk_task>(); List <MODEL.risk_link> linkList = new List <MODEL.risk_link>(); XmlReader xmlContent = new XmlTextReader(new StringReader(xmlDoc.OuterXml)); string projectName = xmlDoc.DocumentElement.GetAttribute("name"); int projectId; MODEL.risk_project project = new MODEL.risk_project(); if (!CommonUtils.checkProjectName(projectName)) { CommonMsg.errMsg = "已经存在相同的项目名称"; return(false); } project.Prj_name = projectName; project.Prj_date = DateTime.Now; project.Prj_xml = xmlDoc.OuterXml; project.Prj_describe = prjDesc; try { projectId = CommonArugment.getProject.saveProject(project); CommonUtils.parseXML(xmlContent, taskList, linkList, projectId); CommonArugment.getTask.insertTask(taskList); CommonArugment.getTask.insertLink(linkList); return(true); } catch (System.Exception ex) { throw ex; } }
public static bool updateProject(string name, string description) { MODEL.risk_project project = new MODEL.risk_project(); project.Prj_name = name; project.Prj_describe = description; try { if (CommonArugment.getProject.updateProject(project)) { return(true); } return(false); } catch (System.Exception ex) { throw ex; } }
public bool updateProject(MODEL.risk_project project) { string sql = @"update RISK_PROJECT set PRJ_DESCRIBE=:PRJ_DESCRIBE where PRJ_NAME=:prjName"; OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":PRJ_DESCRIBE", OracleDbType.Varchar2, 255), new OracleParameter(":prjName", OracleDbType.Varchar2, 64), }; parameters[0].Value = project.Prj_describe; parameters[1].Value = project.Prj_name; try { SqlHelper.ExecuteNonQuery(sql, parameters); return(true); } catch (System.Exception ex) { throw ex; } }
public int saveProject(MODEL.risk_project project) { //connection = connDB.getConn(); //connection.Open(); //OracleCommand command = connection.CreateCommand(); //command.CommandText = @"insert into RISK_PROJECT(PRJ_ID,PRJ_NAME,PRJ_DESCRIBE,PRJ_DATE,PRJ_XML) values(RISK_PROJECT_PRJ_ID.NEXTVAL,:PRJ_NAME,:PRJ_DESCRIBE,:PRJ_DATE,to_blob(:PRJ_XML))"; //command.CommandTimeout = 60; //OracleParameter[] parameters = new OracleParameter[] { // new OracleParameter(":PRJ_NAME",OracleDbType.Varchar2,64), // new OracleParameter(":PRJ_DESCRIBE",OracleDbType.Varchar2,255), // new OracleParameter(":PRJ_DATE",OracleDbType.Date,7), // new OracleParameter(":PRJ_XML",OracleDbType.Blob,4000) // }; //byte[] byteXML = Encoding.Default.GetBytes(project.Prj_xml); //parameters[0].Value = project.Prj_name; //parameters[1].Value = project.Prj_describe; //parameters[2].Value = project.Prj_date; //parameters[3].Value = byteXML; //if (parameters != null) //{ // foreach (OracleParameter p in parameters) // { // command.Parameters.Add(p); // } // try // { // command.ExecuteNonQuery(); // command.CommandText = "select RISK_PROJECT_PRJ_ID.currval from dual "; // OracleDataReader reader = command.ExecuteReader(); // while (reader.Read()) // { // int id = Int32.Parse(reader.GetValue(0).ToString()); // return id; // } // } catch (System.Exception ex) // { // throw ex; // } finally // { // connDB.closeConn(); // } //} //return -1; string sql = @"insert into RISK_PROJECT(PRJ_ID,PRJ_NAME,PRJ_DESCRIBE,PRJ_DATE,PRJ_XML) values(RISK_PROJECT_PRJ_ID.NEXTVAL,:PRJ_NAME,:PRJ_DESCRIBE,:PRJ_DATE,to_blob(:PRJ_XML))"; OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":PRJ_NAME", OracleDbType.Varchar2, 64), new OracleParameter(":PRJ_DESCRIBE", OracleDbType.Varchar2, 255), new OracleParameter(":PRJ_DATE", OracleDbType.Date, 7), new OracleParameter(":PRJ_XML", OracleDbType.Blob, 4000) }; byte[] byteXML = Encoding.Default.GetBytes(project.Prj_xml); parameters[0].Value = project.Prj_name; parameters[1].Value = project.Prj_describe; parameters[2].Value = project.Prj_date; parameters[3].Value = byteXML; if (parameters != null) { try { SqlHelper.ExecuteNonQuery(sql, parameters); sql = "select RISK_PROJECT_PRJ_ID.currval from dual "; OracleParameter parameternull = null; using (OracleDataReader reader = SqlHelper.ExecuteQuery(sql, parameternull)) { while (reader.Read()) { int id = Int32.Parse(reader.GetValue(0).ToString()); return(id); } } } catch (System.Exception ex) { throw ex; } } return(-1); }
public bool deleteProject(MODEL.risk_project project) { return(true); }