/// <summary>
/// 得到一个对象实体
/// </summary>
public Entity.BASE_CASE_CLOSED GetEntity(decimal ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID, MOTIONTIME, MOTIONLOCATION, MOTIONPRO, RECORD, DISCUSS, LEAD, CLOSEDTIME, RECOVERLOSS, CLOSEDEAY, RESULT, REMARK, CASEID ");
strSql.Append(" from BASE_CASE_CLOSED ");
strSql.Append(" where ID=:ID ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleType.Number, 4)
};
parameters[0].Value = ID;
Entity.BASE_CASE_CLOSED entity = new Entity.BASE_CASE_CLOSED();
DataTable dt = OracleHelper.Query(CommandType.Text, strSql.ToString(), parameters);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["ID"].ToString() != "")
{
entity.ID = decimal.Parse(dt.Rows[0]["ID"].ToString());
}
if (dt.Rows[0]["MOTIONTIME"].ToString() != "")
{
entity.MOTIONTIME = DateTime.Parse(dt.Rows[0]["MOTIONTIME"].ToString());
}
if (dt.Rows[0]["MOTIONLOCATION"].ToString() != "")
{
entity.MOTIONLOCATION = DateTime.Parse(dt.Rows[0]["MOTIONLOCATION"].ToString());
}
entity.MOTIONPRO = dt.Rows[0]["MOTIONPRO"].ToString();
entity.RECORD = dt.Rows[0]["RECORD"].ToString();
entity.DISCUSS = dt.Rows[0]["DISCUSS"].ToString();
entity.LEAD = dt.Rows[0]["LEAD"].ToString();
if (dt.Rows[0]["CLOSEDTIME"].ToString() != "")
{
entity.CLOSEDTIME = DateTime.Parse(dt.Rows[0]["CLOSEDTIME"].ToString());
}
if (dt.Rows[0]["RECOVERLOSS"].ToString() != "")
{
entity.RECOVERLOSS = decimal.Parse(dt.Rows[0]["RECOVERLOSS"].ToString());
}
entity.CLOSEDEAY = dt.Rows[0]["CLOSEDEAY"].ToString();
entity.RESULT = dt.Rows[0]["RESULT"].ToString();
entity.REMARK = dt.Rows[0]["REMARK"].ToString();
if (dt.Rows[0]["CASEID"].ToString() != "")
{
entity.CASEID = decimal.Parse(dt.Rows[0]["CASEID"].ToString());
}
return(entity);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Entity.BASE_CASE_CLOSED entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BASE_CASE_CLOSED(");
strSql.Append("ID,MOTIONTIME,MOTIONLOCATION,MOTIONPRO,RECORD,DISCUSS,LEAD,CLOSEDTIME,RECOVERLOSS,CLOSEDEAY,RESULT,REMARK,CASEID");
strSql.Append(") values (");
strSql.Append(":ID,:MOTIONTIME,:MOTIONLOCATION,:MOTIONPRO,:RECORD,:DISCUSS,:LEAD,:CLOSEDTIME,:RECOVERLOSS,:CLOSEDEAY,:RESULT,:REMARK,:CASEID");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleType.Number, 4),
new OracleParameter(":MOTIONTIME", OracleType.DateTime),
new OracleParameter(":MOTIONLOCATION", OracleType.DateTime),
new OracleParameter(":MOTIONPRO", OracleType.VarChar, 50),
new OracleParameter(":RECORD", OracleType.VarChar, 50),
new OracleParameter(":DISCUSS", OracleType.VarChar, 500),
new OracleParameter(":LEAD", OracleType.VarChar, 500),
new OracleParameter(":CLOSEDTIME", OracleType.DateTime),
new OracleParameter(":RECOVERLOSS", OracleType.Number, 4),
new OracleParameter(":CLOSEDEAY", OracleType.VarChar, 500),
new OracleParameter(":RESULT", OracleType.VarChar, 500),
new OracleParameter(":REMARK", OracleType.VarChar, 500),
new OracleParameter(":CASEID", OracleType.Number, 4)
};
parameters[0].Value = entity.ID;
parameters[1].Value = entity.MOTIONTIME;
parameters[2].Value = entity.MOTIONLOCATION;
parameters[3].Value = entity.MOTIONPRO;
parameters[4].Value = entity.RECORD;
parameters[5].Value = entity.DISCUSS;
parameters[6].Value = entity.LEAD;
parameters[7].Value = entity.CLOSEDTIME;
parameters[8].Value = entity.RECOVERLOSS;
parameters[9].Value = entity.CLOSEDEAY;
parameters[10].Value = entity.RESULT;
parameters[11].Value = entity.REMARK;
parameters[12].Value = entity.CASEID;
OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.BASE_CASE_CLOSED entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BASE_CASE_CLOSED set ");
strSql.Append(" ID = :ID , ");
strSql.Append(" MOTIONTIME = :MOTIONTIME , ");
strSql.Append(" MOTIONLOCATION = :MOTIONLOCATION , ");
strSql.Append(" MOTIONPRO = :MOTIONPRO , ");
strSql.Append(" RECORD = :RECORD , ");
strSql.Append(" DISCUSS = :DISCUSS , ");
strSql.Append(" LEAD = :LEAD , ");
strSql.Append(" CLOSEDTIME = :CLOSEDTIME , ");
strSql.Append(" RECOVERLOSS = :RECOVERLOSS , ");
strSql.Append(" CLOSEDEAY = :CLOSEDEAY , ");
strSql.Append(" RESULT = :RESULT , ");
strSql.Append(" REMARK = :REMARK , ");
strSql.Append(" CASEID = :CASEID ");
strSql.Append(" where ID=:ID ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleType.Number, 4),
new OracleParameter(":MOTIONTIME", OracleType.DateTime),
new OracleParameter(":MOTIONLOCATION", OracleType.DateTime),
new OracleParameter(":MOTIONPRO", OracleType.VarChar, 50),
new OracleParameter(":RECORD", OracleType.VarChar, 50),
new OracleParameter(":DISCUSS", OracleType.VarChar, 500),
new OracleParameter(":LEAD", OracleType.VarChar, 500),
new OracleParameter(":CLOSEDTIME", OracleType.DateTime),
new OracleParameter(":RECOVERLOSS", OracleType.Number, 4),
new OracleParameter(":CLOSEDEAY", OracleType.VarChar, 500),
new OracleParameter(":RESULT", OracleType.VarChar, 500),
new OracleParameter(":REMARK", OracleType.VarChar, 500),
new OracleParameter(":CASEID", OracleType.Number, 4)
};
parameters[13].Value = entity.ID;
parameters[14].Value = entity.MOTIONTIME;
parameters[15].Value = entity.MOTIONLOCATION;
parameters[16].Value = entity.MOTIONPRO;
parameters[17].Value = entity.RECORD;
parameters[18].Value = entity.DISCUSS;
parameters[19].Value = entity.LEAD;
parameters[20].Value = entity.CLOSEDTIME;
parameters[21].Value = entity.RECOVERLOSS;
parameters[22].Value = entity.CLOSEDEAY;
parameters[23].Value = entity.RESULT;
parameters[24].Value = entity.REMARK;
parameters[25].Value = entity.CASEID;
int rows = OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
