/// <summary>根据ID查询数据
/// </summary>
/// <param name="userId" 当前员工ID></param>
/// <returns></returns>
public IQueryable <T_FB_BORROWAPPLYMASTER> GetMasterData(string userId)
{
using (TM_SaaS_OA_EFModelContext ex = new TM_SaaS_OA_EFModel.TM_SaaS_OA_EFModelContext())
{
var q = from i in ex.T_FB_BORROWAPPLYMASTER
where i.OWNERID == userId
select i;
//{
// BORROWAPPLYMASTERCODE=i.BORROWAPPLYMASTERCODE,
// CHECKSTATES=i.CHECKSTATES,
// OWNERNAME=i.OWNERNAME,
// OWNERDEPARTMENTNAME=i.OWNERDEPARTMENTNAME,
// OWNERCOMPANYNAME=i.OWNERCOMPANYNAME,
// CREATEUSERNAME=i.CREATEUSERNAME,
// CREATEDATE=i.CREATEDATE,
// UPDATEDATE=i.UPDATEDATE
//};
if (q != null && q.Count() > 0)
{
//return q.ToList();
return(null);
}
else
{
return(null);
}
}
}
public static void Main()
{
using (TM_SaaS_OA_EFModelContext context = new TM_SaaS_OA_EFModelContext())
{
var q = from ent in context.T_SYS_FILELIST
select ent;
if (q.Count() > 0)
{
}
T_SYS_FILELIST file = new T_SYS_FILELIST();
file.SMTFILELISTID = Guid.NewGuid().ToString();
file.FILENAME = "test";
context.AddToT_SYS_FILELIST(file);
context.SaveChanges();
}
}
public bool DelMasterData(List <string> masterList)
{
bool IsReturn = true;
if (masterList != null && masterList.Count() > 0)
{
using (TM_SaaS_OA_EFModelContext ex = new TM_SaaS_OA_EFModel.TM_SaaS_OA_EFModelContext())
{
foreach (var x in masterList)
{
T_FB_BORROWAPPLYMASTER user =
ex.T_FB_BORROWAPPLYMASTER.First <T_FB_BORROWAPPLYMASTER>(u => u.BORROWAPPLYMASTERCODE == x);
ex.DeleteObject(user);
ex.SaveChanges();
}
}
return(true);
}
else
{
return(false);
}
}
