public static void AddUser(string prjGuid, List <string> userCodes) { Guid guid = new Guid(prjGuid); using (pm2Entities entities = new pm2Entities()) { new PTPrjInfoZTBUserService().Delete(prjGuid); if (userCodes != null) { using (List <string> .Enumerator enumerator = userCodes.GetEnumerator()) { string code; while (enumerator.MoveNext()) { code = enumerator.Current; if ((from m in entities.PT_yhmc where m.v_yhdm == code select m).FirstOrDefault <PT_yhmc>() != null) { PT_PrjInfo_ZTB_User user = new PT_PrjInfo_ZTB_User { Id = Guid.NewGuid().ToString(), PrjGuid = new Guid?(guid), UserCode = code }; entities.AddToPT_PrjInfo_ZTB_User(user); } } } } entities.SaveChanges(); } }
public static void AddLimit(Guid guid) { using (pm2Entities entities = new pm2Entities()) { List <string> codes = GetCodes(guid.ToString()); if (codes.Count > 0) { foreach (string str in TenderUser.GetUserCodes(guid)) { if (codes.Contains(str)) { codes.Remove(str); } } foreach (string str2 in codes) { PT_PrjInfo_ZTB_User user = new PT_PrjInfo_ZTB_User { Id = Guid.NewGuid().ToString(), PrjGuid = new Guid?(guid), UserCode = str2 }; entities.AddToPT_PrjInfo_ZTB_User(user); } entities.SaveChanges(); } } }
public static void AddUser(string prjGuid, System.Collections.Generic.List <string> userCodes) { System.Guid guid = new System.Guid(prjGuid); using (pm2Entities context = new pm2Entities()) { PTPrjInfoZTBUserService prjUserSer = new PTPrjInfoZTBUserService(); prjUserSer.Delete(prjGuid); if (userCodes != null) { foreach (string code in userCodes) { PT_yhmc yh = ( from m in context.PT_yhmc where m.v_yhdm == code select m).FirstOrDefault <PT_yhmc>(); if (yh != null) { PT_PrjInfo_ZTB_User user = new PT_PrjInfo_ZTB_User { Id = System.Guid.NewGuid().ToString(), PrjGuid = guid, UserCode = code }; context.AddToPT_PrjInfo_ZTB_User(user); } } } context.SaveChanges(); } }
public static void Add(string prjGuid, string userCode) { using (pm2Entities entities = new pm2Entities()) { PT_PrjInfo_ZTB_User user = new PT_PrjInfo_ZTB_User { Id = Guid.NewGuid().ToString(), PrjGuid = new Guid(prjGuid), UserCode = userCode }; entities.AddToPT_PrjInfo_ZTB_User(user); entities.SaveChanges(); } }
public static void Del(Guid prjGuid, string userCode) { using (pm2Entities entities = new pm2Entities()) { PT_PrjInfo_ZTB_User entity = (from m in entities.PT_PrjInfo_ZTB_User where (m.PrjGuid == prjGuid) && (m.UserCode == userCode) select m).FirstOrDefault <PT_PrjInfo_ZTB_User>(); if (entity != null) { entities.DeleteObject(entity); entities.SaveChanges(); } } }
public static void Del(System.Guid prjGuid, string userCode) { using (pm2Entities context = new pm2Entities()) { PT_PrjInfo_ZTB_User pt_user = ( from m in context.PT_PrjInfo_ZTB_User where m.PrjGuid == (System.Guid?)prjGuid && m.UserCode == userCode select m).FirstOrDefault <PT_PrjInfo_ZTB_User>(); if (pt_user != null) { context.DeleteObject(pt_user); context.SaveChanges(); } } }
public static void Add(string prjGuid, string userCode) { Guid guid = new Guid(prjGuid); using (pm2Entities context = new pm2Entities()) { PT_PrjInfo_ZTB_User user = new PT_PrjInfo_ZTB_User { Id = System.Guid.NewGuid().ToString(), PrjGuid = guid, UserCode = userCode }; context.AddToPT_PrjInfo_ZTB_User(user); context.SaveChanges(); } }