/// <summary> /// 对象编辑 /// </summary> /// <param name="tRptMark_UpdateSet">UpdateSet用户对象</param> /// <param name="tRptMark_UpdateWhere">UpdateWhere用户对象</param> /// <returns>是否成功</returns> public bool Edit(TRptMarkVo tRptMark_UpdateSet, TRptMarkVo tRptMark_UpdateWhere) { string strSQL = SqlHelper.BuildUpdateExpress(tRptMark_UpdateSet, TRptMarkVo.T_RPT_MARK_TABLE); strSQL += this.BuildWhereStatement(tRptMark_UpdateWhere); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tRptMark">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TRptMarkVo tRptMark) { string strSQL = SqlHelper.BuildUpdateExpress(tRptMark, TRptMarkVo.T_RPT_MARK_TABLE); strSQL += string.Format(" where ID='{0}' ", tRptMark.ID); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tRptMark">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TRptMarkVo tRptMark, int iIndex, int iCount) { string strSQL = " select * from T_RPT_MARK {0} "; strSQL = String.Format(strSQL, BuildWhereStatement(tRptMark)); return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount))); }
/// <summary> /// 对象删除 /// </summary> /// <param name="Id">ID</param> /// <returns>是否成功</returns> public bool Delete(TRptMarkVo tRptMark) { string strSQL = "delete from T_RPT_MARK "; strSQL += this.BuildWhereStatement(tRptMark); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 修改数据 /// </summary> /// <returns></returns> public string frmUpdate() { TRptMarkVo objMark = autoBindRequest(Request, new TRptMarkVo()); objMark.ID = Request["id"].ToString(); bool isSuccess = new TRptMarkLogic().Edit(objMark); if (isSuccess) { WriteLog("编辑标签", "", LogInfo.UserInfo.USER_NAME + "编辑标签" + objMark.ID); } return(isSuccess == true ? "1" : "0"); }
/// <summary> /// 增加数据 /// </summary> /// <returns></returns> public string frmAdd() { TRptMarkVo objMark = autoBindRequest(Request, new TRptMarkVo()); objMark.ID = GetSerialNumber("Mark_Id"); bool isSuccess = new TRptMarkLogic().Create(objMark); if (isSuccess) { WriteLog("添加标签", "", LogInfo.UserInfo.USER_NAME + "添加标签" + objMark.ID); } return(isSuccess == true ? "1" : "0"); }
/// <summary> /// 通过标签属性获得标签名称 /// </summary> /// <param name="AttributeName">标签属性</param> /// <returns>标签名称</returns> public string GetBookMarkNameByAttribute(string AttributeName) { TRptMarkVo mark = new TRptMarkVo(); mark.ATTRIBUTE_NAME = AttributeName; List <TRptMarkVo> ListTemp = access.SelectByObject(mark, 0, 0); //判断是否非空 if (null != ListTemp && ListTemp.Count > 0) { return(ListTemp[0].MARK_NAME); } else { return(""); } }
/// <summary> /// 获取标签信息 /// </summary> protected void getMarkInfo() { string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; //当前页面 int intPageIndex = Convert.ToInt32(Request.Params["page"]); //每页记录数 int intPageSize = Convert.ToInt32(Request.Params["pagesize"]); TRptMarkVo objMark = new TRptMarkVo(); objMark.SORT_FIELD = !string.IsNullOrEmpty(strSortname) ? strSortname : TRptMarkVo.ID_FIELD; objMark.SORT_TYPE = SortDirection.Descending.ToString(); int intCount = new TRptMarkLogic().GetSelectResultCount(objMark); DataTable dt = new TRptMarkLogic().SelectByTable(objMark, intPageIndex, intPageSize); Response.Write(CreateToJson(dt, intCount)); Response.End(); }
/// <summary> /// 根据对象构造条件语句 /// </summary> /// <param name="tRptMark"></param> /// <returns></returns> public string BuildWhereStatement(TRptMarkVo tRptMark) { StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 "); if (null != tRptMark) { //ID if (!String.IsNullOrEmpty(tRptMark.ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND ID = '{0}'", tRptMark.ID.ToString())); } //标签名称 if (!String.IsNullOrEmpty(tRptMark.MARK_NAME.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND MARK_NAME = '{0}'", tRptMark.MARK_NAME.ToString())); } //标签描述 if (!String.IsNullOrEmpty(tRptMark.MARK_DESC.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND MARK_DESC = '{0}'", tRptMark.MARK_DESC.ToString())); } //标签说明 if (!String.IsNullOrEmpty(tRptMark.MARK_REMARK.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND MARK_REMARK = '{0}'", tRptMark.MARK_REMARK.ToString())); } //属性名称 if (!String.IsNullOrEmpty(tRptMark.ATTRIBUTE_NAME.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND ATTRIBUTE_NAME = '{0}'", tRptMark.ATTRIBUTE_NAME.ToString())); } //备注 if (!String.IsNullOrEmpty(tRptMark.REMARK.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK = '{0}'", tRptMark.REMARK.ToString())); } } return(strWhereStatement.ToString()); }
/// <summary> /// 根据对象特征获取单一对象 /// </summary> /// <param name="tRptMark">对象</param> /// <returns></returns> public TRptMarkVo SelectByObject(TRptMarkVo tRptMark) { string strSQL = "select * from T_RPT_MARK " + this.BuildWhereStatement(tRptMark); return(SqlHelper.ExecuteObject(new TRptMarkVo(), strSQL)); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tRptMark"></param> /// <returns></returns> public DataTable SelectByTable(TRptMarkVo tRptMark) { string strSQL = "select * from T_RPT_MARK " + this.BuildWhereStatement(tRptMark); return(SqlHelper.ExecuteDataTable(strSQL)); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tRptMark">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TRptMarkVo tRptMark) { return(access.Edit(tRptMark)); }
/// <summary> /// 获取对象List /// </summary> /// <param name="tRptMark">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TRptMarkVo> SelectByObject(TRptMarkVo tRptMark, int iIndex, int iCount) { string strSQL = String.Format("select * from T_RPT_MARK " + this.BuildWhereStatement(tRptMark)); return(SqlHelper.ExecuteObjectList(tRptMark, BuildPagerExpress(strSQL, iIndex, iCount))); }
/// <summary> /// 对象明细 /// </summary> /// <param name="tRptMark">对象条件</param> /// <returns>对象</returns> public TRptMarkVo Details(TRptMarkVo tRptMark) { string strSQL = String.Format("select * from T_RPT_MARK " + this.BuildWhereStatement(tRptMark)); return(SqlHelper.ExecuteObject(new TRptMarkVo(), strSQL)); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tRptMark">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TRptMarkVo tRptMark) { string strSQL = "select Count(*) from T_RPT_MARK " + this.BuildWhereStatement(tRptMark); return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL))); }
/// <summary> /// 对象删除 /// </summary> /// <param name="Id">ID</param> /// <returns>是否成功</returns> public bool Delete(TRptMarkVo tRptMark) { return(access.Delete(tRptMark)); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tRptMark_UpdateSet">UpdateSet用户对象</param> /// <param name="tRptMark_UpdateWhere">UpdateWhere用户对象</param> /// <returns>是否成功</returns> public bool Edit(TRptMarkVo tRptMark_UpdateSet, TRptMarkVo tRptMark_UpdateWhere) { return(access.Edit(tRptMark_UpdateSet, tRptMark_UpdateWhere)); }
/// <summary> /// 对象添加 /// </summary> /// <param name="sysRole">对象</param> /// <returns>是否成功</returns> public bool Create(TRptMarkVo tRptMark) { return(access.Create(tRptMark)); }
public TRptMarkLogic(TRptMarkVo _tRptMark) { tRptMark = _tRptMark; access = new TRptMarkAccess(); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tRptMark">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TRptMarkVo tRptMark) { return(access.GetSelectResultCount(tRptMark)); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tRptMark"></param> /// <returns></returns> public DataTable SelectByTable(TRptMarkVo tRptMark) { return(access.SelectByTable(tRptMark)); }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tRptMark">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TRptMarkVo tRptMark, int iIndex, int iCount) { return(access.SelectByTable(tRptMark, iIndex, iCount)); }
/// <summary> /// 获取对象List /// </summary> /// <param name="tRptMark">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TRptMarkVo> SelectByObject(TRptMarkVo tRptMark, int iIndex, int iCount) { return(access.SelectByObject(tRptMark, iIndex, iCount)); }
/// <summary> /// 对象明细 /// </summary> /// <param name="tRptMark">对象条件</param> /// <returns>对象</returns> public TRptMarkVo Details(TRptMarkVo tRptMark) { return(access.Details(tRptMark)); }
/// <summary> /// 对象添加 /// </summary> /// <param name="tRptMark">对象</param> /// <returns>是否成功</returns> public bool Create(TRptMarkVo tRptMark) { string strSQL = SqlHelper.BuildInsertExpress(tRptMark, TRptMarkVo.T_RPT_MARK_TABLE); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 根据对象特征获取单一对象 /// </summary> /// <param name="tRptMark">对象</param> /// <returns></returns> public TRptMarkVo SelectByObject(TRptMarkVo tRptMark) { return(access.SelectByObject(tRptMark)); }