public int Update(PTBulletinMainModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update PT_BULLETIN_MAIN set ");
builder.Append("CorpCode=@CorpCode,");
builder.Append("V_RELUSERCODE=@V_RELUSERCODE,");
builder.Append("V_RELEASEUSER=@V_RELEASEUSER,");
builder.Append("V_TITLE=@V_TITLE,");
builder.Append("V_CONTENT=@V_CONTENT,");
builder.Append("URL=@URL,");
builder.Append("DTM_RELEASETIME=@DTM_RELEASETIME,");
builder.Append("DTM_EXPRIESDATE=@DTM_EXPRIESDATE,");
builder.Append("I_RELEASEBOUND=@I_RELEASEBOUND,");
builder.Append("DeptRange=@DeptRange,");
builder.Append("AuditState=@AuditState");
builder.Append(" where I_BULLETINID=@I_BULLETINID ");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@I_BULLETINID", SqlDbType.UniqueIdentifier, 0x10), new SqlParameter("@CorpCode", SqlDbType.VarChar, 20), new SqlParameter("@V_RELUSERCODE", SqlDbType.VarChar, 8), new SqlParameter("@V_RELEASEUSER", SqlDbType.VarChar, 50), new SqlParameter("@V_TITLE", SqlDbType.VarChar, 200), new SqlParameter("@V_CONTENT", SqlDbType.VarChar), new SqlParameter("@URL", SqlDbType.VarChar, 100), new SqlParameter("@DTM_RELEASETIME", SqlDbType.DateTime), new SqlParameter("@DTM_EXPRIESDATE", SqlDbType.DateTime), new SqlParameter("@I_RELEASEBOUND", SqlDbType.Int, 4), new SqlParameter("@DeptRange", SqlDbType.VarChar, 200), new SqlParameter("@AuditState", SqlDbType.Int, 4) };
commandParameters[0].Value = model.I_BULLETINID;
commandParameters[1].Value = model.CorpCode;
commandParameters[2].Value = model.V_RELUSERCODE;
commandParameters[3].Value = model.V_RELEASEUSER;
commandParameters[4].Value = model.V_TITLE;
commandParameters[5].Value = model.V_CONTENT;
commandParameters[6].Value = model.URL;
commandParameters[7].Value = model.DTM_RELEASETIME;
commandParameters[8].Value = model.DTM_EXPRIESDATE;
commandParameters[9].Value = model.I_RELEASEBOUND;
commandParameters[10].Value = model.DeptRange;
commandParameters[11].Value = model.AuditState;
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters));
}
public PTBulletinMainModel GetModel(string I_BULLETINID)
{
StringBuilder builder = new StringBuilder();
builder.Append("select I_BULLETINID,CorpCode,V_RELUSERCODE,V_RELEASEUSER,V_TITLE,V_CONTENT,URL,DTM_RELEASETIME,DTM_EXPRIESDATE,I_RELEASEBOUND,DeptRange,AuditState from PT_BULLETIN_MAIN ");
builder.Append(" where I_BULLETINID=@I_BULLETINID ");
PTBulletinMainModel model = null;
using (IDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, builder.ToString(), new SqlParameter[] { new SqlParameter("@I_BULLETINID", I_BULLETINID) }))
{
if (reader.Read())
{
model = this.ReaderBind(reader);
}
}
return(model);
}
public PTBulletinMainModel ReaderBind(IDataReader dataReader)
{
PTBulletinMainModel model = new PTBulletinMainModel();
object obj2 = dataReader["I_BULLETINID"];
if ((obj2 != null) && (obj2 != DBNull.Value))
{
model.I_BULLETINID = new Guid(obj2.ToString());
}
model.CorpCode = dataReader["CorpCode"].ToString();
model.V_RELUSERCODE = dataReader["V_RELUSERCODE"].ToString();
model.V_RELEASEUSER = dataReader["V_RELEASEUSER"].ToString();
model.V_TITLE = dataReader["V_TITLE"].ToString();
model.V_CONTENT = dataReader["V_CONTENT"].ToString();
model.URL = dataReader["URL"].ToString();
obj2 = dataReader["DTM_RELEASETIME"];
if ((obj2 != null) && (obj2 != DBNull.Value))
{
model.DTM_RELEASETIME = (DateTime)obj2;
}
obj2 = dataReader["DTM_EXPRIESDATE"];
if ((obj2 != null) && (obj2 != DBNull.Value))
{
model.DTM_EXPRIESDATE = (DateTime)obj2;
}
obj2 = dataReader["I_RELEASEBOUND"];
if ((obj2 != null) && (obj2 != DBNull.Value))
{
model.I_RELEASEBOUND = (int)obj2;
}
model.DeptRange = dataReader["DeptRange"].ToString();
obj2 = dataReader["AuditState"];
if ((obj2 != null) && (obj2 != DBNull.Value))
{
model.AuditState = (int)obj2;
}
return(model);
}
public int Add(PTBulletinMainModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into PT_BULLETIN_MAIN(");
builder.Append("I_BULLETINID,CorpCode,V_RELUSERCODE,V_RELEASEUSER,V_TITLE,V_CONTENT,URL,DTM_RELEASETIME,DTM_EXPRIESDATE,I_RELEASEBOUND,DeptRange,AuditState)");
builder.Append(" values (");
builder.Append("@I_BULLETINID,@CorpCode,@V_RELUSERCODE,@V_RELEASEUSER,@V_TITLE,@V_CONTENT,@URL,@DTM_RELEASETIME,@DTM_EXPRIESDATE,@I_RELEASEBOUND,@DeptRange,@AuditState)");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@I_BULLETINID", SqlDbType.UniqueIdentifier, 0x10), new SqlParameter("@CorpCode", SqlDbType.VarChar, 20), new SqlParameter("@V_RELUSERCODE", SqlDbType.VarChar, 8), new SqlParameter("@V_RELEASEUSER", SqlDbType.VarChar, 50), new SqlParameter("@V_TITLE", SqlDbType.VarChar, 200), new SqlParameter("@V_CONTENT", SqlDbType.VarChar), new SqlParameter("@URL", SqlDbType.VarChar, 100), new SqlParameter("@DTM_RELEASETIME", SqlDbType.DateTime), new SqlParameter("@DTM_EXPRIESDATE", SqlDbType.DateTime), new SqlParameter("@I_RELEASEBOUND", SqlDbType.Int, 4), new SqlParameter("@DeptRange", SqlDbType.VarChar, 200), new SqlParameter("@AuditState", SqlDbType.Int, 4) };
commandParameters[0].Value = model.I_BULLETINID;
commandParameters[1].Value = model.CorpCode;
commandParameters[2].Value = model.V_RELUSERCODE;
commandParameters[3].Value = model.V_RELEASEUSER;
commandParameters[4].Value = model.V_TITLE;
commandParameters[5].Value = model.V_CONTENT;
commandParameters[6].Value = model.URL;
commandParameters[7].Value = model.DTM_RELEASETIME;
commandParameters[8].Value = model.DTM_EXPRIESDATE;
commandParameters[9].Value = model.I_RELEASEBOUND;
commandParameters[10].Value = model.DeptRange;
commandParameters[11].Value = model.AuditState;
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters));
}