/// <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")); }