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