/// <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); }