/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Entity.BASE_PROCEDURE entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BASE_PROCEDURE(");
strSql.Append("PID,REQUISITIONID,DEPARTMENT,TRANSACTOR,CONTENTS,RESULT,P_DATE,P_STATUS");
strSql.Append(") values (");
strSql.Append(":PID,:REQUISITIONID,:DEPARTMENT,:TRANSACTOR,:CONTENTS,:RESULT,:P_DATE,:P_STATUS");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":PID", OracleType.Number, 4),
new OracleParameter(":REQUISITIONID", OracleType.Number, 4),
new OracleParameter(":DEPARTMENT", OracleType.VarChar, 50),
new OracleParameter(":TRANSACTOR", OracleType.VarChar, 50),
new OracleParameter(":CONTENTS", OracleType.VarChar, 50),
new OracleParameter(":RESULT", OracleType.VarChar, 50),
new OracleParameter(":P_DATE", OracleType.DateTime),
new OracleParameter(":P_STATUS", OracleType.Number, 4)
};
parameters[0].Value = entity.PID;
parameters[1].Value = entity.REQUISITIONID;
parameters[2].Value = entity.DEPARTMENT;
parameters[3].Value = entity.TRANSACTOR;
parameters[4].Value = entity.CONTENTS;
parameters[5].Value = entity.RESULT;
parameters[6].Value = entity.P_DATE;
parameters[7].Value = entity.P_STATUS;
OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.BASE_PROCEDURE entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BASE_PROCEDURE set ");
strSql.Append(" PID = :PID , ");
strSql.Append(" REQUISITIONID = :REQUISITIONID , ");
strSql.Append(" DEPARTMENT = :DEPARTMENT , ");
strSql.Append(" TRANSACTOR = :TRANSACTOR , ");
strSql.Append(" CONTENTS = :CONTENTS , ");
strSql.Append(" RESULT = :RESULT , ");
strSql.Append(" P_DATE = :P_DATE , ");
strSql.Append(" P_STATUS = :P_STATUS ");
strSql.Append(" where PID=:PID ");
OracleParameter[] parameters =
{
new OracleParameter(":PID", OracleType.Number, 4),
new OracleParameter(":REQUISITIONID", OracleType.Number, 4),
new OracleParameter(":DEPARTMENT", OracleType.VarChar, 50),
new OracleParameter(":TRANSACTOR", OracleType.VarChar, 50),
new OracleParameter(":CONTENTS", OracleType.VarChar, 50),
new OracleParameter(":RESULT", OracleType.VarChar, 50),
new OracleParameter(":P_DATE", OracleType.DateTime),
new OracleParameter(":P_STATUS", OracleType.Number, 4)
};
parameters[0].Value = entity.PID;
parameters[1].Value = entity.REQUISITIONID;
parameters[2].Value = entity.DEPARTMENT;
parameters[3].Value = entity.TRANSACTOR;
parameters[4].Value = entity.CONTENTS;
parameters[5].Value = entity.RESULT;
parameters[6].Value = entity.P_DATE;
parameters[7].Value = entity.P_STATUS;
int rows = OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Entity.BASE_PROCEDURE GetEntity(decimal PID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select PID, REQUISITIONID, DEPARTMENT, TRANSACTOR, CONTENTS, RESULT, P_DATE, P_STATUS ");
strSql.Append(" from BASE_PROCEDURE ");
strSql.Append(" where PID=:PID ");
OracleParameter[] parameters =
{
new OracleParameter(":PID", OracleType.Number, 4)
};
parameters[0].Value = PID;
Entity.BASE_PROCEDURE entity = new Entity.BASE_PROCEDURE();
DataTable dt = OracleHelper.Query(CommandType.Text, strSql.ToString(), parameters);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["PID"].ToString() != "")
{
entity.PID = decimal.Parse(dt.Rows[0]["PID"].ToString());
}
if (dt.Rows[0]["REQUISITIONID"].ToString() != "")
{
entity.REQUISITIONID = decimal.Parse(dt.Rows[0]["REQUISITIONID"].ToString());
}
entity.DEPARTMENT = dt.Rows[0]["DEPARTMENT"].ToString();
entity.TRANSACTOR = dt.Rows[0]["TRANSACTOR"].ToString();
entity.CONTENTS = dt.Rows[0]["CONTENTS"].ToString();
entity.RESULT = dt.Rows[0]["RESULT"].ToString();
if (dt.Rows[0]["P_DATE"].ToString() != "")
{
entity.P_DATE = DateTime.Parse(dt.Rows[0]["P_DATE"].ToString());
}
if (dt.Rows[0]["P_STATUS"].ToString() != "")
{
entity.P_STATUS = decimal.Parse(dt.Rows[0]["P_STATUS"].ToString());
}
return(entity);
}
else
{
return(null);
}
}
