/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tSysSerial">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TSysSerialVo tSysSerial, int iIndex, int iCount) { string strSQL = " select t.*,rownum rowno from T_SYS_SERIAL t {0} "; strSQL = String.Format(strSQL, BuildWhereStatement(tSysSerial)); return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount))); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tSysSerial">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TSysSerialVo tSysSerial) { string strSQL = SqlHelper.BuildUpdateExpress(tSysSerial, TSysSerialVo.T_SYS_SERIAL_TABLE); strSQL += string.Format(" where ID='{0}' ", tSysSerial.ID); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 对象添加 /// </summary> /// <param name="tSysSerial">对象</param> /// <returns>是否成功</returns> public bool Create(TSysSerialVo tSysSerial) { tSysSerial.ID = new Resource.TSysSerialAccess().GetSerialNumber(ObjectBase.SerialType.SerialId); // tSysSerial.ID = "11"; string strSQL = SqlHelper.BuildInsertExpress(tSysSerial, TSysSerialVo.T_SYS_SERIAL_TABLE, TSysSerialVo.CREATE_TIME_FIELD); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 获取对象List /// </summary> /// <param name="tSysSerial">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TSysSerialVo> SelectByObject(TSysSerialVo tSysSerial, int iIndex, int iCount) { string strSQL = " select t.* from (select * from T_SYS_SERIAL) t {0} order by id desc"; strSQL = String.Format(strSQL, BuildWhereStatement(tSysSerial)); return(SqlHelper.ExecuteObjectList(tSysSerial, BuildPagerExpress(strSQL, iIndex, iCount))); //string strSQL = String.Format("select * from T_SYS_SERIAL " + this.BuildWhereStatement(tSysSerial)); //return SqlHelper.ExecuteObjectList(tSysSerial, BuildPagerExpress(strSQL, iIndex, iCount)); }
/// <summary> /// 加载序列号列表数据 /// </summary> public void InitSerialListData() { TSysSerialVo voSerial = new TSysSerialVo(); voSerial.SERIAL_NAME = txtSerialName.Text; //重新设定分页控件页数 pager.RecordCount = Convert.ToInt32(new TSysSerialLogic().GetSelectResultCount(voSerial)); grdList.DataSource = new TSysSerialLogic().SelectByObject(voSerial, pager.CurrentPageIndex, pager.PageSize); grdList.DataBind(); }
/// <summary> /// 删除序列号,GridView自带操作 /// </summary> protected void grdList_RowDeleting(object sender, GridViewDeleteEventArgs e) { TSysSerialVo voSerial = new TSysSerialVo(); voSerial = new TSysSerialLogic().Details(grdList.DataKeys[e.RowIndex].Value.ToString()); //删除指定的记录 if (new TSysSerialLogic().Delete(grdList.DataKeys[e.RowIndex].Value.ToString())) { base.WriteLog(i3.ValueObject.ObjectBase.LogType.DelSerial, voSerial.ID, LogInfo.UserInfo.USER_NAME + "删除序列号" + voSerial.SERIAL_CODE + "成功!"); } //重新加载数据 InitSerialListData(); }
/// <summary> /// 删除序列号事件,checkbox选择 By Castle (胡方扬) 2012-10-26 /// </summary> protected void btnDelete_Click(object sender, EventArgs e) { string[] ids = this.txtHidden.Value.Trim().Split(','); foreach (string id in ids) { TSysSerialVo voSerial = new TSysSerialVo(); voSerial = new TSysSerialLogic().Details(id); //删除指定的记录 if (new TSysSerialLogic().Delete(id)) { base.WriteLog(i3.ValueObject.ObjectBase.LogType.DelSerial, voSerial.ID, LogInfo.UserInfo.USER_NAME + "删除序列号" + voSerial.SERIAL_CODE + "成功!"); } //InitSerialListData(); } //重新加载数据 InitSerialListData(); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tSysSerial"></param> /// <returns></returns> public DataTable SelectByTable(TSysSerialVo tSysSerial) { string strSQL = "select * from T_SYS_SERIAL " + this.BuildWhereStatement(tSysSerial); return(SqlHelper.ExecuteDataTable(strSQL)); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tSysSerial">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TSysSerialVo tSysSerial) { return(access.Edit(tSysSerial)); }
/// <summary> /// 对象明细 /// </summary> /// <param name="tSysSerial">对象条件</param> /// <returns>对象</returns> public TSysSerialVo Details(TSysSerialVo tSysSerial) { string strSQL = "select * from T_SYS_SERIAL " + this.BuildWhereStatement(tSysSerial); return(SqlHelper.ExecuteObject(new TSysSerialVo(), strSQL)); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tSysSerial">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TSysSerialVo tSysSerial) { string strSQL = "select Count(*) from T_SYS_SERIAL " + this.BuildWhereStatement(tSysSerial); return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL))); }
/// <summary> /// 根据对象构造条件语句 /// </summary> /// <param name="tSysSerial"></param> /// <returns></returns> public string BuildWhereStatement(TSysSerialVo tSysSerial) { StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 "); if (null != tSysSerial) { //编号 if (!String.IsNullOrEmpty(tSysSerial.ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND ID = '{0}'", tSysSerial.ID.ToString())); } //编码 if (!String.IsNullOrEmpty(tSysSerial.SERIAL_CODE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND SERIAL_CODE = '{0}'", tSysSerial.SERIAL_CODE.ToString())); } //名称 if (!String.IsNullOrEmpty(tSysSerial.SERIAL_NAME.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND SERIAL_NAME like '%{0}%'", tSysSerial.SERIAL_NAME.ToString())); } //分组 if (!String.IsNullOrEmpty(tSysSerial.SERIAL_GROUP.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND SERIAL_GROUP = '{0}'", tSysSerial.SERIAL_GROUP.ToString())); } //序列号 if (!String.IsNullOrEmpty(tSysSerial.SERIAL_NUMBER.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND SERIAL_NUMBER = '{0}'", tSysSerial.SERIAL_NUMBER.ToString())); } //位数 if (!String.IsNullOrEmpty(tSysSerial.LENGTH.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND LENGTH = '{0}'", tSysSerial.LENGTH.ToString())); } //前缀 if (!String.IsNullOrEmpty(tSysSerial.PREFIX.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND PREFIX = '{0}'", tSysSerial.PREFIX.ToString())); } //粒度 if (!String.IsNullOrEmpty(tSysSerial.GRANULARITY.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND GRANULARITY = '{0}'", tSysSerial.GRANULARITY.ToString())); } //最小值 if (!String.IsNullOrEmpty(tSysSerial.MIN.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND MIN = '{0}'", tSysSerial.MIN.ToString())); } //最大值 if (!String.IsNullOrEmpty(tSysSerial.MAX.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND MAX = '{0}'", tSysSerial.MAX.ToString())); } //创建人 if (!String.IsNullOrEmpty(tSysSerial.CREATE_ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND CREATE_ID = '{0}'", tSysSerial.CREATE_ID.ToString())); } //创建日期 if (!String.IsNullOrEmpty(tSysSerial.CREATE_TIME.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND CREATE_TIME = '{0}'", tSysSerial.CREATE_TIME.ToString())); } //备注 if (!String.IsNullOrEmpty(tSysSerial.REMARK.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK = '{0}'", tSysSerial.REMARK.ToString())); } //备注1 if (!String.IsNullOrEmpty(tSysSerial.REMARK1.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK1 = '{0}'", tSysSerial.REMARK1.ToString())); } //备注2 if (!String.IsNullOrEmpty(tSysSerial.REMARK2.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK2 = '{0}'", tSysSerial.REMARK2.ToString())); } //备注3 if (!String.IsNullOrEmpty(tSysSerial.REMARK3.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK3 = '{0}'", tSysSerial.REMARK3.ToString())); } } return(strWhereStatement.ToString()); }
/// <summary> /// 对象添加 /// </summary> /// <param name="sysRole">对象</param> /// <returns>是否成功</returns> public bool Create(TSysSerialVo tSysSerial) { return(access.Create(tSysSerial)); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tSysSerial"></param> /// <returns></returns> public DataTable SelectByTable(TSysSerialVo tSysSerial) { return(access.SelectByTable(tSysSerial)); }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tSysSerial">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TSysSerialVo tSysSerial, int iIndex, int iCount) { return(access.SelectByTable(tSysSerial, iIndex, iCount)); }
/// <summary> /// 获取对象List /// </summary> /// <param name="tSysSerial">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TSysSerialVo> SelectByObject(TSysSerialVo tSysSerial, int iIndex, int iCount) { return(access.SelectByObject(tSysSerial, iIndex, iCount)); }
/// <summary> /// 对象明细 /// </summary> /// <param name="tSysSerial">对象条件</param> /// <returns>对象</returns> public TSysSerialVo Details(TSysSerialVo tSysSerial) { return(access.Details(tSysSerial)); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tSysSerial">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TSysSerialVo tSysSerial) { return(access.GetSelectResultCount(tSysSerial)); }
public TSysSerialLogic(TSysSerialVo _tSysSerial) { tSysSerial = _tSysSerial; access = new TSysSerialAccess(); }
/// <summary> /// 保存按钮事件 /// </summary> protected void btnSave_Click(object sender, EventArgs e) { //序列号对象 TSysSerialVo voSerial = new TSysSerialVo(); if (!String.IsNullOrEmpty(this.id))//如果ID不为空,则状态为更新,否则为新增 { //获取页面数据对象 //BindControlsToObjectMode(); voSerial.SERIAL_CODE = SERIAL_CODE.Text; voSerial.SERIAL_NAME = SERIAL_NAME.Text; //设置ID voSerial.ID = this.id; TSysSerialVo tempSerialVo = new TSysSerialVo(); tempSerialVo.SERIAL_CODE = voSerial.SERIAL_CODE; tempSerialVo.ID = new TSysSerialLogic().Details(tempSerialVo).ID; if (string.IsNullOrEmpty(tempSerialVo.ID) || tempSerialVo.ID == voSerial.ID) { if (new TSysSerialLogic().Edit(voSerial)) { base.WriteLog(i3.ValueObject.ObjectBase.LogType.EditSerial, voSerial.ID, LogInfo.UserInfo.USER_NAME + "修改序列号" + voSerial.SERIAL_CODE + "成功!"); base.Alert("修改成功!"); } else { base.Alert("修改失败!"); } } else { base.Alert("该序列号已经存在!"); } } else { if (!InputValidation()) { return; } //获取页面数据对象 BindControlsToObjectMode(voSerial); //判断该序列号是否存在 TSysSerialVo tempSerialVo = new TSysSerialVo(); tempSerialVo.SERIAL_CODE = voSerial.SERIAL_CODE; tempSerialVo.ID = new TSysSerialLogic().Details(tempSerialVo).ID; if (string.IsNullOrEmpty(tempSerialVo.ID)) { voSerial.CREATE_TIME = DateTime.Now.ToString(); if (new TSysSerialLogic().Create(voSerial)) { base.WriteLog(i3.ValueObject.ObjectBase.LogType.AddSerial, voSerial.ID, LogInfo.UserInfo.USER_NAME + "添加序列号" + voSerial.SERIAL_CODE + "成功!"); base.Alert("添加成功!"); } else { base.Alert("添加失败!"); } } else { base.Alert("该序列号已经存在!"); } } }
/// <summary> /// 根据对象特征获取单一对象 /// </summary> /// <param name="tSysSerial">对象</param> /// <returns></returns> public TSysSerialVo SelectByObject(TSysSerialVo tSysSerial) { return(access.SelectByObject(tSysSerial)); }