/// <summary>
///
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int DeleteSysModelFunction(SysModelFunction info)
{
string strSql = "";
if (this.Sql.GetSql("Manager.SysModelFunctionManager.Delete", ref strSql) == -1)
{
return(-1);
}
try
{
strSql = string.Format(strSql, info.ID);
}
catch (Exception ex)
{
this.ErrCode = ex.Message;
this.Err = ex.Message;
return(-1);
}
try
{
return(this.ExecNoQuery(strSql));
}
catch (Exception ex)
{
this.ErrCode = ex.Message;
this.Err = ex.Message;
return(-1);
}
}
/// <summary>
/// 查询所有
/// 功能
/// </summary>
public ArrayList QuerySysModelFunction()
{
string sqlstring = PrepareSQL("Manager.SysModelFunctionManager.Select", null);
ArrayList SysModelFunctions = new ArrayList();
if (sqlstring == string.Empty)
{
return(SysModelFunctions);
}
try
{
this.ExecQuery(sqlstring);
while (this.Reader.Read())
{
SysModelFunction info = PrepareData();
if (info != null)
{
SysModelFunctions.Add(info);
}
}
}
catch (Exception ex)
{
this.ErrCode = ex.Message;
this.Err = ex.Message;
SysModelFunctions.Clear();
}
return(SysModelFunctions);
}
/// <summary>
///
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int InsertSysModelFunction(SysModelFunction info)
{
string strSql = "";
if (this.Sql.GetSql("Manager.SysModelFunctionManager.Insert", ref strSql) == -1)
{
return(-1);
}
try
{
strSql = string.Format(strSql,
info.SysCode, //0
info.WinName, //1
info.FunName, //2
info.Memo, //3
info.SortID, //4
this.Operator.ID,
"", //操作时间
info.DllName, //7
info.FormShowType, //8
info.FormType, //9
info.TreeControl.DllName, //10
info.TreeControl.WinName, //11
info.Param, //12
info.TreeControl.Param, //13
info.ID); //14
}
catch (Exception ex)
{
this.Err = ex.Message;
this.ErrCode = ex.Message;
return(-1);
}
return(this.ExecNoQuery(strSql));
}
/// <summary>
/// 私有获得数据给实体
/// </summary>
/// <returns></returns>
protected SysModelFunction PrepareData()
{
SysModelFunction info = new SysModelFunction();
info.SysCode = this.Reader[0].ToString();
info.WinName = this.Reader[1].ToString();
info.FunName = this.Reader[2].ToString();
info.Memo = this.Reader[3].ToString();
info.SortID = Neusoft.FrameWork.Function.NConvert.ToInt32(this.Reader[4].ToString());
info.DllName = this.Reader[7].ToString();
info.FormShowType = this.Reader[8].ToString();
info.FormType = this.Reader[9].ToString();
info.TreeControl.DllName = this.Reader[10].ToString();
info.TreeControl.WinName = this.Reader[11].ToString();
info.Param = this.Reader[12].ToString();
info.TreeControl.Param = this.Reader[13].ToString();
info.ID = this.Reader[14].ToString();
return(info);
}
/// <summary>
/// 查询系统模块-通过模块类别
/// </summary>
/// <returns></returns>
public ArrayList QuerySysModelFunctionByType(string FormType)
{
string sqlSelect = "";
if (this.Sql.GetSql("Manager.SysModelFunctionManager.Select", ref sqlSelect) == -1)
{
this.Err = this.Sql.Err;
return(null);
}
string sqlstring = PrepareSQL("Manager.SysModelFunctionManager.Where.ByFormType", new string[] { FormType });
ArrayList SysModelFunctions = new ArrayList();
if (sqlstring == string.Empty)
{
return(SysModelFunctions);
}
try
{
this.ExecQuery(sqlSelect + " " + sqlstring);
while (this.Reader.Read())
{
SysModelFunction info = PrepareData();
if (info != null)
{
SysModelFunctions.Add(info);
}
}
this.Reader.Close();
}
catch (Exception ex)
{
this.ErrCode = ex.Message;
this.Err = ex.Message;
SysModelFunctions.Clear();
}
return(SysModelFunctions);
}
