public string GetSortingGroupId() { using (PersistentManager persistentManager = new PersistentManager()) { SortingGroupDao dao = new SortingGroupDao(); return(dao.FindSortingGroupId()); } }
/// <summary> /// 分页查询数据,指定数据集表名TableName /// </summary> /// <param name="TableViewName">表名或视图名</param> /// <param name="PrimaryKey">表主键字段名称</param> /// <param name="QueryFields">查询字段字符串,字段名称逗号隔开</param> /// <param name="pageIndex">查询页码</param> /// <param name="pageSize">页码大小</param> /// <param name="orderBy">排序字段和方式</param> /// <param name="filter">查询条件</param> /// <param name="strTableName">返回数据集填充的表名</param> /// <returns>返回DataSet</returns> public DataSet GetExecuteQuery(int pageIndex, int pageSize, string filter, string OrderByFields) { using (PersistentManager persistentManager = new PersistentManager()) { SortingGroupDao dao = new SortingGroupDao(); return(dao.FindExecuteQuery(strTableName, strPrimaryKey, strQueryFields, pageIndex, pageSize, OrderByFields, filter, strTableName)); } }
/// <summary> /// 根据条件查询分拣厂家记录 /// </summary> /// <param name="file"></param> /// <returns></returns> public int GetSortingGroup(string file) { using (PersistentManager persistentManager = new PersistentManager()) { SortingGroupDao dao = new SortingGroupDao(); return(dao.FindSortingGroupCount(file, strTableName)); } }
/// <summary> /// 删除 /// </summary> /// <param name="dataSet"></param> /// <returns></returns> public bool Delete(string dataSet) { bool flag = false; using (PersistentManager persistentManager = new PersistentManager()) { SortingGroupDao dao = new SortingGroupDao(); dao.delete(dataSet); flag = true; } return(flag); }
/// <summary> /// 添加 /// </summary> /// <returns></returns> public bool Insert() { bool flag = false; using (PersistentManager persistentManager = new PersistentManager()) { SortingGroupDao dao = new SortingGroupDao(); string date = DateTime.Now.Date.ToString("yyyyMMdd"); string sql = string.Format("insert into DWV_DPS_SORTING(SORTING_CODE,SORTING_NAME,SORTING_TYPE,ISACTIVE,UPDATE_DATE) " + " values('{0}','{1}','{2}','{3}',{4}) ", this.SORTING_CODE1, this.SORTING_NAME1, this.SORTING_TYPE1, this.ISACTIVE1, date); dao.SetData(sql); flag = true; } return(flag); }
/// <summary> /// 修改 /// </summary> /// <returns></returns> public bool Update() { bool flag = false; using (PersistentManager persistentManager = new PersistentManager()) { SortingGroupDao dao = new SortingGroupDao(); string date = DateTime.Now.Date.ToString("yyyyMMdd"); string sql = string.Format("update DWV_DPS_SORTING set SORTING_NAME='{1}',SORTING_TYPE='{2}',ISACTIVE='{3}',UPDATE_DATE='{4}' where SORTING_CODE='{0}'" , this.SORTING_CODE1, this.SORTING_NAME1, this.SORTING_TYPE1, this.ISACTIVE1, date ); dao.SetData(sql); flag = true; } return(flag); }