/// <summary>
///根据SQL语句返回集合
/// </summary>
private IList <Tbl_Class> getTbl_ClasssBySql(string sql)
{
IList <Tbl_Class> list = new List <Tbl_Class>();
DataSet ds = DBHelper.ExecuteDataset(this.connection, CommandType.Text, sql);
if (ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
Tbl_Class tbl_class = new Tbl_Class();
tbl_class.ID = Convert.ToInt32(dr["ID"]);
tbl_class.ClassName = Convert.ToString(dr["ClassName"]);
tbl_class.ParentID = Convert.ToInt32(dr["ParentID"]);
tbl_class.Remark = Convert.ToString(dr["Remark"]);
tbl_class.OrderNum = Convert.ToInt32(dr["OrderNum"]);
tbl_class.Status = Convert.ToString(dr["Status"]);
tbl_class.DealFlag = Convert.ToInt32(dr["DealFlag"]);
tbl_class.DealUser = Convert.ToString(dr["DealUser"]);
tbl_class.DealTime = Convert.ToDateTime(dr["DealTime"]);
tbl_class.AddDate = Convert.ToDateTime(dr["AddDate"]);
list.Add(tbl_class);
}
}
return(list);
}
public static int UpdateTbl_Class(Tbl_Class tbl_class)
{
WebCommon.Public.WriteLog("修改分类：" + tbl_class.ClassName);
tbl_class.DealUser = WebCommon.Public.GetUserName();
tbl_class.DealTime = DateTime.Now;
return(new Tbl_ClassService().UpdateTbl_ClassById(tbl_class));
}
public ActionResult UpdateClass(Tbl_Class class_)
{
var val = db.Tbl_Class.Find(class_.ClassId);
val.ClassName = class_.ClassName;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public JsonResult DeleteClass(int classID)
{
bool resul = false;
Tbl_Class sc = db.Tbl_Class.SingleOrDefault(x => x.Class_Id == classID);
if (sc != null)
{
db.Tbl_Class.Remove(sc);
db.SaveChanges();
resul = true;
}
return(Json(resul, JsonRequestBehavior.AllowGet));
}
public int AddTbl_Class(Tbl_Class tbl_class)
{
string sql = "insert into [Tbl_Class] ([ClassName],[ParentID],[Remark],[OrderNum],[Status],[DealUser]) values (@ClassName,@ParentID,@Remark,@OrderNum,@Status,@DealUser)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ClassName", tbl_class.ClassName),
new SqlParameter("@ParentID", tbl_class.ParentID),
new SqlParameter("@Remark", tbl_class.Remark),
new SqlParameter("@OrderNum", tbl_class.OrderNum),
new SqlParameter("@Status", tbl_class.Status),
new SqlParameter("@DealUser", tbl_class.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
private string RegNo(tbl_TeacherValidation teacher)
{
int id = db.Teachers.Count(s => (s.Class_Id == teacher.Class_Id) &&
(teacher.JoiningDate.Year == teacher.JoiningDate.Year)) + 1;
Tbl_Class aClass = db.Tbl_Class.Where(d => d.Class_Id == teacher.Class_Id).FirstOrDefault();
string registrationId = aClass.Name + "-" + teacher.JoiningDate.Year + "-";
string addZero = "";
int len = 3 - id.ToString().Length;
for (int i = 0; i < len; i++)
{
addZero = "0" + addZero;
}
return(registrationId + addZero + id);
}
public int UpdateTbl_ClassById(Tbl_Class tbl_class)
{
string sql = "update [Tbl_Class] set [ClassName]=@ClassName,[ParentID]=@ParentID,[Remark]=@Remark,[OrderNum]=@OrderNum,[Status]=@Status,[DealFlag]=@DealFlag,[DealUser]=@DealUser,[DealTime]=@DealTime where DealFlag=0 and [ID]=@ID";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ClassName", tbl_class.ClassName),
new SqlParameter("@ParentID", tbl_class.ParentID),
new SqlParameter("@Remark", tbl_class.Remark),
new SqlParameter("@OrderNum", tbl_class.OrderNum),
new SqlParameter("@Status", tbl_class.Status),
new SqlParameter("@DealFlag", tbl_class.DealFlag),
new SqlParameter("@DealUser", tbl_class.DealUser),
new SqlParameter("@DealTime", tbl_class.DealTime.ToString()),
new SqlParameter("@ID", tbl_class.ID)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public ActionResult addClass(tbl_ClassValidation cv)
{
try
{
Tbl_Class c = new Tbl_Class();
c.SchoolId = Convert.ToInt32(Session["school"]);
c.Name = cv.Name;
db.Tbl_Class.Add(c);
db.SaveChanges();
ModelState.Clear();
ViewBag.Message = "Data Submitted";
}
catch (Exception ex)
{
ViewBag.Message = "Not Submitted";
return(View());
}
return(View());
}
public ActionResult updateClass(Tbl_Class dat, int id)
{
try
{
var data = db.Tbl_Class.Where(x => x.Class_Id == id).First();
if (data != null)
{
data.Name = dat.Name;
db.Entry(data).State = EntityState.Modified;
db.SaveChanges();
ViewBag.Message = "Data Successfully Updated";
ModelState.Clear();
}
}
catch (Exception ex)
{
ViewBag.Message = "Not Submitted";
return(View());
}
return(RedirectToAction("viewsClass", "Class"));
}
public static int AddTbl_Class(Tbl_Class tbl_class)
{
WebCommon.Public.WriteLog("添加分类：" + tbl_class.ClassName);
return(new Tbl_ClassService().AddTbl_Class(tbl_class));
}
public ActionResult NewClass(Tbl_Class class_)
{
db.Tbl_Class.Add(class_);
db.SaveChanges();
return(RedirectToAction("Index"));
}
