/// <summary> /// 删除常用旅客 /// </summary> /// <param name="id">常用旅客id</param> /// <returns></returns> internal static ReplayBase SysDelTraveller(string id) { using (SysTemDataBaseDataContext context = new SysTemDataBaseDataContext(SqlConnection)) { Us_RsTraveller trave = context.Us_RsTraveller.Single(p => p.Us_RsTravellerId == id); context.Us_RsTraveller.DeleteOnSubmit(trave); context.SubmitChanges(); return(new ReplayBase() { ReturnMessage = id }); } }
/// <summary> /// 新增/编辑 常用旅客,[isDefault:默认:true,非默认:false] /// </summary> /// <param name="travellerInfo"></param> /// <returns></returns> internal static ReplayBase RsSaveTraveller(Traveller travellerInfo) { using (SysTemDataBaseDataContext context = new SysTemDataBaseDataContext(SqlConnection)) { string NewTravellerId = Guid.NewGuid().ToString(); if (string.IsNullOrEmpty(travellerInfo.ravellerId)) { //新增 Us_RsTraveller dbtraveller = new Us_RsTraveller() { modifiedOn = DateTime.Now, fullName = travellerInfo.fullName, idType = (byte)travellerInfo.idType.GetHashCode(), idCard = travellerInfo.idCard, isDefault = travellerInfo.isDefault, fkId = travellerInfo.fkId, Us_RsTravellerId = NewTravellerId }; context.Us_RsTraveller.InsertOnSubmit(dbtraveller); } else { //编辑 NewTravellerId = travellerInfo.ravellerId; Us_RsTraveller dbtraveller = context.Us_RsTraveller.Single(p => p.Us_RsTravellerId == travellerInfo.ravellerId); dbtraveller.modifiedOn = DateTime.Now; dbtraveller.fullName = travellerInfo.fullName; dbtraveller.idType = (byte)travellerInfo.idType.GetHashCode(); dbtraveller.idCard = travellerInfo.idCard; dbtraveller.isDefault = travellerInfo.isDefault; dbtraveller.fkId = travellerInfo.fkId; } context.SubmitChanges(); return(new ReplayBase() { ReturnMessage = NewTravellerId }); } }