public Model.Sys_Menu DataRowToModel(DataRow row) { TDTK.PlatForm.MVC4.Model.Sys_Menu model = new TDTK.PlatForm.MVC4.Model.Sys_Menu(); if (row != null) { if (row["MenuID"] != null) { model.MenuID = row["MenuID"].ToString(); } if (row["MenuName"] != null) { model.MenuName = row["MenuName"].ToString(); } if (row["MenuUrl"] != null) { model.MenuUrl = row["MenuUrl"].ToString(); } if (row["FunctionID"] != null) { model.FunctionID = row["FunctionID"].ToString(); } if (row["IsLeaf"] != null) { model.IsLeaf = row["IsLeaf"].ToString(); } if (row["MenuLevel"] != null) { model.MenuLevel = row["MenuLevel"].ToString(); } if (row["RootID"] != null) { model.RootID = row["RootID"].ToString(); } if (row["ParentsID"] != null) { model.ParentsID = row["ParentsID"].ToString(); } if (row["DisplayOrder"] != null && row["DisplayOrder"].ToString() != "") { model.DisplayOrder = decimal.Parse(row["DisplayOrder"].ToString()); } if (row["IcValue"] != null) { model.IcValue = row["IcValue"].ToString(); } if (row["IsPop"] != null) { model.IsPop = row["IsPop"].ToString(); } if (row["MenuSeq"] != null) { model.MenuSeq = row["MenuSeq"].ToString(); } } return model; }
public Model.Sys_Menu GetModel(Model.Sys_Menu t) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 MenuID,MenuName,MenuUrl,FunctionID,IsLeaf,MenuLevel,RootID,ParentsID,DisplayOrder,IcValue,IsPop,MenuSeq from Sys_Menu "); strSql.Append(" where MenuID=@MenuID "); SqlParameter[] parameters = { new SqlParameter("@MenuID", SqlDbType.NVarChar,20) }; parameters[0].Value = t.MenuID; TDTK.PlatForm.MVC4.Model.Sys_Menu model = new TDTK.PlatForm.MVC4.Model.Sys_Menu(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }