public void IplasExcelList()
        {
            string json = string.Empty;
            IplasQuery ilpsQuery = new IplasQuery();
            DataTable dtExcel = new DataTable();
            try
            {
                string content = string.Empty;
                if (!string.IsNullOrEmpty(Request.Params["search_type"]))
                {
                    ilpsQuery.serch_type = int.Parse(Request.Params["search_type"]);
                    if (!string.IsNullOrEmpty(Request.Params["searchcontent"]) && Request.Params["searchcontent"].Trim().Length > 0)//有查詢內容就不管時間
                    {

                        switch (ilpsQuery.serch_type)
                        {
                            case 1:
                            case 2:
                                ilpsQuery.searchcontent = Request.Params["searchcontent"].Trim();
                                break;
                            case 3:
                                #region 之後的更改
                                content = Request.Params["searchcontent"].Replace(',', ',').Replace('|', ',').Replace(' ', ',');//.Replace(' ',',')
                                string[] list = content.Split(',');
                                string test = "^[0-9]*$";
                                int count = 0;//實現最後一個不加,
                                for (int i = 0; i < list.Length; i++)
                                {
                                    if (!string.IsNullOrEmpty(list[i]))
                                    {
                                        if (Regex.IsMatch(list[i], test))
                                        {
                                            count = count + 1;
                                            if (count == 1)
                                            {
                                                ilpsQuery.searchcontent = list[i];
                                            }
                                            else
                                            {
                                                ilpsQuery.searchcontent = ilpsQuery.searchcontent + "," + list[i];
                                            }
                                        }
                                        else
                                        {
                                            ilpsQuery.searchcontent = ilpsQuery.searchcontent + list[i] + ",";
                                        }
                                    }
                                }

                                #endregion
                                break;
                            default:
                                break;
                        }


                    }


                }
                DateTime time;
                if (DateTime.TryParse(Request.Params["starttime"].ToString(), out time))
                {
                    ilpsQuery.starttime = DateTime.Parse(time.ToString("yyyy-MM-dd HH:mm:ss"));
                }
                if (DateTime.TryParse(Request.Params["endtime"].ToString(), out time))
                {
                    ilpsQuery.endtime = DateTime.Parse(time.ToString("yyyy-MM-dd HH:mm:ss"));
                }
                List<IplasQuery> store = new List<IplasQuery>();
                _IiplasMgr = new IplasMgr(mySqlConnectionString);
                store = _IiplasMgr.GetIplasExportList(ilpsQuery);
                dtExcel.Columns.Add("商品編號", typeof(String));
                dtExcel.Columns.Add("商品名稱", typeof(String));
                dtExcel.Columns.Add("料位編號", typeof(String));
                dtExcel.Columns.Add("料位容量", typeof(String));
                dtExcel.Columns.Add("是否買斷", typeof(String));
                dtExcel.Columns.Add("創建人", typeof(String));
                dtExcel.Columns.Add("創建時間", typeof(String));
                for (int i = 0; i < store.Count; i++)
                {
                    DataRow newRow = dtExcel.NewRow();
                    newRow[0] = store[i].item_id.ToString();
                    newRow[1] = store[i].product_name.ToString();
                    newRow[2] = store[i].loc_id.ToString();
                    newRow[3] = store[i].loc_stor_cse_cap.ToString();
                    newRow[4] = store[i].prepaid.ToString() == "0" ? "否" : "是";
                    newRow[5] = store[i].create_users.ToString();
                    newRow[6] = store[i].create_dtim.ToString();
                    dtExcel.Rows.Add(newRow);
                }
                if (dtExcel.Rows.Count > 0)
                {
                    string fileName = "商品指定主料位_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls";
                    MemoryStream ms = ExcelHelperXhf.ExportDT(dtExcel, "商品指定主料位_" + DateTime.Now.ToString("yyyyMMddHHmmss"));
                    Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName);
                    Response.BinaryWrite(ms.ToArray());
                }
                else
                {
                    Response.Write("匯出數據不存在");
                }
            }
            catch (Exception ex)
            {
                Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
                logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
                logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
                log.Error(logMessage);
            }
        }