Пример #1
0
        public bool Delete(int AreaID)
        {
            bool flag = false;

            using (PersistentManager persistentManager = new PersistentManager())
            {
                WarehouseAreaDao dao = new WarehouseAreaDao();
                string           sql = string.Format("delete from WMS_WH_AREA WHERE AREA_ID={0}", AreaID);
                dao.SetData(sql);
                flag = true;
            }
            return(flag);
        }
Пример #2
0
        public bool Insert()
        {
            bool flag = false;

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

                string sql = string.Format("Insert into WMS_WH_AREA (WH_CODE,AREACODE,AREANAME,SHORTNAME,ISACTIVE,AREATYPE,MEMO) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')"
                                           , this.WH_CODE,
                                           this.AREACODE,
                                           this.AREANAME,
                                           this.SHORTNAME,
                                           this.ISACTIVE,
                                           this.AREATYPE,
                                           this.MEMO);

                dao.SetData(sql);
                flag = true;
            }
            return(flag);
        }
Пример #3
0
        public bool Update()
        {
            bool flag = false;

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

                string sql = string.Format("update WMS_WH_AREA set WH_CODE='{0}',AREACODE='{1}',AREANAME='{2}',SHORTNAME='{3}',ISACTIVE='{4}',MEMO='{5}',AREATYPE='{6}'  where AREA_ID='{7}'"
                                           , this.WH_CODE,
                                           this.AREACODE,
                                           this.AREANAME,
                                           this.SHORTNAME,
                                           this.ISACTIVE,
                                           this.MEMO,
                                           this.AREATYPE,
                                           this.AREA_ID);

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