protected void grid_DOC_LIST_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { SqlConnection conn = new SqlConnection(OPM_BL.StaticDefaultConnectionString); conn.Open(); SqlTransaction trans; trans = conn.BeginTransaction(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandTimeout = 240; cmd.Transaction = trans; string sql = ""; string ID = e.Keys[grid_DOC_LIST.KeyFieldName].ToString(); try { sql = "Delete From SMM_DOCUMENT_LIST where doc_id = @_DOC_ID"; SqlParameter[] param = new SqlParameter[1]; param[0] = OPM_BL.setParameter("@_DOC_ID", SqlDbType.VarChar, ID); cmd.CommandText = sql; cmd.Parameters.Clear(); foreach (SqlParameter p in param) { if (p != null) { cmd.Parameters.Add(p); } } cmd.ExecuteNonQuery(); trans.Commit(); BindData(); e.Cancel = true; } catch (Exception ex) { trans.Rollback(); } // ]บรายการไฟล์แนบใบประเมิน opmUploadService.ServiceSoapClient s = new opmUploadService.ServiceSoapClient(); DataTable DT = s.GetAttachment("SMM", "Document", ID.ToString(), ""); // ลบรายการเอกสาร ลบ Upload ด้วย for (int i = 0; DT.Rows.Count > i; i++) { string imgID = DT.Rows[i]["IMG_ID"].ToString(); s.DeleteAttachment(imgID, ""); } LogFileEng.SaveActionTransLog("SMM_UT0111", "DELETE", "Success", "SMM_DOCUMENT_LIST", ID, "", Request); e.Cancel = true; }
protected void viewIMAGES_ListView_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { e.Cancel = true; string imgID = e.Keys["IMG_ID"].ToString(); //opmUploadService.Service s = new opmUploadService.Service(); opmUploadService.ServiceSoapClient s = new opmUploadService.ServiceSoapClient(); s.DeleteAttachment(imgID, ""); s = new opmUploadService.ServiceSoapClient(); DataTable dtImages = s.GetAttachment(SYS_ID, SUB_ID, inputCOMMAND_ID, ""); //DataTable dtImages = s.GetAttachment(SYS_ID, SUB_ID, "00000", ""); gv_Upload.DataSource = dtImages; gv_Upload.DataBind(); ScriptManager.RegisterStartupScript(this, this.GetType(), "register", "alert(สำเร็จ);", true); // ScriptManager.RegisterStartupScript(this, this.GetType(), "register", "gv_Upload.Refresh();", true); }
// ดึงไฟล์ของใบประเมิน private void GetFile(string REQ_ID) { ScriptManager.RegisterStartupScript(this, this.GetType(), "register", "gv_Upload.Refresh();", true); opmUploadService.ServiceSoapClient s = new opmUploadService.ServiceSoapClient(); string token = Request.Cookies[SharedDB.TokenName].Value; DataTable dtImages = s.GetAttachment(SYS_ID, SUB_ID, REQ_ID.ToString(), token); DataRow DR; for (int i = 0; dtImages.Rows.Count > i; i++) { DR = dtImages.Rows[i]; DR["URL"] = (dtImages.Rows[i]["URL"].ToString()).Replace("http://opm.demotoday.net/UPLOAD", "http://172.18.2.101/UPLOAD"); } gv_Upload.DataSource = dtImages; gv_Upload.DataBind(); }
// ดึงไฟล์ของใบประเมิน private void GetFile(string DOC_ID) { ScriptManager.RegisterStartupScript(this, this.GetType(), "register", "gv_Upload.Refresh();", true); opmUploadService.ServiceSoapClient s = new opmUploadService.ServiceSoapClient(); string token = Request.Cookies[SharedDB.TokenName].Value; DataTable dtImages = s.GetAttachment(SYS_ID, SUB_ID, DOC_ID.ToString(), token); //dtImages.Columns.Add("Path_File"); DataRow DR; for (int i = 0; dtImages.Rows.Count >i; i++) { DR = dtImages.Rows[i]; DR["URL"] = (dtImages.Rows[i]["URL"].ToString()).Replace("http://opm.demotoday.net/UPLOAD", "http://172.18.2.101/UPLOAD"); } viewRCST_COMMAND_SCAN2_ListView.DataSource = dtImages; viewRCST_COMMAND_SCAN2_ListView.DataBind(); Session["DTCurrent_dtImages"] = dtImages; //dtImages.Columns.Remove("Path_File"); }
protected void btnCancel_Click(object sender, EventArgs e) { if (DOC_ID().ToString() == "0") { // ลบรายการที่กำลังโชว์ในหน้าจอ DataTable DT = (DataTable)Session["DTCurrent_dtImages"]; for (int i = 0; DT.Rows.Count > i; i++) { string imgID = DT.Rows[i]["IMG_ID"].ToString(); opmUploadService.ServiceSoapClient s = new opmUploadService.ServiceSoapClient(); s.DeleteAttachment(imgID, ""); } } LogFileEng.SaveActionTransLog("SMM_UT0111", "BACK", "Back From SMM_DOC", "", "", "", Request); Response.Redirect("SMM_DOC_ListView.aspx"); }
protected void Page_Load(object sender, EventArgs e) { JS = ""; if (Request.QueryString[key] != null && Request.QueryString[key] != "-1") { mode = "e"; } if (!IsPostBack) { } ScriptManager.RegisterStartupScript(this, this.GetType(), "register", "SetCalendar();", true); ScriptManager.RegisterStartupScript(this, this.GetType(), "register", "viewRCST_COMMAND_SCAN2_ListView.Refresh();", true); opmUploadService.ServiceSoapClient s = new opmUploadService.ServiceSoapClient(); DataTable dtImages = s.GetAttachment(SYS_ID, SUB_ID, inputCOMMAND_ID, ""); viewRCST_COMMAND_SCAN2_ListView.DataSource = dtImages; viewRCST_COMMAND_SCAN2_ListView.DataBind(); }
protected void btnBack_Click(object sender, EventArgs e) { if (REQ_ID().ToString() == "0") { // ลบรายการที่กำลังโชว์ในหน้าจอ DataTable DT = (DataTable)Session["DTCurrent_dtImages"]; for (int i = 0; DT.Rows.Count > i; i++) { string imgID = DT.Rows[i]["IMG_ID"].ToString(); opmUploadService.ServiceSoapClient s = new opmUploadService.ServiceSoapClient(); s.DeleteAttachment(imgID, ""); } } if (role() == "other") { Response.Redirect("SMM_PER_PROMOTE_PROJECT_ListView.aspx"); } else { Response.Redirect("SMM_PER_PROMOTE_REQ_ListView.aspx?role=" + role()); } LogFileEng.SaveActionTransLog(lblFormCode.Text.Replace("(", "").Replace(")", ""), "BACK", "", "", "", "", Request); }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["req"] != null && Request.QueryString["req"] != "-1") { inputCOMMAND_ID = Request.QueryString["req"]; } if (role() == "staff") { SetDDLPERSON(dx_REQ_By); } if (!IsPostBack) { CurrentTab = 1; //หา USER ID //ถ้า ROLE = requester USER ID = Login User_ID //ถ้า ROLE = Staff USER_ID = ตาม dx_REQ_By string _USER_ID = user_id; if (role() == "staff") { if (dx_REQ_By.Items.Count > 0) { if (REQ_ID() == 0) { dx_REQ_By.SelectedIndex = 0; } else { dx_REQ_By.Value = GetUserIDFromReqID(REQ_ID().ToString()); } _USER_ID = dx_REQ_By.Value.ToString(); } } //กำหนดข้อมูล USER SetUserInfo(_USER_ID); //กำหนดรายละเอียดตำแหน่งเดิมตาม ROLE if (REQ_ID() == 0) { if (role() == "staff") { SetPositionByUser_staff(_USER_ID); } else { SetPositionByUser_requester(_USER_ID); } } //แสดง POSITION HISTORY จาก DPIS SetPOSHistory_DPIS(_USER_ID); } //SET POSITION IN DDL SetDDLPOSITION(dx_NewPos, PER_TYPE); SetDDLPOSITION(dx_OldPos, PER_TYPE); if (!IsPostBack) { //เพื่อให้ระดับและรายละเอียดเปลี่ยนตามตำแหน่งที่เลือก if (dx_NewPos.Items.Count > 0) { dx_NewPos.SelectedIndex = 0; } dx_NewPos_SelectedIndexChanged(sender, e); //กรณีแก้ไขข้อมูล if (REQ_ID() != 0) { SetPROMOTE_REQ(REQ_ID().ToString()); SetProject(REQ_ID().ToString()); SetAction(REQ_ID().ToString()); SetSCORE(REQ_ID().ToString()); LogFileEng.SaveActionTransLog(lblFormCode.Text.Replace("(", "").Replace(")", ""), "EDIT", "REQ_ID :" + REQ_ID().ToString(), "", "", "", Request); } } //เก็บข้อมูลจาก Project ใส่ Session if (CurrentTab == 1) { Session["ProjectDT"] = getCurrentGridData(gvProject); } ScriptManager.RegisterStartupScript(this, this.GetType(), "register", "viewRCST_COMMAND_SCAN2_ListView.Refresh();", true); opmUploadService.ServiceSoapClient s = new opmUploadService.ServiceSoapClient(); DataTable dtImages = s.GetAttachment(SYS_ID, SUB_ID, inputCOMMAND_ID, ""); viewRCST_COMMAND_SCAN2_ListView.DataSource = dtImages; viewRCST_COMMAND_SCAN2_ListView.DataBind(); }