public bool insertNewEntity(PhotoFlow s)
{
int rowsAffected = 0;
SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@FlowTitle", SqlDbType.NVarChar), new SqlParameter("@CreateDate", SqlDbType.NVarChar), new SqlParameter("@UserName", SqlDbType.NVarChar), new SqlParameter("@Content", SqlDbType.NVarChar), new SqlParameter("@State", SqlDbType.Int) };
parameters[0].Value = s.FlowTitle;
parameters[1].Value = s.CreateDate;
parameters[2].Value = s.UserName;
parameters[3].Value = s.Content;
parameters[4].Value = s.State;
SQLHelper.RunProcedure("p_PhotoFlow_insertNewEntity", parameters, out rowsAffected);
return(1 == rowsAffected);
}
public List <PhotoFlow> getSearchList()
{
List <PhotoFlow> list = new List <PhotoFlow>();
SqlDataReader reader = SQLHelper.RunProcedure("p_PhotoFlow_getSearchList", null);
while (reader.Read())
{
PhotoFlow item = new PhotoFlow();
item.Content = reader.GetString(reader.GetOrdinal("Content"));
item.CreateDate = reader.GetString(reader.GetOrdinal("CreateDate"));
item.FlowID = reader.GetInt32(reader.GetOrdinal("FlowID"));
item.FlowTitle = reader.GetString(reader.GetOrdinal("FlowTitle"));
item.Reply = reader.GetString(reader.GetOrdinal("Reply"));
item.State = reader.GetInt32(reader.GetOrdinal("State"));
item.UserName = reader.GetString(reader.GetOrdinal("UserName"));
item.AuditingUser = reader.GetString(reader.GetOrdinal("AuditingUser"));
list.Add(item);
}
reader.Close();
return(list);
}
public PhotoFlow getByID(int FlowID)
{
PhotoFlow flow = new PhotoFlow();
SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@FlowID", SqlDbType.Int) };
parameters[0].Value = FlowID;
SqlDataReader reader = SQLHelper.RunProcedure("p_PhotoFlow_getByID", parameters);
while (reader.Read())
{
flow.Content = reader.GetString(reader.GetOrdinal("Content"));
flow.CreateDate = reader.GetString(reader.GetOrdinal("CreateDate"));
flow.FlowID = reader.GetInt32(reader.GetOrdinal("FlowID"));
flow.FlowTitle = reader.GetString(reader.GetOrdinal("FlowTitle"));
flow.Reply = reader.GetString(reader.GetOrdinal("Reply"));
flow.State = reader.GetInt32(reader.GetOrdinal("State"));
flow.UserName = reader.GetString(reader.GetOrdinal("UserName"));
flow.AuditingUser = reader.GetString(reader.GetOrdinal("AuditingUser"));
}
reader.Close();
return(flow);
}
