/****************************************************************************************************************************/
private void CompareProcess(DicParam db)
{
if (db.Compare == CompareXEnum.In ||
db.Compare == CompareXEnum.NotIn)
{
InProcess(db);
}
else if (db.Compare == CompareXEnum.Like ||
db.Compare == CompareXEnum.NotLike)
{
LikeProcess(db);
}
else
{
Spacing(X);
if (db.Crud == CrudEnum.Join)
{
DbSql.Column(db.TbAlias, db.TbCol, X);
}
else if (DC.IsSingleTableOption())
{
DbSql.Column(string.Empty, db.TbCol, X);
}
Compare(db.Compare, X, DC); DbSql.DbParam(db.Param, X);
}
}
private void IsNullProcess(DicParam db)
{
Spacing(X);
if (db.Crud == CrudEnum.Join)
{
DbSql.Column(db.TbAlias, db.TbCol, X);
}
else if (DC.IsSingleTableOption())
{
DbSql.Column(string.Empty, db.TbCol, X);
}
Spacing(X); Option(db.Option, X, DC);
}
private void LikeProcess(DicParam db)
{
Spacing(X);
if (db.Crud == CrudEnum.Join)
{
DbSql.Column(db.TbAlias, db.TbCol, X);
}
else if (DC.IsSingleTableOption())
{
DbSql.Column(string.Empty, db.TbCol, X);
}
Compare(db.Compare, X, DC); LikeStrHandle(db);
}
private void LikeProcess(DicParam db)
{
Spacing(X);
if (db.Crud == CrudEnum.Join)
{
Column(db.TableAliasOne, db.ColumnOne, X);
}
else if (DC.IsSingleTableOption())
{
Column(string.Empty, db.ColumnOne, X);
}
Option(db.Option, X); LikeStrHandle(db);
}
/****************************************************************************************************************/
private void CompareProcess(DicParam db)
{
Spacing(X);
if (db.Crud == CrudEnum.Join)
{
Column(db.TableAliasOne, db.ColumnOne, X);
}
else if (DC.IsSingleTableOption())
{
Column(string.Empty, db.ColumnOne, X);
}
Compare(db.Compare, X); DbParam(db.Param, X);
}
private void InProcess(DicParam db)
{
Spacing(X);
if (db.Crud == CrudEnum.Join)
{
DbSql.Column(db.TbAlias, db.TbCol, X);
}
else if (DC.IsSingleTableOption())
{
DbSql.Column(string.Empty, db.TbCol, X);
}
Spacing(X);
Compare(db.Compare, X, DC); LeftRoundBracket(X); InParams(db.InItems); RightRoundBracket(X);
}
private void InProcess(DicParam db)
{
Spacing(X);
if (db.Crud == CrudEnum.Join)
{
Column(db.TableAliasOne, db.ColumnOne, X);
}
else if (DC.IsSingleTableOption())
{
Column(string.Empty, db.ColumnOne, X);
}
Spacing(X);
Function(db.Func, X); LeftBracket(X); InParams(db.InItems); RightBracket(X);
}
private void TrimProcess(DicParam db)
{
Spacing(X);
Function(db.Func, X, DC); LeftRoundBracket(X);
if (db.Crud == CrudEnum.Join)
{
DbSql.Column(db.TbAlias, db.TbCol, X);
}
else if (DC.IsSingleTableOption())
{
DbSql.Column(string.Empty, db.TbCol, X);
}
RightRoundBracket(X);
Compare(db.Compare, X, DC); DbSql.DbParam(db.Param, X);
}
private void TrimProcess(DicParam db)
{
Spacing(X);
Function(db.Func, X); LeftBracket(X);
if (db.Crud == CrudEnum.Join)
{
Column(db.TableAliasOne, db.ColumnOne, X);
}
else if (DC.IsSingleTableOption())
{
Column(string.Empty, db.ColumnOne, X);
}
RightBracket(X);
Compare(db.Compare, X); DbParam(db.Param, X);
}
private void DateFormatProcess(DicParam db)
{
Spacing(X);
Function(db.Func, X); LeftBracket(X);
if (db.Crud == CrudEnum.Join)
{
Column(db.TableAliasOne, db.ColumnOne, X);
}
else if (DC.IsSingleTableOption())
{
Column(string.Empty, db.ColumnOne, X);
}
Comma(X); SingleQuote(X); X.Append(db.Format); SingleQuote(X);
RightBracket(X); Compare(db.Compare, X); DbParam(db.Param, X);
}