Пример #1
0
 public bool DelMaterial(string materialid)
 {
     bool suc = false;
     SQLDB _operator = new SQLDB();
     string deletestring = "DELETE ICS_Material where NO= '" + materialid + "'";
     suc = _operator.ExecuteStatement(deletestring);
     return suc;
 }
Пример #2
0
    protected void gv_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "cmd_delete")
        {
            int index = Convert.ToInt32(e.CommandArgument);
            GridViewRow row = gv.Rows[index];
            string filename = row.Cells[0].Text;
            string delete = " delete StudyFileUpload where FileName = '" + filename + "'";
            SQLDB _operator = new SQLDB();
            if (_operator.ExecuteStatement(delete))
            {
                ShowMsg(UpdatePanel1, "刪除成功");
                SearchData();
            }

            try
            {
                string strDestPath = Server.MapPath("../Temp/");

                FileInfo TheFile = new FileInfo(@strDestPath+filename);
                if (TheFile.Exists)
                {
                    File.Delete(@strDestPath + filename);
                }
                else
                {
                    throw new FileNotFoundException();
                }
            }

            catch (FileNotFoundException ex)
            {
                ShowMsg(UpdatePanel1, ex.Message);
            }
            catch (Exception ex)
            {
                ShowMsg(UpdatePanel1, ex.Message);
            }


        }
    }
Пример #3
0
    //private void ExportTOExcel()
    //{

    //    ExcelReport report = null;
    //    try
    //    {
    //        report = new ExcelReport("MIS/EquipmentData");

    //        DataSet ds = (DataSet)Session["DS_MIS"];

    //        for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
    //        {
    //            report.FillData(j + 3, 1, ds.Tables[0].Rows[j]["DeviceID"].ToString(), 1);
    //            report.FillData(j + 3, 2, ds.Tables[0].Rows[j]["DeviceModelName"].ToString(), 1);
    //            report.FillData(j + 3, 3, ds.Tables[0].Rows[j]["RegionName"].ToString(), 1);
    //            report.FillData(j + 3, 4, ds.Tables[0].Rows[j]["SectorName"].ToString(), 1);
    //            report.FillData(j + 3, 5, ds.Tables[0].Rows[j]["TCModel"].ToString(), 1);
    //            report.FillData(j + 3, 6, ds.Tables[0].Rows[j]["ContractName"].ToString(), 1);
    //            report.FillData(j + 3, 7, ds.Tables[0].Rows[j]["DeviceStatus"].ToString(), 1);
    //            report.FillData(j + 3, 8, ds.Tables[0].Rows[j]["DeviceNote"].ToString(), 1);
    //            report.FillData(j + 3, 9, ds.Tables[0].Rows[j]["Longitude"].ToString(), 1);
    //            report.FillData(j + 3, 10, ds.Tables[0].Rows[j]["Latitude"].ToString(), 1);
    //            //report.FillData(j + 1, 2, ds.Tables[0].Rows[j]["DevicePhoto"].ToString(), 1);
    //        }


    //        ScriptManager.RegisterStartupScript(this, this.GetType(), "newprintwindow2", "open_new_window(\"../Temp/" + report.Report() + "\");", true);
    //    }
    //    catch (Exception e)
    //    {
    //        if (report != null)
    //        {
    //            ScriptManager.RegisterStartupScript(this, this.GetType(), "newprintwindow2", "open_new_window(\"../Temp/" + report.Report() + "\");", true);
    //        }

    //    }
    //    finally
    //    {
    //        try
    //        {
    //            report.Close();
    //        }
    //        catch (Exception ex)
    //        {
    //        }
    //    }

    //}


    /// <summary>
    /// 重新計算檢修周期:以設備合約起始日期開始累加檢修週期直到合約截止
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void lnkbtn_Add_Click(object sender, EventArgs e)
    {
        SQLDB db = new SQLDB();
        //先將舊有檢修日期刪除
        string deleteCheckDate = "Delete from CD_DeviceCheckDate where 1=1";
        db.ExecuteStatement(deleteCheckDate);
        
        string queryDevice = "SELECT [Device_ID],[ContractStartDate],[ContractEndDate],[Cycle] FROM [View_DeviceConfig] where [ContractStartDate] is not null and [ContractEndDate] is not null";
        DataSet ds = db.SelectQuery(queryDevice);
        DataSet ds_checkdate = db.Select("1 = 0", "", "CD_DeviceCheckDate");
        for (int i = 0; i < ds.Tables[0].Rows.Count ; i++)
        {
            string device = ds.Tables[0].Rows[i]["Device_ID"].ToString();
            DateTime start = Convert.ToDateTime(ds.Tables[0].Rows[i]["ContractStartDate"].ToString());
            DateTime end = Convert.ToDateTime(ds.Tables[0].Rows[i]["ContractEndDate"].ToString());
            TimeSpan cycle = TimeSpan.FromDays( Convert.ToDouble( ds.Tables[0].Rows[i]["cycle"].ToString()));
            while (start < end)
            {
                start += cycle;
                if (start < end)
                {
                    DataRow dr = ds_checkdate.Tables[0].NewRow();
                    dr["Device_ID"] = ds.Tables[0].Rows[i]["Device_ID"].ToString();
                    dr["CheckDate"] = start.ToString("yyyy/MM/dd HH:mm:ss");
                    ds_checkdate.Tables[0].Rows.Add(dr);
                }
            }
            
        }

        //開始將檢修日期塞到資料庫
        DataSet DSChange = ds_checkdate.GetChanges();
        if (db.Insert(DSChange))
        {
            ShowMsg(UpdatePanel1, "資料計算成功");
        }
    }
Пример #4
0
    //刪除入庫紀錄單、入庫單內容、計畫分攤成本
    private void DeleteStockIn(string stockinid)
    {
        string userid = (string)Session["UserID"];
        SQLDB db = new SQLDB();

        #region 更新庫存量資料表相關欄位
        //DataSet ds_StockInItem = db.Select("StockInID = '" + stockinid + "'", "", "ICS_StockIn_Item");
        //if (ds_StockInItem.Tables[0].Rows.Count> 0)
        //{
        //    //更新庫存量
        //    //庫存數量 = 目前庫存數量+(入庫數 X 轉換係數)

        //    //查詢庫存資料
        //    DataSet ds_inventory = db.Select("", "", "ICS_Inventory");
        //    //查詢物料轉換係數
        //    DataSet ds_material = db.Select("", "", "ICS_Material");
        //    for (int i = 0; i < ds_StockInItem.Tables[0].Rows.Count; i++)
        //    {
        //        string materialid = ds_StockInItem.Tables[0].Rows[i]["MaterialID"].ToString();
        //        string materialName = ds_StockInItem.Tables[0].Rows[i]["MaterialName"].ToString();
        //        int stockInQuantity = Convert.ToInt32(ds_StockInItem.Tables[0].Rows[i]["StockIn_Quantity"].ToString());
        //        int materialValue = Convert.ToInt32(ds_StockInItem.Tables[0].Rows[i]["Material_Single_Value"].ToString());
        //        int stockinCost = Convert.ToInt32(ds_StockInItem.Tables[0].Rows[i]["StockIn_Cost"].ToString());

        //        DataRow[] dr_invertory = ds_inventory.Tables[0].Select("MaterialID = '" + materialid + "'");
        //        DataRow[] dr_material = ds_material.Tables[0].Select("NO = '" + materialid + "'");
        //        double ConversionFactor = Convert.ToDouble(dr_material[0]["ConversionFactor"].ToString());//轉換係數
        //        //若庫存有資料
        //        if (dr_invertory.Length > 0)
        //        {
        //            double invetory_stockinquantity = Convert.ToDouble(dr_invertory[0]["StockInQuantity"].ToString());//庫存購入數量
        //            double invetory_q = Convert.ToDouble(dr_invertory[0]["Quantity"].ToString());//庫存量
        //            double inventoryCost = Convert.ToDouble(dr_invertory[0]["InventoryCost"].ToString());//庫存成本
        //            //更新庫存購入數量:庫存購入數量-(刪除)入庫量
        //            double INStockInQuantity = invetory_stockinquantity - stockInQuantity;
        //            if (INStockInQuantity < 0)
        //                dr_invertory[0]["StockInQuantity"] = 0;
        //            else
        //                dr_invertory[0]["StockInQuantity"] = INStockInQuantity;
        //            //更新庫存數量:庫存數量 = 目前庫存數量-((刪除)入庫數 X 轉換係數)
        //            double quantity =invetory_q - (stockInQuantity * ConversionFactor);
        //            if (quantity < 0)
        //                dr_invertory[0]["Quantity"] = 0;
        //            else
        //                dr_invertory[0]["Quantity"] = invetory_q - (stockInQuantity * ConversionFactor);
        //            //更新料價: (庫存成本-(刪除)入庫成本)/(庫存數量-(刪除)入庫數量)
        //            if ((inventoryCost - stockinCost) <= 0 || (stockInQuantity - invetory_stockinquantity) <= 0 || (invetory_stockinquantity - stockInQuantity) <= 0)
        //            {
        //                dr_invertory[0]["MaterialCost"] = 0;
        //                dr_invertory[0]["InventoryCost"] = 0;
        //            }
        //            else
        //            {   //更新料價: (庫存成本-(刪除)入庫成本)/(庫存數量-(刪除)入庫數量)
        //                dr_invertory[0]["MaterialCost"] = (inventoryCost - stockinCost) / (invetory_stockinquantity -stockInQuantity);
        //                //更新庫存成本:料價 X (刪除)庫存購入數量
        //                dr_invertory[0]["InventoryCost"] = (inventoryCost - stockinCost) / (invetory_stockinquantity - stockInQuantity) * (invetory_stockinquantity - stockInQuantity);
        //            }
        //            dr_invertory[0]["UpdateTime"] = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
        //        }
        //    }
        //    DataSet ds_invetoryEdit = ds_inventory.GetChanges();
        //    if (db.Update(ds_invetoryEdit))
        //        ShowMsg2(UpdatePanel1, "庫存量更新成功、料價更新成功");
        //    else
        //        ShowMsg2(UpdatePanel1, "庫存量更新成功、料價更新失敗");
        //    SearchData();
        //}
        #endregion
        #region 刪除入庫紀錄單、入庫單內容、計畫分攤成本
        string delete_stockRecord = "Delete ICS_StockIn_Record where stockInID = '" + stockinid + "'";
        string delete_stockitem = "Delete ICS_StockIn_Item where stockInID = '" + stockinid + "'";
        string delete_stockproject = "Delete ICS_Stock_Project where stockInID = '" + stockinid + "'";
        bool suc = false;
        suc = db.ExecuteStatement(delete_stockRecord);
        suc = db.ExecuteStatement(delete_stockitem);
        suc = db.ExecuteStatement(delete_stockproject);
        if (suc)
        {
            ShowMsg2(UpdatePanel1, "刪除成功");
        }
        else
            ShowMsg2(UpdatePanel1, "刪除失敗");
        #endregion
        SearchData();

        //TODO:應該在刪除入庫資料後存一份入庫歷史資料
    }
Пример #5
0
    //刪除入庫紀錄單、入庫單內容、計畫分攤成本
    private void DeleteStockIn(string stockOutid)
    {
        string userid = (string)Session["UserID"];
        SQLDB db = new SQLDB();

        #region 刪除出庫紀錄單、出庫單內容
        string delete_stockRecord = "Delete ICS_StockOut_Record where stockOutID = '" + stockOutid + "'";
        string delete_stockitem = "Delete ICS_StockOut_Item where stockOutID = '" + stockOutid + "'";
        bool suc = false;
        suc = db.ExecuteStatement(delete_stockRecord);
        suc = db.ExecuteStatement(delete_stockitem);
        if (suc)
        {
            ShowMsg2(UpdatePanel1, "刪除成功");
        }
        else
            ShowMsg2(UpdatePanel1, "刪除失敗");
        #endregion
        SearchData();

        //TODO:應該在刪除入庫資料後存一份入庫歷史資料
    }
Пример #6
0
    protected void btn_saveAll_Click(object sender, EventArgs e)
    {
        DataSet ds_StockInItem = (DataSet)Session["StockInItem"];
        DataSet ds_StockProject = (DataSet)Session["ICS_Stock_Project"];
        #region 驗證是否有輸入資料
        if (ds_StockInItem == null || ds_StockProject == null)
        {
            ShowMsg2(UpdatePanel1, "請輸入資料");
            return;
        }
        #endregion
        #region 驗證物料成本跟計畫分攤成本有沒有相同
        int stockcost = 0;
        int projectcost = 0;
        //驗證物料成本跟計畫分攤成本有沒有相同
        if (ds_StockInItem != null)
        {
            for (int i = 0; i < ds_StockInItem.Tables[0].Rows.Count; i++)
            {
                stockcost += Convert.ToInt32(ds_StockInItem.Tables[0].Rows[i]["StockIn_Cost"].ToString());

            }
        }
        if (ds_StockProject!= null)
        {
            for (int j = 0; j < ds_StockProject.Tables[0].Rows.Count; j++)
            {
                projectcost += Convert.ToInt32(ds_StockProject.Tables[0].Rows[j]["ContractCost"].ToString());
            }
        }
        if (stockcost != projectcost)
        {
            ShowMsg2(UpdatePanel1, "入庫單總成本與計畫總成本不一致,請重新調整");
            return;
        }
        #endregion
        #region 新增入庫資料與計畫成本

        string userid = (string)Session["UserID"];
        string stockinid = "";
        SQLDB db = new SQLDB();
        DateTime now = DateTime.Now;
        
        if (hidden_Action.Value == "add")
        {
            //將入庫單時間紀錄起來,之後利用入庫單時間與登入者帳號抓取入庫單編號
            string Stockin_date = now.ToString("yyyy/MM/dd HH:mm:ss");
            string insertstockrecord = "INSERT INTO ICS_StockIn_Record ([UpdateTime],[UpdateUser]) VALUES ('" + Stockin_date + "','" + userid + "')";

            if (db.ExecuteStatement(insertstockrecord))
            {
                DataSet ds = db.Select("UpdateTime ='" + Stockin_date + "'and UpdateUser ='******'", "", "ICS_StockIn_Record");
                if (ds.Tables[0].Rows.Count > 0)
                {
                    //抓到入庫單編號
                    stockinid = ds.Tables[0].Rows[0]["StockInID"].ToString();

                    //將入庫單編號塞到StockInItem裡
                    for (int i = 0; i < ds_StockInItem.Tables[0].Rows.Count; i++)
                    {
                        DataRow dr = ds_StockInItem.Tables[0].Rows[i];
                        dr["StockInID"] = stockinid;
                        dr["UpdateTime"] = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
                        dr["UpdateUser"] = userid;
                    }
                    //將入庫單編號塞到StockProject裡
                    for (int j = 0; j < ds_StockProject.Tables[0].Rows.Count; j++)
                    {
                        DataRow dr = ds_StockProject.Tables[0].Rows[j];
                        dr["StockInID"] = stockinid;
                        dr["UpdateTime"] = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
                        dr["UpdateUser"] = userid;
                    }
                    //刪除rowindex欄位
                    ds_StockInItem.Tables[0].Columns.Remove("rowindex");
                    ds_StockProject.Tables[0].Columns.Remove("rowindex");
                    DataSet DSChangeItem = ds_StockInItem.GetChanges();
                    DataSet DSChangeProject = ds_StockProject.GetChanges();
                    if (db.Insert(DSChangeItem))
                        ShowMsg2(UpdatePanel1, "入庫單內容新增成功");
                    else
                        ShowMsg2(UpdatePanel1, "入庫單內容新增失敗");

                    if (db.Insert(DSChangeProject))
                        ShowMsg2(UpdatePanel1, "入庫分攤成本新增成功");
                    else
                        ShowMsg2(UpdatePanel1, "入庫分攤成本新增失敗");
                }
            }

        }
        else//入庫單內容修改(目前暫時隱藏因為要考量的東西太多)
        {
            DataSet DSChangeItem = ds_StockInItem.GetChanges(DataRowState.Deleted);
            DataSet DSChangeProject = ds_StockProject.GetChanges(DataRowState.Deleted);
            if (DSChangeItem != null)
            {
                if (db.Update(DSChangeItem))
                    ShowMsg2(UpdatePanel1, "入庫單內容修改成功");
                else
                    ShowMsg2(UpdatePanel1, "入庫單內容修改失敗");
            }
            if (DSChangeProject != null)
            {
                if (db.Update(DSChangeProject))
                    ShowMsg2(UpdatePanel1, "入庫分攤成本修改成功");
                else
                    ShowMsg2(UpdatePanel1, "入庫分攤成本修改失敗");
            }
        }
        #endregion

        #region 更新物料庫存量與料價

        #region 舊寫法用庫存資料即時算出物料庫存量與料價再存到ICS_Inventory
        /* 
        //更新庫存量
        //庫存數量 = 目前庫存數量+(入庫數 X 轉換係數)

        //查詢庫存資料
        DataSet ds_inventory = db.Select("", "", "ICS_Inventory");
        //查詢物料轉換係數
        DataSet ds_material = db.Select("", "", "ICS_Material");
        for (int i = 0; i < ds_StockInItem.Tables[0].Rows.Count; i++)
        {
            string materialid = ds_StockInItem.Tables[0].Rows[i]["MaterialID"].ToString();
            string materialName = ds_StockInItem.Tables[0].Rows[i]["MaterialName"].ToString();
            int stockInQuantity = Convert.ToInt32(ds_StockInItem.Tables[0].Rows[i]["StockIn_Quantity"].ToString());
            int materialValue = Convert.ToInt32(ds_StockInItem.Tables[0].Rows[i]["Material_Single_Value"].ToString());
            int stockinCost = Convert.ToInt32(ds_StockInItem.Tables[0].Rows[i]["StockIn_Cost"].ToString());

            DataRow[] dr_invertory = ds_inventory.Tables[0].Select("MaterialID = '" + materialid + "'");
            DataRow[] dr_material = ds_material.Tables[0].Select("NO = '" + materialid + "'");
            double ConversionFactor = Convert.ToDouble(dr_material[0]["ConversionFactor"].ToString());//轉換係數
            //若庫存有資料
            if (dr_invertory.Length > 0)
            {
                double invetory_stockinquantity = Convert.ToDouble(dr_invertory[0]["StockInQuantity"].ToString());//庫存購入數量
                double invetory_q = Convert.ToDouble(dr_invertory[0]["Quantity"].ToString());//庫存量
                double inventoryCost = Convert.ToDouble(dr_invertory[0]["InventoryCost"].ToString());//庫存成本
                //更新庫存購入數量:庫存購入數量+入庫量
                dr_invertory[0]["StockInQuantity"] = invetory_stockinquantity + stockInQuantity;
                //更新庫存數量:庫存數量 = 目前庫存數量+(入庫數 X 轉換係數)
                dr_invertory[0]["Quantity"] = invetory_q + (stockInQuantity * ConversionFactor);
                //更新料價: (庫存成本+入庫成本)/(庫存數量+入庫數量)
                dr_invertory[0]["MaterialCost"] = (inventoryCost + stockinCost) / (stockInQuantity + invetory_stockinquantity);
                //更新庫存成本:料價 X 庫存購入數量
                dr_invertory[0]["InventoryCost"] = (inventoryCost + stockinCost) / (stockInQuantity + invetory_stockinquantity) * (invetory_stockinquantity + stockInQuantity);
                dr_invertory[0]["UpdateTime"] = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
            }
            else//若庫存無此物料資料則新增
            {
                DataRow dr = ds_inventory.Tables[0].NewRow();
                dr["MaterialID"] = materialid;
                dr["MaterialName"] = materialName;
                dr["StockInQuantity"] = stockInQuantity;
                dr["Quantity"] = stockInQuantity * ConversionFactor;
                dr["MaterialCost"] = materialValue;
                dr["InventoryCost"] = stockinCost;
                dr["UpdateTime"] = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
                dr["UpdateUser"] = userid;
                ds_inventory.Tables[0].Rows.Add(dr);
            }

        }
        DataSet ds_invetoryEdit = ds_inventory.GetChanges();
        if (db.Update(ds_invetoryEdit))
            ShowMsg2(UpdatePanel1, "庫存量更新成功、料價更新成功");
        else
            ShowMsg2(UpdatePanel1, "庫存量更新成功、料價更新失敗");
         */
        #endregion

        #region 新寫法:從View_ICS_Inventory查出物料庫存量與料價再存到ICS_Inventory_History
        //更新庫存量
        //庫存數量 = 目前庫存數量+(入庫數 X 轉換係數)

        
        //組出要查詢的入庫物料
        StringBuilder stockinItem = new StringBuilder("MaterialID in (");
        for (int i = 0; i < ds_StockInItem.Tables[0].Rows.Count; i++)
        {
            string materialid  = ds_StockInItem.Tables[0].Rows[i]["MaterialID"].ToString();
            stockinItem.Append(" ' ");
            stockinItem.Append(materialid);
            stockinItem.Append(" ',");
        }
        stockinItem.Remove(stockinItem.Length - 1, 1);  //將最後的,號拿掉
        stockinItem.Append(")");
        
        //查詢View_ICS_Inventory即時物料庫存量與料價
        DataSet ds_viewInventory = db.Select(stockinItem.ToString(), "", "View_ICS_Inventory");
        //查詢庫存歷史資料
        DataSet ds_inventoryHis = db.Select(" 1= 0", "", "ICS_Inventory_History");

        for (int i = 0; i < ds_StockInItem.Tables[0].Rows.Count; i++)
        {
            string materialid = ds_StockInItem.Tables[0].Rows[i]["MaterialID"].ToString();
            string materialName = ds_StockInItem.Tables[0].Rows[i]["MaterialName"].ToString();
            string stockLocation = ds_StockInItem.Tables[0].Rows[i]["Stock_Location"].ToString();

            DataRow[] dr_viewinventory = ds_viewInventory.Tables[0].Select("MaterialID = '" + materialid + "'");
            DataRow dr = ds_inventoryHis.Tables[0].NewRow();
            dr["StockInid"] = stockinid;
            dr["MaterialID"] = materialid;
            dr["MaterialName"] = materialName;
            dr["StockInQuantity"] = Convert.ToDouble(ds_StockInItem.Tables[0].Rows[i]["StockIn_Quantity"].ToString());
            dr["Quantity"] = dr_viewinventory[0]["Quantity"];
            dr["MaterialCost"] = dr_viewinventory[0]["MaterialCost"];
            dr["InventoryCost"] = dr_viewinventory[0]["InventoryCost"];
            dr["StockLocation"] = stockLocation;
            dr["UpdateTime"] = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
            dr["UpdateUser"] = userid;
            ds_inventoryHis.Tables[0].Rows.Add(dr);
        }
        DataSet ds_invetoryEdit = ds_inventoryHis.GetChanges();
        if (db.Update(ds_invetoryEdit))
            ShowMsg2(UpdatePanel1, "庫存量更新成功、料價更新成功");
        else
            ShowMsg2(UpdatePanel1, "庫存量更新成功、料價更新失敗");
        #endregion
       
        #endregion
    }
Пример #7
0
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        SQLDB db = new SQLDB();
        string deviceKind = gv.Rows[e.RowIndex].Cells[1].Text;
        TextBox checkcycle;
        checkcycle = (TextBox)gv.Rows[e.RowIndex].Cells[2].Controls[0];

        if (!IsNumeric(checkcycle.Text))
        {
            ShowMsg2(UpdatePanel1, "請輸入數字");
            return;
        }

        //檢查更新是否成功
        string updatestring = "Update  CD_CheckCycle set cycle= '" + checkcycle.Text + "'  where Devicekind = '" + deviceKind + "'";
        if (db.ExecuteStatement(updatestring))
        {
            ShowMsg2(UpdatePanel1, "更新成功");
        }
        else
        {
            ShowMsg2(UpdatePanel1, "更新失敗");
        }

        gv.EditIndex = -1;
        InitData();
        SearchData();
    }
Пример #8
0
 protected void gv_RowCommand(object sender, GridViewCommandEventArgs e)
 {
     if (e.CommandName == "cmd_delete")
     {
         int index = Convert.ToInt32(e.CommandArgument);
         GridViewRow row = gv.Rows[index];
         string id = row.Cells[1].Text;
         string delete = " delete VD_DOORSILL where ID = '" + id + "'";
         SQLDB _operator = new SQLDB("VD_DOORSILL","KPT");
         if (_operator.ExecuteStatement(delete))
         {
             ShowMsg(UpdatePanel1, "刪除成功");
             SearchData();
         }
     }
 }
Пример #9
0
 protected void gv_RowCommand(object sender, GridViewCommandEventArgs e)
 {
     if (e.CommandName == "singleMapView")
     {
         int index = Convert.ToInt32(e.CommandArgument);
         GridViewRow row = gv.Rows[index];
         string id = row.Cells[3].Text;
         Response.Redirect("../MIS/mapViewer.aspx?type=Case&id=" + id);
     }
     if (e.CommandName == "WEdit")
     {
        int index = Convert.ToInt32(e.CommandArgument);
         GridViewRow row = gv.Rows[index];
         string id = row.Cells[3].Text;
         Response.Redirect("WarrantyNotifyAdd.aspx?act=edit&caseid=" + id);
     }
     if (e.CommandName == "WReturn")
     {
         int index = Convert.ToInt32(e.CommandArgument);
         GridViewRow row = gv.Rows[index];
         string id = row.Cells[3].Text;
         Response.Redirect("ReportReturnManage.aspx?act=return&id=" + id);
     }
     if (e.CommandName == "cmd_delete")
     {
         int index = Convert.ToInt32(e.CommandArgument);
         GridViewRow row = gv.Rows[index];
         string id = row.Cells[3].Text;
         string delete = " delete WarrantyNotify where CaseID = '" + id + "'";
         SQLDB _operator = new SQLDB();
         if (_operator.ExecuteStatement(delete))
         {
             ScriptManager.RegisterStartupScript(this, this.GetType(), "", "alert(\"刪除成功\")", true);
             //Application["App_Invetory_MaterialType"] = CommonLib.GetMaterialType();
             SearchData();
         }
     }
 }
Пример #10
0
    //private void ExportTOExcel()
    //{

    //    ExcelReport report = null;
    //    try
    //    {
    //        report = new ExcelReport("MIS/Region");

    //        DataSet ds = (DataSet)Session["DS_MIS"];

    //        for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
    //        {
    //            report.FillData(j + 3, 1, ds.Tables[0].Rows[j]["RegionName"].ToString(), 1);
    //            report.FillData(j + 3, 2, ds.Tables[0].Rows[j]["RegionCode"].ToString(), 1);
    //        }


    //        ScriptManager.RegisterStartupScript(this, this.GetType(), "newprintwindow2", "open_new_window(\"../Temp/" + report.Report() + "\");", true);
    //    }
    //    catch (Exception e)
    //    {
    //        if (report != null)
    //        {
    //            ScriptManager.RegisterStartupScript(this, this.GetType(), "newprintwindow2", "open_new_window(\"../Temp/" + report.Report() + "\");", true);
    //        }

    //    }
    //    finally
    //    {
    //        try
    //        {
    //            report.Close();
    //        }
    //        catch (Exception ex)
    //        {
    //        }
    //    }

    //}
    protected void gv_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "cmd_delete")
        {
            int index = Convert.ToInt32(e.CommandArgument);
            GridViewRow row = gv.Rows[index];
            string id = row.Cells[1].Text;
            string delete = " delete ICS_Material_Type where materialTypeID = '" + id + "'";
            SQLDB _operator = new SQLDB();
            if (_operator.ExecuteStatement(delete))
            {
                ShowMsg(UpdatePanel1, "刪除成功");
                Application["App_Invetory_MaterialType"] = CommonLib.GetMaterialType();
                SearchData();
            }
        }
    }