public List <PEIS.Model.SysMenu> DataTableToList(DataTable dt) { List <PEIS.Model.SysMenu> list = new List <PEIS.Model.SysMenu>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { PEIS.Model.SysMenu sysMenu = new PEIS.Model.SysMenu(); if (dt.Rows[i]["MenuID"].ToString() != "") { sysMenu.MenuID = int.Parse(dt.Rows[i]["MenuID"].ToString()); } sysMenu.MenuName = dt.Rows[i]["MenuName"].ToString(); if (dt.Rows[i]["ID_ParentMenu"].ToString() != "") { sysMenu.ParentID = new int?(int.Parse(dt.Rows[i]["ParentID"].ToString())); } sysMenu.Url = dt.Rows[i]["Url"].ToString(); //if (dt.Rows[i]["CreateDate"].ToString() != "") //{ // sysMenu.CreateDate = new DateTime?(DateTime.Parse(dt.Rows[i]["CreateDate"].ToString())); //} //if (dt.Rows[i]["UpdateDate"].ToString() != "") //{ // sysMenu.UpdateDate = new DateTime?(DateTime.Parse(dt.Rows[i]["UpdateDate"].ToString())); //} if (dt.Rows[i]["DispOrder"].ToString() != "") { sysMenu.DispOrder = new int?(int.Parse(dt.Rows[i]["DispOrder"].ToString())); } sysMenu.RightCode = dt.Rows[i]["RightCode"].ToString(); //if (dt.Rows[i]["ID_Operator"].ToString() != "") //{ // sysMenu.ID_Operator = new int?(int.Parse(dt.Rows[i]["ID_Operator"].ToString())); //} if (dt.Rows[i]["Is_CombineWithSection"].ToString() != "") { if (dt.Rows[i]["Is_CombineWithSection"].ToString() == "1" || dt.Rows[i]["Is_CombineWithSection"].ToString().ToLower() == "true") { sysMenu.Is_CombineWithSection = true; } else { sysMenu.Is_CombineWithSection = false; } } list.Add(sysMenu); } } return(list); }
public PEIS.Model.SysMenu DataRowToModel(DataRow row) { PEIS.Model.SysMenu model = new PEIS.Model.SysMenu(); if (row != null) { if (row["MenuID"] != null && row["MenuID"].ToString() != "") { model.MenuID = int.Parse(row["MenuID"].ToString()); } if (row["MenuName"] != null) { model.MenuName = row["MenuName"].ToString(); } if (row["ParentID"] != null && row["ParentID"].ToString() != "") { model.ParentID = int.Parse(row["ParentID"].ToString()); } if (row["Url"] != null) { model.Url = row["Url"].ToString(); } if (row["DispOrder"] != null && row["DispOrder"].ToString() != "") { model.DispOrder = int.Parse(row["DispOrder"].ToString()); } if (row["MenuLevel"] != null && row["MenuLevel"].ToString() != "") { model.MenuLevel = int.Parse(row["MenuLevel"].ToString()); } if (row["RightCode"] != null) { model.RightCode = row["RightCode"].ToString(); } if (row["Is_CombineWithSection"] != null && row["Is_CombineWithSection"].ToString() != "") { if ((row["Is_CombineWithSection"].ToString() == "1") || (row["Is_CombineWithSection"].ToString().ToLower() == "true")) { model.Is_CombineWithSection = true; } else { model.Is_CombineWithSection = false; } } } return(model); }
public bool Update(PEIS.Model.SysMenu model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update SysMenu set "); strSql.Append("MenuName=@MenuName,"); strSql.Append("ParentID=@ParentID,"); strSql.Append("Url=@Url,"); strSql.Append("DispOrder=@DispOrder,"); strSql.Append("MenuLevel=@MenuLevel,"); strSql.Append("RightCode=@RightCode,"); strSql.Append("Is_CombineWithSection=@Is_CombineWithSection"); strSql.Append(" where MenuID=@MenuID "); SqlParameter[] parameters = { new SqlParameter("@MenuName", SqlDbType.VarChar, 60), new SqlParameter("@ParentID", SqlDbType.Int, 4), new SqlParameter("@Url", SqlDbType.VarChar, 200), new SqlParameter("@DispOrder", SqlDbType.Int, 4), new SqlParameter("@MenuLevel", SqlDbType.Int, 4), new SqlParameter("@RightCode", SqlDbType.VarChar, 80), new SqlParameter("@Is_CombineWithSection", SqlDbType.Bit, 1), new SqlParameter("@MenuID", SqlDbType.Int, 4) }; parameters[0].Value = model.MenuName; parameters[1].Value = model.ParentID; parameters[2].Value = model.Url; parameters[3].Value = model.DispOrder; parameters[4].Value = model.MenuLevel; parameters[5].Value = model.RightCode; parameters[6].Value = model.Is_CombineWithSection; parameters[7].Value = model.MenuID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public int Add(PEIS.Model.SysMenu model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into SysMenu("); strSql.Append("MenuID,MenuName,ParentID,Url,DispOrder,MenuLevel,RightCode,Is_CombineWithSection)"); strSql.Append(" values ("); strSql.Append("@MenuID,@MenuName,@ParentID,@Url,@DispOrder,@MenuLevel,@RightCode,@Is_CombineWithSection)"); SqlParameter[] parameters = { new SqlParameter("@MenuID", SqlDbType.Int, 4), new SqlParameter("@MenuName", SqlDbType.VarChar, 60), new SqlParameter("@ParentID", SqlDbType.Int, 4), new SqlParameter("@Url", SqlDbType.VarChar, 200), new SqlParameter("@DispOrder", SqlDbType.Int, 4), new SqlParameter("@MenuLevel", SqlDbType.Int, 4), new SqlParameter("@RightCode", SqlDbType.VarChar, 80), new SqlParameter("@Is_CombineWithSection", SqlDbType.Bit, 1) }; parameters[0].Value = model.MenuID; parameters[1].Value = model.MenuName; parameters[2].Value = model.ParentID; parameters[3].Value = model.Url; parameters[4].Value = model.DispOrder; parameters[5].Value = model.MenuLevel; parameters[6].Value = model.RightCode; parameters[7].Value = model.Is_CombineWithSection; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(0); } else { return(1); } }
public PEIS.Model.SysMenu GetModel(int MenuID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 MenuID,MenuName,ParentID,Url,DispOrder,MenuLevel,RightCode,Is_CombineWithSection from SysMenu "); strSql.Append(" where MenuID=@MenuID "); SqlParameter[] parameters = { new SqlParameter("@MenuID", SqlDbType.Int, 4) }; parameters[0].Value = MenuID; PEIS.Model.SysMenu model = new PEIS.Model.SysMenu(); 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 bool Update(PEIS.Model.SysMenu model) { return(this.dal.Update(model)); }
public int Add(PEIS.Model.SysMenu model) { return(this.dal.Add(model)); }