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