/// <summary> /// 得到一个对象实体 /// </summary> public webs_YueyxShop.Model.FunctionBase GetModel(Guid f_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append( "select top 1 f_ID,f_BianM,f_MingCh,f_CengJ,f_ParentId,f_MiaoSh,f_ZhuJM,f_PaiX,f_CreatedOn,f_CreatedBy,f_StatusCode,f_DeleteStateCode from FunctionBase "); strSql.Append(" where f_ID=@f_ID "); SqlParameter[] parameters = { new SqlParameter("@f_ID", SqlDbType.UniqueIdentifier, 16) }; parameters[0].Value = f_ID; webs_YueyxShop.Model.FunctionBase model = new webs_YueyxShop.Model.FunctionBase(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }
public ActionResult FunctionEdit() { this.ViewData["hfOtype"] = RequestBase.GetString("otype"); ViewData["IsHasFunRole"] = _roleManager.IsHasFunRole(EmployeeBase.e_ID, "001004001"); //是否拥有管理的权限 switch (ViewData["hfOtype"].ToString()) { case "modify": //获取选中功能的f_ID Guid id = new Guid(RequestBase.GetString("f_ID").Split('|')[0]); //将选中的f_ID记为子列表的hfid this.ViewData["hfid"] = RequestBase.GetString("f_ID").Split('|')[0]; //获取当前实体 webs_YueyxShop.Model.FunctionBase model2 = _db.GetModel(id); Guid parentid = model2.f_ParentId; //将实体内容记录到内存 this.ViewData["txtMingc"] = model2.f_MingCh; this.ViewData["txtPaix"] = model2.f_PaiX; this.ViewData["txtMiaos"] = model2.f_MiaoSh; this.ViewData["txtZhujm"] = model2.f_ZhuJM; this.ViewData["hfid"] = model2.f_ID; //获取当前模块的上级模块 webs_YueyxShop.Model.FunctionBase model3 = _db.GetModel(parentid); if (model3 != null) { //存在记录名称 ViewData["txtPid"] = model3.f_MingCh; } break; case "add": ViewData["hfPid"] = RequestBase.GetString("hf_add").Split('|')[0]; ViewData["hf_Cengj"] = RequestBase.GetString("hf_add").Split('|')[1]; //非顶级层级 if ((string) ViewData["hf_Cengj"] != "0") { webs_YueyxShop.Model.FunctionBase model = _db.GetModel(new Guid(RequestBase.GetString("hf_add").Split('|')[0])); if (model != null) { ViewData["hfbianm"] = model.f_BianM; ViewData["txtPid"] = model.f_MingCh; } } break; default: FunctionObj = new webs_YueyxShop.Model.FunctionBase(); break; } return View(); }
/// <summary> /// 得到一个对象实体 /// </summary> public webs_YueyxShop.Model.FunctionBase DataRowToModel(DataRow row) { webs_YueyxShop.Model.FunctionBase model = new webs_YueyxShop.Model.FunctionBase(); if (row != null) { if (row["f_ID"] != null && row["f_ID"].ToString() != "") { model.f_ID = new Guid(row["f_ID"].ToString()); } if (row["f_BianM"] != null) { model.f_BianM = row["f_BianM"].ToString(); } if (row["f_MingCh"] != null) { model.f_MingCh = row["f_MingCh"].ToString(); } if (row["f_CengJ"] != null && row["f_CengJ"].ToString() != "") { model.f_CengJ = int.Parse(row["f_CengJ"].ToString()); } if (row["f_ParentId"] != null && row["f_ParentId"].ToString() != "") { model.f_ParentId = new Guid(row["f_ParentId"].ToString()); } if (row["f_MiaoSh"] != null) { model.f_MiaoSh = row["f_MiaoSh"].ToString(); } if (row["f_ZhuJM"] != null) { model.f_ZhuJM = row["f_ZhuJM"].ToString(); } if (row["f_PaiX"] != null && row["f_PaiX"].ToString() != "") { model.f_PaiX = int.Parse(row["f_PaiX"].ToString()); } if (row["f_CreatedOn"] != null && row["f_CreatedOn"].ToString() != "") { model.f_CreatedOn = DateTime.Parse(row["f_CreatedOn"].ToString()); } if (row["f_CreatedBy"] != null && row["f_CreatedBy"].ToString() != "") { model.f_CreatedBy = new Guid(row["f_CreatedBy"].ToString()); } if (row["f_StatusCode"] != null && row["f_StatusCode"].ToString() != "") { model.f_StatusCode = int.Parse(row["f_StatusCode"].ToString()); } if (row["f_DeleteStateCode"] != null && row["f_DeleteStateCode"].ToString() != "") { model.f_DeleteStateCode = int.Parse(row["f_DeleteStateCode"].ToString()); } } return model; }