/// <summary>
/// 得到GetList()的代码
/// </summary>
/// <param name="_tablename"></param>
/// <param name="_key"></param>
/// <returns></returns>
public string CreatGetListByPageProc()
{
StringPlus strclass = new StringPlus();
strclass.AppendSpaceLine(2, "/*");
strclass.AppendSpaceLine(2, "/// <summary>");
strclass.AppendSpaceLine(2, "/// 分页获取数据列表");
strclass.AppendSpaceLine(2, "/// </summary>");
strclass.AppendSpaceLine(2, "public DataSet GetList(int PageSize,int PageIndex,string strWhere)");
strclass.AppendSpaceLine(2, "{");
strclass.AppendSpaceLine(3, "" + DbParaHead + "Parameter[] parameters = {");
strclass.AppendSpaceLine(5, "new " + DbParaHead + "Parameter(\"" + preParameter + "tblName\", " + DbParaDbType + ".VarChar, 255),");
strclass.AppendSpaceLine(5, "new " + DbParaHead + "Parameter(\"" + preParameter + "fldName\", " + DbParaDbType + ".VarChar, 255),");
strclass.AppendSpaceLine(5, "new " + DbParaHead + "Parameter(\"" + preParameter + "PageSize\", " + DbParaDbType + "." + CodeCommon.CSToProcType(dbobj.DbType, "int") + "),");
strclass.AppendSpaceLine(5, "new " + DbParaHead + "Parameter(\"" + preParameter + "PageIndex\", " + DbParaDbType + "." + CodeCommon.CSToProcType(dbobj.DbType, "int") + "),");
strclass.AppendSpaceLine(5, "new " + DbParaHead + "Parameter(\"" + preParameter + "IsReCount\", " + DbParaDbType + "." + CodeCommon.CSToProcType(dbobj.DbType, "bit") + "),");
strclass.AppendSpaceLine(5, "new " + DbParaHead + "Parameter(\"" + preParameter + "OrderType\", " + DbParaDbType + "." + CodeCommon.CSToProcType(dbobj.DbType, "bit") + "),");
strclass.AppendSpaceLine(5, "new " + DbParaHead + "Parameter(\"" + preParameter + "strWhere\", " + DbParaDbType + ".VarChar,1000),");
strclass.AppendSpaceLine(5, "};");
strclass.AppendSpaceLine(3, "parameters[0].Value = \"" + this.TableName + "\";");
strclass.AppendSpaceLine(3, "parameters[1].Value = \"" + this._key + "\";");
strclass.AppendSpaceLine(3, "parameters[2].Value = PageSize;");
strclass.AppendSpaceLine(3, "parameters[3].Value = PageIndex;");
strclass.AppendSpaceLine(3, "parameters[4].Value = 0;");
strclass.AppendSpaceLine(3, "parameters[5].Value = 0;");
strclass.AppendSpaceLine(3, "parameters[6].Value = strWhere; ");
strclass.AppendSpaceLine(3, "return " + DbHelperName + ".RunProcedure(\"UP_GetRecordByPage\",parameters,\"ds\");");
strclass.AppendSpaceLine(2, "}*/");
return(strclass.Value);
}
public string CreatGetListByPageProc()
{
StringPlus stringPlus = new StringPlus();
stringPlus.AppendSpaceLine(2, "/*");
stringPlus.AppendSpaceLine(2, "/// <summary>");
stringPlus.AppendSpaceLine(2, "/// " + this.Languagelist["summaryGetList3"].ToString());
stringPlus.AppendSpaceLine(2, "/// </summary>");
stringPlus.AppendSpaceLine(2, "public DataSet GetList(int PageSize,int PageIndex,string strWhere)");
stringPlus.AppendSpaceLine(2, "{");
stringPlus.AppendSpaceLine(3, this.DbParaHead + "Parameter[] parameters = {");
stringPlus.AppendSpaceLine(5, string.Concat(new string[]
{
"new ",
this.DbParaHead,
"Parameter(\"",
this.preParameter,
"tblName\", ",
this.DbParaDbType,
".VarChar, 255),"
}));
stringPlus.AppendSpaceLine(5, string.Concat(new string[]
{
"new ",
this.DbParaHead,
"Parameter(\"",
this.preParameter,
"fldName\", ",
this.DbParaDbType,
".VarChar, 255),"
}));
stringPlus.AppendSpaceLine(5, string.Concat(new string[]
{
"new ",
this.DbParaHead,
"Parameter(\"",
this.preParameter,
"PageSize\", ",
this.DbParaDbType,
".",
CodeCommon.CSToProcType(this.dbobj.DbType, "int"),
"),"
}));
stringPlus.AppendSpaceLine(5, string.Concat(new string[]
{
"new ",
this.DbParaHead,
"Parameter(\"",
this.preParameter,
"PageIndex\", ",
this.DbParaDbType,
".",
CodeCommon.CSToProcType(this.dbobj.DbType, "int"),
"),"
}));
stringPlus.AppendSpaceLine(5, string.Concat(new string[]
{
"new ",
this.DbParaHead,
"Parameter(\"",
this.preParameter,
"IsReCount\", ",
this.DbParaDbType,
".",
CodeCommon.CSToProcType(this.dbobj.DbType, "bit"),
"),"
}));
stringPlus.AppendSpaceLine(5, string.Concat(new string[]
{
"new ",
this.DbParaHead,
"Parameter(\"",
this.preParameter,
"OrderType\", ",
this.DbParaDbType,
".",
CodeCommon.CSToProcType(this.dbobj.DbType, "bit"),
"),"
}));
stringPlus.AppendSpaceLine(5, string.Concat(new string[]
{
"new ",
this.DbParaHead,
"Parameter(\"",
this.preParameter,
"strWhere\", ",
this.DbParaDbType,
".VarChar,1000),"
}));
stringPlus.AppendSpaceLine(5, "};");
stringPlus.AppendSpaceLine(3, "parameters[0].Value = \"" + this.TableName + "\";");
stringPlus.AppendSpaceLine(3, "parameters[1].Value = \"" + this._key + "\";");
stringPlus.AppendSpaceLine(3, "parameters[2].Value = PageSize;");
stringPlus.AppendSpaceLine(3, "parameters[3].Value = PageIndex;");
stringPlus.AppendSpaceLine(3, "parameters[4].Value = 0;");
stringPlus.AppendSpaceLine(3, "parameters[5].Value = 0;");
stringPlus.AppendSpaceLine(3, "parameters[6].Value = strWhere;\t");
stringPlus.AppendSpaceLine(3, "return " + this.DbHelperName + ".RunProcedure(\"UP_GetRecordByPage\",parameters,\"ds\");");
stringPlus.AppendSpaceLine(2, "}*/");
return(stringPlus.Value);
}