/****************************************
***生成器版本：V1.0.1.31494
***生成时间：2013-04-24 18:43:49
***公司：山西ICat Studio有限公司
***友情提示：以下代码为生成器自动生成，可做参照修改之用；
*** 如需有其他业务要求，可在region外添加新方法；
*** 如发现任何编译和运行时错误，请联系QQ：330669393。
*****************************************/
#region public members methods
/// <summary>
/// 根据条件筛选所有WLOGProjectTree指定页码的数据（分页型）
/// </summary>
/// <param name="wlogprojecttree">实体对象</param>
/// <param name="pageparams">分页对象</param>
/// <returns></returns>
public string GetJsonByPage(EntityWLOGProjectTree wlogprojecttree, PageParams pageparams)
{
#region
int totalCount = 0;
WLOGProjectTreeClass wlogprojecttreeclass = new WLOGProjectTreeClass();
pageparams.PageSorts.Add(new PageSort(WLOGProjectTreeData.writeTime, EnumSQLOrderBY.DESC));
DataSet wlogprojecttreedata = this.GetData(wlogprojecttree, pageparams, out totalCount);
return(base.GetJson(wlogprojecttreedata, totalCount));
#endregion
}
/// <summary>
/// 将符合查询的数据导出Excel
/// </summary>
/// <param name="filename"></param>
/// <param name="grid"></param>
/// <param name="httplink"></param>
public void OutputExcel(string filename, ExtjsGrid grid, EntityWLOGProjectTree wlogprojecttree)
{
#region
int totalcount = 0;
PageParams queryparams = new PageParams(1, 65536);
DataSet ds = this.GetData(wlogprojecttree, queryparams, out totalcount);
ExportExcel exportexcel = new ExportExcel(filename, ds, grid);
exportexcel.Output();
#endregion
}
/// <summary>
/// 添加WLOGProjectTree表行数据（如主键为非自增型字段，则自行修改代码）
/// </summary>
/// <param name="wlogprojecttreedata">数据集对象</param>
/// <param name="wlogprojecttree">实体对象</param>
public void AddRow(ref WLOGProjectTreeData wlogprojecttreedata, EntityWLOGProjectTree wlogprojecttree)
{
#region
DataRow dr = wlogprojecttreedata.Tables[0].NewRow();
wlogprojecttree.currentId = this._wlogprojecttreeclass.GetMaxAddOne(wlogprojecttreedata).ToString();
wlogprojecttreedata.Assign(dr, WLOGProjectTreeData.parentId, wlogprojecttree.parentId);
wlogprojecttreedata.Assign(dr, WLOGProjectTreeData.currentId, wlogprojecttree.currentId);
wlogprojecttreedata.Assign(dr, WLOGProjectTreeData.writeUser, wlogprojecttree.writeUser);
wlogprojecttreedata.Assign(dr, WLOGProjectTreeData.dirName, wlogprojecttree.dirName);
wlogprojecttreedata.Assign(dr, WLOGProjectTreeData.usable, wlogprojecttree.usable);
wlogprojecttreedata.Assign(dr, WLOGProjectTreeData.writeIp, wlogprojecttree.writeIp);
wlogprojecttreedata.Assign(dr, WLOGProjectTreeData.writeTime, wlogprojecttree.writeTime);
wlogprojecttreedata.Tables[0].Rows.Add(dr);
#endregion
}
/// <summary>
/// 编辑wlogprojecttreedata数据集中指定的行数据
/// </summary>
/// <param name="wlogprojecttreedata">数据集对象</param>
/// <param name="wlogprojecttree">实体对象</param>
public void EditRow(ref WLOGProjectTreeData wlogprojecttreedata, EntityWLOGProjectTree wlogprojecttree)
{
#region
if (wlogprojecttreedata.Tables[0].Rows.Count <= 0)
{
wlogprojecttreedata = this.getData(wlogprojecttree.currentId);
}
DataRow dr = wlogprojecttreedata.Tables[0].Rows.Find(new object[1] {
wlogprojecttree.currentId
});
wlogprojecttreedata.Assign(dr, WLOGProjectTreeData.parentId, wlogprojecttree.parentId);
wlogprojecttreedata.Assign(dr, WLOGProjectTreeData.currentId, wlogprojecttree.currentId);
wlogprojecttreedata.Assign(dr, WLOGProjectTreeData.writeUser, wlogprojecttree.writeUser);
wlogprojecttreedata.Assign(dr, WLOGProjectTreeData.dirName, wlogprojecttree.dirName);
wlogprojecttreedata.Assign(dr, WLOGProjectTreeData.usable, wlogprojecttree.usable);
wlogprojecttreedata.Assign(dr, WLOGProjectTreeData.writeIp, wlogprojecttree.writeIp);
wlogprojecttreedata.Assign(dr, WLOGProjectTreeData.writeTime, wlogprojecttree.writeTime);
#endregion
}
/// <summary>
/// 根据条件筛选所有WLOGProjectTree指定页码的数据（分页型）
/// </summary>
/// <param name="wlogprojecttree">实体对象</param>
/// <param name="pageparams">分页对象</param>
/// <param name="totalCount">符合条件的记录总数量</param>
/// <returns></returns>
public DataSet GetData(EntityWLOGProjectTree wlogprojecttree, PageParams pageparams, out int totalCount)
{
#region
DBConditions querybusinessparams = new DBConditions(pageparams);
querybusinessparams.Add(WLOGProjectTreeData.parentId, EnumSqlType.sqlint,
EnumCondition.Equal, wlogprojecttree.parentId);
querybusinessparams.Add(WLOGProjectTreeData.currentId, EnumSqlType.sqlint,
EnumCondition.Equal, wlogprojecttree.currentId);
querybusinessparams.Add(WLOGProjectTreeData.writeUser, EnumSqlType.sqlint,
EnumCondition.Equal, wlogprojecttree.writeUser);
querybusinessparams.Add(WLOGProjectTreeData.dirName, EnumSqlType.nvarchar,
EnumCondition.Equal, wlogprojecttree.dirName);
querybusinessparams.Add(WLOGProjectTreeData.usable, EnumSqlType.bit,
EnumCondition.Equal, wlogprojecttree.usable);
querybusinessparams.Add(WLOGProjectTreeData.writeIp, EnumSqlType.nvarchar,
EnumCondition.Equal, wlogprojecttree.writeIp);
querybusinessparams.Add(WLOGProjectTreeData.writeTime, EnumSqlType.datetime,
EnumCondition.Equal, wlogprojecttree.writeTime);
WLOGProjectTreeData wlogprojecttreedata = new WLOGProjectTreeData();
totalCount = this._wlogprojecttreeclass.GetSingleT(wlogprojecttreedata, querybusinessparams);
return(wlogprojecttreedata);
#endregion
}
