예제 #1
0
 public string GetNewTypeCode(string businessType)
 {
     using (PersistentManager persistentManager = new PersistentManager())
     {
         BillTypeDao dao = new BillTypeDao();
         return(dao.GetNewTypeCode(businessType));
     }
 }
예제 #2
0
 public int GetRowCount(string filter)
 {
     using (PersistentManager persistentManager = new PersistentManager())
     {
         BillTypeDao dao = new BillTypeDao();
         return(dao.GetRowCount(strTableView, filter));
     }
 }
예제 #3
0
 public DataSet QueryBillType(int pageIndex, int pageSize, string filter, string OrderByFields)
 {
     using (PersistentManager persistentManager = new PersistentManager())
     {
         BillTypeDao dao = new BillTypeDao();
         return(dao.Query(strTableView, strPrimaryKey, strQueryFields, pageIndex, pageSize, OrderByFields, filter, strTableView));
     }
 }
예제 #4
0
        public bool Delete(DataSet dataSet)
        {
            bool flag = false;

            using (PersistentManager persistentManager = new PersistentManager())
            {
                BillTypeDao dao = new BillTypeDao();
                dao.DeleteEntity(dataSet);
                flag = true;
            }
            return(flag);
        }
예제 #5
0
        public bool Insert()
        {
            bool flag = false;

            using (PersistentManager persistentManager = new PersistentManager())
            {
                BillTypeDao dao = new BillTypeDao();

                string sql = string.Format("Insert into WMS_BILLTYPE (TYPECODE,TYPENAME,BUSINESS,ISNEEDCELL,MEMO) values('{0}','{1}','{2}','{3}','{4}')"
                                           , this.TYPECODE,
                                           this.TYPENAME,
                                           this.BUSINESS,
                                           this.ISNEEDCELL,
                                           this.MEMO);

                dao.SetData(sql);
                flag = true;
            }
            return(flag);
        }
예제 #6
0
        public bool Update()
        {
            bool flag = false;

            using (PersistentManager persistentManager = new PersistentManager())
            {
                BillTypeDao dao = new BillTypeDao();

                string sql = string.Format("update WMS_BILLTYPE set TYPECODE='{1}',TYPENAME='{2}',BUSINESS='{3}',ISNEEDCELL='{4}',MEMO='{5}'  where ID='{0}'"
                                           , this.ID,
                                           this.TYPECODE,
                                           this.TYPENAME,
                                           this.BUSINESS,
                                           this.ISNEEDCELL,
                                           this.MEMO);

                dao.SetData(sql);
                flag = true;
            }
            return(flag);
        }