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