UWInfo Blog | 全省銀行資訊

DOM物件隱藏後，用jquery的eachfunction會永遠抓到第一個物件..varTotalOldQty=0;...在做地址的時候用了一個套件(TWZIPCODE)可以幫你產生下拉霸的 ...

        DataTable qtyControls = U2.SQL.DTFromSQL("Select YA00, PD00 from QtyControl Where EndDate > " + EndDate + " and SoldQty >= InitQty");

        var values = qtyControls.AsEnumerable().Select(r => "(" + r.Field<string>("YA00") + "," + r.Field<string>("PD00") + ")").ToList();

        var sqls = new List<string>();         sqls.Add("Delete StopSaleYAP;");

        int start = 0;                 while(start < values.Count)         {             var end = start + 999;             if(end > values.Count - 1)             {                 end = values.Count;             }

            sqls.Add("insert into StopSaleYAP(YA00, PD00) Values" + string.Join(",", values.GetRange(start, end)) + ";");

            start = end + 1;         }

        U2.SQL.ExecuteSQL(string.Join(" ", sqls));