public bool IsExist(MenuInfo menuInfo_0) { string str = ""; if (string.IsNullOrEmpty(menuInfo_0.PROGID)) { str = string.Format("select * from {0} where COMPONENTDLLNAME='{1}' and CLASSNAME='{2}'", this.string_0, menuInfo_0.COMPONENTDLLNAME, menuInfo_0.CLASSNAME); } else { str = string.Format("select * from {0} where PROGID='{1}' ", this.string_0, menuInfo_0.PROGID); } DataAccessLayerBaseClass dataAccessLayer = DataAccessLayerFactory.GetDataAccessLayer(this.dataProviderType_0, this.string_1); dataAccessLayer.Open(); DataTable table = dataAccessLayer.ExecuteDataTable(str); dataAccessLayer.Close(); return(table.Rows.Count > 0); }
public List <MenuInfo> Load() { List <MenuInfo> list = new List <MenuInfo>(); try { DataAccessLayerBaseClass dataAccessLayer = DataAccessLayerFactory.GetDataAccessLayer(this.dataProviderType_0, this.string_1); dataAccessLayer.Open(); DataTable table = dataAccessLayer.ExecuteDataTable("select * from " + this.string_0); for (int i = 0; i < table.Rows.Count; i++) { DataRow row = table.Rows[i]; MenuInfo item = new MenuInfo { MenuID = Convert.ToString(row["MenuID"]), NAME = Convert.ToString(row["NAME"]) }; object obj1 = row["ORDERBY"]; item.ORDERBY = new int?(!(row["ORDERBY"] is DBNull) ? Convert.ToInt32(row["ORDERBY"]) : -1); item.PROGID = Convert.ToString(row["PROGID"]); item.SHORTCUT = Convert.ToString(row["SHORTCUT"]); item.SUBTYPE = new int?(!(row["SUBTYPE"] is DBNull) ? Convert.ToInt32(row["SUBTYPE"]) : -1); item.VISIBLE = new bool?(!(row["VISIBLE"] is DBNull) ? (Convert.ToInt32(row["VISIBLE"]) == 1) : true); item.ItemCol = new int?(!(row["ItemCol"] is DBNull) ? Convert.ToInt32(row["ItemCol"]) : -1); item.ISPOPMENUITEM = new bool?(!(row["ISPOPMENUITEM"] is DBNull) ? (Convert.ToInt32(row["ISPOPMENUITEM"]) == 1) : false); item.COMPONENTDLLNAME = Convert.ToString(row["COMPONENTDLLNAME"]); item.CLASSNAME = Convert.ToString(row["CLASSNAME"]); item.PARENTIDS = Convert.ToString(row["PARENTIDS"]); item.BEGINGROUP = new bool?(!(row["BEGINGROUP"] is DBNull) ? (Convert.ToInt32(row["BEGINGROUP"]) == 1) : false); item.CAPTION = Convert.ToString(row["CAPTION"]); list.Add(item); } dataAccessLayer.Close(); } catch { } return(list); }
public MenuInfo GetByClassName(string string_2, string string_3) { MenuInfo info = null; try { DataAccessLayerBaseClass dataAccessLayer = DataAccessLayerFactory.GetDataAccessLayer(this.dataProviderType_0, this.string_1); dataAccessLayer.Open(); DataTable table = dataAccessLayer.ExecuteDataTable("select * from " + this.string_0 + " where COMPONENTDLLNAME='" + string_2 + "' and CLASSNAME='" + string_3 + "'"); if (table.Rows.Count > 0) { DataRow row = table.Rows[0]; info = new MenuInfo { MenuID = Convert.ToString(row["MenuID"]), NAME = Convert.ToString(row["NAME"]) }; object obj1 = row["ORDERBY"]; info.ORDERBY = new int?(!(row["ORDERBY"] is DBNull) ? Convert.ToInt32(row["ORDERBY"]) : -1); info.PROGID = Convert.ToString(row["PROGID"]); info.SHORTCUT = Convert.ToString(row["SHORTCUT"]); info.SUBTYPE = new int?(!(row["SUBTYPE"] is DBNull) ? Convert.ToInt32(row["SUBTYPE"]) : -1); info.VISIBLE = new bool?(!(row["VISIBLE"] is DBNull) ? (Convert.ToInt32(row["VISIBLE"]) == 1) : true); info.ItemCol = new int?(!(row["ItemCol"] is DBNull) ? Convert.ToInt32(row["ItemCol"]) : -1); info.ISPOPMENUITEM = new bool?(!(row["ISPOPMENUITEM"] is DBNull) ? (Convert.ToInt32(row["ISPOPMENUITEM"]) == 1) : false); info.COMPONENTDLLNAME = Convert.ToString(row["COMPONENTDLLNAME"]); info.CLASSNAME = Convert.ToString(row["CLASSNAME"]); info.BEGINGROUP = new bool?(!(row["BEGINGROUP"] is DBNull) ? (Convert.ToInt32(row["BEGINGROUP"]) == 1) : false); info.CAPTION = Convert.ToString(row["CAPTION"]); info.PARENTIDS = Convert.ToString(row["PARENTIDS"]); } dataAccessLayer.Close(); } catch { } return(info); }