Example #1
0
 public object getChunaBianhao(string id)
 {
     using (var ent = new OAtoU8DATAEntities())
     {
         var tes = (from r in ent.RecordTable
                    where r.Pid.Contains(id)
                    select r).ToList();
         return(tes);
     }
 }
Example #2
0
 /// <summary>
 /// 获取用户信息,登录
 /// </summary>
 /// <param name="user"></param>
 /// <returns></returns>
 public userInfo getUserInfo(UserModel user)
 {
     using (var db = new OAtoU8DATAEntities())
     {
         try
         {
             return(db.userInfo.Where(o => o.name.Equals(user.userName) && o.password.Equals(user.password)).FirstOrDefault());
         }
         catch (Exception)
         {
             return(null);
         }
     }
 }
Example #3
0
 public userInfo updateUserInfo(UserModel user)
 {
     using (var db = new OAtoU8DATAEntities())
     {
         try
         {
             var oldUser = db.userInfo.Where(o => o.name.Equals(user.userName) && o.password.Equals(user.password)).FirstOrDefault();
             oldUser.password = user.newpassword;
             db.SaveChanges();
             return(oldUser);
         }
         catch (Exception)
         {
             return(null);
         }
     }
 }
Example #4
0
 /// <summary>
 /// 获取关联的预支单(用于预支单报销)
 /// </summary>
 /// <param name="model"></param>
 /// <returns></returns>
 public List <YuzhiAttachment> getSunByattachment(ResultListModel model)
 {
     using (var db = new v3xEntities())
     {
         using (var myent = new OAtoU8DATAEntities())
         {
             var col_id  = Convert.ToInt64(model.colId);
             var colBody = (from c in db.col_body
                            join a in db.v3x_affair on c.col_id equals a.object_id
                            join t in db.v3x_attachment on a.id equals t.genesis_id
                            where t.reference == col_id
                            select c).ToList();
             ResultListModel models = new ResultListModel();
             models.type = "上海悦目-预支单";//预支单才能冲账
             models.list = new List <Detail>();
             var yuzhiAttachmentList = new List <YuzhiAttachment>();
             foreach (var body in colBody)
             {
                 var yuzhiAttachment = new YuzhiAttachment();
                 yuzhiAttachment.Id         = body.content;
                 yuzhiAttachment.detailList = new List <Detail>();
                 yuzhiAttachment.col_id     = body.col_id;
                 models.Id    = body.content;//预支单才能冲账
                 models.colId = body.col_id.ToString();
                 var t = getDetail(models);
                 if (t != null)
                 {
                     //model.list.Concat(t.list);//Union去重
                     foreach (var de in t.list)
                     {
                         yuzhiAttachment.detailList.Add(de);
                     }
                 }
                 yuzhiAttachment.record = myent.RecordTable.Where(o => o.Pid.Contains(models.Id)).ToList();
                 yuzhiAttachmentList.Add(yuzhiAttachment);
             }
             return(yuzhiAttachmentList);
         }
     }
 }