/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.BASE_SHOUWEN entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BASE_SHOUWEN set ");
strSql.Append(" SID = :SID , ");
strSql.Append(" S_NUMBERS = :S_NUMBERS , ");
strSql.Append(" S_ORGAN = :S_ORGAN , ");
strSql.Append(" S_FROMDATE = :S_FROMDATE , ");
strSql.Append(" S_TITLE = :S_TITLE , ");
strSql.Append(" S_HANDLINGTIME = :S_HANDLINGTIME , ");
strSql.Append(" S_DEP_ORGAN = :S_DEP_ORGAN , ");
strSql.Append(" S_HANDLEPROGRESS = :S_HANDLEPROGRESS , ");
strSql.Append(" S_RESULT = :S_RESULT , ");
strSql.Append(" S_APPLICANT = :S_APPLICANT , ");
strSql.Append(" S_HANDLER = :S_HANDLER , ");
strSql.Append(" REMARKS = :REMARKS ");
strSql.Append(" where ");
OracleParameter[] parameters =
{
new OracleParameter(":SID", OracleType.Number, 4),
new OracleParameter(":S_NUMBERS", OracleType.VarChar, 50),
new OracleParameter(":S_ORGAN", OracleType.VarChar, 50),
new OracleParameter(":S_FROMDATE", OracleType.DateTime),
new OracleParameter(":S_TITLE", OracleType.VarChar, 50),
new OracleParameter(":S_HANDLINGTIME", OracleType.DateTime),
new OracleParameter(":S_DEP_ORGAN", OracleType.VarChar, 50),
new OracleParameter(":S_HANDLEPROGRESS", OracleType.VarChar, 50),
new OracleParameter(":S_RESULT", OracleType.VarChar, 200),
new OracleParameter(":S_APPLICANT", OracleType.VarChar, 50),
new OracleParameter(":S_HANDLER", OracleType.VarChar, 50),
new OracleParameter(":REMARKS", OracleType.VarChar, 200)
};
parameters[0].Value = entity.SID;
parameters[1].Value = entity.S_NUMBERS;
parameters[2].Value = entity.S_ORGAN;
parameters[3].Value = entity.S_FROMDATE;
parameters[4].Value = entity.S_TITLE;
parameters[5].Value = entity.S_HANDLINGTIME;
parameters[6].Value = entity.S_DEP_ORGAN;
parameters[7].Value = entity.S_HANDLEPROGRESS;
parameters[8].Value = entity.S_RESULT;
parameters[9].Value = entity.S_APPLICANT;
parameters[10].Value = entity.S_HANDLER;
parameters[11].Value = entity.REMARKS;
int rows = OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool update(Entity.BASE_SHOUWEN model)
{
if (dal.Update(model))
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Entity.BASE_SHOUWEN GetEntity(decimal SID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select SID, S_NUMBERS, S_ORGAN, S_FROMDATE, S_TITLE, S_HANDLINGTIME, S_DEP_ORGAN, S_HANDLEPROGRESS, S_RESULT, S_APPLICANT, S_HANDLER, REMARKS ");
strSql.Append(" from BASE_SHOUWEN ");
strSql.Append(" where ");
strSql.Append(" SID = :SID ");
OracleParameter[] parameters =
{
new OracleParameter(":SID", OracleType.Number, 4)
};
parameters[0].Value = SID;
Entity.BASE_SHOUWEN entity = new Entity.BASE_SHOUWEN();
DataTable dt = OracleHelper.Query(CommandType.Text, strSql.ToString(), parameters);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["SID"].ToString() != "")
{
entity.SID = decimal.Parse(dt.Rows[0]["SID"].ToString());
}
entity.S_NUMBERS = dt.Rows[0]["S_NUMBERS"].ToString();
entity.S_ORGAN = dt.Rows[0]["S_ORGAN"].ToString();
if (dt.Rows[0]["S_FROMDATE"].ToString() != "")
{
entity.S_FROMDATE = DateTime.Parse(dt.Rows[0]["S_FROMDATE"].ToString());
}
entity.S_TITLE = dt.Rows[0]["S_TITLE"].ToString();
if (dt.Rows[0]["S_HANDLINGTIME"].ToString() != "")
{
entity.S_HANDLINGTIME = DateTime.Parse(dt.Rows[0]["S_HANDLINGTIME"].ToString());
}
entity.S_DEP_ORGAN = dt.Rows[0]["S_DEP_ORGAN"].ToString();
entity.S_HANDLEPROGRESS = dt.Rows[0]["S_HANDLEPROGRESS"].ToString();
entity.S_RESULT = dt.Rows[0]["S_RESULT"].ToString();
entity.S_APPLICANT = dt.Rows[0]["S_APPLICANT"].ToString();
entity.S_HANDLER = dt.Rows[0]["S_HANDLER"].ToString();
entity.REMARKS = dt.Rows[0]["REMARKS"].ToString();
return(entity);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Entity.BASE_SHOUWEN entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BASE_SHOUWEN(");
strSql.Append("SID,S_NUMBERS,S_ORGAN,S_FROMDATE,S_TITLE,S_HANDLINGTIME,S_DEP_ORGAN,S_HANDLEPROGRESS,S_RESULT,S_APPLICANT,S_HANDLER,REMARKS");
strSql.Append(") values (");
strSql.Append(":SID,:S_NUMBERS,:S_ORGAN,:S_FROMDATE,:S_TITLE,:S_HANDLINGTIME,:S_DEP_ORGAN,:S_HANDLEPROGRESS,:S_RESULT,:S_APPLICANT,:S_HANDLER,:REMARKS");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":SID", OracleType.Number, 4),
new OracleParameter(":S_NUMBERS", OracleType.VarChar, 50),
new OracleParameter(":S_ORGAN", OracleType.VarChar, 50),
new OracleParameter(":S_FROMDATE", OracleType.DateTime),
new OracleParameter(":S_TITLE", OracleType.VarChar, 50),
new OracleParameter(":S_HANDLINGTIME", OracleType.DateTime),
new OracleParameter(":S_DEP_ORGAN", OracleType.VarChar, 50),
new OracleParameter(":S_HANDLEPROGRESS", OracleType.VarChar, 50),
new OracleParameter(":S_RESULT", OracleType.VarChar, 200),
new OracleParameter(":S_APPLICANT", OracleType.VarChar, 50),
new OracleParameter(":S_HANDLER", OracleType.VarChar, 50),
new OracleParameter(":REMARKS", OracleType.VarChar, 200)
};
parameters[0].Value = entity.SID;
parameters[1].Value = entity.S_NUMBERS;
parameters[2].Value = entity.S_ORGAN;
parameters[3].Value = entity.S_FROMDATE;
parameters[4].Value = entity.S_TITLE;
parameters[5].Value = entity.S_HANDLINGTIME;
parameters[6].Value = entity.S_DEP_ORGAN;
parameters[7].Value = entity.S_HANDLEPROGRESS;
parameters[8].Value = entity.S_RESULT;
parameters[9].Value = entity.S_APPLICANT;
parameters[10].Value = entity.S_HANDLER;
parameters[11].Value = entity.REMARKS;
OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 新建公文
/// </summary>
/// <param name="model">公文实体</param>
public void Add(Entity.BASE_SHOUWEN model)
{
dal.Add(model);
}
