void LoadMemberList()
{
DataEntityQuery <AccountGrouping> query = new DataEntityQuery <AccountGrouping>();
var v = from c in query
where c.RoleName == this.Role.Name
select c;
DataPortal <AccountGrouping> dp = new DataPortal <AccountGrouping>();
dp.BeginExecuteQuery(v).Completed +=
(s, e2) =>
{
QueryTask <AccountGrouping> task = s as QueryTask <AccountGrouping>;
if (task.Error != null)
{
MessageBox.Show("读取成员数据时出错：" + task.Error.Message, "错误", MessageBoxButton.OK);
return;
}
else
{
this.memberList = task.Entities;
this.dataMembers.ItemsSource = this.memberList;
}
};
}
void GetPermissionList()
{
DataEntityQuery <ACL> query = new DataEntityQuery <ACL>();
var v = from c in query
where c.PObject == this.Module.Guid
select c;
DataPortal <ACL> dp = new DataPortal <ACL>();
dp.BeginExecuteQuery(v).Completed +=
(s, e2) =>
{
QueryTask <ACL> task = s as QueryTask <ACL>;
if (task.Error != null)
{
MessageBox.Show("读取模块权限时出错：" + task.Error.Message, "错误", MessageBoxButton.OK);
return;
}
else
{
this.permissionList = task.Entities;
this.dataPermissions.ItemsSource = this.permissionList;
if (this.permissionList.Count > 0)
{
this.dataPermissions.SelectedItem = this.permissionList[0];
}
}
};
}
void LoadDataList()
{
DataEntityQuery <Role> query = new DataEntityQuery <Role>();
var v = from c in query
where c.Name.StartsWith(this.tbSeach.Text) || c.Description.StartsWith(this.tbSeach.Text)
select c;
EAS.Controls.Window.ShowLoading("请求数据...");
DataPortal <Role> dp = new DataPortal <Role>();
dp.BeginExecuteCountQuery(v).Completed +=
(s, e2) =>
{
QueryTask <Role> task = s as QueryTask <Role>;
if (task.Error != null)
{
EAS.Controls.Window.HideLoading();
MessageBox.Show("请求数据时发生错误：" + task.Error.Message, "错误", MessageBoxButton.OK);
return;
}
else
{
this.iCount = task.Count;
int mod = iCount % PageSize;
int pages = mod == 0 ? iCount / PageSize : (iCount / PageSize) + 1;
this.pager.PageCount = pages;
this.pager.ReBind(pages);
this.GetPageList(1);
}
};
}
void LoadInstanceList()
{
this.btnTrack.IsEnabled = this.btnExecute.IsEnabled = this.btnKill.IsEnabled = false;
DateTime startTime = this.dtpStart.SelectedDate.HasValue == true ? dtpStart.SelectedDate.Value.Date : DateTime.Now.Date;
DateTime endTime = this.dtpEnd.SelectedDate.HasValue == true ? this.dtpEnd.SelectedDate.Value.Date : DateTime.Now.Date;
string flowID = this.tbKey.Tag.ToString();
int isComplate = this.checkBox1.IsChecked.HasValue ? (this.checkBox1.IsChecked.Value ?1 : 0) :0;
DataEntityQuery <WFInstance> query = new DataEntityQuery <WFInstance>();
var v = from c in query
where c.CreateTime >= startTime && c.CreateTime <= endTime.AddDays(1)
select new WFInstance
{
ID = c.ID,
FlowID = c.FlowID,
FlowName = c.FlowName,
Handler = c.Handler,
Subject = c.Subject,
CreateTime = c.CreateTime,
ProcessTime = c.ProcessTime,
ComplateTime = c.ComplateTime,
Sender = c.Sender,
CurrentState = c.CurrentState,
IsComplate = c.IsComplate
};
if (flowID.Length > 0)
{
v = v.Where(p => p.FlowID == flowID);
}
if (isComplate > 0)
{
v = v.Where(p => p.IsComplate != 0);
}
else
{
v = v.Where(p => p.IsComplate == 0);
}
v = v.OrderByDescending(p => p.CreateTime);
this.vList = v as IQueryable <WFInstance>;
DataPortal <WFInstance> dataPortal = new DataPortal <WFInstance>();
dataPortal.BeginExecuteCountQuery(this.vList).Completed += (s, e)
=>
{
QueryTask <WFInstance> task = s as QueryTask <WFInstance>;
if (task.Error != null)
{
MessageBox.Show("请求数据时发生错误：" + task.Error.Message, "错误", MessageBoxButton.OK);
}
else
{
this.dataPager.RecordCount = task.Count;
}
};
}
void LoadDataList(Organization category)
{
DataEntityQuery <Account> query = new DataEntityQuery <Account>();
var v = from c in query
where c.OrganID == category.Guid
select c;
EAS.Controls.Window.ShowLoading("请求数据...");
DataPortal <Account> dp = new DataPortal <Account>();
dp.BeginExecuteCountQuery(v).Completed +=
(s, e2) =>
{
QueryTask <Account> task = s as QueryTask <Account>;
if (task.Error != null)
{
EAS.Controls.Window.HideLoading();
MessageBox.Show("请求数据时发生错误：" + task.Error.Message, "错误", MessageBoxButton.OK);
return;
}
else
{
this.iCount = task.Count;
int mod = iCount % PageSize;
int pages = mod == 0 ? iCount / PageSize : (iCount / PageSize) + 1;
this.pager.PageCount = pages;
this.pager.ReBind(pages);
this.GetPageList(1);
}
};
}
public IList <Store> GetDrugList(string keyWord)
{
//以下代码将以默认的数据访问访问。
DataEntityQuery <Store> query = DataEntityQuery <Store> .Create();
var p = (from item in query
where (keyWord == string.Empty || item.InputCode1.StartsWith(keyWord) || item.ChinseName.StartsWith(keyWord))
orderby item.ChinseName ascending
select item);
var x = p.ToList();
////以下代码将会以自宝定义访问
//IDataAccessor da = EAS.Objects.ContainerBuilder.BuilderDefault().GetComponentInstance("DataAccessor2") as IDataAccessor;
////以下代码将会以自宝定义访问
//IOrmAccessor oa = EAS.Objects.ContainerBuilder.BuilderDefault().GetComponentInstance("IOrmAccessor2") as IOrmAccessor;
//DataEntityQuery<Store> query2 = DataEntityQuery<Store>.Create();
//query2.OrmAccessor = oa;
//query2.DataAccessor = da;
//var p2 = (from item in query2
// where item.InputCode1.StartsWith(keyWord)
// orderby item.ChinseName ascending
// select item);
//x = p2.ToList();
return(x);
}
void LoadACategory()
{
DataEntityQuery <Organization> query = new DataEntityQuery <Organization>();
EAS.Controls.Window.ShowLoading("请求数据...");
DataPortal <Organization> dp = new DataPortal <Organization>();
dp.BeginExecuteQuery(query).Completed +=
(s, e2) =>
{
EAS.Controls.Window.HideLoading();
QueryTask <Organization> task = s as QueryTask <Organization>;
if (task.Error != null)
{
MessageBox.Show("请求数据时发生错误：" + task.Error.Message, "错误", MessageBoxButton.OK);
return;
}
else
{
this.categoryList = task.Entities;
this.InitializeTree();
}
};
}
void LoadGroupTree()
{
DataEntityQuery <NavigateGroup> query = new DataEntityQuery <NavigateGroup>();
var v = from c in query
select c;
EAS.Controls.Window.ShowLoading("请求数据...");
DataPortal <NavigateGroup> dp = new DataPortal <NavigateGroup>();
dp.BeginExecuteQuery(v).Completed +=
(s, e2) =>
{
EAS.Controls.Window.HideLoading();
QueryTask <NavigateGroup> task = s as QueryTask <NavigateGroup>;
if (task.Error != null)
{
MessageBox.Show("请求数据时发生错误：" + task.Error.Message, "错误", MessageBoxButton.OK);
return;
}
else
{
this.groupList = task.Entities;
this.InitializeNavigationTree();
}
};
}
void LoadPermissionList()
{
this.permissionList = new List <ACLEx>();
DataEntityQuery <ACL> query = new DataEntityQuery <ACL>();
var v = from c in query
where c.Privileger == this.Role.Name
select c;
DataPortal <ACL> dp = new DataPortal <ACL>();
dp.BeginExecuteQuery(v).Completed +=
(s, e2) =>
{
QueryTask <ACL> task = s as QueryTask <ACL>;
if (task.Error != null)
{
MessageBox.Show("读取权限数据时出错：" + task.Error.Message, "错误", MessageBoxButton.OK);
return;
}
else
{
ModuleConverter.LoadAllPermission(this.dataPermissions, task.Entities, this.permissionList);
}
};
}
public int findDocments(String parentID, String docName)
{
DataEntityQuery <DOC_FILE_DIR> query = DataEntityQuery <DOC_FILE_DIR> .Create();
var p = (from item in query where item.DFD_PATH_NAME == docName && item.DFD_PARENT_DIR_ID == parentID select item);
return(p.Count());
}
public int findSonDocments(String id)
{
DataEntityQuery <DOC_FILE_DIR> query = DataEntityQuery <DOC_FILE_DIR> .Create();
var p = (from item in query where item.DFD_PARENT_DIR_ID == id select item);
return(p.Count());
}
/// <summary>
/// 删除目录
/// </summary>
/// <param name="dir"></param>
/// <returns></returns>
/* public bool deleteDocumentDir(DOC_FILE_DIR dir)
* {
* try
* {
* dir.Delete();
* return true;
* }
* catch (Exception)
* {
* return false;
*
* }
* }*/
/// <summary>
/// 根据文件节点id查询相应记录
/// </summary>
/// <param name="dfd_id"></param>
/// <returns></returns>
public DOC_FILE_DIR findDoc(String dfd_id)
{
DataEntityQuery <DOC_FILE_DIR> query = DataEntityQuery <DOC_FILE_DIR> .Create();
var p = (from item in query where item.DFD_ID == dfd_id select item);
return(p.FirstOrDefault());
}
public IList <WF_APP_USER> GetWFAppStepUser(string wfappID, string wftStepID)
{
DataEntityQuery <WF_APP_USER> query = DataEntityQuery <WF_APP_USER> .Create();
IWFTemplatesStepService _wfService = ServiceContainer.GetService <WFTemplatesStepService>();
IList <WF_APP_USER> list = _wfService.GetWFAppStepUser(wfappID, wftStepID);
return(list);
}
public void GetDataList(string equipname)
{
DataEntityQuery <EquipTypeSlet> query = DataEntityQuery <EquipTypeSlet> .Create();
var v = (from item in query
where (equipname.Trim().Length == 0 || item.EquipName == equipname)
select item);
this.vList = v as IQueryable <EquipTypeSlet>;
}
/// <summary>
/// 获取树形目录结构
/// </summary>
/// <returns></returns>
public List <MYWOKSPACE> GetByParentId(string p_parentId)
{
DataEntityQuery <MYWOKSPACE> query = DataEntityQuery <MYWOKSPACE> .Create();
var p = (from item in query
where (item.PARENTID == p_parentId)
select item
);
return(p.ToList());
}
public ComboBoxValue GetComboBoxItemByComboID(string comboID)
{
DataEntityQuery <ComboBoxValue> query = DataEntityQuery <ComboBoxValue> .Create();
var p = (from item in query
where item.COMBID == comboID
select item
);
return(p.ToList()[0]);
}
//public int GetMaxID()
//{
// return new MaxCodeService().GetMaxCode(new PDM_DOCUMENT().DbTableName);
//}
public IList <PDM_DOCUMENT> GetDocumentListForList()
{
DataEntityQuery <PDM_DOCUMENT> query = DataEntityQuery <PDM_DOCUMENT> .Create();
var p = (from item in query
orderby item.CREATEDATE ascending
select item
);
return(p.ToList());
}
public IList <Provider> GetProviderList()
{
DataEntityQuery <Provider> query = DataEntityQuery <Provider> .Create();
var p = (from item in query
orderby item.Name ascending
select item
);
return(p.ToList());
}
public IList <PDM_PRODUCT_DOCUMENT> getProDocByProID(String proID)
{
DataEntityQuery <PDM_PRODUCT_DOCUMENT> query = DataEntityQuery <PDM_PRODUCT_DOCUMENT> .Create();
var p = (from item in query
where (item.PRODUCTID == proID)
select item
);
return(p.ToList());
}
public IList <PDM_PARTS_DOCUMENT> GetPartsDocByDocID(string docID)
{
DataEntityQuery <PDM_PARTS_DOCUMENT> query = DataEntityQuery <PDM_PARTS_DOCUMENT> .Create();
var p = (from item in query
where (item.DOCID == docID)
select item
);
return(p.ToList());
}
public IList <PDM_PRODUCT_STRUCT> getListByPartsID(String productID, String partsID)
{
DataEntityQuery <PDM_PRODUCT_STRUCT> query = DataEntityQuery <PDM_PRODUCT_STRUCT> .Create();
var p = (from item in query
where (item.PRODUCTID == productID) && (item.PARTSID == partsID)
select item
);
return(p.ToList());
}
public IList <WF_APP_USER> GetAllUserList(string wfaID)
{
DataEntityQuery <WF_APP_USER> query = DataEntityQuery <WF_APP_USER> .Create();
var p = (from item in query
where (item.WFA_ID == wfaID && item.DEL_FLAG == "N")
select item
);
return(p.ToList());
}
private void btnQuery_Click(object sender, EventArgs e)
{
DataEntityQuery <Leave> query = DataEntityQuery <Leave> .Create();
var v = from c in query
where c.Name.StartsWith(this.tbName.Text)
select c;
this.vList = v as IQueryable <Leave>;
this.dataPager.RecordCount = this.vList.Count();
}
public IList <WF_DETAIL> GetWfDetailList(string wfaID)
{
DataEntityQuery <WF_DETAIL> query = DataEntityQuery <WF_DETAIL> .Create();
var p = (from item in query
where (item.DEL_FLAG == "N" && item.WFA_ID == wfaID)
select item
);
return(p.ToList());
}
public IList <DrugType> GetDrugTypeList()
{
DataEntityQuery <DrugType> query = DataEntityQuery <DrugType> .Create();
var p = (from item in query
orderby item.Name ascending
select item
);
return(p.ToList());
}
public IList <Dict> GetDrugDictList(string keyWord)
{
DataEntityQuery <Dict> query = DataEntityQuery <Dict> .Create();
var p = (from item in query
where (keyWord == string.Empty || item.InputCode1.ToUpper().StartsWith(keyWord) || item.ChinseName.ToUpper().StartsWith(keyWord))
orderby item.ChinseName ascending
select item);
return(p.ToList());
}
void LoadDataList()
{
string login = this.tbLoginID.Text.Trim();
string ip = this.tbIp.Text.Trim();
DateTime T1 = this.dpStart.SelectedDate.HasValue ? this.dpStart.SelectedDate.Value.Date : DateTime.Now.Date;
DateTime T2 = this.dpEnd.SelectedDate.HasValue ? this.dpEnd.SelectedDate.Value.Date.AddDays(1) : DateTime.Now.Date.AddDays(1);
DataEntityQuery <Log> query = new DataEntityQuery <Log>();
var v = from c in query
where c.EventTime >= T1 && c.EventTime <= T2.AddDays(1)
select c;
if (login.Length > 0)
{
v = v.Where(p => p.LoginID.StartsWith(login));
}
if (ip.Length > 0)
{
v = v.Where(p => p.IpAddress == ip || p.HostName == ip);
}
v = v.OrderByDescending(p => p.ID);
this.vList = v as IQueryable <Log>;
System.Threading.WaitCallback callBack = (state) =>
{
try
{
this.iCount = v.Count();
}
catch (System.Exception exc)
{
Dispatcher.BeginInvoke(() =>
{
EAS.Controls.Window.HideLoading();
MessageBox.Show("请求数据时发生错误：" + exc.Message, "错误", MessageBoxButton.OK);
});
return;
}
Dispatcher.BeginInvoke(() =>
{
int mod = iCount % PageSize;
int pages = mod == 0 ? iCount / PageSize : (iCount / PageSize) + 1;
this.pager.PageCount = pages;
this.pager.ReBind(pages);
this.GetPageList(1);
});
};
System.Threading.ThreadPool.QueueUserWorkItem(callBack);
}
public IList <WF_APP_USER> GetWFAppStepUser(string wfappID, string wftStepID)
{
DataEntityQuery <WF_APP_USER> query = DataEntityQuery <WF_APP_USER> .Create();
var p = (from item in query
where (item.DEL_FLAG == "N" && item.WFA_ID == wfappID && item.WFT_STEP_ID == wftStepID)
select item
);
return(p.ToList());
}
public IList <PDM_PRODUCT_PRORECORD> GetProductList()
{
DataEntityQuery <PDM_PRODUCT_PRORECORD> query = DataEntityQuery <PDM_PRODUCT_PRORECORD> .Create();
var p = (from item in query
orderby item.PRORECORDID ascending
select item
);
return(p.ToList());
}
public IList <PDM_PRODUCT_STRUCT> getProStructListByID(String proStructID)
{
DataEntityQuery <PDM_PRODUCT_STRUCT> query = DataEntityQuery <PDM_PRODUCT_STRUCT> .Create();
var p = (from item in query
where (item.ID == proStructID)
select item
);
return(p.ToList());
}
