/// <summary> /// 保存wlogprojecttreedata数据集数据 /// </summary> /// <param name="wlogprojecttreedata">数据集对象</param> /// <returns>返回保存后的响应信息</returns> public String SaveWLOGProjectTree(WLOGProjectTreeData wlogprojecttreedata) { #region WLOGProjectTreeClass wlogprojecttreeclass = new WLOGProjectTreeClass(); return(base.Save(wlogprojecttreedata, wlogprojecttreeclass)); #endregion }
/// <summary> /// 获取WLOGProjectTree数据表的全部数据 /// </summary> /// <returns>Json字符串</returns> public string GetJsonByAll() { #region int totalCount = 0; WLOGProjectTreeData wlogprojecttreedata = this.getData(null); totalCount = wlogprojecttreedata.Tables[0].Rows.Count; return(base.GetJson(wlogprojecttreedata, totalCount)); #endregion }
/// <summary> /// 根据主键值检索符合该条件的记录,用于编辑和删除记录时。 /// </summary> /// <param name="currentId">主键-当前项目节点编号</param> /// <returns></returns> private WLOGProjectTreeData getData(string currentId) { #region WLOGProjectTreeData wlogprojecttreedata = new WLOGProjectTreeData(); DBConditions querybusinessparams = new DBConditions(); querybusinessparams.Add(WLOGProjectTreeData.currentId, EnumSqlType.sqlint, EnumCondition.Equal, currentId); this._wlogprojecttreeclass.GetSingleTAllWithoutCount(wlogprojecttreedata, querybusinessparams); return(wlogprojecttreedata); #endregion }
///**************************************** //***生成器版本:V1.0.1.31494 //***生成时间:2013-04-24 18:44:01 //***公司:山西ICat Studio有限公司 //***友情提示:以下代码为生成器自动生成,可做参照复制之用; //*** 如需有其他业务要求,则可在region外添加新的业务关联方法; //*** 如发现任何编译错误,请联系QQ:330669393。 //*****************************************/ /// <summary> /// 检索数据并分页返回数据集 /// </summary> /// <param name="recordCount">符合条件的总记录数</param> /// <param name="qParams">分页对象</param> /// <param name="conditions">查询条件集合</param> /// <returns>分页数据</returns> public DataSet SelectWLOGProjectTreeByPage(PageParams qParams, DBConditions conditions) { #region WLOGProjectTreeData wlogprojecttreedata = new WLOGProjectTreeData(); string businessSql = @"SELECT * FROM [WLOGProjectTree]"; //conditions.AddKeys(WLOGProjectTreeData.currentId); base.GetCustomBusiness(businessSql, wlogprojecttreedata, conditions); return(wlogprojecttreedata); #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="currentId">主键-当前项目节点编号</param> public void DeleteRow(ref WLOGProjectTreeData wlogprojecttreedata, string currentId) { #region if (wlogprojecttreedata.Tables[0].Rows.Count <= 0) { wlogprojecttreedata = this.getData(currentId); } DataRow dr = wlogprojecttreedata.Tables[0].Rows.Find(new object[1] { currentId }); if (dr != null) { dr.Delete(); } #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 }