/// <summary>
/// 删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void ButtonDelete_Click(object sender, RoutedEventArgs e)
{
if (dgModelCode.SelectedItems.Count > 1)
{
ComfirmWindow.ConfirmationBox("提示信息", "只能选择一条需要删除的记录！", "确定");
return;
}
if (dgModelCode.SelectedItems.Count == 1)
{
string Result = "";
ComfirmWindow com = new ComfirmWindow();
com.OnSelectionBoxClosed += (obj, result) =>
{
pBar.Start();
FLOW_MODELDEFINE_T define = (dgModelCode.SelectedItem as FLOW_MODELDEFINE_T);
ObservableCollection <string> delete = new ObservableCollection <string>();
delete.Add(define.MODELCODE);
client.DeleteModelDefineAsync(delete);
};
com.SelectionBox("删除确定", "你确定删除选中的记录吗？", ComfirmWindow.titlename, Result);
}
else
{
ComfirmWindow.ConfirmationBox("提示信息", "请先选择一条需要删除的记录！", "确定");
}
}
public DoTaskRuleEdit(FLOW_MODELDEFINE_T system, FLOW_MODELDEFINE_T model, PlatformService.T_WF_DOTASKRULEDETAIL entity, string ruleID)
{
InitializeComponent();
XmlClient = new FlowXmlDefineClient();
string strMsgOpen = string.Empty;
RuleID = ruleID;
XmlClient.ListFuncTableColumnCompleted += new EventHandler <ListFuncTableColumnCompletedEventArgs>(XmlClient_ListFuncTableColumnCompleted);
client.EditDoTaskRuleDetailCompleted += new EventHandler <EditDoTaskRuleDetailCompletedEventArgs>(client_EditDoTaskRuleDetailCompleted);
client.AddDoTaskRuleDetailCompleted += new EventHandler <AddDoTaskRuleDetailCompletedEventArgs>(client_AddDoTaskRuleDetailCompleted);
//加载子系统xml
//XmlClient.ListModelCompleted += new EventHandler<ListModelCompletedEventArgs>(clientXml_ListModelCompleted);
if (system != null && model != null)
{
XmlClient.ListFuncTableColumnAsync(XmlUtils.GetSystemPath(system.SYSTEMCODE), model.MODELCODE, strMsgOpen);
}
if (entity != null)
{
Entity = entity;
InitDetail();
}
else
{
txtAvailabilityProcessDates.Text = "3";
}
if (chkIsMsg.IsChecked == true)
{
SetIsEnabled(false);
}
}
public DoTaskRuleEdit(FLOW_MODELDEFINE_T system, FLOW_MODELDEFINE_T model, PlatformService.T_WF_DOTASKRULEDETAIL entity, string ruleID)
{
InitializeComponent();
XmlClient = new FlowXmlDefineClient();
string strMsgOpen = string.Empty;
RuleID = ruleID;
XmlClient.ListFuncTableColumnCompleted += new EventHandler<ListFuncTableColumnCompletedEventArgs>(XmlClient_ListFuncTableColumnCompleted);
client.EditDoTaskRuleDetailCompleted += new EventHandler<EditDoTaskRuleDetailCompletedEventArgs>(client_EditDoTaskRuleDetailCompleted);
client.AddDoTaskRuleDetailCompleted += new EventHandler<AddDoTaskRuleDetailCompletedEventArgs>(client_AddDoTaskRuleDetailCompleted);
//加载子系统xml
//XmlClient.ListModelCompleted += new EventHandler<ListModelCompletedEventArgs>(clientXml_ListModelCompleted);
if (system != null && model != null)
{
XmlClient.ListFuncTableColumnAsync(XmlUtils.GetSystemPath(system.SYSTEMCODE), model.MODELCODE, strMsgOpen);
}
if (entity != null)
{
Entity = entity;
InitDetail();
}
else
{
txtAvailabilityProcessDates.Text = "3";
}
if (chkIsMsg.IsChecked == true)
{
SetIsEnabled(false);
}
}
/// <summary>
/// 新增模块代码
/// </summary>
/// <param name="flowModel">FlowModel</param>
/// <returns>string</returns>
public string AddModelDefine(FLOW_MODELDEFINE_T flowModel)
{
try
{
OracleConnection conn = MicrosoftOracle.CreateOracleConnection(ConnectionString);
StringBuilder inssql = new StringBuilder();
inssql.Append("INSERT INTO FLOW_MODELDEFINE_T (MODELDEFINEID,SYSTEMCODE,SYSTEMNAME,MODELCODE,PARENTMODELCODE,DESCRIPTION,");
inssql.Append("CREATEUSERID,CREATEUSERNAME,CREATECOMPANYID,CREATEDEPARTMENTID,CREATEPOSTID,CREATEDATE) VALUES (:MODELDEFINEID,");
inssql.Append(":SYSTEMCODE,:SYSTEMNAME,:MODELCODE,:PARENTMODELCODE,:DESCRIPTION,:CREATEUSERID,:CREATEUSERNAME,:CREATECOMPANYID,");
inssql.Append(":CREATEDEPARTMENTID,:CREATEPOSTID,:CREATEDATE)");
OracleParameter[] pageparm =
{
new OracleParameter(":MODELDEFINEID", GetValue(flowModel.MODELDEFINEID)), //模块ID
new OracleParameter(":SYSTEMCODE", GetValue(flowModel.SYSTEMCODE)), //系统代码
new OracleParameter(":SYSTEMNAME", GetValue(flowModel.SYSTEMNAME)), //系统代码
new OracleParameter(":MODELCODE", GetValue(flowModel.MODELCODE)), //模块代码
new OracleParameter(":PARENTMODELCODE", GetValue(flowModel.PARENTMODELCODE)), //上级模块代码
new OracleParameter(":DESCRIPTION", GetValue(flowModel.DESCRIPTION)), //模块描述
new OracleParameter(":CREATEUSERID", GetValue(flowModel.CREATEUSERID)), //创建人ID
new OracleParameter(":CREATEUSERNAME", GetValue(flowModel.CREATEUSERNAME)), //创建人名
new OracleParameter(":CREATECOMPANYID", GetValue(flowModel.CREATECOMPANYID)), //创建公司ID
new OracleParameter(":CREATEDEPARTMENTID", GetValue(flowModel.CREATEDEPARTMENTID)), //创建部门ID
new OracleParameter(":CREATEPOSTID", GetValue(flowModel.CREATEPOSTID)), //创建岗位ID
new OracleParameter(":CREATEDATE", GetValue(DateTime.Now)) //创建时间
};
int result = MicrosoftOracle.ExecuteNonQuery(conn, CommandType.Text, inssql.ToString(), pageparm);
MicrosoftOracle.Close(conn);
return(result > 0 ? "1" : "0");
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
/// <summary>
/// 模块定义
/// </summary>
/// <param name="con">OracleConnection</param>
/// <param name="ModelCode">模块代码</param>
/// <returns></returns>
public static List<FLOW_MODELDEFINE_T> GetModelDefineByCode(OracleConnection con,string ModelCode)
{
if (string.IsNullOrEmpty(con.ConnectionString))
{
con.ConnectionString = ADOHelper.ConnectionString;
}
List<FLOW_MODELDEFINE_T> list = new List<FLOW_MODELDEFINE_T>();
OracleDataReader dr = null;
try
{
#region
//OracleCommand cmd = con.CreateCommand();
//cmd.CommandText = "select * from FLOW_MODELDEFINE_T where MODELCODE='" + ModelCode + "'";
//dr = cmd.ExecuteReader();
string sql = "select * from FLOW_MODELDEFINE_T where MODELCODE='" + ModelCode + "'";
dr= MsOracle.ExecuteReaderByTransaction(con, sql, null);
while (dr.Read())
{
#region define
FLOW_MODELDEFINE_T define = new FLOW_MODELDEFINE_T();
define.CREATECOMPANYID = dr["CREATECOMPANYID"] == DBNull.Value ? null : dr["CREATECOMPANYID"].ToString();
define.CREATEDATE = (DateTime)dr["CREATEDATE"];
define.CREATEDEPARTMENTID = dr["CREATEDEPARTMENTID"] == DBNull.Value ? null : dr["CREATEDEPARTMENTID"].ToString();
define.CREATEPOSTID = dr["CREATEPOSTID"] == DBNull.Value ? null : dr["CREATEDEPARTMENTID"].ToString();
define.CREATEUSERID = dr["CREATEUSERID"] == DBNull.Value ? null : dr["CREATEUSERID"].ToString();
define.CREATEUSERNAME = dr["CREATEUSERNAME"] == DBNull.Value ? null : dr["CREATEUSERNAME"].ToString();
define.DESCRIPTION = dr["DESCRIPTION"] == DBNull.Value ? null : dr["DESCRIPTION"].ToString();
define.EDITDATE = dr["EDITDATE"] == DBNull.Value ? null : (DateTime?)dr["EDITDATE"];
define.EDITUSERID = dr["EDITUSERID"] == DBNull.Value ? null : dr["EDITUSERID"].ToString();
define.EDITUSERNAME = dr["EDITUSERNAME"] == DBNull.Value ? null : dr["EDITUSERNAME"].ToString();
define.MODELCODE = dr["MODELCODE"] == DBNull.Value ? null : dr["MODELCODE"].ToString();
define.MODELDEFINEID = dr["MODELDEFINEID"] == DBNull.Value ? null : dr["MODELDEFINEID"].ToString();
define.PARENTMODELCODE = dr["PARENTMODELCODE"] == DBNull.Value ? null : dr["PARENTMODELCODE"].ToString();
define.SYSTEMCODE = dr["SYSTEMCODE"] == DBNull.Value ? null : dr["SYSTEMCODE"].ToString();
list.Add(define);
#endregion
}
dr.Close();
#endregion
return list;
}
catch (Exception ex)
{
if (dr != null && !dr.IsClosed)
{
dr.Close();
}
if (con.State == ConnectionState.Open)
{
con.Close();
}
throw new Exception("GetModelDefineByCode-->" + ex.Message);
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
if (txtMSGCONTENT.Text.Trim() == "")
{
ComfirmWindow.ConfirmationBox("提示信息", "消息内容不能为空！", "确定");
return;
}
FLOW_MODELDEFINE_T system = cobSYSTEMCODE.SelectedItem as FLOW_MODELDEFINE_T;
FLOW_MODELDEFINE_T model = cobMODELCODE.SelectedItem as FLOW_MODELDEFINE_T;
if (system.SYSTEMCODE == "0" || model.MODELCODE == "0")
{
ComfirmWindow.ConfirmationBox("提示信息", "请正确选择 [系统]和[模块]！", "确定");
return;
}
PlatformService.T_WF_MESSAGEBODYDEFINE entity = new PlatformService.T_WF_MESSAGEBODYDEFINE();
entity.MESSAGEBODY = ParamOperate.MessageBodyExchange(ListTableColumn.ToList(), true, txtMSGCONTENT.Text);
entity.MESSAGEURL = txtURL.Text.Trim();
entity.SYSTEMCODE = (cobSYSTEMCODE.SelectedItem as FLOW_MODELDEFINE_T).SYSTEMCODE;
entity.MODELCODE = (cobMODELCODE.SelectedItem as FLOW_MODELDEFINE_T).MODELCODE;
entity.COMPANYID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
entity.RECEIVETYPE = this.rBRole.IsChecked == true ? 0 : 1;
if (entity.RECEIVETYPE == 0 && OrgObjPost != null && OrgObjPost.Count > 0)
{
foreach (var item in OrgObjPost)
{
entity.RECEIVEPOSTID += item.ObjectID + ",";
entity.RECEIVEPOSTNAME += item.ObjectName + ",";
}
entity.RECEIVEPOSTID = entity.RECEIVEPOSTID.TrimEnd(',');
entity.RECEIVEPOSTNAME = entity.RECEIVEPOSTNAME.TrimEnd(',');
}
else if (entity.RECEIVETYPE == 1 && OrgObj != null && OrgObj.Count > 0)
{
foreach (var item in OrgObj)
{
entity.RECEIVERUSERID += item.ObjectID + ",";
entity.RECEIVERUSERNAME += item.ObjectName + ",";
}
entity.RECEIVERUSERID = entity.RECEIVERUSERID.TrimEnd(',');
entity.RECEIVERUSERNAME = entity.RECEIVERUSERNAME.TrimEnd(',');
}
if (ActionType == "0")
{
entity.DEFINEID = Guid.NewGuid().ToString();
entity.CREATEDATE = DateTime.Now;
entity.CREATEUSERNAME = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeName;
entity.CREATEUSERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID;
entity.COMPANYID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
messageClient.AddDefaultMessgeAsync(entity);
}
else
{
entity.DEFINEID = DEFINEID;
messageClient.EditDefaultMessgeAsync(entity);
}
//this.DialogResult = true;
}
/// <summary>
/// 模块定义
/// </summary>
/// <param name="con">OracleConnection</param>
/// <param name="ModelCode">模块代码</param>
/// <returns></returns>
public static List <FLOW_MODELDEFINE_T> GetModelDefineByCode(OracleConnection con, string ModelCode)
{
if (string.IsNullOrEmpty(con.ConnectionString))
{
con.ConnectionString = ADOHelper.ConnectionString;
}
List <FLOW_MODELDEFINE_T> list = new List <FLOW_MODELDEFINE_T>();
OracleDataReader dr = null;
try
{
#region
//OracleCommand cmd = con.CreateCommand();
//cmd.CommandText = "select * from FLOW_MODELDEFINE_T where MODELCODE='" + ModelCode + "'";
//dr = cmd.ExecuteReader();
string sql = "select * from FLOW_MODELDEFINE_T where MODELCODE='" + ModelCode + "'";
dr = MsOracle.ExecuteReaderByTransaction(con, sql, null);
while (dr.Read())
{
#region define
FLOW_MODELDEFINE_T define = new FLOW_MODELDEFINE_T();
define.CREATECOMPANYID = dr["CREATECOMPANYID"] == DBNull.Value ? null : dr["CREATECOMPANYID"].ToString();
define.CREATEDATE = (DateTime)dr["CREATEDATE"];
define.CREATEDEPARTMENTID = dr["CREATEDEPARTMENTID"] == DBNull.Value ? null : dr["CREATEDEPARTMENTID"].ToString();
define.CREATEPOSTID = dr["CREATEPOSTID"] == DBNull.Value ? null : dr["CREATEDEPARTMENTID"].ToString();
define.CREATEUSERID = dr["CREATEUSERID"] == DBNull.Value ? null : dr["CREATEUSERID"].ToString();
define.CREATEUSERNAME = dr["CREATEUSERNAME"] == DBNull.Value ? null : dr["CREATEUSERNAME"].ToString();
define.DESCRIPTION = dr["DESCRIPTION"] == DBNull.Value ? null : dr["DESCRIPTION"].ToString();
define.EDITDATE = dr["EDITDATE"] == DBNull.Value ? null : (DateTime?)dr["EDITDATE"];
define.EDITUSERID = dr["EDITUSERID"] == DBNull.Value ? null : dr["EDITUSERID"].ToString();
define.EDITUSERNAME = dr["EDITUSERNAME"] == DBNull.Value ? null : dr["EDITUSERNAME"].ToString();
define.MODELCODE = dr["MODELCODE"] == DBNull.Value ? null : dr["MODELCODE"].ToString();
define.MODELDEFINEID = dr["MODELDEFINEID"] == DBNull.Value ? null : dr["MODELDEFINEID"].ToString();
define.PARENTMODELCODE = dr["PARENTMODELCODE"] == DBNull.Value ? null : dr["PARENTMODELCODE"].ToString();
define.SYSTEMCODE = dr["SYSTEMCODE"] == DBNull.Value ? null : dr["SYSTEMCODE"].ToString();
list.Add(define);
#endregion
}
dr.Close();
#endregion
return(list);
}
catch (Exception ex)
{
if (dr != null && !dr.IsClosed)
{
dr.Close();
}
if (con.State == ConnectionState.Open)
{
con.Close();
}
throw new Exception("GetModelDefineByCode-->" + ex.Message);
}
}
void GetModelNameInfosComboxCompleted(object sender, GetModelNameInfosComboxCompletedEventArgs e)//获取模块代码
{
if (e.Result != null)
{
ModelDefineList = e.Result.ToList();
MODELDEFINE = ModelDefineList.FirstOrDefault();
InitModelCode(sender, null);
}
}
private void cobMODELCODE_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
FLOW_MODELDEFINE_T system = cobSYSTEMCODE.SelectedItem as FLOW_MODELDEFINE_T;
FLOW_MODELDEFINE_T model = cobMODELCODE.SelectedItem as FLOW_MODELDEFINE_T;
string strMsgOpen = string.Empty;
if (system != null && model != null && system.SYSTEMCODE != "0" && model.MODELCODE != "0")
{
flowXmlClient.ListFuncTableColumnAsync(XmlUtils.GetSystemPath(system.SYSTEMCODE), model.MODELCODE, strMsgOpen);
}
}
/// <summary>
/// 修改模块代码
/// </summary>
/// <param name="FlowModel"></param>
/// <returns></returns>
public string UpdateModelDefine(FLOW_MODELDEFINE_T FlowModel)
{
try
{
return(FlowModelBll.UpdateModelDefine(FlowModel));
}
catch (Exception ex)
{
LogHelper.WriteLog("修改模块定义出错：" + ex.Message);
return("0");
}
}
void BindModelCode(T_SYS_DICTIONARY DICTIONARY)//绑定模块代码
{
cbModelCode.ItemsSource = null;
if (AgentSetInfo != null && DICTIONARY != null && ModelDefineList != null)
{
List <FLOW_MODELDEFINE_T> tmpModelDefine = ModelDefineList.Where(c => c.SYSTEMCODE == ((T_SYS_DICTIONARY)cbSYSTEMTYPE.SelectedItem).SYSTEMCODE).ToList();
FLOW_MODELDEFINE_T tmp = new FLOW_MODELDEFINE_T();
tmp.DESCRIPTION = Utility.GetResourceStr("PLEASESELECTL");
tmpModelDefine.Insert(0, tmp);
if (tmpModelDefine.Count > 0)
{
cbModelCode.ItemsSource = tmpModelDefine;
cbModelCode.DisplayMemberPath = "DESCRIPTION";
cbModelCode.SelectedIndex = 0;
}
}
}
/// <summary>
/// 修改模块代码
/// </summary>
/// <param name="FlowModel"></param>
/// <returns></returns>
public string UpdateModelDefine(FLOW_MODELDEFINE_T FlowModel)
{
try
{
if (dal.GetExistModelDefine(FlowModel.MODELCODE, FlowModel.DESCRIPTION, FlowModel.MODELDEFINEID))
{
return("10");
}
else
{
return(dal.UpdateModelDefine(FlowModel));
}
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public object Convert(object value, Type targetType, object parameter, CultureInfo culture)
{
if (value == null)
{
return(null);
}
List <FLOW_MODELDEFINE_T> dicts = Application.Current.Resources["FLOW_MODELDEFINE_T"] as List <FLOW_MODELDEFINE_T>;
if (dicts == null)
{
return(value);
}
var objs = from a in dicts
where a.MODELCODE.ToString() == value.ToString()
select a;
FLOW_MODELDEFINE_T dict = objs.Count() > 0 ? objs.FirstOrDefault() : null;
return(dict == null ? value : dict.DESCRIPTION);//模块描述
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
if (txtModelCode.Text.Trim() == "")
{
ComfirmWindow.ConfirmationBox("提示信息", "模块代码不能为空！", "确定");
return;
}
if (entity == null)
{
entity = new FLOW_MODELDEFINE_T();
entity.FlowCancelCompanyList = FlowCancelCompanyList;
entity.FreeFlowCompanyList = FreeFlowCompanyList;
entity.MODELDEFINEID = Guid.NewGuid().ToString();
entity.MODELCODE = this.txtModelCode.Text.Trim();
entity.SYSTEMCODE = (this.cbSystemCode.SelectedItem as AppSystem).Name;
entity.SYSTEMNAME = (this.cbSystemCode.SelectedItem as AppSystem).Description;
entity.DESCRIPTION = this.txtModelName.Text.Trim();
entity.CREATECOMPANYID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
entity.CREATEDEPARTMENTID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].DepartmentID;
entity.CREATEPOSTID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].PostID;
entity.CREATEUSERNAME = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeName;
entity.CREATEUSERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID;
client.AddModelDefineAsync(entity);
//pBar.Start();
}
else
{
entity.FlowCancelCompanyList = FlowCancelCompanyList;
entity.FreeFlowCompanyList = FreeFlowCompanyList;
entity.MODELCODE = this.txtModelCode.Text.Trim();
entity.SYSTEMCODE = (this.cbSystemCode.SelectedItem as AppSystem).Name;
entity.DESCRIPTION = this.txtModelName.Text.Trim();
entity.EDITUSERNAME = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeName;
entity.EDITUSERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID;
client.UpdateModelDefineAsync(entity);
// pBar.Start();
}
}
public ModelCodeEdit(FLOW_MODELDEFINE_T define, ObservableCollection<AppModel> modelCodeList, ObservableCollection<AppSystem> systemList)
{
InitializeComponent();
this.entity = define;
appModel = modelCodeList;
appSystem = systemList;
if (define == null)
{
this.cbSystemCode.ItemsSource = systemList;
this.cbSystemCode.SelectedIndex = 0;
//this.cbModelCode.ItemsSource = modelCodeList;
//this.cbModelCode.SelectedIndex = 0;
this.btnSelect1.Visibility = Visibility.Collapsed;
this.tbCancel.Visibility = Visibility.Collapsed;
this.dgCompany1.Visibility = Visibility.Collapsed;
this.dataPager1.Visibility = Visibility.Collapsed;
this.btnSelect2.Visibility = Visibility.Collapsed;
this.tbFree.Visibility = Visibility.Collapsed;
this.dgCompany2.Visibility = Visibility.Collapsed;
this.dataPager2.Visibility = Visibility.Collapsed;
}
else
{
this.cbSystemCode.ItemsSource = systemList;
//this.cbModelCode.ItemsSource = modelCodeList;
this.cbSystemCode.Selected<AppSystem>("Name", define.SYSTEMCODE);
this.cbModelCode.Selected<AppModel>("Name", define.MODELCODE);
GetAllOwnerCompanyId();
BindCompanyList1();
BindCompanyList2();
this.cbSystemCode.IsEnabled = false;
this.cbModelCode.IsEnabled = false;
pBar.Start();
}
InitWcfEvent();
}
public ModelCodeEdit(FLOW_MODELDEFINE_T define, ObservableCollection <AppModel> modelCodeList, ObservableCollection <AppSystem> systemList)
{
InitializeComponent();
this.entity = define;
appModel = modelCodeList;
appSystem = systemList;
if (define == null)
{
this.cbSystemCode.ItemsSource = systemList;
this.cbSystemCode.SelectedIndex = 0;
//this.cbModelCode.ItemsSource = modelCodeList;
//this.cbModelCode.SelectedIndex = 0;
this.btnSelect1.Visibility = Visibility.Collapsed;
this.tbCancel.Visibility = Visibility.Collapsed;
this.dgCompany1.Visibility = Visibility.Collapsed;
this.dataPager1.Visibility = Visibility.Collapsed;
this.btnSelect2.Visibility = Visibility.Collapsed;
this.tbFree.Visibility = Visibility.Collapsed;
this.dgCompany2.Visibility = Visibility.Collapsed;
this.dataPager2.Visibility = Visibility.Collapsed;
}
else
{
this.cbSystemCode.ItemsSource = systemList;
//this.cbModelCode.ItemsSource = modelCodeList;
this.cbSystemCode.Selected <AppSystem>("Name", define.SYSTEMCODE);
this.cbModelCode.Selected <AppModel>("Name", define.MODELCODE);
GetAllOwnerCompanyId();
BindCompanyList1();
BindCompanyList2();
this.cbSystemCode.IsEnabled = false;
this.cbModelCode.IsEnabled = false;
pBar.Start();
}
InitWcfEvent();
}
/// <summary>
/// 修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void ButtonUpdate_Click(object sender, RoutedEventArgs e)
{
if (appModel.Count > 1 && appSystem.Count > 1)
{
if (this.dgModelCode.SelectedItems.Count == 1)
{
FLOW_MODELDEFINE_T define = this.dgModelCode.SelectedItem as FLOW_MODELDEFINE_T;
ModelCodeEdit edit = new ModelCodeEdit(define, appModel, appSystem);
edit.SaveCompleted += (obj, ev) =>
{
ModelCodeListBind();
};
edit.Show();
}
else
{
ComfirmWindow.ConfirmationBox("提示", "选择一条需要修改的记录！", "确定");
}
}
else
{
ComfirmWindow.ConfirmationBox("提示", "数据加载有误！", "确定");
}
}
private void InitWcfEvent()
{
#region 基本信息
messageClient.GetDefaultMessgeListCompleted += (o, e) =>
{
if (e.Error == null)
{
if (e.Result != null)
{
if (e.Result.FirstOrDefault() != null)
{
txtMSGCONTENT.Text = e.Result.FirstOrDefault().MESSAGEBODY;
this.cobSYSTEMCODE.Selected <FLOW_MODELDEFINE_T>("SYSTEMCODE", e.Result.FirstOrDefault().SYSTEMCODE);
this.cobMODELCODE.Selected <FLOW_MODELDEFINE_T>("MODELCODE", e.Result.FirstOrDefault().MODELCODE);
if (e.Result.FirstOrDefault().RECEIVETYPE == 1)
{
this.rBUser.IsChecked = true;
this.txtReceiveUser.Text = e.Result.FirstOrDefault().RECEIVERUSERNAME == null ? "" : e.Result.FirstOrDefault().RECEIVERUSERNAME;
if (e.Result.FirstOrDefault().RECEIVERUSERNAME != null)
{
BindRoleUser(e.Result.FirstOrDefault(), true);
}
}
else
{
this.rBUser.IsChecked = false;
this.txtReceivePost.Text = e.Result.FirstOrDefault().RECEIVEPOSTNAME == null ? "" : e.Result.FirstOrDefault().RECEIVEPOSTNAME;
if (e.Result.FirstOrDefault().RECEIVEPOSTNAME != null)
{
BindRoleUser(e.Result.FirstOrDefault(), false);
}
}
//OrgObjPost = new SaaS.FrameworkUI.OrganizationControl.ExtOrgObj() { ObjectID = e.Result.FirstOrDefault().RECEIVEPOSTID, ObjectName = e.Result.FirstOrDefault().RECEIVEPOSTNAME };
//OrgObj = new SaaS.FrameworkUI.OrganizationControl.ExtOrgObj() { ObjectID = e.Result.FirstOrDefault().RECEIVERUSERID, ObjectName = e.Result.FirstOrDefault().RECEIVERUSERNAME };
#region
FLOW_MODELDEFINE_T system = cobSYSTEMCODE.SelectedItem as FLOW_MODELDEFINE_T;
FLOW_MODELDEFINE_T model = cobMODELCODE.SelectedItem as FLOW_MODELDEFINE_T;
string strMsgOpen = string.Empty;
flowXmlClient.ListFuncTableColumnAsync(XmlUtils.GetSystemPath(system.SYSTEMCODE), model.MODELCODE, strMsgOpen);
#endregion
}
}
}
};
#endregion
#region 消息连接
flowXmlClient.ListFuncTableColumnCompleted += (o, e) =>
{
if (e.Error == null)
{
if (e.Result != null)
{
ListTableColumn = e.Result.Values.FirstOrDefault();
ListTableColumn.Insert(0, new TableColumn()
{
Description = "请选择.......", FieldName = ""
});
this.cmbColumn.ItemsSource = ListTableColumn;
this.cmbColumn.SelectedIndex = 0;
txtURL.Text = e.MsgLinkUrl;
}
}
};
#endregion
#region 新增完成
messageClient.AddDefaultMessgeCompleted += (o, e) =>
{
if (e.Error == null)
{
if (e.Result != null)
{
if (e.Result == "1")
{
ComfirmWindow.ConfirmationBox("提示信息", "新增成功", "确定");
if (this.SaveCompleted != null)
{
this.SaveCompleted(this, null);
}
this.DialogResult = false;
this.ActionType = "1";
}
else if (e.Result == "2")
{
ComfirmWindow.ConfirmationBox("提示信息", "此模块已经存在默认消息", "确定");
}
else
{
ComfirmWindow.ConfirmationBox("提示信息", "新增失败", "确定");
}
}
}
};
#endregion
#region 修改完成
messageClient.EditDefaultMessgeCompleted += (o, e) =>
{
if (e.Error == null)
{
if (e.Result != null)
{
if (e.Result == "1")
{
ComfirmWindow.ConfirmationBox("提示信息", "修改成功", "确定");
if (this.SaveCompleted != null)
{
this.SaveCompleted(this, null);
}
this.DialogResult = false;
}
else if (e.Result == "2")
{
ComfirmWindow.ConfirmationBox("提示信息", "此模块已经存在默认消息", "确定");
}
else
{
ComfirmWindow.ConfirmationBox("提示信息", "修改失败", "确定");
}
}
}
};
#endregion
}
void BindModelCode(T_SYS_DICTIONARY DICTIONARY)//绑定模块代码
{
cbModelCode.ItemsSource = null;
if (AgentSetInfo != null && DICTIONARY != null && ModelDefineList != null)
{
List<FLOW_MODELDEFINE_T> tmpModelDefine = ModelDefineList.Where(c => c.SYSTEMCODE == ((T_SYS_DICTIONARY)cbSYSTEMTYPE.SelectedItem).SYSTEMCODE).ToList();
FLOW_MODELDEFINE_T tmp = new FLOW_MODELDEFINE_T();
tmp.DESCRIPTION = Utility.GetResourceStr("PLEASESELECTL");
tmpModelDefine.Insert(0, tmp);
if (tmpModelDefine.Count > 0)
{
cbModelCode.ItemsSource = tmpModelDefine;
cbModelCode.DisplayMemberPath = "DESCRIPTION";
cbModelCode.SelectedIndex = 0;
}
}
}
void GetModelNameInfosComboxCompleted(object sender, GetModelNameInfosComboxCompletedEventArgs e)//获取模块代码
{
if (e.Result != null)
{
ModelDefineList = e.Result.ToList();
MODELDEFINE = ModelDefineList.FirstOrDefault();
InitModelCode(sender, null);
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
if (txtTriggerName.Text.Trim() == "")
{
ComfirmWindow.ConfirmationBox("提示信息", "定时触发名称不能为空！", "确定");
return;
}
FLOW_MODELDEFINE_T system = cmbSystemCode.SelectedItem as FLOW_MODELDEFINE_T;
FLOW_MODELDEFINE_T model = cmbModelCode.SelectedItem as FLOW_MODELDEFINE_T;
if (system.SYSTEMCODE == "0" || model.MODELCODE == "0")
{
ComfirmWindow.ConfirmationBox("提示信息", "请正确选择 [系统名称]和[模块名称]！", "确定");
return;
}
if (myDate.Text == "")
{
ComfirmWindow.ConfirmationBox("提示信息", "开始时间不能为空！", "确定");
return;
}
if (ActionType == "0")
{
#region 新增
Entity = new PlatformService.T_WF_TIMINGTRIGGERACTIVITY();
Entity.TRIGGERID = Guid.NewGuid().ToString();
Entity.TRIGGERNAME = txtTriggerName.Text;
Entity.CREATEUSERNAME = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeName;
Entity.CREATEUSERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID;
Entity.COMPANYID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
Entity.SYSTEMCODE = (this.cmbSystemCode.SelectedItem as FLOW_MODELDEFINE_T).SYSTEMCODE;
Entity.SYSTEMNAME = (this.cmbSystemCode.SelectedItem as FLOW_MODELDEFINE_T).SYSTEMNAME;
Entity.MODELCODE = (this.cmbModelCode.SelectedItem as FLOW_MODELDEFINE_T).MODELCODE;
Entity.MODELNAME = (this.cmbModelCode.SelectedItem as FLOW_MODELDEFINE_T).DESCRIPTION;
Entity.TRIGGERROUND = CycleOperate.CycleExchangeTo((this.cmbCycle.SelectedItem as Cycle).CycleType);
Entity.CONTRACTTYPE = "Engine";
Entity.TRIGGERTYPE = rbUser.IsChecked == true ? "User" : "System";
Entity.TRIGGERTIME = DateTime.Parse(myDate.Text + " " + myTime.Value.Value.TimeOfDay.ToString());
Entity.TRIGGERACTIVITYTYPE = rbSMS.IsChecked == true ? 1 : 2;
Entity.MESSAGEURL = MsgOpen;
if (this.txtValue.Text.Trim() != "" && cmbFunc.SelectedIndex > 0)
{
AppFunc func = cmbFunc.SelectedItem as AppFunc;
Entity.FUNCTIONNAME = func.FuncName;
Entity.FUNCTIONPARAMTER = ParamOperate.CollectionToString(listpatrm);
Entity.WCFURL = func.Address;
Entity.WCFBINDINGCONTRACT = func.Binding;
Entity.PAMETERSPLITCHAR = func.SplitChar;
}
else
{
Entity.FUNCTIONNAME = string.Empty;
Entity.FUNCTIONPARAMTER = string.Empty;
Entity.WCFURL = string.Empty;
Entity.WCFBINDINGCONTRACT = string.Empty;
Entity.PAMETERSPLITCHAR = string.Empty;
}
triggerClient.AddTimingActivityAsync(Entity);
#endregion
}
else
{
#region 修改
Entity.TRIGGERNAME = txtTriggerName.Text;
Entity.COMPANYID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
Entity.SYSTEMCODE = (this.cmbSystemCode.SelectedItem as FLOW_MODELDEFINE_T).SYSTEMCODE;
Entity.SYSTEMNAME = (this.cmbSystemCode.SelectedItem as FLOW_MODELDEFINE_T).SYSTEMNAME;
Entity.MODELCODE = (this.cmbModelCode.SelectedItem as FLOW_MODELDEFINE_T).MODELCODE;
Entity.MODELNAME = (this.cmbModelCode.SelectedItem as FLOW_MODELDEFINE_T).DESCRIPTION;
Entity.TRIGGERROUND = CycleOperate.CycleExchangeTo((this.cmbCycle.SelectedItem as Cycle).CycleType);
Entity.CONTRACTTYPE = "Engine";
Entity.TRIGGERTYPE = rbUser.IsChecked == true ? "User" : "System";
Entity.TRIGGERTIME = DateTime.Parse(myDate.Text + " " + myTime.Value.Value.TimeOfDay.ToString());
Entity.TRIGGERACTIVITYTYPE = rbSMS.IsChecked == true ? 1 : 2;
Entity.MESSAGEURL = MsgOpen;
if (this.txtValue.Text.Trim() != "" && cmbFunc.SelectedIndex > 0)
{
AppFunc func = cmbFunc.SelectedItem as AppFunc;
Entity.FUNCTIONNAME = func.FuncName;
Entity.FUNCTIONPARAMTER = ParamOperate.CollectionToString(listpatrm);
Entity.WCFURL = func.Address;
Entity.WCFBINDINGCONTRACT = func.Binding;
Entity.PAMETERSPLITCHAR = func.SplitChar;
}
else
{
Entity.FUNCTIONNAME = string.Empty;
Entity.FUNCTIONPARAMTER = string.Empty;
Entity.WCFURL = string.Empty;
Entity.WCFBINDINGCONTRACT = string.Empty;
Entity.PAMETERSPLITCHAR = string.Empty;
}
#endregion
triggerClient.EditTimingActivityAsync(Entity);
}
}
/// <summary>
/// 修改模块代码
/// </summary>
/// <param name="flowModel">flowModel</param>
/// <returns>string</returns>
public string UpdateModelDefine(FLOW_MODELDEFINE_T flowModel)
{
try
{
OracleConnection conn = MicrosoftOracle.CreateOracleConnection(ConnectionString);
string updSql = "UPDATE FLOW_MODELDEFINE_T SET MODELDEFINEID=:MODELDEFINEID,SYSTEMCODE=:SYSTEMCODE,SYSTEMNAME=:SYSTEMNAME,PARENTMODELCODE=:PARENTMODELCODE,DESCRIPTION=:DESCRIPTION,EDITUSERID=:EDITUSERID,EDITUSERNAME=:EDITUSERNAME,EDITDATE=:EDITDATE WHERE MODELCODE=:MODELCODE";
OracleParameter[] pageparm =
{
new OracleParameter(":MODELDEFINEID", GetValue(flowModel.MODELDEFINEID)), //模块ID
new OracleParameter(":SYSTEMCODE", GetValue(flowModel.SYSTEMCODE)), //系统代码
new OracleParameter(":SYSTEMNAME", GetValue(flowModel.SYSTEMNAME)), //系统代码
new OracleParameter(":MODELCODE", GetValue(flowModel.MODELCODE)), //模块代码
new OracleParameter(":PARENTMODELCODE", GetValue(flowModel.PARENTMODELCODE)), //上级模块代码
new OracleParameter(":DESCRIPTION", GetValue(flowModel.DESCRIPTION)), //模块描述
new OracleParameter(":EDITUSERID", GetValue(flowModel.EDITUSERID)), //修改人ID
new OracleParameter(":EDITUSERNAME", GetValue(flowModel.EDITUSERNAME)), //修改人用户名
new OracleParameter(":EDITDATE", GetValue(DateTime.Now)) //修改时间
};
int result = MicrosoftOracle.ExecuteNonQuery(conn, CommandType.Text, updSql, pageparm);
if (result > 0)
{
#region 哪些公司在模块中可以允许自选流程
if (flowModel.FreeFlowCompanyList != null && flowModel.FreeFlowCompanyList.Count > 0)
{
foreach (var ent in flowModel.FreeFlowCompanyList)
{
StringBuilder sb = new StringBuilder();
sb.AppendLine("declare ");
sb.AppendLine(" i integer;");
sb.AppendLine(" MODELDEFINEFREEFLOWID varchar2(50) :='" + ent.MODELDEFINEFREEFLOWID + "';");
sb.AppendLine(" MODELCODE_temp varchar2(50) :='" + ent.MODELCODE + "';");
sb.AppendLine(" COMPANYNAME_temp varchar2(50) :='" + ent.COMPANYNAME + "';");
sb.AppendLine(" COMPANYID_temp varchar2(50) :='" + ent.COMPANYID + "';");
sb.AppendLine(" CREATEUSERID_temp varchar2(50) :='" + ent.CREATEUSERID + "';");
sb.AppendLine(" CREATEUSERNAME_temp varchar2(50) :='" + ent.CREATEUSERNAME + "';");
sb.AppendLine(" CREATECOMPANYID_temp varchar2(50) :='" + ent.CREATECOMPANYID + "';");
sb.AppendLine(" CREATEDEPARTMENTID_temp varchar2(50) :='" + ent.CREATEDEPARTMENTID + "';");
sb.AppendLine(" CREATEPOSTID_temp varchar2(50) :='" + ent.CREATEPOSTID + "';");
sb.AppendLine(" CREATEDATE_temp date :=to_date('" + DateTime.Now.ToString() + "', 'yyyy/mm/dd hh24:mi:ss');");
sb.AppendLine("begin");
sb.AppendLine(" select count(1) into i from FLOW_MODELDEFINE_FREEFLOW t where t.MODELCODE='" + ent.MODELCODE + "' and t.COMPANYID='" + ent.COMPANYID + "';");
sb.AppendLine(" if i<1 then");
sb.AppendLine(" execute immediate 'INSERT INTO FLOW_MODELDEFINE_FREEFLOW (MODELDEFINEFREEFLOWID,MODELCODE,COMPANYNAME,COMPANYID,CREATEUSERID,CREATEUSERNAME,CREATECOMPANYID,CREATEDEPARTMENTID,CREATEPOSTID,CREATEDATE) values (:MODELDEFINEFREEFLOWID,:MODELCODE,:COMPANYNAME,:COMPANYID,:CREATEUSERID,:CREATEUSERNAME,:CREATECOMPANYID,:CREATEDEPARTMENTID,:CREATEPOSTID,:CREATEDATE)'");
sb.AppendLine(" using MODELDEFINEFREEFLOWID,MODELCODE_temp,COMPANYNAME_temp,COMPANYID_temp,CREATEUSERID_temp,CREATEUSERNAME_temp,CREATECOMPANYID_temp,CREATEDEPARTMENTID_temp,CREATEPOSTID_temp,CREATEDATE_temp; ");
sb.AppendLine(" --commit; ");
sb.AppendLine(" end if;");
sb.AppendLine("end;");
int n = MicrosoftOracle.ExecuteNonQuery(conn, CommandType.Text, sb.ToString());
}
}
#endregion
#region 哪些公司在模块中可以允许提单人撒回流程
if (flowModel.FlowCancelCompanyList != null && flowModel.FlowCancelCompanyList.Count > 0)
{
foreach (var ent in flowModel.FlowCancelCompanyList)
{
StringBuilder sb = new StringBuilder();
sb.AppendLine("declare ");
sb.AppendLine(" i integer;");
sb.AppendLine(" MODELDEFINEFLOWCANCLEID_temp varchar2(50) :='" + ent.MODELDEFINEFLOWCANCLEID + "';");
sb.AppendLine(" MODELCODE_temp varchar2(50) :='" + ent.MODELCODE + "';");
sb.AppendLine(" COMPANYNAME_temp varchar2(50) :='" + ent.COMPANYNAME + "';");
sb.AppendLine(" COMPANYID_temp varchar2(50) :='" + ent.COMPANYID + "';");
sb.AppendLine(" CREATEUSERID_temp varchar2(50) :='" + ent.CREATEUSERID + "';");
sb.AppendLine(" CREATEUSERNAME_temp varchar2(50) :='" + ent.CREATEUSERNAME + "';");
sb.AppendLine(" CREATECOMPANYID_temp varchar2(50) :='" + ent.CREATECOMPANYID + "';");
sb.AppendLine(" CREATEDEPARTMENTID_temp varchar2(50) :='" + ent.CREATEDEPARTMENTID + "';");
sb.AppendLine(" CREATEPOSTID_temp varchar2(50) :='" + ent.CREATEPOSTID + "';");
sb.AppendLine(" CREATEDATE_temp date :=to_date('" + DateTime.Now.ToString() + "', 'yyyy/mm/dd hh24:mi:ss');");
sb.AppendLine("begin");
sb.AppendLine(" select count(1) into i from FLOW_MODELDEFINE_FLOWCANCLE t where t.MODELCODE='" + ent.MODELCODE + "' and t.COMPANYID='" + ent.COMPANYID + "';");
sb.AppendLine(" if i<1 then");
sb.AppendLine(" execute immediate 'INSERT INTO FLOW_MODELDEFINE_FLOWCANCLE (MODELDEFINEFLOWCANCLEID,MODELCODE,COMPANYNAME,COMPANYID,CREATEUSERID,CREATEUSERNAME,CREATECOMPANYID,CREATEDEPARTMENTID,CREATEPOSTID,CREATEDATE) values (:MODELDEFINEFLOWCANCLEID,:MODELCODE,:COMPANYNAME,:COMPANYID,:CREATEUSERID,:CREATEUSERNAME,:CREATECOMPANYID,:CREATEDEPARTMENTID,:CREATEPOSTID,:CREATEDATE)'");
sb.AppendLine(" using MODELDEFINEFLOWCANCLEID_temp,MODELCODE_temp,COMPANYNAME_temp,COMPANYID_temp,CREATEUSERID_temp,CREATEUSERNAME_temp,CREATECOMPANYID_temp,CREATEDEPARTMENTID_temp,CREATEPOSTID_temp,CREATEDATE_temp; ");
sb.AppendLine(" --commit; ");
sb.AppendLine(" end if;");
sb.AppendLine("end;");
int n = MicrosoftOracle.ExecuteNonQuery(conn, CommandType.Text, sb.ToString());
}
}
#endregion
}
MicrosoftOracle.Close(conn);
return(result > 0 ? "1" : "0");
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
if (txtModelCode.Text.Trim() == "")
{
ComfirmWindow.ConfirmationBox("提示信息", "模块代码不能为空！", "确定");
return;
}
if (entity == null)
{
entity = new FLOW_MODELDEFINE_T();
entity.FlowCancelCompanyList = FlowCancelCompanyList;
entity.FreeFlowCompanyList = FreeFlowCompanyList;
entity.MODELDEFINEID = Guid.NewGuid().ToString();
entity.MODELCODE = this.txtModelCode.Text.Trim();
entity.SYSTEMCODE = (this.cbSystemCode.SelectedItem as AppSystem).Name;
entity.SYSTEMNAME = (this.cbSystemCode.SelectedItem as AppSystem).Description;
entity.DESCRIPTION = this.txtModelName.Text.Trim();
entity.CREATECOMPANYID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
entity.CREATEDEPARTMENTID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].DepartmentID;
entity.CREATEPOSTID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].PostID;
entity.CREATEUSERNAME = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeName;
entity.CREATEUSERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID;
client.AddModelDefineAsync(entity);
//pBar.Start();
}
else
{
entity.FlowCancelCompanyList = FlowCancelCompanyList;
entity.FreeFlowCompanyList = FreeFlowCompanyList;
entity.MODELCODE = this.txtModelCode.Text.Trim();
entity.SYSTEMCODE = (this.cbSystemCode.SelectedItem as AppSystem).Name;
entity.DESCRIPTION = this.txtModelName.Text.Trim();
entity.EDITUSERNAME = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeName;
entity.EDITUSERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID;
client.UpdateModelDefineAsync(entity);
// pBar.Start();
}
}
