/// <summary> /// 得到一个对象实体,从缓存中 /// </summary> public TDTK.PlatForm.MVC4.Model.Sys_Operator GetModelByCache(string UserCode) { Sys_Operator so = new Sys_Operator(); so.UserCode = UserCode; string CacheKey = "Sys_OperatorModel-" + UserCode; object objModel = Maticsoft.Common.DataCache.GetCache(CacheKey); if (objModel == null) { try { objModel = dal.GetModel(so); if (objModel != null) { int ModelCache = Maticsoft.Common.ConfigHelper.GetConfigInt("ModelCache"); Maticsoft.Common.DataCache.SetCache(CacheKey, objModel, DateTime.Now.AddMinutes(ModelCache), TimeSpan.Zero); } } catch { } } return (TDTK.PlatForm.MVC4.Model.Sys_Operator)objModel; }
public Sys_Operator GetModel(Sys_Operator t) { return dal.GetModel(t); }
public bool Update(Sys_Operator t) { return dal.Update(t); }
public bool Delete(Sys_Operator t) { return dal.Delete(t); }
public bool Exists(Sys_Operator t) { return dal.Exists(t); }
public int Add(Sys_Operator t) { return dal.Add(t); }
/// <summary> /// 获取一条数据 /// </summary> /// <returns></returns> public ActionResult GetDemoByID() { string UserCode = ""; if (Request["UserCode"] != null) { UserCode = Request["UserCode"].ToString(); } BLL.Sys_OperatorBLL pb = new Sys_OperatorBLL(); Model.Sys_Operator p = new TDTK.PlatForm.MVC4.Model.Sys_Operator(); p.UserCode = UserCode; Model.Sys_Operator pp = new TDTK.PlatForm.MVC4.Model.Sys_Operator(); if (!string.IsNullOrEmpty(UserCode)) { pp = pb.GetModel(p); } return Json(pp, JsonRequestBehavior.AllowGet); }
/// <summary> /// 删除数据 /// </summary> /// <returns></returns> public ActionResult Delete() { string UserCode = ""; if (Request["UserCode"] != null) { UserCode = Request["UserCode"].ToString(); Model.Sys_Operator p = new TDTK.PlatForm.MVC4.Model.Sys_Operator(); BLL.Sys_OperatorBLL pb = new Sys_OperatorBLL(); p.UserCode = UserCode; if (pb.Delete(p)) { return Content("ok"); } else { return Content("no"); } } else { return Content("no"); } }
public ActionResult IsForbid() { //IsForbid PositionCode string UserCode = ""; if (Request["UserCode"] != null) { UserCode = Request["UserCode"].ToString(); } else { return Content("no:数据异常!"); } #region 数据禁用、启用 if (!string.IsNullOrEmpty(UserCode)) { BLL.Sys_OperatorBLL pbl = new Sys_OperatorBLL(); Model.Sys_Operator p = new TDTK.PlatForm.MVC4.Model.Sys_Operator(); p.UserCode = UserCode; p = pbl.GetModel(p); string IsForbid = p.IsForbid; if (IsForbid == "1") { p.IsForbid = "0"; } else { p.IsForbid = "1"; } if (pbl.Update(p)) { if (IsForbid == "0") { return Content("ok:禁用成功!"); } else { return Content("ok:启用成功!"); } } else { return Content("no:操作失败!"); } } #endregion else { return Content("no:操作有误!"); } }
public Model.Sys_Operator DataRowToModel(DataRow row) { TDTK.PlatForm.MVC4.Model.Sys_Operator model = new TDTK.PlatForm.MVC4.Model.Sys_Operator(); if (row != null) { if (row["UserCode"] != null) { model.UserCode = row["UserCode"].ToString(); } if (row["UserName"] != null) { model.UserName = row["UserName"].ToString(); } if (row["Password"] != null) { model.Password = row["Password"].ToString(); } if (row["IsForbid"] != null) { model.IsForbid = row["IsForbid"].ToString(); } if (row["OrgCode"] != null) { model.OrgCode = row["OrgCode"].ToString(); } if (row["Tel"] != null) { model.Tel = row["Tel"].ToString(); } if (row["Email"] != null) { model.Email = row["Email"].ToString(); } if (row["Address"] != null) { model.Address = row["Address"].ToString(); } if (row["ZipCode"] != null) { model.ZipCode = row["ZipCode"].ToString(); } if (row["PID"] != null) { model.PID = row["PID"].ToString(); } if (row["Gender"] != null) { model.Gender = row["Gender"].ToString(); } if (row["RegDate"] != null && row["RegDate"].ToString() != "") { model.RegDate = DateTime.Parse(row["RegDate"].ToString()); } if (row["MobileNo"] != null) { model.MobileNo = row["MobileNo"].ToString(); } if (row["TypeCode"] != null) { model.TypeCode = row["TypeCode"].ToString(); } if (row["IsChangePwd"] != null) { model.IsChangePwd = row["IsChangePwd"].ToString(); } } return model; }
public Model.Sys_Operator GetModel(Model.Sys_Operator t) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 UserCode,UserName,Password,IsForbid,OrgCode,Tel,Email,Address,ZipCode,PID,Gender,RegDate,MobileNo,TypeCode,IsChangePwd from Sys_Operator "); strSql.Append(" where UserCode=@UserCode "); SqlParameter[] parameters = { new SqlParameter("@UserCode", SqlDbType.VarChar,10) }; parameters[0].Value = t.UserCode; TDTK.PlatForm.MVC4.Model.Sys_Operator model = new TDTK.PlatForm.MVC4.Model.Sys_Operator(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }