private void cmdEdytuj_Click(object sender, EventArgs e)
{
Worker worker ;
try { worker = (Worker)dgwWorkers.CurrentRow.DataBoundItem; }
catch { return; }
FindWorker newWorker = new FindWorker("Edycja pracownika", "Zapisz");
newWorker.IMIE = worker.IMIE;
newWorker.NAZWISKO = worker.NAZWISKO;
newWorker.ADRES = worker.ADRES;
newWorker.PESEL = worker.PESEL;
newWorker.NIP = worker.NIP;
newWorker.BANK = worker.BANK;
newWorker.ShowDialog();
if (newWorker.CANCEL) return;
CustomerDatabase.UpdateWorker(worker.ID, newWorker.IMIE, newWorker.NAZWISKO,
newWorker.ADRES, newWorker.PESEL, newWorker.NIP,newWorker.BANK);
LoadWorkers(worker.ID, "", "", "", "", "");
Message.InfoMessage("Zaktulizowano dane pracownika");
}
/// <summary>
/// 获取下一步骤的所有节点
/// </summary>
/// <param name="workflowNo">流程编号</param>
/// <param name="NodeID">从节点</param>
/// <param name="WorkID">工作ID</param>
/// <param name="FID">父工作ID</param>
/// <param name="paramPairs">参数</param>
/// <returns>节点列表</returns>
public ActionResult WorkOpt_GetToNodes(int WorkID, int NodeID, int FID, List <KeyValuePair <string, string> > wfParams = null, int singleSelect = 1)
{
BP.WF.Dev2Interface.Port_Login(ApplicationUser.Current.Name, "dd2f628c-3f38-4c8c-aa83-1a52ebf6a45a");
var work = NH.Session.QueryOver <WF_GenerWorkFlow>().Where(x => x.WorkID == WorkID).List().FirstOrDefault();
wfParams = wfParams == null ? new List <KeyValuePair <string, string> >() : wfParams;
var nodeEntity = NH.Session.Get <WF_Node>(NodeID);
var dic = wfParams.ToDictionary(x => x.Key, x => x.Value);
var ht = new Hashtable(dic);
BP.WF.Glo.SendHTOfTemp = ht;
var result = BP.WF.Dev2Interface.WorkOpt_GetToNodes(work.FK_Flow, NodeID, WorkID, FID);// NodeService.WorkOpt_GetToNodes(workflowNo, NODEID, WORKID, FID);
//result = result.Where(x => x.NodeID != 0).ToList();
var data = new List <dynamic>();
//var trackList = FlowService.DB_GenerTrack(workflowNo, WORKID, 0).ToList();
var userList = NH.Session.QueryOver <Auth_User>().List().ToList();
foreach (BP.WF.Node item in result)
{
dynamic parent = new ExpandoObject();
parent.FK_NODE = "";
parent.value = item.NodeID.ToString();
parent.text = item.Name;
parent.RUNMODEL = item.HisRunModel;
var flow = new BP.WF.Flow(work.FK_Flow);
var workNode = new BP.WF.WorkNode(WorkID, NodeID);
var toNode = new BP.WF.WorkNode(WorkID, item.NodeID);
FindWorker fw = new FindWorker();
var dt = fw.DoIt(flow, workNode, toNode);
// var select = new BP.WF.Template.Selector(item.NodeID);
//var wk = item.HisWork;
//wk.OID = WORKID;
//wk.Retrieve();
//var ds = select.GenerDataSet(item.NodeID, null);
var children = new List <ExpandoObject>();
foreach (DataRow dr in dt.Rows)
{
var user = userList.Where(x => x.Name == dr["No"].ToString()).FirstOrDefault();
if (user == null)
{
continue;
}
dynamic child = new ExpandoObject();
child.value = dr["No"].ToString();
child.text = user.RealName;
child.NODEID = item.NodeID;
children.Add(child);
}
parent.children = children;
//var empList = new List<dynamic>();
//var toNodeEntity = NH.Session.Get<WF_NODE>(item.NodeID.ToString());
//if (toNodeEntity.DELIVERYWAY == 8)
//{
// //指定某个环节的处理人
// empList = QueryService.GetData(string.Format("SELECT DISTINCT {0} AS FK_NODE, T.FK_EMP AS NO ,T.FK_EMPTEXT AS NAME FROM WF_GENERWORKERLIST t WHERE ( t.workid={1} or t.workid={2} ) AND T.FK_NODE={3}", item.NodeID, WORKID, FID, toNodeEntity.DELIVERYPARAS), null, null, true).ToList();
//}
//else
//{
// if (nodeEntity.HISDEPTSTRS == "1")
// {
// var userName = CurrentUser.UserName;
// empList = QueryService.GetData(string.Format("SELECT DISTINCT TO_CHAR(NT.FK_NODE) AS FK_NODE,E.NO,E.NAME||(CASE WHEN EMP.AUTHOR IS NOT NULL THEN '(由【'||AUTHOR.NAME||'】代理)' ELSE '' END) AS NAME,E.EMPNO FROM WF_NODESTATION NT INNER JOIN PORT_EMPSTATION ES ON NT.FK_STATION=ES.FK_STATION INNER JOIN PORT_EMP E ON E.NO=ES.FK_EMP INNER JOIN PORT_EMPDEPT EP ON EP.FK_EMP=E.NO LEFT OUTER JOIN WF_EMP EMP ON EMP.NO=E.NO LEFT OUTER JOIN PORT_EMP AUTHOR ON AUTHOR.NO=EMP.AUTHOR WHERE NT.FK_NODE='{0}' AND EP.FK_DEPT IN (SELECT FK_DEPT FROM PORT_EMPDEPT WHERE FK_EMP='{1}') ORDER BY E.EMPNO", item.NodeID, CurrentUser.UserName), null, null, true).ToList();
// }
// else
// {
// empList = QueryService.GetData(string.Format("SELECT DISTINCT TO_CHAR(NT.FK_NODE) AS FK_NODE,E.NO,E.NAME||(CASE WHEN EMP.AUTHOR IS NOT NULL THEN '(由【'||AUTHOR.NAME||'】代理)' ELSE '' END) AS NAME,E.EMPNO FROM WF_NODESTATION NT INNER JOIN PORT_EMPSTATION ES ON NT.FK_STATION=ES.FK_STATION INNER JOIN PORT_EMP E ON E.NO=ES.FK_EMP LEFT OUTER JOIN WF_EMP EMP ON EMP.NO=E.NO LEFT OUTER JOIN PORT_EMP AUTHOR ON AUTHOR.NO=EMP.AUTHOR WHERE NT.FK_NODE='{0}' ORDER BY E.EMPNO", item.NodeID), null, null, true).ToList();
// }
//}
//var test = new ExpandoObject();
//foreach (Dictionary<string, object> emp in empList)
//{
// emp.Add("RUNMODEL", item.HisRunModel);
//}
//data.AddRange(empList);
data.Add(parent);
}
return(Json_Get(data));
}
private void cmdPracownikSearch_Click(object sender, EventArgs e)
{
FindWorker findWorkers = new FindWorker("Wyszukaj pracowników", "Szukaj");
findWorkers.ShowDialog();
if (findWorkers.CANCEL) return;
List<Worker> workers =
CustomerDatabase.GetWorkers(-1, findWorkers.IMIE, findWorkers.NAZWISKO,
findWorkers.PESEL, findWorkers.NIP, findWorkers.BANK);
if (workers == null) { Message.InfoMessage("Nie znaleziono"); return; }
cbxPracownik.DisplayMember = "";
cbxPracownik.ValueMember = "";
cbxPracownik.DataSource = null;
cbxPracownik.DataSource = workers;
cbxPracownik.DisplayMember = "PRACOWNIK";
cbxPracownik.ValueMember = "ID";
Settings.ShowDropDownList(ref cbxPracownik);
}
private void cmdPracownikDodaj_Click(object sender, EventArgs e)
{
FindWorker newWorker = new FindWorker("Nowy pracownik", "Dodaj");
newWorker.ShowDialog();
if (newWorker.CANCEL) return;
int id = CustomerDatabase.NewWorker(newWorker.IMIE, newWorker.NAZWISKO, newWorker.ADRES, newWorker.PESEL,
newWorker.NIP, newWorker.BANK);
List<Worker> pracownicy = CustomerDatabase.GetWorkers(id, "", "", "", "", "");
cbxPracownik.DisplayMember = "";
cbxPracownik.ValueMember = "";
cbxPracownik.DataSource = null;
cbxPracownik.DataSource = pracownicy;
cbxPracownik.DisplayMember = "PRACOWNIK";
cbxPracownik.ValueMember = "ID";
cbxPracownik.SelectedValue = id;
PRACOWNIK = (Worker)cbxPracownik.SelectedItem;
Message.InfoMessage("Nowy pracownik został dodany");
}
private void cmdNowy_Click(object sender, EventArgs e)
{
FindWorker newWorker = new FindWorker("Nowy pracownik", "Dodaj");
newWorker.ShowDialog();
if (newWorker.CANCEL) return;
CustomerDatabase.NewWorker(newWorker.IMIE, newWorker.NAZWISKO, newWorker.ADRES, newWorker.PESEL,
newWorker.NIP, newWorker.BANK);
LoadWorkers(-1, newWorker.IMIE, newWorker.NAZWISKO, newWorker.PESEL, newWorker.NIP, newWorker.BANK);
Message.InfoMessage("Nowy pracownik został dodany");
}
private void cmdSzukaj_Click(object sender, EventArgs e)
{
FindWorker findWorkers = new FindWorker("Wyszukaj pracowników", "Szukaj");
findWorkers.ShowDialog();
if (findWorkers.CANCEL) return;
LoadWorkers(-1, findWorkers.IMIE, findWorkers.NAZWISKO, findWorkers.PESEL, findWorkers.NIP, findWorkers.BANK);
}
