/// <summary> /// ارسال به تایید کننده /// </summary> /// <returns></returns> public bool SendConfirm(JDataBase db, int pArchivePlaceCode) { try { string Query = @"select * from VOrganizationChart Where Code IN (select pu.User_Post_Code from PermissionUser pu inner join PermissionDecision pd on pu.DecisionCode=pd.Code inner join PermissionControl pc on pc.Decision_Code = pd.Code where pu.ObjectCode = " + pArchivePlaceCode + " and pc.Class_Name=N'ArchivedDocuments.JRequestArchiveFile.SendConfirm') "; db.setQuery(Query); DataTable dt = db.Query_DataTable(); if (dt.Rows.Count > 0) { Automation.JARefer tmprefer = new Automation.JARefer(); tmprefer.send_date_time = DateTime.Now; //db.setQuery("select * from VOrganizationChart Where Code = " + dt.Rows[0][0].ToString()); //DataTable tmpdt = db.Query_DataTable(); tmprefer.sender_code = JMainFrame.CurrentUserCode; tmprefer.sender_full_title = JMainFrame.CurrentPostTitle; tmprefer.sender_post_code = JMainFrame.CurrentPostCode; tmprefer.receiver_code = Convert.ToInt32(dt.Rows[0]["User_Code"]); tmprefer.receiver_full_title = dt.Rows[0]["Full_Title"].ToString(); tmprefer.receiver_post_code = Convert.ToInt32(dt.Rows[0]["Code"]); tmprefer.register_user_code = JMainFrame.CurrentUserCode; tmprefer.register_Date_Time = DateTime.Now; tmprefer.status = 1; tmprefer.is_active = true; tmprefer.ReferGroup = 1; if (_Refer_Code != 0) { tmprefer.parent_code = _Refer_Code; } //tmprefer.object_code = tmprefer.SendToAutomation(Code, ClassLibrary.Domains.JAutomation.JObjectType.ArchiveRequest //, "درخواست آرشیو فایل", "درخواست آرشیو فایل", "ArchivedDocuments.JRequestArchiveFile", //db, JMainFrame.CurrentPostTitle, JMainFrame.CurrentUserCode, JMainFrame.CurrentUserCode, false); //if (tmprefer.Send(db, true) > 0) //return true; //else return(false); } else { return(false); } } catch (Exception ex) { JSystem.Except.AddException(ex); return(false); } finally { db.Dispose(); } }
private void btnSave_Click(object sender, EventArgs e) { bool Error = false; if (chbUsers.CheckedItems.Count == 0) { return; } if (chbUsers.CheckedItems.Count > 1) { if (JMessages.Warning("تعداد " + chbUsers.CheckedItems.Count.ToString() + " نفر جهت ارجاع انتخاب شده است. آیا مطمئن هستید؟", "ارجاع به چند نفر") != DialogResult.OK) { return; } } List <string> Recivers = new List <string>(); for (int i = 0; i < chbUsers.CheckedItems.Count; i++) { Recivers.AddRange((chbUsers.CheckedItems[i] as JKeyValue).Value.ToString().Split(';')); } JDataBase db = new JDataBase(); try { foreach (string Reciver in Recivers) { int d; if (int.TryParse(Reciver, out d)) { Employment.JEOrganizationChart jeoc = new Employment.JEOrganizationChart(d); Automation.JARefer tmprefer = new Automation.JARefer(); tmprefer.send_date_time = JDateTime.Now(); tmprefer.sender_code = JMainFrame.CurrentUserCode; tmprefer.sender_full_title = JMainFrame.CurrentPostTitle; tmprefer.sender_post_code = JMainFrame.CurrentPostCode; tmprefer.receiver_code = Convert.ToInt32(jeoc.user_code); tmprefer.receiver_full_title = jeoc.full_Name; tmprefer.receiver_post_code = d; tmprefer.register_user_code = JMainFrame.CurrentUserCode; tmprefer.register_Date_Time = JDateTime.Now(); tmprefer.status = ClassLibrary.Domains.JAutomation.JReferStatus.Current; tmprefer.is_active = true; tmprefer.ReferGroup = 1; tmprefer.parent_code = _ParentRefer; tmprefer.description = txtComment.Text; tmprefer.WorkFlowCode = ((JWorkFlow)cmbNextNodes.SelectedItem).Code; tmprefer.object_code = tmprefer.SendToAutomation(_ObjectCode, "", _title, _ClassName, _DynamicClassName, db, JMainFrame.CurrentPostTitle, JMainFrame.CurrentPostCode, JMainFrame.CurrentUserCode, false); if (tmprefer.Send(db, true) > 0) { ((JWorkFlow)cmbNextNodes.SelectedItem).RUNSQL(); ((JWorkFlow)cmbNextNodes.SelectedItem).RUNACTION(); _ReferCode = tmprefer.Code; if (_ParentRefer > 0) { jArchiveList1.ObjectCode = _ParentRefer; jArchiveList1.ArchiveList(); } } else { Error = true; JMessages.Error("اتوماسیون با خطا مواجه شد.", "اتوماسیون"); } } } if (!Error) { JMessages.Information("با موفقیت ارجاع داده شد.", "اتوماسیون"); this.Close(); DialogResult = DialogResult.OK; this.Close(); } } finally { db.Dispose(); } }