public PageDataStrMaker(IHashObject qryParams, SQLHelper helper, string conString, int pageIndex, int pageCount, string sort)
: base(qryParams, helper, conString)
{
this.index = pageIndex;
this.count = pageCount;
this.sortInfo = sort;
}
public RightsSQLMaker(IHashObject qryParams, SQLHelper helper, string conString)
: base(qryParams, helper, conString)
{
}
public RecordCountMaker(IHashObject qryParams, SQLHelper helper, string conString)
: base(qryParams, helper, conString)
{
}
public FunctionStrMaker(IHashObject qryParams, SQLHelper sqlHelper, string conString)
{
this.conStr = conString;
this.helper = sqlHelper;
QueryParams = qryParams;
}
public void getBaseSqlInfo(out string baseSQl, out List<string> userParams, out List<string> sysParams, out IHashObject defaultValue)
{
baseSQl = getBaseSQL();
if (helper == null) helper = new SQLHelper();
helper.getAllParams(baseSQl, out userParams, out sysParams, out defaultValue);
}
protected void checkSQL(string sql)
{
string errInfo = "";
SQLHelper h = new SQLHelper();
List<string> sysParams, userParams;
IHashObject defaultValue = null;
h.getAllParams(sql, out userParams, out sysParams, out defaultValue);
bool haveSys = false;
foreach (string param in userParams)
{
errInfo += "用户参数： [" + param + "] 没有设置对应的值，请检查输入参数\n\r";
}
foreach (string param in sysParams)
{
errInfo += "公用变量： [" + param + "] 没有设置对应的值，请检查注册的处理器\n\r";
haveSys = true;
}
if (errInfo != "")
{
if (haveSys)
{
errInfo += "\n\r\n\r";
errInfo += "[当前注册的公用变量]:" + "\n\r";
foreach (FunctionStrMaker maker in funcMakers)
{
errInfo += "类名：" + maker.GetType().Name + "\n\r";
foreach (KeyValuePair<string, object> pair in maker.tags)
{
errInfo += " " + pair.Key + "\n\r";
}
}
}
Clipboard.Clear();
Clipboard.SetText(errInfo);
System.Windows.Forms.MessageBox.Show(errInfo);
}
}
public virtual void setTestParams()
{
if (helper == null) helper = new SQLHelper();
if (queryParams == null)
{
queryParams = new HashObject();
string sql = getBaseSQL();
helper.setSQL(getBaseSQL(), queryParams);
}
else
helper.setSQL(getBaseSQL(), queryParams);
}
public void ini(DbHelper dbHelper, IHashObject qryParams)
{
try
{
this.funcMakers = new List<FunctionStrMaker>();
this.wrappers = new List<FunctionStrMaker>();
this.db = dbHelper;
this.queryParams = qryParams;
executeSql = new ExecuteSQL();
helper = new SQLHelper();
innerIni(dbHelper, qryParams);
}
catch (Exception e)
{
System.Windows.Forms.MessageBox.Show(e.Message);
}
}
public PageSumMaker(IHashObject qryParams, SQLHelper helper, string conString)
: base(qryParams, helper, conString)
{
}