Exemple #1
0
        private static List <Query_Stored> DoQuery(string sql_str)
        {
            List <Query_Stored> rtn = new List <Query_Stored>();

            try
            {
                DBHelper DBHelper_SqlServer = new DBLink();
                using (IDataReader dr = DBHelper_SqlServer.ExecuteReader(sql_str))
                {
                    while (dr.Read())
                    {
                        var p = new Query_Stored();
                        #region 逐个赋值
                        p.WAREHOUSENO = DBHelper_SqlServer.GetDataValue <string>(dr, "WAREHOUSENO");
                        p.PLACEID     = DBHelper_SqlServer.GetDataValue <string>(dr, "PLACEID");
                        p.CONTAINERID = DBHelper_SqlServer.GetDataValue <string>(dr, "CONTAINERID");
                        p.ITEMSKU     = DBHelper_SqlServer.GetDataValue <string>(dr, "ITEMSKU");
                        p.ITEMDESC    = DBHelper_SqlServer.GetDataValue <string>(dr, "ITEMDESC");
                        p.ITEMQTY     = DBHelper_SqlServer.GetDataValue <decimal>(dr, "ITEMQTY");

                        #endregion
                        rtn.Add(p);
                    }
                }
            }
            catch
            {
            }
            return(rtn);
        }
        private static List <Device_Alert> DoQuery(string sql_str)
        {
            List <Device_Alert> rtn = new List <Device_Alert>();

            try
            {
                DBHelper DBHelper_SqlServer = new DBLink();
                using (IDataReader dr = DBHelper_SqlServer.ExecuteReader(sql_str))
                {
                    while (dr.Read())
                    {
                        var p = new Device_Alert();
                        #region 逐个赋值
                        p.ID               = DBHelper_SqlServer.GetDataValue <string>(dr, "ID");
                        p.DEVICEID         = DBHelper_SqlServer.GetDataValue <string>(dr, "DEVICEID");
                        p.ALERTID          = DBHelper_SqlServer.GetDataValue <string>(dr, "ALERTID");
                        p.ALERTNAME        = DBHelper_SqlServer.GetDataValue <string>(dr, "ALERTNAME");
                        p.CREATETIME       = DBHelper_SqlServer.GetDataValue <string>(dr, "CREATETIME");
                        p.FINISH_TIME      = DBHelper_SqlServer.GetDataValue <string>(dr, "FINISH_TIME");
                        p.TIME_OF_DURATION = DBHelper_SqlServer.GetDataValue <string>(dr, "TIME_OF_DURATION");
                        p.SYSTEMFLAG       = DBHelper_SqlServer.GetDataValue <string>(dr, "SYSTEMFLAG");
                        #endregion
                        rtn.Add(p);
                    }
                }
            }
            catch
            {
            }
            return(rtn);
        }
Exemple #3
0
        private static List <IM_Container> DoQuery(string sql_str)
        {
            List <IM_Container> rtn = new List <IM_Container>();

            try
            {
                DBHelper DBHelper_SqlServer = new DBLink();
                using (IDataReader dr = DBHelper_SqlServer.ExecuteReader(sql_str))
                {
                    while (dr.Read())
                    {
                        var p = new IM_Container();
                        p.CONTAINERID   = DBHelper_SqlServer.GetDataValue <string>(dr, "CONTAINERID");
                        p.CONTAINERDESC = DBHelper_SqlServer.GetDataValue <string>(dr, "CONTAINERDESC");
                        p.CONTAINERTYPE = DBHelper_SqlServer.GetDataValue <string>(dr, "CONTAINERTYPE");
                        p.LENGTH        = DBHelper_SqlServer.GetDataValue <decimal>(dr, "LENGTH");
                        p.WIDTH         = DBHelper_SqlServer.GetDataValue <decimal>(dr, "WIDTH");
                        p.HEIGHT        = DBHelper_SqlServer.GetDataValue <decimal>(dr, "HEIGHT");
                        p.MAXWEIGHT     = DBHelper_SqlServer.GetDataValue <decimal>(dr, "MAXWEIGHT");
                        p.VOID          = DBHelper_SqlServer.GetDataValue <int>(dr, "VOID");
                        p.STATUS        = DBHelper_SqlServer.GetDataValue <int>(dr, "STATUS");
                        p.WAREHOUSENO   = DBHelper_SqlServer.GetDataValue <string>(dr, "WAREHOUSENO");
                        p.ONLINEMODEL   = DBHelper_SqlServer.GetDataValue <string>(dr, "ONLINEMODEL");
                        p.UPDATETIME    = DBHelper_SqlServer.GetDataValue <string>(dr, "UPDATETIME");
                        p.UPDATEUSER    = DBHelper_SqlServer.GetDataValue <string>(dr, "UPDATEUSER");

                        rtn.Add(p);
                    }
                }
            }
            catch (Exception ex)
            {
            }
            return(rtn);
        }
        private static List <MODULE_VS_GROUP> DoQuery(string sql_str)
        {
            List <MODULE_VS_GROUP> rtn = new List <MODULE_VS_GROUP>();

            try
            {
                DBHelper DBHelper_SqlServer = new DBLink();
                using (IDataReader dr = DBHelper_SqlServer.ExecuteReader(sql_str))
                {
                    while (dr.Read())
                    {
                        var p = new MODULE_VS_GROUP();
                        p.ID          = DBHelper_SqlServer.GetDataValue <string>(dr, "ID");
                        p.GROUP_NAME  = DBHelper_SqlServer.GetDataValue <string>(dr, "GROUP_NAME");
                        p.GROUP_DESC  = DBHelper_SqlServer.GetDataValue <string>(dr, "GROUP_DESC");
                        p.MODULE_ID   = DBHelper_SqlServer.GetDataValue <string>(dr, "MODULE_ID");
                        p.MODULE_NAME = DBHelper_SqlServer.GetDataValue <string>(dr, "MODULE_NAME");
                        rtn.Add(p);
                    }
                }
            }
            catch
            {
            }
            return(rtn);
        }
Exemple #5
0
        private static List <MODULE> DoQuery(string sql_str)
        {
            List <MODULE> rtn = new List <MODULE>();

            try
            {
                DBHelper DBHelper_SqlServer = new DBLink();
                using (IDataReader dr = DBHelper_SqlServer.ExecuteReader(sql_str))
                {
                    while (dr.Read())
                    {
                        var p = new MODULE();
                        p.ID              = DBHelper_SqlServer.GetDataValue <string>(dr, "ID");
                        p.MODULE_NAME     = DBHelper_SqlServer.GetDataValue <string>(dr, "MODULE_NAME");
                        p.MODULE_DESCRIBE = DBHelper_SqlServer.GetDataValue <string>(dr, "MODULE_DESCRIBE");
                        p.TAGNAME         = DBHelper_SqlServer.GetDataValue <string>(dr, "TAGNAME");
                        p.STATUS          = DBHelper_SqlServer.GetDataValue <string>(dr, "STATUS");
                        rtn.Add(p);
                    }
                }
            }
            catch
            {
            }
            return(rtn);
        }
        private static List <PW_User> DoQuery(string sql_str)
        {
            List <PW_User> rtn = new List <PW_User>();
            DBHelper       DBHelper_SqlServer = new DBLink();

            try
            {
                using (IDataReader dr = DBHelper_SqlServer.ExecuteReader(sql_str))
                {
                    while (dr.Read())
                    {
                        var p = new PW_User();
                        p.ID                 = DBHelper_SqlServer.GetDataValue <string>(dr, "ID");
                        p.USERNAME           = DBHelper_SqlServer.GetDataValue <string>(dr, "USERNAME");
                        p.PASSWORD           = DBHelper_SqlServer.GetDataValue <string>(dr, "PASSWORD");
                        p.USERGROUP          = DBHelper_SqlServer.GetDataValue <string>(dr, "USERGROUP");
                        p.DEPARTMENT         = DBHelper_SqlServer.GetDataValue <string>(dr, "DEPARTMENT");
                        p.UPDATETIME         = DBHelper_SqlServer.GetDataValue <string>(dr, "UPDATETIME");
                        p.PASSWORDUPDATETIME = DBHelper_SqlServer.GetDataValue <string>(dr, "PASSWORDUPDATETIME");
                        p.PASSWORDEXPIRETIME = DBHelper_SqlServer.GetDataValue <string>(dr, "PASSWORDEXPIRETIME");
                        p.LASTLOGINTIME      = DBHelper_SqlServer.GetDataValue <string>(dr, "LASTLOGINTIME");
                        p.ISLOGININ          = DBHelper_SqlServer.GetDataValue <string>(dr, "ISLOGININ");
                        p.HANDSHAKE          = DBHelper_SqlServer.GetDataValue <string>(dr, "HANDSHAKE");
                        p.PW_BACKUP1         = DBHelper_SqlServer.GetDataValue <string>(dr, "PW_BACKUP1");
                        p.PW_BACKUP2         = DBHelper_SqlServer.GetDataValue <string>(dr, "PW_BACKUP2");
                        p.PW_BACKUP3         = DBHelper_SqlServer.GetDataValue <string>(dr, "PW_BACKUP3");
                        rtn.Add(p);
                    }
                }
            }
            catch
            {
            }
            return(rtn);
        }
        private static List <OD_Task> DoQuery(string sql_str)
        {
            List <OD_Task> rtn = new List <OD_Task>();

            try
            {
                DBHelper DBHelper_SqlServer = new DBLink();
                using (IDataReader dr = DBHelper_SqlServer.ExecuteReader(sql_str))
                {
                    while (dr.Read())
                    {
                        var p = new OD_Task();
                        #region 逐个赋值
                        p.TASKID              = DBHelper_SqlServer.GetDataValue <string>(dr, "TASKID");
                        p.TASKNAME            = DBHelper_SqlServer.GetDataValue <string>(dr, "TASKNAME");
                        p.DODEVICEID          = DBHelper_SqlServer.GetDataValue <string>(dr, "DODEVICEID");
                        p.DODEVICENODEID      = DBHelper_SqlServer.GetDataValue <string>(dr, "DODEVICENODEID");
                        p.DODEVICETYPE        = DBHelper_SqlServer.GetDataValue <string>(dr, "DODEVICETYPE");
                        p.TASKTYPE            = DBHelper_SqlServer.GetDataValue <string>(dr, "TASKTYPE");
                        p.TASKLEVEL           = DBHelper_SqlServer.GetDataValue <string>(dr, "TASKLEVEL");
                        p.TASKSTATUS          = DBHelper_SqlServer.GetDataValue <string>(dr, "TASKSTATUS");
                        p.TASKCONTENTSTRING   = DBHelper_SqlServer.GetDataValue <string>(dr, "TASKCONTENTSTRING");
                        p.TASKTYPEDESCRIPTION = DBHelper_SqlServer.GetDataValue <string>(dr, "TASKTYPEDESCRIPTION");
                        p.CONTAINERNO         = DBHelper_SqlServer.GetDataValue <string>(dr, "CONTAINERNO");
                        p.SOURCEPLACE         = DBHelper_SqlServer.GetDataValue <string>(dr, "SOURCEPLACE");
                        p.TOPLACE             = DBHelper_SqlServer.GetDataValue <string>(dr, "TOPLACE");
                        p.ORDERDETAILSID      = DBHelper_SqlServer.GetDataValue <string>(dr, "ORDERDETAILSID");
                        p.ORDERHEADID         = DBHelper_SqlServer.GetDataValue <string>(dr, "ORDERHEADID");
                        p.SENDTIMES           = DBHelper_SqlServer.GetDataValue <int>(dr, "SENDTIMES");
                        p.RELEASESTATUS       = DBHelper_SqlServer.GetDataValue <string>(dr, "RELEASESTATUS");
                        p.HADFINISH           = DBHelper_SqlServer.GetDataValue <string>(dr, "HADFINISH");
                        p.VOID               = DBHelper_SqlServer.GetDataValue <int>(dr, "VOID");
                        p.UPDATETIME         = DBHelper_SqlServer.GetDataValue <string>(dr, "UPDATETIME");
                        p.UPDATEUSER         = DBHelper_SqlServer.GetDataValue <string>(dr, "UPDATEUSER");
                        p.WAREHOUSENO        = DBHelper_SqlServer.GetDataValue <string>(dr, "WAREHOUSENO");
                        p.ISCURRENTTASK      = DBHelper_SqlServer.GetDataValue <string>(dr, "ISCURRENTTASK");
                        p.INPUTLOCATIONLEVEL = DBHelper_SqlServer.GetDataValue <int>(dr, "INPUTLOCATIONLEVEL");
                        p.ISLASTTASK         = DBHelper_SqlServer.GetDataValue <string>(dr, "ISLASTTASK");
                        p.ISEMPTYCONTAINER   = DBHelper_SqlServer.GetDataValue <string>(dr, "ISEMPTYCONTAINER");

                        #endregion
                        rtn.Add(p);
                    }
                }
            }
            catch
            {
            }
            return(rtn);
        }
        private static List <PL_Place> DoQuery(string sql_str)
        {
            List <PL_Place> rtn = new List <PL_Place>();

            try
            {
                DBHelper DBHelper_SqlServer = new DBLink();
                using (IDataReader dr = DBHelper_SqlServer.ExecuteReader(sql_str))
                {
                    while (dr.Read())
                    {
                        var p = new PL_Place();
                        #region 逐个赋值
                        p.PLACEID            = DBHelper_SqlServer.GetDataValue <string>(dr, "PLACEID");
                        p.PLACENODEID        = DBHelper_SqlServer.GetDataValue <string>(dr, "PLACENODEID");
                        p.PLACETYPE          = DBHelper_SqlServer.GetDataValue <string>(dr, "PLACETYPE");
                        p.PLACEAREA          = DBHelper_SqlServer.GetDataValue <string>(dr, "PLACEAREA");
                        p.ROWNO              = DBHelper_SqlServer.GetDataValue <string>(dr, "ROWNO");
                        p.COLUMNNO           = DBHelper_SqlServer.GetDataValue <string>(dr, "COLUMNNO");
                        p.LAYERNO            = DBHelper_SqlServer.GetDataValue <string>(dr, "LAYERNO");
                        p.DEEPCELLNO         = DBHelper_SqlServer.GetDataValue <string>(dr, "DEEPCELLNO");
                        p.AISLE              = DBHelper_SqlServer.GetDataValue <string>(dr, "AISLE");
                        p.LINE               = DBHelper_SqlServer.GetDataValue <string>(dr, "LINE");
                        p.AISLESIDE          = DBHelper_SqlServer.GetDataValue <string>(dr, "AISLESIDE");
                        p.ISLOCK             = DBHelper_SqlServer.GetDataValue <string>(dr, "ISLOCK");
                        p.ISFULL             = DBHelper_SqlServer.GetDataValue <string>(dr, "ISFULL");
                        p.HASTASKDOING       = DBHelper_SqlServer.GetDataValue <string>(dr, "HASTASKDOING");
                        p.WAREHOUSENO        = DBHelper_SqlServer.GetDataValue <string>(dr, "WAREHOUSENO");
                        p.POSITIONNO_FOR_SRM = DBHelper_SqlServer.GetDataValue <string>(dr, "POSITIONNO_FOR_SRM");
                        p.X           = DBHelper_SqlServer.GetDataValue <string>(dr, "X");
                        p.Y           = DBHelper_SqlServer.GetDataValue <string>(dr, "Y");
                        p.Z           = DBHelper_SqlServer.GetDataValue <string>(dr, "Z");
                        p.LENGTH      = DBHelper_SqlServer.GetDataValue <decimal>(dr, "LENGTH");
                        p.WIDTH       = DBHelper_SqlServer.GetDataValue <decimal>(dr, "WIDTH");
                        p.HEIGHT      = DBHelper_SqlServer.GetDataValue <decimal>(dr, "HEIGHT");
                        p.MAXWEIGHT   = DBHelper_SqlServer.GetDataValue <decimal>(dr, "MAXWEIGHT");
                        p.HEIGHTLEVEL = DBHelper_SqlServer.GetDataValue <string>(dr, "HEIGHTLEVEL");
                        p.PRIORITY    = DBHelper_SqlServer.GetDataValue <int>(dr, "PRIORITY");
                        p.AREA_LOGIC  = DBHelper_SqlServer.GetDataValue <string>(dr, "AREA_LOGIC");

                        #endregion
                        rtn.Add(p);
                    }
                }
            }
            catch
            {
            }
            return(rtn);
        }
        /// <summary>
        /// 获取被锁定库位
        /// </summary>
        /// <returns></returns>
        public static List <string> GetLockedPlace()
        {
            string        getstr      = "";
            List <string> LockedPlace = new List <string>();
            StringBuilder sb          = new StringBuilder();

            sb.Append(" select distinct placeid from PL_Place where islock='1'");
            getstr = sb.ToString();
            DBHelper DBHelper_SqlServer = new DBLink();
            var      rd = DBHelper_SqlServer.ExecuteReader(getstr);

            while (rd.Read())
            {
                LockedPlace.Add(rd["PLACEID"].ToString());
            }
            return(LockedPlace);
        }
        private static List <IM_Item> DoQuery(string sql_str)
        {
            List <IM_Item> rtn = new List <IM_Item>();

            try
            {
                DBHelper DBHelper_SqlServer = new DBLink();
                {
                    using (IDataReader dr = DBHelper_SqlServer.ExecuteReader(sql_str))
                    {
                        while (dr.Read())
                        {
                            var p = new IM_Item();
                            p.SKU            = DBHelper_SqlServer.GetDataValue <string>(dr, "SKU");
                            p.SKUDESC        = DBHelper_SqlServer.GetDataValue <string>(dr, "SKUDESC");
                            p.BARCODE        = DBHelper_SqlServer.GetDataValue <string>(dr, "BARCODE");
                            p.EANCODE        = DBHelper_SqlServer.GetDataValue <string>(dr, "EANCODE");
                            p.COMPATIBLECODE = DBHelper_SqlServer.GetDataValue <string>(dr, "COMPATIBLECODE");
                            p.SPEC           = DBHelper_SqlServer.GetDataValue <string>(dr, "SPEC");
                            p.ITEMCLASS      = DBHelper_SqlServer.GetDataValue <string>(dr, "ITEMCLASS");
                            p.ABCCLASS       = DBHelper_SqlServer.GetDataValue <string>(dr, "ABCCLASS");
                            p.UOM            = DBHelper_SqlServer.GetDataValue <string>(dr, "UOM");
                            p.LENGTH         = DBHelper_SqlServer.GetDataValue <decimal>(dr, "LENGTH");
                            p.WIDTH          = DBHelper_SqlServer.GetDataValue <decimal>(dr, "WIDTH");
                            p.HEIGHT         = DBHelper_SqlServer.GetDataValue <decimal>(dr, "HEIGHT");
                            p.WEIGHT         = DBHelper_SqlServer.GetDataValue <decimal>(dr, "WEIGHT");
                            p.SAVEQTY        = DBHelper_SqlServer.GetDataValue <decimal>(dr, "SAVEQTY");
                            p.STORGELIFE     = DBHelper_SqlServer.GetDataValue <string>(dr, "STORGELIFE");
                            p.VOID           = DBHelper_SqlServer.GetDataValue <int>(dr, "VOID");
                            p.UPDATETIME     = DBHelper_SqlServer.GetDataValue <string>(dr, "UPDATETIME");
                            p.UPDATEUSER     = DBHelper_SqlServer.GetDataValue <string>(dr, "UPDATEUSER");
                            p.ITEM_BK1       = DBHelper_SqlServer.GetDataValue <string>(dr, "ITEM_BK1");
                            p.ITEM_BK2       = DBHelper_SqlServer.GetDataValue <string>(dr, "ITEM_BK2");
                            p.ITEM_BK3       = DBHelper_SqlServer.GetDataValue <string>(dr, "ITEM_BK3");

                            rtn.Add(p);
                        }
                    }
                }
            }
            catch (Exception ex)
            {
            }
            return(rtn);
        }
        private static List <DU_Device> DoQuery(string sql_str)
        {
            List <DU_Device> rtn = new List <DU_Device>();

            try
            {
                DBHelper DBHelper_SqlServer = new DBLink();
                using (IDataReader dr = DBHelper_SqlServer.ExecuteReader(sql_str))
                {
                    while (dr.Read())
                    {
                        var p = new DU_Device();
                        #region 逐个赋值
                        p.DEVICEID        = DBHelper_SqlServer.GetDataValue <string>(dr, "DEVICEID");
                        p.DEVICENODEID    = DBHelper_SqlServer.GetDataValue <string>(dr, "DEVICENODEID");
                        p.DEVICESERVICEID = DBHelper_SqlServer.GetDataValue <string>(dr, "DEVICESERVICEID");
                        p.DEVICENAME      = DBHelper_SqlServer.GetDataValue <string>(dr, "DEVICENAME");
                        p.DEVICETYPE      = DBHelper_SqlServer.GetDataValue <string>(dr, "DEVICETYPE");
                        p.VOID            = DBHelper_SqlServer.GetDataValue <int>(dr, "VOID");
                        p.WAREHOUSENO     = DBHelper_SqlServer.GetDataValue <string>(dr, "WAREHOUSENO");
                        p.AISLE           = DBHelper_SqlServer.GetDataValue <string>(dr, "AISLE");
                        p.LINE            = DBHelper_SqlServer.GetDataValue <string>(dr, "LINE");
                        p.SERVERIPADDRESS = DBHelper_SqlServer.GetDataValue <string>(dr, "SERVERIPADDRESS");
                        p.SERVERPORTNO    = DBHelper_SqlServer.GetDataValue <string>(dr, "SERVERPORTNO");
                        p.IPADDRESS       = DBHelper_SqlServer.GetDataValue <string>(dr, "IPADDRESS");
                        p.PORTNO          = DBHelper_SqlServer.GetDataValue <int>(dr, "PORTNO");
                        p.SOCKETTYPE      = DBHelper_SqlServer.GetDataValue <string>(dr, "SOCKETTYPE");
                        p.LOCALIPADDRESS  = DBHelper_SqlServer.GetDataValue <string>(dr, "LOCALIPADDRESS");
                        p.LOCALPORTNO     = DBHelper_SqlServer.GetDataValue <int>(dr, "LOCALPORTNO");
                        p.REMOTEIPADDRESS = DBHelper_SqlServer.GetDataValue <string>(dr, "REMOTEIPADDRESS");
                        p.REMOTEPORTNO    = DBHelper_SqlServer.GetDataValue <int>(dr, "REMOTEPORTNO");
                        p.ISONLINE        = DBHelper_SqlServer.GetDataValue <int>(dr, "ISONLINE");
                        p.WORKINGSTATUS   = DBHelper_SqlServer.GetDataValue <string>(dr, "WORKINGSTATUS");

                        #endregion
                        rtn.Add(p);
                    }
                }
            }
            catch
            {
            }
            return(rtn);
        }
        /// <summary>
        /// 获取空库位
        /// </summary>
        /// <returns></returns>
        public static List <string> GetEmptyPlace()
        {
            string        getstr     = "";
            List <string> emptyplace = new List <string>();
            StringBuilder sb;

            sb = new StringBuilder();
            sb.Append("select PlaceID from PL_PLACE where IsLock !='Y' and PLACEID not in (");
            sb.Append(" select PLACEID from IV_PLACE_VS_CONTAINER)");
            // sb.Append(" and PlaceID not in(select PlaceID from IV_place_vs_container) order by LayerNo,RowNo,ColumnNo");
            DBHelper DBHelper_SqlServer = new DBLink();

            getstr = sb.ToString();
            var rd = DBHelper_SqlServer.ExecuteReader(getstr);

            while (rd.Read())
            {
                emptyplace.Add(rd["PLACEID"].ToString());
            }
            return(emptyplace);
        }
Exemple #13
0
        private static List <IV_container_vs_item> DoQuery(string sql_str)
        {
            List <IV_container_vs_item> rtn = new List <IV_container_vs_item>();

            try
            {
                DBHelper DBHelper_SqlServer = new DBLink();
                using (IDataReader dr = DBHelper_SqlServer.ExecuteReader(sql_str))
                {
                    while (dr.Read())
                    {
                        var p = new IV_container_vs_item();
                        p.ID           = DBHelper_SqlServer.GetDataValue <string>(dr, "ID");
                        p.CONTAINERID  = DBHelper_SqlServer.GetDataValue <string>(dr, "CONTAINERID");
                        p.ITEMSKU      = DBHelper_SqlServer.GetDataValue <string>(dr, "ITEMSKU");
                        p.ITEMDESC     = DBHelper_SqlServer.GetDataValue <string>(dr, "ITEMDESC");
                        p.ITEMBATCHNO  = DBHelper_SqlServer.GetDataValue <string>(dr, "ITEMBATCHNO");
                        p.ITEMSTATUSNO = DBHelper_SqlServer.GetDataValue <string>(dr, "ITEMSTATUSNO");
                        p.ITEMQTY      = DBHelper_SqlServer.GetDataValue <decimal>(dr, "ITEMQTY");
                        p.OCC_QTY      = DBHelper_SqlServer.GetDataValue <decimal>(dr, "OCC_QTY");
                        p.WITHORDER    = DBHelper_SqlServer.GetDataValue <string>(dr, "WITHORDER");
                        p.UPDATETIME   = DBHelper_SqlServer.GetDataValue <string>(dr, "UPDATETIME");
                        p.UPDATEUSER   = DBHelper_SqlServer.GetDataValue <string>(dr, "UPDATEUSER");
                        p.VOID         = DBHelper_SqlServer.GetDataValue <int>(dr, "VOID");
                        p.EXPIREDAY    = DBHelper_SqlServer.GetDataValue <string>(dr, "EXPIREDAY");
                        p.CVI_BACKUP1  = DBHelper_SqlServer.GetDataValue <string>(dr, "CVI_BACKUP1");
                        p.CVI_BACKUP2  = DBHelper_SqlServer.GetDataValue <string>(dr, "CVI_BACKUP2");
                        p.CVI_BACKUP3  = DBHelper_SqlServer.GetDataValue <string>(dr, "CVI_BACKUP3");

                        rtn.Add(p);
                    }
                }
            }
            catch (Exception ex)
            {
            }
            return(rtn);
        }
Exemple #14
0
        private static List <IV_place_vs_container> DoQuery(string sql_str)
        {
            List <IV_place_vs_container> rtn = new List <IV_place_vs_container>();

            try
            {
                DBHelper DBHelper_SqlServer = new DBLink();
                using (IDataReader dr = DBHelper_SqlServer.ExecuteReader(sql_str))
                {
                    while (dr.Read())
                    {
                        var p = new IV_place_vs_container();
                        #region 逐个赋值
                        p.ID               = DBHelper_SqlServer.GetDataValue <string>(dr, "ID");
                        p.WAREHOUSENO      = DBHelper_SqlServer.GetDataValue <string>(dr, "WAREHOUSENO");
                        p.PLACEID          = DBHelper_SqlServer.GetDataValue <string>(dr, "PLACEID");
                        p.CONTAINERID      = DBHelper_SqlServer.GetDataValue <string>(dr, "CONTAINERID");
                        p.UPDATETIME       = DBHelper_SqlServer.GetDataValue <string>(dr, "UPDATETIME");
                        p.UPDATEUSER       = DBHelper_SqlServer.GetDataValue <string>(dr, "UPDATEUSER");
                        p.VOID             = DBHelper_SqlServer.GetDataValue <int>(dr, "VOID");
                        p.ISEMPTYCONTAINER = DBHelper_SqlServer.GetDataValue <string>(dr, "ISEMPTYCONTAINER");
                        p.ISEMPTYPLACE     = DBHelper_SqlServer.GetDataValue <string>(dr, "ISEMPTYPLACE");
                        p.PVC_BACKUP1      = DBHelper_SqlServer.GetDataValue <string>(dr, "PVC_BACKUP1");
                        p.PVC_BACKUP2      = DBHelper_SqlServer.GetDataValue <string>(dr, "PVC_BACKUP2");
                        p.PVC_BACKUP3      = DBHelper_SqlServer.GetDataValue <string>(dr, "PVC_BACKUP3");

                        #endregion
                        rtn.Add(p);
                    }
                }
            }
            catch
            {
            }
            return(rtn);
        }