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