public List <ArrangeClassEntity> GetSearch(string sort, string order, int offset, int pageSize, out int total)
{
int pageCount = 0;
string querySql = string.Format("select * from ArrangeClass(nolock) where valid = 'T'");
DataTable dt = SplitPage.SqlSplitPage(querySql, string.Format("order by {0} {1}", sort, order), null, offset / pageSize, pageSize, out pageCount, out total);
List <ArrangeClassEntity> list = new List <ArrangeClassEntity>();
foreach (DataRow dr in dt.Rows)
{
ArrangeClassEntity entity = new ArrangeClassEntity();
entity.ID = Ext.ToInt(dr["ID"]);
entity.CurriculumID = Ext.ToInt(dr["CurriculumID"]);
entity.ClassID = Ext.ToInt(dr["ClassID"]);
entity.ClassRoomID = Ext.ToInt(dr["ClassRoomID"]);
entity.TeacherID = Ext.ToInt(dr["TeacherID"]);
entity.StartTime = Ext.ToDateOrNull(dr["StartTime"]);
entity.EndTime = Ext.ToDateOrNull(dr["EndTime"]);
entity.Remark = Ext.ToString(dr["Remark"]);
entity.BespeakCount = Ext.ToIntOrNull(dr["BespeakCount"]);
entity.AttendCount = Ext.ToIntOrNull(dr["AttendCount"]);
entity.PassedCount = Ext.ToIntOrNull(dr["PassedCount"]);
entity.Valid = Ext.ToString(dr["Valid"]);
entity.CreateTime = Ext.ToDate(dr["CreateTime"]);
entity.CreateBy = Ext.ToString(dr["CreateBy"]);
entity.UpdateTime = Ext.ToDate(dr["UpdateTime"]);
entity.UpdateBy = Ext.ToString(dr["UpdateBy"]);
list.Add(entity);
}
return(list);
}
public void Update(ArrangeClassEntity entity)
{
entity.UpdateTime = DateTime.Now;
IDbSession session = SessionFactory.CreateSession();
try
{
session.BeginTrans();
Repository.Update <ArrangeClassEntity>(session.Connection, entity, session.Transaction);
session.Commit();
}
catch (System.Exception)
{
session.Rollback();
throw;
}
finally
{
session.Dispose();
}
}
public string DeleteArrangeClass(int id)
{
try
{
ArrangeClassManager manager = new ArrangeClassManager();
ArrangeClassEntity entity = manager.GetArrangeClassByID(id);
if (entity != null)
{
entity.Valid = "F";
entity.CreateTime = DateTime.Now;
entity.CreateTime = DateTime.Now;
manager.Update(entity);
}
return("success");
}
catch (Exception e)
{
return(e.ToString());
}
}
public string PostArrangeClass(ArrangeClassEntity entity)
{
try
{
if (entity == null || entity.ClassID <= 0 || entity.ClassRoomID <= 0 || entity.CurriculumID <= 0 || entity.TeacherID <= 0)
{
return("error");
}
ArrangeClassManager manager = new ArrangeClassManager();
entity.CreateTime = DateTime.Now;
entity.CreateTime = DateTime.Now;
manager.Insert(entity);
return("success");
}
catch (Exception e)
{
return(e.ToString());
}
}
public string PutArrangeClass(ArrangeClassEntity entity)
{
try
{
if (entity == null)
{
return("error");
}
ArrangeClassManager manager = new ArrangeClassManager();
entity.CreateTime = DateTime.Now;
entity.CreateTime = DateTime.Now;
manager.Update(entity);
return("success");
}
catch (Exception e)
{
return(e.ToString());
}
}
