/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tBaseItemSubItem">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TBaseItemSubItemVo tBaseItemSubItem, int iIndex, int iCount) { string strSQL = " select * from T_BASE_ITEM_SUB_ITEM {0} "; strSQL = String.Format(strSQL, BuildWhereStatement(tBaseItemSubItem)); return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount))); }
public static string deleteItemBag(string strDelIDs) { if (strDelIDs.Length == 0) { return("0"); } string[] arrDelIDs = strDelIDs.Split(','); bool isSuccess = true; for (int i = 0; i < arrDelIDs.Length; i++) { TBaseItemInfoVo objItem = new TBaseItemInfoVo(); objItem.ID = arrDelIDs[i]; objItem.IS_DEL = "1"; isSuccess = new TBaseItemInfoLogic().Edit(objItem); TBaseItemSubItemVo objSubItemSet = new TBaseItemSubItemVo(); objSubItemSet.IS_DEL = "1"; TBaseItemSubItemVo objSubItemWhere = new TBaseItemSubItemVo(); objSubItemWhere.PARENT_ITEM_ID = arrDelIDs[i]; new TBaseItemSubItemLogic().Edit(objSubItemSet, objSubItemWhere); } if (isSuccess) { new PageBase().WriteLog("删除项目包", "", new PageBase().LogInfo.UserInfo.USER_NAME + "删除项目包" + arrDelIDs[0].ToString() + "成功"); return("1"); } else { return("0"); } }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tBaseItemSubItem_UpdateSet">UpdateSet用户对象</param> /// <param name="tBaseItemSubItem_UpdateWhere">UpdateWhere用户对象</param> /// <returns>是否成功</returns> public bool Edit(TBaseItemSubItemVo tBaseItemSubItem_UpdateSet, TBaseItemSubItemVo tBaseItemSubItem_UpdateWhere) { string strSQL = SqlHelper.BuildUpdateExpress(tBaseItemSubItem_UpdateSet, TBaseItemSubItemVo.T_BASE_ITEM_SUB_ITEM_TABLE); strSQL += this.BuildWhereStatement(tBaseItemSubItem_UpdateWhere); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tBaseItemSubItem">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TBaseItemSubItemVo tBaseItemSubItem) { string strSQL = SqlHelper.BuildUpdateExpress(tBaseItemSubItem, TBaseItemSubItemVo.T_BASE_ITEM_SUB_ITEM_TABLE); strSQL += string.Format(" where ID='{0}' ", tBaseItemSubItem.ID); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 对象删除 /// </summary> /// <param name="Id">ID</param> /// <returns>是否成功</returns> public bool Delete(TBaseItemSubItemVo tBaseItemSubItem) { string strSQL = "delete from T_BASE_ITEM_SUB_ITEM "; strSQL += this.BuildWhereStatement(tBaseItemSubItem); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 根据对象构造条件语句 /// </summary> /// <param name="tBaseItemSubItem"></param> /// <returns></returns> public string BuildWhereStatement(TBaseItemSubItemVo tBaseItemSubItem) { StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 "); if (null != tBaseItemSubItem) { //ID if (!String.IsNullOrEmpty(tBaseItemSubItem.ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND ID = '{0}'", tBaseItemSubItem.ID.ToString())); } //监测项目ID if (!String.IsNullOrEmpty(tBaseItemSubItem.ITEM_ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND ITEM_ID = '{0}'", tBaseItemSubItem.ITEM_ID.ToString())); } //监测父项ID if (!String.IsNullOrEmpty(tBaseItemSubItem.PARENT_ITEM_ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND PARENT_ITEM_ID = '{0}'", tBaseItemSubItem.PARENT_ITEM_ID.ToString())); } //0为在使用、1为停用 if (!String.IsNullOrEmpty(tBaseItemSubItem.IS_DEL.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND IS_DEL = '{0}'", tBaseItemSubItem.IS_DEL.ToString())); } //备注1 if (!String.IsNullOrEmpty(tBaseItemSubItem.REMARK1.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK1 = '{0}'", tBaseItemSubItem.REMARK1.ToString())); } //备注2 if (!String.IsNullOrEmpty(tBaseItemSubItem.REMARK2.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK2 = '{0}'", tBaseItemSubItem.REMARK2.ToString())); } //备注3 if (!String.IsNullOrEmpty(tBaseItemSubItem.REMARK3.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK3 = '{0}'", tBaseItemSubItem.REMARK3.ToString())); } //备注4 if (!String.IsNullOrEmpty(tBaseItemSubItem.REMARK4.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK4 = '{0}'", tBaseItemSubItem.REMARK4.ToString())); } //备注5 if (!String.IsNullOrEmpty(tBaseItemSubItem.REMARK5.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK5 = '{0}'", tBaseItemSubItem.REMARK5.ToString())); } } return(strWhereStatement.ToString()); }
protected void BindList() { string strMonitorID = new TBaseItemInfoLogic().Details(this.Request["selBagID"].ToString()).MONITOR_ID; TBaseItemInfoVo objItem = new TBaseItemInfoVo(); objItem.IS_DEL = "0"; objItem.IS_SUB = "1"; objItem.HAS_SUB_ITEM = "0"; objItem.MONITOR_ID = strMonitorID; List <TBaseItemInfoVo> lstItem = new TBaseItemInfoLogic().SelectByObject(objItem, 0, 0); lstItem.Sort(delegate(TBaseItemInfoVo a, TBaseItemInfoVo b) { return(a.ORDER_NUM.CompareTo(b.ORDER_NUM)); }); this.ListBox1.DataSource = lstItem; this.ListBox1.DataValueField = TBaseItemInfoVo.ID_FIELD; this.ListBox1.DataTextField = TBaseItemInfoVo.ITEM_NAME_FIELD; this.ListBox1.DataBind(); TBaseItemSubItemVo objSubItem = new TBaseItemSubItemVo(); objSubItem.IS_DEL = "0"; objSubItem.PARENT_ITEM_ID = this.Request["selBagID"].ToString(); List <TBaseItemSubItemVo> lstSubItem = new TBaseItemSubItemLogic().SelectByObject(objSubItem, 0, 0); string strSubItemIDs = ""; for (int i = 0; i < lstSubItem.Count; i++) { strSubItemIDs += "," + lstSubItem[i].ITEM_ID; } strSubItemIDs = strSubItemIDs + ","; for (int i = lstItem.Count - 1; i >= 0; i--) { if (!strSubItemIDs.Contains(lstItem[i].ID)) { lstItem.RemoveAt(i); } } this.ListBox2.DataSource = lstItem; this.ListBox2.DataValueField = TBaseItemInfoVo.ID_FIELD; this.ListBox2.DataTextField = TBaseItemInfoVo.ITEM_NAME_FIELD; this.ListBox2.DataBind(); for (int i = 0; i < ListBox2.Items.Count; i++) { ListItem item = ListBox2.Items[i]; ListBox1.Items.Remove(item); } }
public static string SaveDataItem(string strBagID, string strSelItem_IDs) { bool isSuccess = true; string[] arrSelItemId = strSelItem_IDs.Split(','); TBaseItemSubItemVo objSubItemSet = new TBaseItemSubItemVo(); objSubItemSet.IS_DEL = "1"; TBaseItemSubItemVo objSubItemWhere = new TBaseItemSubItemVo(); objSubItemWhere.IS_DEL = "0"; objSubItemWhere.PARENT_ITEM_ID = strBagID; if (new TBaseItemSubItemLogic().Edit(objSubItemSet, objSubItemWhere)) { new PageBase().WriteLog("删除项目包中监测项目", "", new PageBase().LogInfo.UserInfo.USER_NAME + "删除项目包父项目" + strBagID + "成功"); } for (int i = 0; i < arrSelItemId.Length; i++) { TBaseItemSubItemVo objSubItem = new TBaseItemSubItemVo(); objSubItem.ID = GetSerialNumber("t_base_item_sub_item_id"); objSubItem.IS_DEL = "0"; objSubItem.ITEM_ID = arrSelItemId[i]; objSubItem.PARENT_ITEM_ID = strBagID; isSuccess = new TBaseItemSubItemLogic().Create(objSubItem); } if (isSuccess) { new PageBase().WriteLog("新增项目包监测项目", "", new PageBase().LogInfo.UserInfo.USER_NAME + "新增项目包监测项目" + arrSelItemId[0].ToString() + "成功"); return("1"); } else { return("0"); } }
/// <summary> /// 获取对象List /// </summary> /// <param name="tBaseItemSubItem">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TBaseItemSubItemVo> SelectByObject(TBaseItemSubItemVo tBaseItemSubItem, int iIndex, int iCount) { return(access.SelectByObject(tBaseItemSubItem, iIndex, iCount)); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tBaseItemSubItem">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TBaseItemSubItemVo tBaseItemSubItem) { return(access.GetSelectResultCount(tBaseItemSubItem)); }
/// <summary> /// 对象明细 /// </summary> /// <param name="tBaseItemSubItem">对象条件</param> /// <returns>对象</returns> public TBaseItemSubItemVo Details(TBaseItemSubItemVo tBaseItemSubItem) { return(access.Details(tBaseItemSubItem)); }
/// <summary> /// 对象删除 /// </summary> /// <param name="Id">ID</param> /// <returns>是否成功</returns> public bool Delete(TBaseItemSubItemVo tBaseItemSubItem) { return(access.Delete(tBaseItemSubItem)); }
public TBaseItemSubItemLogic(TBaseItemSubItemVo _tBaseItemSubItem) { tBaseItemSubItem = _tBaseItemSubItem; access = new TBaseItemSubItemAccess(); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tBaseItemSubItem">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TBaseItemSubItemVo tBaseItemSubItem) { return(access.Edit(tBaseItemSubItem)); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tBaseItemSubItem_UpdateSet">UpdateSet用户对象</param> /// <param name="tBaseItemSubItem_UpdateWhere">UpdateWhere用户对象</param> /// <returns>是否成功</returns> public bool Edit(TBaseItemSubItemVo tBaseItemSubItem_UpdateSet, TBaseItemSubItemVo tBaseItemSubItem_UpdateWhere) { return(access.Edit(tBaseItemSubItem_UpdateSet, tBaseItemSubItem_UpdateWhere)); }
/// <summary> /// 根据对象特征获取单一对象 /// </summary> /// <param name="tBaseItemSubItem">对象</param> /// <returns></returns> public TBaseItemSubItemVo SelectByObject(TBaseItemSubItemVo tBaseItemSubItem) { return(access.SelectByObject(tBaseItemSubItem)); }
/// <summary> /// 对象添加 /// </summary> /// <param name="sysRole">对象</param> /// <returns>是否成功</returns> public bool Create(TBaseItemSubItemVo tBaseItemSubItem) { return(access.Create(tBaseItemSubItem)); }
/// <summary> /// 对象添加 /// </summary> /// <param name="tBaseItemSubItem">对象</param> /// <returns>是否成功</returns> public bool Create(TBaseItemSubItemVo tBaseItemSubItem) { string strSQL = SqlHelper.BuildInsertExpress(tBaseItemSubItem, TBaseItemSubItemVo.T_BASE_ITEM_SUB_ITEM_TABLE); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tBaseItemSubItem">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TBaseItemSubItemVo tBaseItemSubItem, int iIndex, int iCount) { return(access.SelectByTable(tBaseItemSubItem, iIndex, iCount)); }
/// <summary> /// 获取对象List /// </summary> /// <param name="tBaseItemSubItem">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TBaseItemSubItemVo> SelectByObject(TBaseItemSubItemVo tBaseItemSubItem, int iIndex, int iCount) { string strSQL = String.Format("select * from T_BASE_ITEM_SUB_ITEM " + this.BuildWhereStatement(tBaseItemSubItem)); return(SqlHelper.ExecuteObjectList(tBaseItemSubItem, BuildPagerExpress(strSQL, iIndex, iCount))); }
/// <summary> /// 对象明细 /// </summary> /// <param name="tBaseItemSubItem">对象条件</param> /// <returns>对象</returns> public TBaseItemSubItemVo Details(TBaseItemSubItemVo tBaseItemSubItem) { string strSQL = String.Format("select * from T_BASE_ITEM_SUB_ITEM " + this.BuildWhereStatement(tBaseItemSubItem)); return(SqlHelper.ExecuteObject(new TBaseItemSubItemVo(), strSQL)); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tBaseItemSubItem">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TBaseItemSubItemVo tBaseItemSubItem) { string strSQL = "select Count(*) from T_BASE_ITEM_SUB_ITEM " + this.BuildWhereStatement(tBaseItemSubItem); return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL))); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tBaseItemSubItem"></param> /// <returns></returns> public DataTable SelectByTable(TBaseItemSubItemVo tBaseItemSubItem) { return(access.SelectByTable(tBaseItemSubItem)); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tBaseItemSubItem"></param> /// <returns></returns> public DataTable SelectByTable(TBaseItemSubItemVo tBaseItemSubItem) { string strSQL = "select * from T_BASE_ITEM_SUB_ITEM " + this.BuildWhereStatement(tBaseItemSubItem); return(SqlHelper.ExecuteDataTable(strSQL)); }