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();
}
