Exemplo n.º 1
0
        public DataTable getSubinv(string org, int searchType)
        {
            string sql = "";

            if (searchType == 1)
            {
                sql = "SELECT subinv from location WHERE org ='" + org + @"' and subinv like '%HD%' GROUP BY subinv";
            }
            else
            {
                sql = "SELECT subinv from location WHERE org ='" + org + @"' and subinv not like '%HD%' GROUP BY subinv";
            }

            DataTable dt = new DataTable();

            if (MiddleWare == "1")
            {
                dt = MyCatfsg_SqlHelper.ExcuteTable(sql);
            }
            else
            {
                dt = Mysqlfsg_SqlHelper.ExcuteTable(sql);
            }
            return(dt);
        }
        public DataTable getMesworktagscansByinvoiceDetail(string tagInvoice)
        {
            string sql = @"
							SELECT	s.Id,
									s.tagNumber ,
									s.tagScanDateTime ,
									s.tagStyle ,
									s.tagColor ,
									s.tagSize ,
									s.tagQty ,
									s.tagOrg ,
									d.DeptName ,
									s.tagScanAccount 
								FROM
									mesworktagscans s
									LEFT JOIN mesdepts d ON d.DeptNumber = s.tagScanDeptID 
								WHERE
									tagInvoice = '"                                     + tagInvoice + @"'
										ORDER BY    id"                                        ;


            DataTable result = new DataTable();

            if (MiddleWare == "1")
            {
                result = MyCatfsg_SqlHelper.ExcuteTable(sql);
            }
            else
            {
                result = Mysqlfsg_SqlHelper.ExcuteTable(sql);
            }

            return(result);
        }
Exemplo n.º 3
0
        public bool isExistsByaccount(string account)
        {
            string sql = @"SELECT id FROM mesusers WHERE account='" + account + "'";

            DataTable dt = new DataTable();

            if (MiddleWare == "1")
            {
                dt = MyCatfsg_SqlHelper.ExcuteTable(sql);
            }
            else
            {
                dt = Mysqlfsg_SqlHelper.ExcuteTable(sql);
            }



            if (dt.Rows.Count <= 0)
            {
                return(false);
            }
            else
            {
                return(true);
            }
        }
Exemplo n.º 4
0
        public DataTable getStyleCounts(string org, string outsubinv, string outLine, string style)
        {
            string sqlstr = @"SELECT    
                                       id,
                                    styleCount,
	                                qtyCount
                                FROM
	                                countreceis 
                                WHERE
	                                org = '"     + org + @"' 
	                                AND subinv = '"     + outsubinv + @"' 
	                                AND line = '"     + outLine + @"' 
                                    AND style = '" + style + @"'
	                                AND STATUS = 0"    ;

            DataTable dt = new DataTable();

            if (MiddleWare == "1")
            {
                dt = MyCatfsg_SqlHelper.ExcuteTable(sqlstr);
            }
            else
            {
                dt = Mysqlfsg_SqlHelper.ExcuteTable(sqlstr);
            }


            return(dt);
        }
        public DataTable getLocation(string org)
        {
            string sql = @"SELECT
	                            tagLocation 
                            FROM
	                            mesworktagscans 
                            WHERE
	                            tagOrg = 'SAA' 
	                            AND tagLocation != '' 
	                            AND tagLocation IS NOT NULL 
                            GROUP BY
	                            tagLocation"    ;

            DataTable dt = new DataTable();

            if (MiddleWare == "1")
            {
                dt = MyCatfsg_SqlHelper.ExcuteTable(sql);
            }
            else
            {
                dt = Mysqlfsg_SqlHelper.ExcuteTable(sql);
            }

            return(dt);
        }
Exemplo n.º 6
0
        public DataTable getPropertysByPnumberFromLocalHost(string propertyIDs)
        {
            string[] propertyID = propertyIDs.Split('|');
            string   sql        = "";
            string   wherestr   = "";

            if (propertyID.Length > 0)
            {
                for (int i = 0; i < propertyID.Length; i++)
                {
                    //('AE9O-0184','AE9O-0183','AE9O-0189')
                    wherestr = wherestr + "'" + propertyID[i] + "',";
                }
            }
            wherestr = wherestr.Remove(wherestr.Length - 1, 1);
            sql      = @"SELECT * from  propertys WHERE   propertyID in (" + wherestr + ")";



            DataTable dt = new DataTable();

            if (MiddleWare == "1")
            {
                dt = MyCatfsg_SqlHelper.ExcuteTable(sql);
            }
            else
            {
                dt = Mysqlfsg_SqlHelper.ExcuteTable(sql);
            }
            return(dt);
        }
Exemplo n.º 7
0
        public List <string> getOrg()
        {
            List <string> orgs   = new List <string>();
            string        sqlstr = "SELECT org FROM  location GROUP BY org";

            DataTable dt = new DataTable();

            if (MiddleWare == "1")
            {
                dt = MyCatfsg_SqlHelper.ExcuteTable(sqlstr);
            }
            else
            {
                dt = Mysqlfsg_SqlHelper.ExcuteTable(sqlstr);
            }
            if (dt.Rows.Count <= 0)
            {
                orgs.Add("没有数据");
                return(orgs);
            }
            foreach (DataRow dr in dt.Rows)
            {
                orgs.Add(dr["org"].ToString().Trim().ToUpper());
            }
            return(orgs);
        }
Exemplo n.º 8
0
        public DataTable getOffSet(string org, string subinv, string location, string starTime, string stopTime)
        {
            string sql = @"
							SELECT
									TagNumber
								FROM
									invreceis 
								WHERE
									org = '"                                     + org + @"' 
									AND subinv = '"                                     + subinv + @"' 
									AND line = '"                                     + location + @"'
									AND scantime BETWEEN STR_TO_DATE( '"                                     + starTime + @"', '%Y-%m-%d' ) 
									AND STR_TO_DATE( '"                                     + stopTime + "','%Y-%m-%d' )";

            DataTable result = new DataTable();

            if (MiddleWare == "1")
            {
                result = MyCatfsg_SqlHelper.ExcuteTable(sql);
            }
            else
            {
                result = Mysqlfsg_SqlHelper.ExcuteTable(sql);
            }
            return(result);
        }
Exemplo n.º 9
0
        public DataTable getMoveLocals(string tags)
        {
            string sql = @"SELECT
								id,
								TagNumber,
								max( ScanTime ) max_time ,								
								Location
							FROM
								inv  
							WHERE
								TagNumber = '"                                 + tags + @"'
	 
							GROUP BY
								ScanTime,
								id 
							ORDER BY
								ScanTime DESC 
								LIMIT 0,
								1"                                ;

            DataTable result = new DataTable();

            if (MiddleWare == "1")
            {
                result = MyCatfsg_SqlHelper.ExcuteTable(sql);
            }
            else
            {
                result = Mysqlfsg_SqlHelper.ExcuteTable(sql);
            }
            return(result);
        }
Exemplo n.º 10
0
        public List <string> getColors(string style)
        {
            List <string> colors = new List <string>();
            string        sqlstr = "SELECT color_code  from con_detail WHERE Buyer_Item='" + style + "' GROUP BY  color_code ORDER BY color_code";

            DataTable dt = new DataTable();

            if (MiddleWare == "1")
            {
                dt = MyCatfsg_SqlHelper.ExcuteTable(sqlstr);
            }
            else
            {
                dt = Mysqlfsg_SqlHelper.ExcuteTable(sqlstr);
            }
            if (dt.Rows.Count <= 0)
            {
                colors.Add("没有数据");
                return(colors);
            }
            foreach (DataRow dr in dt.Rows)
            {
                colors.Add(dr["color_code"].ToString().Trim().ToUpper());
            }
            return(colors);
        }
Exemplo n.º 11
0
        public List <string> getSubinv(string org)
        {
            List <string> subinvs = new List <string>();
            string        sqlstr  = "SELECT subinv FROM  location  WHERE org = '" + org + "' GROUP BY subinv ";

            DataTable dt = new DataTable();

            if (MiddleWare == "1")
            {
                dt = MyCatfsg_SqlHelper.ExcuteTable(sqlstr);
            }
            else
            {
                dt = Mysqlfsg_SqlHelper.ExcuteTable(sqlstr);
            }
            if (dt.Rows.Count <= 0)
            {
                subinvs.Add("没有数据");
                return(subinvs);
            }
            foreach (DataRow dr in dt.Rows)
            {
                subinvs.Add(dr["subinv"].ToString().Trim().ToUpper());
            }
            return(subinvs);
        }
Exemplo n.º 12
0
        public DataTable  getLoginByAccount(string account, string pwd)
        {
            string    sql = @"SELECT
								u.id,
								u.UserName,
								u.deptID,
								u.marsk,
								d.DeptName,
								d.DeptNumber 
							FROM
								mesusers u
								LEFT JOIN mesdepts d ON d.DeptNumber = u.deptID 
							WHERE
								u.account = '"                                 + account + @"' 
								AND u.PASSWORD = '******'";
            DataTable dt  = new DataTable();

            if (MiddleWare == "1")
            {
                dt = MyCatfsg_SqlHelper.ExcuteTable(sql);
            }
            else
            {
                dt = Mysqlfsg_SqlHelper.ExcuteTable(sql);
            }

            return(dt);
        }
Exemplo n.º 13
0
        public DataTable getFsgTagNumber( )
        {
            string sql = @"SELECT
							tagnumber 
						FROM
							(
							SELECT
								b1.tagnumber,
								b1.con_no,
								ROUND( c.con_no, 2 ),
								b1.location,
								b1.cust_id,
								c.po,
								c.buyer_item,
								c.color_code,
								c.size1,
								c.qty,
								b1.kg,
								b1.subinv,
								b1.lastscantime,
								b2.completed_no,
							IF
								( isnull( b2.qty ), IF ( isnull( b2.completed_no ), NULL, c.qty ), b2.qty ),
								c.gtn_po,
								c.corg,
								c.pprfno,
								b1.updatedate,
								c.main_line AS po_line 
							FROM
								tag_stock_info b1
								LEFT JOIN con_no c ON b1.cust_id = c.cust_id 
								AND b1.con_no = c.serial_from
								LEFT JOIN tag_inf b2 ON b1.tagnumber = b2.tagnumber 
								AND c.buyer_item = b2.buyer_item 
								AND c.color_code = b2.color_code 
								AND c.size1 = b2.size1 
							WHERE
								1 = 1 
								AND b1.org = 'TOP' 
								AND c.po IS NULL 
								AND b1.cust_id = 'NIKE' 
								AND b1.lastScanTime > '2020-12-31' 
							) a 
						GROUP BY
							tagnumber"                            ;
            //  DataTable result = Mysqlfsg_SqlHelper.ExcuteTable(sql);
            DataTable dt = new DataTable();

            if (MiddleWare == "1")
            {
                dt = MyCatfsg_SqlHelper.ExcuteTable(sql);
            }
            else
            {
                dt = Mysqlfsg_SqlHelper.ExcuteTable(sql);
            }
            return(dt);
            //return result;
        }
Exemplo n.º 14
0
        public DataTable getReceiFromNoBarCode(string org, string subinv, string location, string starTime, string stopTime)
        {
            string sql = @"
							 
							SELECT
								org,
								subinv,
								line,
								style,
								color,
								size,
								SUM( qtyCount ) qtyCount,
								SUM( PO ) OffsetQty,
								receiNumber ,
								receiDate,
								receiInPcName
							FROM
								receis 
							WHERE
								org = '"                                 + org + @"' 
								AND subinv = '"                                 + subinv + @"'
								AND line = '"                                 + location + @"' 
								AND qtyCount > 0 
								AND isFull = 0
								AND receiDate BETWEEN '"                                 + starTime + "' and '" + stopTime + @"'
							GROUP BY
								org,
								subinv,
								line,
								style,
								color,
								size,
								receiNumber,
								receiDate,
								receiInPcName
							ORDER BY 
								org,
								subinv,
								line,
								receiDate,
								style,
								color,
								size;"                                ;

            DataTable result = new DataTable();

            if (MiddleWare == "1")
            {
                result = MyCatfsg_SqlHelper.ExcuteTable(sql);
            }
            else
            {
                result = Mysqlfsg_SqlHelper.ExcuteTable(sql);
            }
            return(result);
        }
Exemplo n.º 15
0
        public DataTable getUserInfo(string[] searchParameter)
        {
            // { account, processID, userName };
            string deptID = searchParameter[1];

            MyCatParameter[] cp = new MyCatParameter[3];
            MySqlParameter[] mp = new MySqlParameter[3];
            if (deptID == "-1")
            {
                deptID = "";
            }


            if (MiddleWare == "1")
            {
                cp[0] = new MyCatParameter("account", searchParameter[0]);
                cp[1] = new MyCatParameter("deptID", deptID);
                cp[2] = new MyCatParameter("userName", searchParameter[2]);
            }
            else
            {
                mp[0] = new MySqlParameter("account", searchParameter[0]);
                mp[1] = new MySqlParameter("deptID", deptID);
                mp[2] = new MySqlParameter("userName", searchParameter[2]);
            };
            //  account ,processID, userName
            string    sql   = @"SELECT
	                            ID,
	                            account,
	                            userName,
	                            deptID,
	                            marsk 
                            FROM
	                            mesusers 
                            WHERE 1 = 1 and  
                            if(@account ='',0=0, account = @account ) and 
                            if(@deptID ='',0=0, deptID = @deptID ) and 
                            if(@userName ='',0=0, userName = @userName )
                            ORDER BY
	                            Id;"    ;
            DataTable users = new DataTable();

            if (MiddleWare == "1")
            {
                users = MyCatfsg_SqlHelper.ExcuteTable(sql, cp);
            }
            else
            {
                users = Mysqlfsg_SqlHelper.ExcuteTable(sql, mp);
            };
            return(users);
        }
        public DataTable getTagInvoiceById(string Mid)
        {
            string    sql    = @"
							SELECT
									concat_ws(
										'-',
										ifNULL( s.tagScanPDAUUID, '0' ),
										concat(
											ifNULL((
												SELECT
												CASE
														LENGTH( tagScanDeptID ) 
														WHEN 1 THEN
														concat( '0', tagScanDeptID ) 
														ELSE
															tagScanDeptID
													END AS tagScanDeptID 
														
												FROM
													mesworktagscanreceipts 
												WHERE
													id ="                                                     + Mid + @"
													),
												'0' 
											),
											ifNULL( DATE_FORMAT( s.tagScanDateTime, '%Y%m%d' ), '0' ) 
										),
										ifNULL( `Version`, '0' ) 
									) AS tagInvoice,
									s.tagScanDeptID,
									s.Version,
									s.tagScanAccount,
									s.tagScanDateTime 
								FROM
									mesworktagscanreceipts s 
								WHERE
									s.id ="                                     + Mid;
            DataTable result = new DataTable();

            if (MiddleWare == "1")
            {
                result = MyCatfsg_SqlHelper.ExcuteTable(sql);
            }
            else
            {
                result = Mysqlfsg_SqlHelper.ExcuteTable(sql);
            }

            return(result);
        }
Exemplo n.º 17
0
        public DataTable gettagLocations(string taginvoice, bool isAuto)
        {
            string sql = "";

            if (isAuto)
            {
                sql = @"SELECT
							CASE		
								WHEN
									tagLocation = '' THEN
										'%' ELSE tagLocation 
									END tagLocation
									FROM
										mesworktagscans
									WHERE
										tagInvoice LIKE '"                                         + taginvoice + @"%' 
										 
								GROUP BY
								tagLocation"                                ;
            }
            else
            {
                sql = @"SELECT
							CASE		
								WHEN
									tagLocation = '' THEN
										'%' ELSE tagLocation 
									END tagLocation
									FROM
										mesworktagscans
									WHERE
										tagInvoice LIKE '"                                         + taginvoice + @"%' 
										 
								GROUP BY
								tagLocation"                                ;
            }

            DataTable result = new DataTable();

            if (MiddleWare == "1")
            {
                result = MyCatfsg_SqlHelper.ExcuteTable(sql);
            }
            else
            {
                result = Mysqlfsg_SqlHelper.ExcuteTable(sql);
            }

            return(result);
        }
Exemplo n.º 18
0
        public int isHaveByTradingComanyPO(string Tpo)
        {
            string    sql    = @"SELECT GTN_PO FROM `gtn_po` WHERE GTN_PO ='" + Tpo + "'";
            DataTable result = new DataTable();

            if (MiddleWare == "1")
            {
                result = MyCatfsg_SqlHelper.ExcuteTable(sql);
            }
            else
            {
                result = Mysqlfsg_SqlHelper.ExcuteTable(sql);
            }
            return(result.Rows.Count);
        }
Exemplo n.º 19
0
        public DataTable getOrg()
        {
            string    sqlstr = @"SELECT DISTINCT org,id FROM location  GROUP BY org";
            DataTable dt     = new DataTable();

            if (MiddleWare == "1")
            {
                dt = MyCatfsg_SqlHelper.ExcuteTable(sqlstr);
            }
            else
            {
                dt = Mysqlfsg_SqlHelper.ExcuteTable(sqlstr);
            }
            return(dt);
        }
Exemplo n.º 20
0
        public DataTable getOrgs()
        {
            string    sql = @"SELECT org  from inv  GROUP BY org;";
            DataTable dt  = new DataTable();

            if (MiddleWare == "1")
            {
                dt = MyCatfsg_SqlHelper.ExcuteTable(sql);
            }
            else
            {
                dt = Mysqlfsg_SqlHelper.ExcuteTable(sql);
            }
            return(dt);
        }
Exemplo n.º 21
0
        public int isHaveByNikeConnect(string Npo)
        {
            string    sql    = @"SELECT PONumber from nikeconnect WHERE PONumber ='" + Npo + "'";
            DataTable result = new DataTable();

            if (MiddleWare == "1")
            {
                result = MyCatfsg_SqlHelper.ExcuteTable(sql);
            }
            else
            {
                result = Mysqlfsg_SqlHelper.ExcuteTable(sql);
            }
            return(result.Rows.Count);
        }
Exemplo n.º 22
0
        public DataTable getLocations(string org, string subinv)
        {
            string    sqlstr = @"SELECT DISTINCT location,id FROM location  WHERE org ='" + org + "' and subinv = '" + subinv + "'  AND LOCATION LIKE 'CF%D'  GROUP BY location";
            DataTable dt     = new DataTable();

            if (MiddleWare == "1")
            {
                dt = MyCatfsg_SqlHelper.ExcuteTable(sqlstr);
            }
            else
            {
                dt = Mysqlfsg_SqlHelper.ExcuteTable(sqlstr);
            }
            return(dt);
        }
Exemplo n.º 23
0
        public DataTable getFromWriteExcel(string createPC, string starTime, string stopTime)
        {
            string sql = @"SELECT
								d.lineName,
								d.DeliveryDate,
								d.styleId,
								d.colorId,
							CASE
								WHEN t.AFTER != NULL THEN
									t.AFTER ELSE d.sizeName 
								END sizeName,
								sum( d.Qty ) Qty 
							FROM
								delivertb d
								LEFT JOIN transize t ON d.sizeName = t.AFTER 
								OR d.sizeName = t.BEFORE 
							WHERE
								Create_Pc = '"                                 + createPC + @"' 
								AND isdel = 0 
								AND deliveryDate    BETWEEN    STR_TO_DATE('"                                 + starTime + @"','%Y-%m-%d') 
								AND  STR_TO_DATE('"                                 + stopTime + @"','%Y-%m-%d' )
								AND isDel =0
							GROUP BY
								lineName,
								DeliveryDate,
								styleId,
								colorId,
								sizeName 
							ORDER BY
								d.deliveryDate,
								d.lineName,
								d.styleId,
								d.colorId,
								sizeName;"                                ;

            DataTable dt = new DataTable();

            if (MiddleWare == "1")
            {
                dt = MyCatfsg_SqlHelper.ExcuteTable(sql);
            }
            else
            {
                dt = Mysqlfsg_SqlHelper.ExcuteTable(sql);
            }

            return(dt);
        }
Exemplo n.º 24
0
        public DataTable getSubinvByOrg(string org)
        {
            string sql = @"SELECT DISTINCT subinv from Location WHERE org='" + org + "'";

            DataTable dt = new DataTable();

            if (MiddleWare == "1")
            {
                dt = MyCatfsg_SqlHelper.ExcuteTable(sql);
            }
            else
            {
                dt = Mysqlfsg_SqlHelper.ExcuteTable(sql);
            }
            return(dt);
        }
Exemplo n.º 25
0
        public DataTable getStyles()
        {
            string sqlstr = "SELECT Buyer_Item  from con_detail GROUP BY  Buyer_Item ORDER BY Buyer_Item";

            DataTable dt = new DataTable();

            if (MiddleWare == "1")
            {
                dt = MyCatfsg_SqlHelper.ExcuteTable(sqlstr);
            }
            else
            {
                dt = Mysqlfsg_SqlHelper.ExcuteTable(sqlstr);
            }
            return(dt);
        }
Exemplo n.º 26
0
        public DataTable getLocationByOrgAndSubinv(string org, string subinv)
        {
            string sql = @"SELECT DISTINCT location from Location WHERE org='" + org + "'  AND Subinv = '" + subinv + "'";

            DataTable dt = new DataTable();

            if (MiddleWare == "1")
            {
                dt = MyCatfsg_SqlHelper.ExcuteTable(sql);
            }
            else
            {
                dt = Mysqlfsg_SqlHelper.ExcuteTable(sql);
            }
            return(dt);
        }
Exemplo n.º 27
0
        public DataTable getLocation(string subinv)
        {
            string sql = @"SELECT DISTINCT Location FROM location  WHERE subinv='" + subinv + "'";

            DataTable result = new DataTable();

            if (MiddleWare == "1")
            {
                result = MyCatfsg_SqlHelper.ExcuteTable(sql);
            }
            else
            {
                result = Mysqlfsg_SqlHelper.ExcuteTable(sql);
            }
            return(result);
        }
Exemplo n.º 28
0
        public DataTable getSubinvs(string org)
        {
            string sqlstr = @"SELECT DISTINCT subinv,id FROM location  WHERE org ='" + org + "' and subinv like '%HD'  GROUP BY subinv";

            DataTable dt = new DataTable();

            if (MiddleWare == "1")
            {
                dt = MyCatfsg_SqlHelper.ExcuteTable(sqlstr);
            }
            else
            {
                dt = Mysqlfsg_SqlHelper.ExcuteTable(sqlstr);
            }
            return(dt);
        }
Exemplo n.º 29
0
        public DataTable getLocationsBysubinv(string org, string subinv)
        {
            string sql = @"select  location  from location where  org = '" + org + "'  and subinv = '" + subinv + "'  group by  location;";

            DataTable result = new DataTable();

            if (MiddleWare == "1")
            {
                result = MyCatfsg_SqlHelper.ExcuteTable(sql);
            }
            else
            {
                result = Mysqlfsg_SqlHelper.ExcuteTable(sql);
            }
            return(result);
        }
        public DataTable updataMesworktagscansByinvoiceIsprint(string id)
        {
            string    sql    = @" UPDATE mesworktagscans set isPrints = 1 WHERE ID = '" + id + "'";
            DataTable result = new DataTable();

            if (MiddleWare == "1")
            {
                result = MyCatfsg_SqlHelper.ExcuteTable(sql);
            }
            else
            {
                result = Mysqlfsg_SqlHelper.ExcuteTable(sql);
            }

            return(result);
        }