private static List <SchoolItem> Get(SqlCommand SqlCommand)
{
List <SchoolItem> SchoolItems = new List <SchoolItem>();
using (SqlConnection SqlConnection = ConnectionManager.GetConnection())
{
using (SqlCommand.Connection = SqlConnection)
{
SqlConnection.Open();
SqlDataReader SqlDataReader = SqlCommand.ExecuteReader();
while (SqlDataReader.Read())
{
string AreaItemId = (string)SqlDataReader["AreaItemId"];
string Id = (string)SqlDataReader["Id"];
string Name = (string)SqlDataReader["Name"];
int Sort = (int)SqlDataReader["Sort"];
DateTime UpdateTime = (DateTime)SqlDataReader["UpdateTime"];
DateTime CreateTime = (DateTime)SqlDataReader["CreateTime"];
SchoolItem SchoolItem = new SchoolItem(AreaItemId, Id, Name, Sort, UpdateTime, CreateTime);
SchoolItems.Add(SchoolItem);
}
}
}
return(SchoolItems);
}
public static void Remove(SchoolItem SchoolItem)
{
//更新資料庫
SchoolItemAccessor.Delete(SchoolItem);
//更新記憶体
_SchoolItemCache.Remove(SchoolItem);
}
internal static void Delete(SchoolItem SchoolItem)
{
using (SqlConnection SqlConnection = ConnectionManager.GetConnection())
{
using (SqlCommand SqlCommand = SqlConnection.CreateCommand())
{
SqlCommand.CommandText = "Delete "
+ " School_SchoolItem "
+ "WHERE "
+ " Id = @Id ";
SqlCommand.Parameters.AddWithValue("Id", SchoolItem.Id);
SqlConnection.Open();
SqlCommand.ExecuteNonQuery();
}
}
}
internal static void UpdateInsert(SchoolItem SchoolItem)
{
using (SqlConnection SqlConnection = ConnectionManager.GetConnection())
{
using (SqlCommand SqlCommand = SqlConnection.CreateCommand())
{
SqlCommand.CommandText = "UPDATE "
+ " School_SchoolItem "
+ "SET "
+ " AreaItemId = @AreaItemId "
+ " ,Name = @Name "
+ " ,Sort = @Sort "
+ " ,UpdateTime = @UpdateTime "
+ " ,CreateTime = @CreateTime "
+ "WHERE "
+ " Id = @Id "
+ "IF @@ROWCOUNT = 0 "
+ "BEGIN "
+ "INSERT INTO "
+ " School_SchoolItem "
+ "( AreaItemId, Id, Name, Sort, UpdateTime, CreateTime ) "
+ "VALUES "
+ "( @AreaItemId, @Id, @Name, @Sort, @UpdateTime, @CreateTime ) "
+ "END ";
SqlCommand.Parameters.AddWithValue("AreaItemId", SchoolItem.AreaItemId);
SqlCommand.Parameters.AddWithValue("Id", SchoolItem.Id);
SqlCommand.Parameters.AddWithValue("Name", SchoolItem.Name);
SqlCommand.Parameters.AddWithValue("Sort", SchoolItem.Sort);
SqlCommand.Parameters.AddWithValue("UpdateTime", SchoolItem.UpdateTime);
SqlCommand.Parameters.AddWithValue("CreateTime", SchoolItem.CreateTime);
SqlConnection.Open();
SqlCommand.ExecuteNonQuery();
}
}
}
public static void Save(SchoolItem SchoolItem)
{
lock (SaveObject)
{
if (SchoolItem.Id == "-1")
{
SchoolItem.Id = Guid.NewGuid().ToString();
}
SchoolItem.UpdateTime = DateTime.Now;
//更新資料庫
SchoolItemAccessor.UpdateInsert(SchoolItem);
//更新記憶體
_SchoolItemCache.Remove(SchoolItem);
_SchoolItemCache.Add(SchoolItem);
_SchoolItemCache.OrderBy(b => b.Id)
.ThenByDescending(c => c.CreateTime)
.ToList();
}
}