You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
647 lines
29 KiB
647 lines
29 KiB
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Data;
|
|
using MySql.Data.MySqlClient;
|
|
|
|
namespace FangYar.OracleDAL.TBL
|
|
{
|
|
public class SysMenuDAL : FangYar.IDAL.TBL.SysMenuIDAL
|
|
{
|
|
#region 私有方法
|
|
/// <summary>
|
|
/// DataRow转model实体类对象
|
|
/// </summary>
|
|
/// <param name="dr"></param>
|
|
/// <returns></returns>
|
|
private void DataRowToModel(Model.TBL.TBL_SYS_MENU_Model model, DataRow dr)
|
|
{
|
|
if (!DBNull.Value.Equals(dr["ID"]))
|
|
model.ID = dr["ID"].ToString();
|
|
if (!DBNull.Value.Equals(dr["APP_ID"]))
|
|
model.APP_ID = dr["APP_ID"].ToString();
|
|
if (!DBNull.Value.Equals(dr["MENU_TITLE"]))
|
|
model.MENU_TITLE = dr["MENU_TITLE"].ToString();
|
|
if (!DBNull.Value.Equals(dr["MENU_URL"]))
|
|
model.MENU_URL = dr["MENU_URL"].ToString();
|
|
if (!DBNull.Value.Equals(dr["MENU_PARENT"]))
|
|
model.MENU_PARENT = dr["MENU_PARENT"].ToString();
|
|
if (!DBNull.Value.Equals(dr["MENU_TYPE"]))
|
|
model.MENU_TYPE = dr["MENU_TYPE"].ToString();
|
|
if (!DBNull.Value.Equals(dr["MENU_FLAG"]))
|
|
model.MENU_FLAG = dr["MENU_FLAG"].ToString();
|
|
if (!DBNull.Value.Equals(dr["MENU_LEVEL"]))
|
|
model.MENU_LEVEL = dr["MENU_LEVEL"].ToString();
|
|
if (!DBNull.Value.Equals(dr["MENU_ORDER"]))
|
|
model.MENU_ORDER = Convert.ToInt32(dr["MENU_ORDER"].ToString());
|
|
if (!DBNull.Value.Equals(dr["MENU_MAP"]))
|
|
model.MENU_MAP = dr["MENU_MAP"].ToString();
|
|
if (!DBNull.Value.Equals(dr["MENU_ACTION"]))
|
|
model.MENU_ACTION = dr["MENU_ACTION"].ToString();
|
|
if (!DBNull.Value.Equals(dr["MENU_ICON"]))
|
|
model.MENU_ICON = dr["MENU_ICON"].ToString();
|
|
|
|
if (!DBNull.Value.Equals(dr["ADDRESS"]))
|
|
model.Address = dr["ADDRESS"].ToString();
|
|
if (!DBNull.Value.Equals(dr["TYPE"]))
|
|
model.Type = dr["TYPE"].ToString();
|
|
if (dr.Table.Columns.Contains("OPENMODE"))
|
|
{
|
|
if (dr["OPENMODE"] != null && dr["OPENMODE"].ToString() != "")
|
|
{
|
|
model.OpenMode = int.Parse(dr["OPENMODE"].ToString());
|
|
}
|
|
}
|
|
if (dr.Table.Columns.Contains("WIDTH"))
|
|
{
|
|
if (dr["WIDTH"] != null && dr["WIDTH"].ToString() != "")
|
|
{
|
|
model.Width = int.Parse(dr["WIDTH"].ToString());
|
|
}
|
|
}
|
|
if (dr.Table.Columns.Contains("HEIGHT"))
|
|
{
|
|
if (dr["HEIGHT"] != null && dr["HEIGHT"].ToString() != "")
|
|
{
|
|
model.Height = int.Parse(dr["HEIGHT"].ToString());
|
|
}
|
|
}
|
|
if (!DBNull.Value.Equals(dr["PARAMS"]))
|
|
model.Params = dr["PARAMS"].ToString();
|
|
if (!DBNull.Value.Equals(dr["MANAGER"]))
|
|
model.Manager = dr["MANAGER"].ToString();
|
|
if (!DBNull.Value.Equals(dr["NOTE"]))
|
|
model.Note = dr["NOTE"].ToString();
|
|
if (!DBNull.Value.Equals(dr["CODE"]))
|
|
model.Code = dr["CODE"].ToString();
|
|
if (!DBNull.Value.Equals(dr["USEMEMBER"]))
|
|
model.UseMember = dr["USEMEMBER"].ToString();
|
|
if (dr.Table.Columns.Contains("FLOWTYPE"))
|
|
{
|
|
if (dr["FLOWTYPE"] != null && dr["FLOWTYPE"].ToString() != "")
|
|
{
|
|
model.FLOWTYPE = int.Parse(dr["FLOWTYPE"].ToString());
|
|
}
|
|
}
|
|
if (!DBNull.Value.Equals(dr["AUTHORITYTYPE"]))
|
|
model.AUTHORITYTYPE = dr["AUTHORITYTYPE"].ToString();
|
|
if (!DBNull.Value.Equals(dr["ORG_ID"]))
|
|
model.ORG_ID = dr["ORG_ID"].ToString();
|
|
}
|
|
/// <summary>
|
|
/// DataRow转model实体类对象
|
|
/// </summary>
|
|
/// <param name="dr"></param>
|
|
/// <returns></returns>
|
|
private Model.TBL.TBL_SYS_MENU_Model DataRowToModel(DataRow dr)
|
|
{
|
|
Model.TBL.TBL_SYS_MENU_Model model = new Model.TBL.TBL_SYS_MENU_Model();
|
|
if (!DBNull.Value.Equals(dr["ID"]))
|
|
model.ID = dr["ID"].ToString();
|
|
if (!DBNull.Value.Equals(dr["APP_ID"]))
|
|
model.APP_ID = dr["APP_ID"].ToString();
|
|
if (!DBNull.Value.Equals(dr["MENU_TITLE"]))
|
|
model.MENU_TITLE = dr["MENU_TITLE"].ToString();
|
|
if (!DBNull.Value.Equals(dr["MENU_URL"]))
|
|
model.MENU_URL = dr["MENU_URL"].ToString();
|
|
if (!DBNull.Value.Equals(dr["MENU_PARENT"]))
|
|
model.MENU_PARENT = dr["MENU_PARENT"].ToString();
|
|
if (!DBNull.Value.Equals(dr["MENU_TYPE"]))
|
|
model.MENU_TYPE = dr["MENU_TYPE"].ToString();
|
|
if (!DBNull.Value.Equals(dr["MENU_FLAG"]))
|
|
model.MENU_FLAG = dr["MENU_FLAG"].ToString();
|
|
if (!DBNull.Value.Equals(dr["MENU_LEVEL"]))
|
|
model.MENU_LEVEL = dr["MENU_LEVEL"].ToString();
|
|
if (!DBNull.Value.Equals(dr["MENU_ORDER"]))
|
|
model.MENU_ORDER = Convert.ToInt32(dr["MENU_ORDER"].ToString());
|
|
if (!DBNull.Value.Equals(dr["MENU_MAP"]))
|
|
model.MENU_MAP = dr["MENU_MAP"].ToString();
|
|
if (!DBNull.Value.Equals(dr["MENU_ACTION"]))
|
|
model.MENU_ACTION = dr["MENU_ACTION"].ToString();
|
|
if (!DBNull.Value.Equals(dr["MENU_ICON"]))
|
|
model.MENU_ICON = dr["MENU_ICON"].ToString();
|
|
|
|
if (!DBNull.Value.Equals(dr["ADDRESS"]))
|
|
model.Address = dr["ADDRESS"].ToString();
|
|
if (!DBNull.Value.Equals(dr["TYPE"]))
|
|
model.Type = dr["TYPE"].ToString();
|
|
if (dr.Table.Columns.Contains("OPENMODE"))
|
|
{
|
|
if (dr["OPENMODE"] != null && dr["OPENMODE"].ToString() != "")
|
|
{
|
|
model.OpenMode = int.Parse(dr["OPENMODE"].ToString());
|
|
}
|
|
}
|
|
if (dr.Table.Columns.Contains("WIDTH"))
|
|
{
|
|
if (dr["WIDTH"] != null && dr["WIDTH"].ToString() != "")
|
|
{
|
|
model.Width = int.Parse(dr["WIDTH"].ToString());
|
|
}
|
|
}
|
|
if (dr.Table.Columns.Contains("HEIGHT"))
|
|
{
|
|
if (dr["HEIGHT"] != null && dr["HEIGHT"].ToString() != "")
|
|
{
|
|
model.Height = int.Parse(dr["HEIGHT"].ToString());
|
|
}
|
|
}
|
|
if (!DBNull.Value.Equals(dr["PARAMS"]))
|
|
model.Params = dr["PARAMS"].ToString();
|
|
if (!DBNull.Value.Equals(dr["MANAGER"]))
|
|
model.Manager = dr["MANAGER"].ToString();
|
|
if (!DBNull.Value.Equals(dr["NOTE"]))
|
|
model.Note = dr["NOTE"].ToString();
|
|
if (!DBNull.Value.Equals(dr["CODE"]))
|
|
model.Code = dr["CODE"].ToString();
|
|
if (!DBNull.Value.Equals(dr["USEMEMBER"]))
|
|
model.UseMember = dr["USEMEMBER"].ToString();
|
|
if (dr.Table.Columns.Contains("FLOWTYPE"))
|
|
{
|
|
if (dr["FLOWTYPE"] != null && dr["FLOWTYPE"].ToString() != "")
|
|
{
|
|
model.FLOWTYPE = int.Parse(dr["FLOWTYPE"].ToString());
|
|
}
|
|
}
|
|
if (!DBNull.Value.Equals(dr["AUTHORITYTYPE"]))
|
|
model.AUTHORITYTYPE = dr["AUTHORITYTYPE"].ToString();
|
|
if (!DBNull.Value.Equals(dr["ORG_ID"]))
|
|
model.ORG_ID = dr["ORG_ID"].ToString();
|
|
return model;
|
|
|
|
}
|
|
/// <summary>
|
|
/// 把DataTable行转成实体类List集合
|
|
/// </summary>
|
|
private List<FangYar.Model.TBL.TBL_SYS_MENU_Model> DataTableToList(DataTable dt)
|
|
{
|
|
|
|
List<FangYar.Model.TBL.TBL_SYS_MENU_Model> modellist = new List<Model.TBL.TBL_SYS_MENU_Model>();
|
|
if (dt.Rows.Count > 0)
|
|
{
|
|
|
|
foreach (DataRow myRow in dt.Rows)
|
|
{
|
|
modellist.Add(DataRowToModel(myRow));
|
|
}
|
|
}
|
|
|
|
return modellist;
|
|
|
|
}
|
|
#endregion
|
|
#region 基本方法
|
|
|
|
|
|
/// <summary>
|
|
/// 根据ID获取实体对象
|
|
/// </summary>
|
|
public Model.TBL.TBL_SYS_MENU_Model GetModelByID(string Id)
|
|
{
|
|
Model.TBL.TBL_SYS_MENU_Model model = null;
|
|
string sql = "select * from TBL_SYS_MENU where ID=@ID";
|
|
MySqlParameter[] paras ={
|
|
new MySqlParameter("@ID",MySqlDbType.VarChar,36)
|
|
};
|
|
paras[0].Value = Id;
|
|
DataTable dt = FangYar.Common.MySqlHelper.QueryTable(sql, paras);
|
|
if (dt.Rows.Count > 0)
|
|
{
|
|
model = new Model.TBL.TBL_SYS_MENU_Model();
|
|
DataRowToModel(model, dt.Rows[0]);
|
|
return model;
|
|
|
|
}
|
|
else
|
|
{
|
|
|
|
return null;
|
|
}
|
|
|
|
}
|
|
/// <summary>
|
|
/// 根据APP_ID获取实体类对象
|
|
/// </summary>
|
|
public Model.TBL.TBL_SYS_MENU_Model GetModelByAppId(string AppId)
|
|
{
|
|
Model.TBL.TBL_SYS_MENU_Model model = null;
|
|
string sql = "select * from TBL_SYS_MENU where APP_ID=@APP_ID";
|
|
MySqlParameter[] paras ={
|
|
new MySqlParameter("@APP_ID",MySqlDbType.VarChar,50)
|
|
};
|
|
paras[0].Value = AppId;
|
|
DataTable dt = FangYar.Common.MySqlHelper.QueryTable(sql, paras);
|
|
if (dt.Rows.Count > 0)
|
|
{
|
|
model = new Model.TBL.TBL_SYS_MENU_Model();
|
|
DataRowToModel(model, dt.Rows[0]);
|
|
return model;
|
|
}
|
|
else
|
|
{
|
|
|
|
return null;
|
|
}
|
|
}
|
|
/// <summary>
|
|
/// 添加
|
|
/// </summary>
|
|
public bool Add(Model.TBL.TBL_SYS_MENU_Model model)
|
|
{
|
|
string sql1 = "select count(1) from TBL_SYS_MENU where ID='" + model.ID + "'";
|
|
bool exist = FangYar.Common.MySqlHelper.Exists(sql1);
|
|
if (exist)//存在不添加
|
|
{
|
|
return false;
|
|
|
|
}
|
|
else
|
|
{
|
|
StringBuilder strsql = new StringBuilder();
|
|
strsql.Append("insert into TBL_SYS_MENU (APP_ID,MENU_TITLE,MENU_URL,MENU_PARENT,MENU_TYPE,MENU_FLAG,MENU_LEVEL,MENU_ORDER,MENU_MAP,MENU_ACTION,MENU_ICON,AUTHORITYTYPE,ORG_ID,ID)");
|
|
strsql.Append("values");
|
|
strsql.Append("(@APP_ID,@MENU_TITLE,@MENU_URL,@MENU_PARENT,@MENU_TYPE,@MENU_FLAG,@MENU_LEVEL,@MENU_ORDER,@MENU_MAP,@MENU_ACTION,@MENU_ICON,@AUTHORITYTYPE,@ORG_ID,@ID)");
|
|
MySqlParameter[] paras ={
|
|
new MySqlParameter("@APP_ID",model.APP_ID),
|
|
new MySqlParameter("@MENU_TITLE", model.MENU_TITLE),
|
|
new MySqlParameter("@MENU_URL", model.MENU_URL),
|
|
new MySqlParameter("@MENU_PARENT", model.MENU_PARENT),
|
|
new MySqlParameter("@MENU_TYPE",model.MENU_TYPE),
|
|
new MySqlParameter("@MENU_FLAG", model.MENU_FLAG),
|
|
new MySqlParameter("@MENU_LEVEL",model.MENU_LEVEL),
|
|
new MySqlParameter("@MENU_ORDER",model.MENU_ORDER),
|
|
new MySqlParameter("@MENU_MAP",model.MENU_MAP),
|
|
new MySqlParameter("@MENU_ACTION",model.MENU_ACTION),
|
|
new MySqlParameter("@MENU_ICON",model.MENU_ICON),
|
|
new MySqlParameter("@AUTHORITYTYPE", model.AUTHORITYTYPE),
|
|
new MySqlParameter("@ORG_ID",model.ORG_ID),
|
|
new MySqlParameter("@ID",model.ID),
|
|
|
|
};
|
|
int i = FangYar.Common.MySqlHelper.ExecuteSql(strsql.ToString(), paras);
|
|
if (i > 0)
|
|
{
|
|
return true;
|
|
}
|
|
else
|
|
{
|
|
return false;
|
|
}
|
|
}
|
|
}
|
|
/// <summary>
|
|
///修改
|
|
/// </summary>
|
|
public bool Edit(Model.TBL.TBL_SYS_MENU_Model model)
|
|
{
|
|
StringBuilder strsql = new StringBuilder();
|
|
strsql.Append("update TBL_SYS_MENU set ");
|
|
strsql.Append("APP_ID=@APP_ID,");
|
|
strsql.Append("MENU_TITLE=@MENU_TITLE,");
|
|
strsql.Append("MENU_URL=@MENU_URL,");
|
|
strsql.Append("MENU_PARENT=@MENU_PARENT,");
|
|
strsql.Append("MENU_TYPE=@MENU_TYPE,");
|
|
strsql.Append("MENU_FLAG=@MENU_FLAG,");
|
|
strsql.Append("MENU_LEVEL=@MENU_LEVEL,");
|
|
strsql.Append("MENU_ORDER=@MENU_ORDER,");
|
|
strsql.Append("MENU_MAP=@MENU_MAP,");
|
|
strsql.Append("MENU_ACTION=@MENU_ACTION,");
|
|
strsql.Append("MENU_ICON=@MENU_ICON, ");
|
|
strsql.Append("AUTHORITYTYPE=@AUTHORITYTYPE, ");
|
|
strsql.Append("ORG_ID=@ORG_ID ");
|
|
strsql.Append(" where ID=@ID");
|
|
MySqlParameter[] paras ={
|
|
new MySqlParameter("@APP_ID",model.APP_ID),
|
|
new MySqlParameter("@MENU_TITLE",model.MENU_TITLE),
|
|
new MySqlParameter("@MENU_URL",model.MENU_URL),
|
|
new MySqlParameter("@MENU_PARENT",model.MENU_PARENT),
|
|
new MySqlParameter("@MENU_TYPE",model.MENU_TYPE),
|
|
new MySqlParameter("@MENU_FLAG",model.MENU_FLAG),
|
|
new MySqlParameter("@MENU_LEVEL",model.MENU_LEVEL),
|
|
new MySqlParameter("@MENU_ORDER",model.MENU_ORDER),
|
|
new MySqlParameter("@MENU_MAP",model.MENU_MAP),
|
|
new MySqlParameter("@MENU_ACTION",model.MENU_ACTION),
|
|
new MySqlParameter("@MENU_ICON",model.MENU_ICON),
|
|
new MySqlParameter("@AUTHORITYTYPE",model.AUTHORITYTYPE),
|
|
new MySqlParameter("@ORG_ID",model.ORG_ID),
|
|
new MySqlParameter("@ID",model.ID)
|
|
};
|
|
int i = FangYar.Common.MySqlHelper.ExecuteSql(strsql.ToString(), paras);
|
|
if (i > 0) { return true; }
|
|
else { return false; }
|
|
|
|
}
|
|
/// <summary>
|
|
/// 删除
|
|
/// </summary>
|
|
public bool Delete(string IDList)
|
|
{
|
|
string sql = "delete from TBL_SYS_MENU where ID in('" + IDList + "')";
|
|
try
|
|
{
|
|
int i = FangYar.Common.MySqlHelper.ExecuteSql(sql);
|
|
if (i > 0)
|
|
{
|
|
return true;
|
|
}
|
|
else { return false; }
|
|
}
|
|
catch
|
|
{
|
|
return false;
|
|
}
|
|
|
|
}
|
|
public int Count(string where)
|
|
{
|
|
|
|
string sql = "select count(1) from TBL_SYS_MENU ";
|
|
if (where != null && where != "")
|
|
{
|
|
sql += " where " + where;
|
|
}
|
|
try
|
|
{
|
|
return FangYar.Common.MySqlHelper.GetCount(sql);
|
|
}
|
|
catch
|
|
{
|
|
return 0;
|
|
}
|
|
|
|
}
|
|
/// <summary>
|
|
/// 根据APP_ID获取实体类对象
|
|
/// </summary>
|
|
public List<FangYar.Model.TBL.TBL_SYS_MENU_Model> QueryWhere(string strwhere)
|
|
{
|
|
string sql = "select * from TBL_SYS_MENU where " + strwhere;
|
|
|
|
DataTable dt = FangYar.Common.MySqlHelper.QueryTable(sql);
|
|
if (dt.Rows.Count > 0)
|
|
{
|
|
|
|
return this.DataTableToList(dt);
|
|
|
|
}
|
|
else
|
|
{
|
|
|
|
return null;
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// 删除 角色与菜单关联表
|
|
/// </summary>
|
|
/// <param name="strlist"></param>
|
|
/// <returns></returns>
|
|
public bool DeleteRoleMenu(string IDList)
|
|
{
|
|
string sql = "delete from TBL_SYS_ROLEMENU where MENU_ID in ('" + IDList + "')";
|
|
try
|
|
{
|
|
int i = FangYar.Common.MySqlHelper.ExecuteSql(sql);
|
|
if (i > 0)
|
|
{
|
|
return true;
|
|
}
|
|
else { return false; }
|
|
}
|
|
catch
|
|
{
|
|
return false;
|
|
}
|
|
|
|
}
|
|
|
|
#endregion
|
|
#region 分页
|
|
|
|
/// <summary>
|
|
/// 分页无排序
|
|
/// </summary>
|
|
/// <param name="PageIndex">页面索引</param>
|
|
/// <param name="PageSize">页面大小</param>
|
|
/// <param name="strwhere">查询条件</param>
|
|
/// <returns></returns>
|
|
public string QueryJsonList(int PageIndex, int PageSize, string strwhere)
|
|
{
|
|
|
|
return FangYar.Common.JsonHelper.ToJson(QueryPage(PageIndex, PageSize, strwhere));
|
|
}
|
|
/// <summary>
|
|
/// 分页无排序
|
|
/// </summary>
|
|
/// <param name="PageIndex">页面索引</param>
|
|
/// <param name="PageSize">页面大小</param>
|
|
/// <param name="strwhere">查询条件</param>
|
|
/// <returns></returns>
|
|
public string QueryJsonList(int PageIndex, int PageSize, string strwhere, string order)
|
|
{
|
|
|
|
return FangYar.Common.JsonHelper.ToJson(QueryPage(PageIndex, PageSize, strwhere, order));
|
|
}
|
|
/// <summary>
|
|
/// 分页无排序
|
|
/// </summary>
|
|
/// <param name="PageIndex">页面索引</param>
|
|
/// <param name="PageSize">页面大小</param>
|
|
/// <param name="strwhere">查询条件</param>
|
|
/// <returns></returns>
|
|
public List<FangYar.Model.TBL.TBL_SYS_MENU_Model> QueryList(int PageIndex, int PageSize, string strwhere)
|
|
{
|
|
|
|
return DataTableToList(QueryPage(PageIndex, PageSize, strwhere));
|
|
}
|
|
/// <summary>
|
|
/// 分页无排序
|
|
/// </summary>
|
|
/// <param name="PageIndex">页面索引</param>
|
|
/// <param name="PageSize">页面大小</param>
|
|
/// <param name="strwhere">查询条件</param>
|
|
/// <returns></returns>
|
|
public List<FangYar.Model.TBL.TBL_SYS_MENU_Model> QueryList(int PageIndex, int PageSize, string strwhere, string order)
|
|
{
|
|
|
|
return DataTableToList(QueryPage(PageIndex, PageSize, strwhere, order));
|
|
}
|
|
/// <summary>
|
|
/// 分页无排序
|
|
/// </summary>
|
|
/// <param name="PageIndex">页面索引</param>
|
|
/// <param name="PageSize">页面大小</param>
|
|
/// <param name="strwhere">查询条件</param>
|
|
/// <returns></returns>
|
|
public DataTable QueryPage(int PageIndex, int PageSize, string strwhere)
|
|
{
|
|
|
|
return FangYar.Common.MySqlHelper.QueryPage(PageIndex, PageSize, "TBL_SYS_MENU", strwhere);
|
|
}
|
|
|
|
/// <summary>
|
|
/// 分页无排序
|
|
/// </summary>
|
|
/// <param name="PageIndex">页面索引</param>
|
|
/// <param name="PageSize">页面大小</param>
|
|
/// <param name="strwhere">查询条件</param>
|
|
/// <param name="strwhere">排序</param>
|
|
/// <returns></returns>
|
|
public DataTable QueryPage(int PageIndex, int PageSize, string strwhere, string order)
|
|
{
|
|
|
|
return FangYar.Common.MySqlHelper.QueryPage(PageIndex, PageSize, "TBL_SYS_MENU", strwhere, order);
|
|
}
|
|
/// <summary>
|
|
/// 存储过程分页
|
|
/// </summary>
|
|
/// <param name="PageIndex">页面索引</param>
|
|
/// <param name="PageSize">页面大小</param>
|
|
/// <param name="strwhere">查询条件</param>
|
|
/// <param name="strwhere">排序</param>
|
|
/// <returns></returns>
|
|
public void QueryProc(int PageIndex, int PageSize, string strwhere, string order)
|
|
{
|
|
int totalcount = 0;
|
|
FangYar.Common.SqlPagerHelperOra.Select(PageSize, PageIndex, out totalcount, "TBL_SYS_MENU", "*", null, null, null);
|
|
|
|
|
|
}
|
|
#endregion
|
|
|
|
|
|
|
|
|
|
#region flow用的
|
|
/// <summary>
|
|
/// flow用的
|
|
/// 添加
|
|
/// </summary>
|
|
public bool flowAdd(Model.TBL.TBL_SYS_MENU_Model model)
|
|
{
|
|
RoadFlow.Data.ORACLE.DBHelper dbHelper = new RoadFlow.Data.ORACLE.DBHelper();
|
|
string strsql = "INSERT INTO TBL_SYS_MENU " +
|
|
"(ID,MENU_TITLE,Address,Type,OpenMode,Width,Height,Params,Manager,Note,Code,UseMember,FLOWTYPE,AUTHORITYTYPE,ORG_ID) " +
|
|
"VALUES(@ID,@MENU_TITLE,@Address,@Type,@OpenMode,@Width,@Height,@Params,@Manager,@Note,@Code,@UseMember,@FLOWTYPE,@AUTHORITYTYPE,@ORG_ID)";
|
|
MySqlParameter[] parameters = new MySqlParameter[]{
|
|
new MySqlParameter("@ID", MySqlDbType.VarChar, 50){ Value = model.ID },
|
|
new MySqlParameter("@MENU_TITLE", MySqlDbType.VarChar, 510){ Value = model.MENU_TITLE },
|
|
new MySqlParameter("@Address", MySqlDbType.VarChar, 200){ Value = model.Address },
|
|
new MySqlParameter("@Type", MySqlDbType.VarChar, 50){ Value = model.Type },
|
|
new MySqlParameter("@OpenMode", MySqlDbType.Int32){ Value = model.OpenMode },
|
|
model.Width == null ? new MySqlParameter("@Width", MySqlDbType.Int32) { Value = DBNull.Value } : new MySqlParameter("@Width", MySqlDbType.Int32) { Value = model.Width },
|
|
model.Height == null ? new MySqlParameter("@Height", MySqlDbType.Int32) { Value = DBNull.Value } : new MySqlParameter("@Height", MySqlDbType.Int32) { Value = model.Height },
|
|
model.Params == null ? new MySqlParameter("@Params", MySqlDbType.VarChar) { Value = DBNull.Value } : new MySqlParameter("@Params", MySqlDbType.VarChar) { Value = model.Params },
|
|
model.Manager == null ? new MySqlParameter("@Manager", MySqlDbType.VarChar) { Value = DBNull.Value } : new MySqlParameter("@Manager", MySqlDbType.VarChar) { Value = model.Manager },
|
|
model.Note == null ? new MySqlParameter("@Note", MySqlDbType.VarChar) { Value = DBNull.Value } : new MySqlParameter("@Note", MySqlDbType.VarChar) { Value = model.Note },
|
|
model.Code == null ? new MySqlParameter("@Code", MySqlDbType.VarChar, 50) { Value = DBNull.Value } : new MySqlParameter("@Code", MySqlDbType.VarChar, 50) { Value = model.Code },
|
|
model.UseMember == null ? new MySqlParameter("@UseMember", MySqlDbType.VarChar) { Value = DBNull.Value } : new MySqlParameter("@UseMember", MySqlDbType.VarChar) { Value = model.UseMember },
|
|
model.FLOWTYPE == null ? new MySqlParameter("@FLOWTYPE", MySqlDbType.Int32) { Value = DBNull.Value } : new MySqlParameter("@FLOWTYPE", MySqlDbType.Int32) { Value = model.FLOWTYPE },
|
|
new MySqlParameter("@AUTHORITYTYPE", MySqlDbType.VarChar, 2){ Value = model.AUTHORITYTYPE },
|
|
new MySqlParameter("@ORG_ID", MySqlDbType.VarChar){ Value = model.ORG_ID }
|
|
};
|
|
int i = dbHelper.Execute(strsql, parameters);
|
|
if (i > 0)
|
|
{
|
|
return true;
|
|
}
|
|
else
|
|
{
|
|
return false;
|
|
}
|
|
}
|
|
/// <summary>
|
|
/// flow用的
|
|
///修改
|
|
/// </summary>
|
|
public bool flowEdit(Model.TBL.TBL_SYS_MENU_Model model)
|
|
{
|
|
RoadFlow.Data.ORACLE.DBHelper dbHelper = new RoadFlow.Data.ORACLE.DBHelper();
|
|
string strsql = "UPDATE TBL_SYS_MENU SET " +
|
|
"MENU_TITLE =@MENU_TITLE,Address=@Address,Type=@Type,OpenMode=@OpenMode,Width=@Width,Height=@Height,Params=@Params,Manager=@Manager,Note=@Note,Code=@Code,UseMember=@UseMember " +
|
|
" where ID=@ID";
|
|
MySqlParameter[] parameters = new MySqlParameter[]{
|
|
new MySqlParameter("@MENU_TITLE", MySqlDbType.VarChar, 510){ Value = model.MENU_TITLE },
|
|
new MySqlParameter("@Address", MySqlDbType.VarChar, 200){ Value = model.Address },
|
|
new MySqlParameter("@Type", MySqlDbType.VarChar, 50){ Value = model.Type },
|
|
new MySqlParameter("@OpenMode", MySqlDbType.Int32){ Value = model.OpenMode },
|
|
model.Width == null ? new MySqlParameter("@Width", MySqlDbType.Int32) { Value = DBNull.Value } : new MySqlParameter("@Width", MySqlDbType.Int32) { Value = model.Width },
|
|
model.Height == null ? new MySqlParameter("@Height", MySqlDbType.Int32) { Value = DBNull.Value } : new MySqlParameter("@Height", MySqlDbType.Int32) { Value = model.Height },
|
|
model.Params == null ? new MySqlParameter("@Params", MySqlDbType.VarChar) { Value = DBNull.Value } : new MySqlParameter("@Params", MySqlDbType.VarChar) { Value = model.Params },
|
|
model.Manager == null ? new MySqlParameter("@Manager", MySqlDbType.VarChar) { Value = DBNull.Value } : new MySqlParameter("@Manager", MySqlDbType.VarChar) { Value = model.Manager },
|
|
model.Note == null ? new MySqlParameter("@Note", MySqlDbType.VarChar) { Value = DBNull.Value } : new MySqlParameter("@Note", MySqlDbType.VarChar) { Value = model.Note },
|
|
model.Code == null ? new MySqlParameter("@Code", MySqlDbType.VarChar, 50) { Value = DBNull.Value } : new MySqlParameter("@Code", MySqlDbType.VarChar, 50) { Value = model.Code },
|
|
model.UseMember == null ? new MySqlParameter("@UseMember", MySqlDbType.VarChar) { Value = DBNull.Value } : new MySqlParameter("@UseMember", MySqlDbType.VarChar) { Value = model.UseMember },
|
|
new MySqlParameter("@ID", MySqlDbType.VarChar){ Value = model.ID }
|
|
};
|
|
int i = dbHelper.Execute(strsql, parameters);
|
|
if (i > 0) { return true; }
|
|
else { return false; }
|
|
}
|
|
|
|
/// <summary>
|
|
/// flow用的
|
|
/// 根据type字段查询list集合
|
|
/// </summary>
|
|
/// <param name="model"></param>
|
|
/// <returns></returns>
|
|
public List<FangYar.Model.TBL.TBL_SYS_MENU_Model> typegetmenu(string type)
|
|
{
|
|
RoadFlow.Data.ORACLE.DBHelper dbHelper = new RoadFlow.Data.ORACLE.DBHelper();
|
|
string sql = "SELECT ID,MENU_TITLE,ADDRESS,TYPE,OPENMODE,WIDTH,Height,Params,Manager,Note,Code,UseMember FROM TBL_SYS_MENU WHERE FLOWTYPE = 1 and Type IN(" + RoadFlow.Utility.Tools.GetSqlInString(type) + ")";
|
|
var dataReader = dbHelper.GetDataReader(sql);
|
|
List<FangYar.Model.TBL.TBL_SYS_MENU_Model> List = DataReaderToList(dataReader);
|
|
return List;
|
|
}
|
|
/// <summary>
|
|
/// flow用的
|
|
/// 将DataRedar转换为List
|
|
/// </summary>
|
|
private List<FangYar.Model.TBL.TBL_SYS_MENU_Model> DataReaderToList(DataTable dataReader)
|
|
{
|
|
List<FangYar.Model.TBL.TBL_SYS_MENU_Model> List = new List<FangYar.Model.TBL.TBL_SYS_MENU_Model>();
|
|
FangYar.Model.TBL.TBL_SYS_MENU_Model model = null;
|
|
for (int i = 0; i < dataReader.Rows.Count; i++)
|
|
{
|
|
model = new FangYar.Model.TBL.TBL_SYS_MENU_Model();
|
|
model.ID = dataReader.Rows[i][0] + "";
|
|
model.MENU_TITLE = dataReader.Rows[i][1] + "";
|
|
model.Address = dataReader.Rows[i][2] + "";
|
|
model.Type = dataReader.Rows[i][3] + "";
|
|
int.TryParse(dataReader.Rows[i][4] + "", out int n4);
|
|
model.OpenMode = n4;
|
|
int.TryParse(dataReader.Rows[i][5] + "", out int n5);
|
|
model.Width = n5;
|
|
int.TryParse(dataReader.Rows[i][6] + "", out int n6);
|
|
model.Height = n6;
|
|
model.Params = dataReader.Rows[i][7] + "";
|
|
model.Manager = dataReader.Rows[i][8] + "";
|
|
model.Note = dataReader.Rows[i][9] + "";
|
|
model.Code = dataReader.Rows[i][10] + "";
|
|
model.UseMember = dataReader.Rows[i][11] + "";
|
|
List.Add(model);
|
|
}
|
|
return List;
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
/// flow用的
|
|
/// 根据CODE获取实体对象
|
|
/// </summary>
|
|
public Model.TBL.TBL_SYS_MENU_Model GetModelByCODE(string code)
|
|
{
|
|
RoadFlow.Data.ORACLE.DBHelper dbHelper = new RoadFlow.Data.ORACLE.DBHelper();
|
|
string sql = "SELECT ID,MENU_TITLE,ADDRESS,TYPE,OPENMODE,WIDTH,Height,Params,Manager,Note,Code,UseMember FROM TBL_SYS_MENU WHERE Code=@Code";
|
|
MySqlParameter[] parameters = new MySqlParameter[]{
|
|
new MySqlParameter("@Code", MySqlDbType.VarChar, 50){ Value = code }
|
|
};
|
|
var dataReader = dbHelper.GetDataReader(sql, parameters);
|
|
List<Model.TBL.TBL_SYS_MENU_Model> List = DataReaderToList(dataReader);
|
|
return List.Count > 0 ? List[0] : null;
|
|
}
|
|
#endregion
|
|
|
|
}
|
|
}
|
|
|