获得显示顺序最大值 - ShowSeqDefaultGetMax
2017-02-21 23:06:52 访问(1581) 赞(0) 踩(0)
/// <summary>
/// 获得显示顺序最大值 - ShowSeqDefaultGetMax
/// </summary>
/// <param name="listShowSeqAssistParams"></param>
/// <param name="xdbHelper">数据库链接串</param>
/// <returns></returns>
public int ShowSeqDefaultGetMax
(
List<ShowSeqAssistParams> listShowSeqAssistParams,
DBHelper xdbHelper
)
{
BaseEntity entity = CreateBaseEntity();
string showSeqDataColumnName
= entity.GetExistShowSeqDataColumnName();
int theResult = 0;
bool bIsCreate = true;
if (xdbHelper == null)
{
xdbHelper = SlowX.DAL.Helpers.DBHelper.CreateDBHelper();
}
else
{
// 没有打开链接 //
bIsCreate = xdbHelper.IsNotOpen();
}
try
{
if (bIsCreate)
xdbHelper.OpenDBHelper();
if (listShowSeqAssistParams != null)
{
EntityFieldInfo info = null;
foreach (ShowSeqAssistParams p in listShowSeqAssistParams)
{
if (p == null)
continue;
info = entity.GetExistEntityFieldInfo(p.dataColumnName);
entity.i_iqueryDriver.AddIQueryItemWithEntityFieldInfo(info, p.theValue);
}
}
entity.maxEntityFieldInfo = entity.GetExistEntityFieldInfo
(
showSeqDataColumnName
);
object oResult = _Max(entity, xdbHelper);
if (oResult == null || oResult.ToString().Length == 0)
theResult = 0;
else
theResult = Convert.ToInt32(oResult);
if (bIsCreate)
xdbHelper.EndDBHelper();
}
catch (Exception err)
{
if (bIsCreate)
xdbHelper.TranDBHelper();
throw err;
}
finally
{
if (bIsCreate)
xdbHelper.FinallyDBHelper();
}
return theResult;
}
/// <summary>
/// 获得最大值 - ShowSeqGetMax
/// </summary>
/// <param name="xdbHelper">数据库链接串</param>
/// <returns></returns>
public int ShowSeqGetMax
(
DBHelper xdbHelper
)
{
int theResult = 0;
bool bIsCreate = true;
if (xdbHelper == null)
{
xdbHelper = SlowX.DAL.Helpers.DBHelper.CreateDBHelper();
}
else
{
// 没有打开链接 //
bIsCreate = xdbHelper.IsNotOpen();
}
try
{
if (bIsCreate)
xdbHelper.OpenDBHelper();
BaseEntity entity = CreateBaseEntity();
string showSeqDataColumnName
= entity.GetExistShowSeqDataColumnName();
entity.maxEntityFieldInfo = entity.GetExistEntityFieldInfo
(
showSeqDataColumnName
);
object oResult = _Max(entity, xdbHelper);
if (oResult == null || oResult.ToString().Length == 0)
theResult = 0;
else
theResult = Convert.ToInt32(oResult);
if (bIsCreate)
xdbHelper.EndDBHelper();
}
catch (Exception err)
{
if (bIsCreate)
xdbHelper.TranDBHelper();
throw err;
}
finally
{
if (bIsCreate)
xdbHelper.FinallyDBHelper();
}
return theResult;
}
/// <summary>
/// 获得最大值 - ShowSeqGetMax
/// </summary>
/// <param name="showSeqDataColumnName"></param>
/// <param name="xdbHelper">数据库链接串</param>
/// <returns></returns>
public int ShowSeqGetMax
(
string showSeqDataColumnName,
DBHelper xdbHelper
)
{
int theResult = 0;
bool bIsCreate = true;
if (xdbHelper == null)
{
xdbHelper = SlowX.DAL.Helpers.DBHelper.CreateDBHelper();
}
else
{
// 没有打开链接 //
bIsCreate = xdbHelper.IsNotOpen();
}
try
{
if (bIsCreate)
xdbHelper.OpenDBHelper();
BaseEntity entity = CreateBaseEntity();
entity.maxEntityFieldInfo = entity.GetExistEntityFieldInfo
(
showSeqDataColumnName
);
object oResult = _Max(entity, xdbHelper);
if (oResult == null || oResult.ToString().Length == 0)
theResult = 0;
else
theResult = Convert.ToInt32(oResult);
if (bIsCreate)
xdbHelper.EndDBHelper();
}
catch (Exception err)
{
if (bIsCreate)
xdbHelper.TranDBHelper();
throw err;
}
finally
{
if (bIsCreate)
xdbHelper.FinallyDBHelper();
}
return theResult;
}
/// <summary>
/// 获得最大值 - ShowSeqGetMax
/// </summary>
/// <param name="showSeqDataColumnName"></param>
/// <param name="configDataColumnName"></param>
/// <param name="configDataColumnValue"></param>
/// <param name="xdbHelper">数据库链接串</param>
/// <returns></returns>
public int ShowSeqGetMax
(
string showSeqDataColumnName,
string configDataColumnName,
object configDataColumnValue,
DBHelper xdbHelper
)
{
int theResult = 0;
bool bIsCreate = true;
if (xdbHelper == null)
{
xdbHelper = SlowX.DAL.Helpers.DBHelper.CreateDBHelper();
}
else
{
// 没有打开链接 //
bIsCreate = xdbHelper.IsNotOpen();
}
try
{
if (bIsCreate)
xdbHelper.OpenDBHelper();
BaseEntity entity = CreateBaseEntity();
if (configDataColumnName != null && configDataColumnName.Length > 0)
{
EntityFieldInfo info = entity.GetExistEntityFieldInfo(configDataColumnName);
entity.i_iqueryDriver.AddIQueryItemWithEntityFieldInfo(info, configDataColumnValue);
}
entity.maxEntityFieldInfo = entity.GetExistEntityFieldInfo
(
showSeqDataColumnName
);
object oResult = _Max(entity, xdbHelper);
if (oResult == null || oResult.ToString().Length == 0)
theResult = 0;
else
theResult = Convert.ToInt32(oResult);
if (bIsCreate)
xdbHelper.EndDBHelper();
}
catch (Exception err)
{
if (bIsCreate)
xdbHelper.TranDBHelper();
throw err;
}
finally
{
if (bIsCreate)
xdbHelper.FinallyDBHelper();
}
return theResult;
}
/// <summary>
/// 获得最大值 - ShowSeqGetMax
/// </summary>
/// <param name="showSeqDataColumnName"></param>
/// <param name="listShowSeqAssistParams"></param>
/// <param name="xdbHelper">数据库链接串</param>
/// <returns></returns>
public int ShowSeqGetMax
(
string showSeqDataColumnName,
List<ShowSeqAssistParams> listShowSeqAssistParams,
DBHelper xdbHelper
)
{
int theResult = 0;
bool bIsCreate = true;
if (xdbHelper == null)
{
xdbHelper = SlowX.DAL.Helpers.DBHelper.CreateDBHelper();
}
else
{
// 没有打开链接 //
bIsCreate = xdbHelper.IsNotOpen();
}
try
{
if (bIsCreate)
xdbHelper.OpenDBHelper();
BaseEntity entity = CreateBaseEntity();
if (listShowSeqAssistParams != null)
{
EntityFieldInfo info = null;
foreach (ShowSeqAssistParams p in listShowSeqAssistParams)
{
if (p == null)
continue;
info = entity.GetExistEntityFieldInfo(p.dataColumnName);
entity.i_iqueryDriver.AddIQueryItemWithEntityFieldInfo(info, p.theValue);
}
}
entity.maxEntityFieldInfo = entity.GetExistEntityFieldInfo
(
showSeqDataColumnName
);
object oResult = _Max(entity, xdbHelper);
if (oResult == null || oResult.ToString().Length == 0)
theResult = 0;
else
theResult = Convert.ToInt32(oResult);
if (bIsCreate)
xdbHelper.EndDBHelper();
}
catch (Exception err)
{
if (bIsCreate)
xdbHelper.TranDBHelper();
throw err;
}
finally
{
if (bIsCreate)
xdbHelper.FinallyDBHelper();
}
return theResult;
}
标签：
获得显示顺序最大值 - ShowSeqDefaultGetMax 
上一条：
下一条：
相关评论
发表评论