public Result DeleteAccessFile(string fileCoverID, string accessFileName, string account) { Result result = new Result(); try { Guid g = new Guid(fileCoverID); PCBEntities pCBEntities = new PCBEntities(); PCB_AccessFileTB pCB_AccessFileTB = pCBEntities.PCB_AccessFileTB.FirstOrDefault(p => p.CreateAccount == account && p.FileCoverID == g && p.AccessFileName == accessFileName); // pCBEntities.PCB_AccessFileTB.FirstOrDefault(p => p.FileCoverID == new Guid(fileCoverID) && p.CreateAccount == account && p.FileExtension == fileExtension); if (pCB_AccessFileTB == null || pCB_AccessFileTB == default(PCB_AccessFileTB)) { result.IsOK = false; result.Description = "找不到对应的附件"; return(result); } pCBEntities.DeleteObject(pCB_AccessFileTB); result.IsOK = Convert.ToBoolean(pCBEntities.SaveChanges()); if (!result.IsOK) { result.Description = "删除失败"; return(result); } string saveToUrl = @ParameterAPI.GetConfig("FileURL").ConfigValue + @"\\" + account + @"\\" + fileCoverID + @"\\" + accessFileName + "." + pCB_AccessFileTB.FileExtension; File.Delete(saveToUrl); } catch (Exception ex) { LogHelper.WriteLog(GetType()).Info(ex.StackTrace); result.IsOK = false; result.Description = ex.InnerException.Message; } return(result); }
/// <summary> /// 删除订单表记录 /// </summary> /// <param name="account"></param> /// <param name="tradeNO"></param> /// <param name="flag"></param> /// <returns></returns> public static Result DelectOrderTB(string account, string tradeNO) { Result result = new Result(); try { result.IsOK = true; result.StateCodeID = 0; PCBEntities pCBEntities = new PCBEntities(); PCB_OrderTB PCBOrderTB = pCBEntities.PCB_OrderTB.FirstOrDefault(p => p.CreateAccount == account && p.OrderNumber == tradeNO && p.IsPay == false); if (PCBOrderTB != null) { pCBEntities.DeleteObject(PCBOrderTB); pCBEntities.SaveChanges(); } else { result.IsOK = false; } } catch (Exception ex) { LogHelper.WriteLog(typeof(Common)).Info(ex.StackTrace); result.IsOK = false; result.Description = ex.Message; } return(result); }
public Result DeleteFileCover(string fileCoverID, string account) { Result result = new Result(); try { Guid g = new Guid(fileCoverID); PCBEntities pCBEntities = new PCBEntities(); PCB_FileCoverTB pCB_FileCoverTB = pCBEntities.PCB_FileCoverTB.FirstOrDefault(p => p.FileCoverID == g && p.CreateAccount == account); if (pCB_FileCoverTB == null || pCB_FileCoverTB == default(PCB_FileCoverTB)) { result.IsOK = false; result.Description = "找不到该文件信息"; return(result); } pCBEntities.DeleteObject(pCB_FileCoverTB); IQueryable <PCB_AccessFileTB> queryable = pCBEntities.PCB_AccessFileTB.Where(p => p.FileCoverID == g && p.CreateAccount == account); foreach (var item in queryable) { pCBEntities.DeleteObject(item); } result.IsOK = Convert.ToBoolean(pCBEntities.SaveChanges()); if (!result.IsOK) { result.Description = "删除失败"; return(result); } string saveToUrl = @ParameterAPI.GetConfig("FileURL").ConfigValue + @"\\" + account + @"\\" + fileCoverID; Directory.Delete(saveToUrl, true); } catch (Exception ex) { LogHelper.WriteLog(GetType()).Info(ex.StackTrace); result.IsOK = false; result.Description = ex.InnerException.Message; } return(result); }
/// <summary> /// 预下单记录 /// </summary> /// <returns></returns> public static Result RecordPreRenewal(string account, string fileCoverId, string tradeNO) { Result result = new Result(); try { PCBEntities pCBEntities = new PCBEntities(); Guid fid = new Guid(fileCoverId); var pcborderTBlist = from order in pCBEntities.PCB_OrderTB where order.CreateAccount == account && order.FileCoverID == fid select order; if (pcborderTBlist.Count() > 0) { pcborderTBlist.ToList()[0].UpdateDateTime = DateTime.Now; pcborderTBlist.ToList()[0].OrderNumber = tradeNO; for (int i = 1; i < pcborderTBlist.Count(); i++) { pCBEntities.DeleteObject(pcborderTBlist.ToList()[i]); } } else { PCB_OrderTB orderTB = new PCB_OrderTB(); orderTB.OrderID = System.Guid.NewGuid(); orderTB.CreateAccount = account; orderTB.CreateDateTime = DateTime.Now; orderTB.FileCoverID = fid; orderTB.IsPay = false; orderTB.OrderNumber = tradeNO; orderTB.OrderPrice = pCBEntities.PCB_FileCoverTB.FirstOrDefault(p => p.FileCoverID == fid).Price; orderTB.UpdateDateTime = DateTime.Now; pCBEntities.AddToPCB_OrderTB(orderTB); } result.IsOK = Convert.ToBoolean(pCBEntities.SaveChanges()); } catch (Exception ex) { LogHelper.WriteLog(typeof(Common)).Info(ex.StackTrace); result.IsOK = false; result.Description = ex.Message; } return(result); }
public Result NewShareCode(string qaFolderId, string account, string durationTime) { var result = new Result(); try { var shareCode = Common.Common.Encrypt(qaFolderId + "," + account + "," + DateTime.Now); var pcbEntities = new PCBEntities(); var pcbShareCodeTb = new PCB_ShareCodeTB(); pcbShareCodeTb.QAFolderID = new Guid(qaFolderId); pcbShareCodeTb.ShareCode = shareCode; pcbShareCodeTb.CreateAccount = account; pcbShareCodeTb.EffectDatetime = DateTime.Now.AddMinutes(int.Parse(durationTime)); pcbShareCodeTb.CreateDateTime = DateTime.Now; pcbEntities.AddToPCB_ShareCodeTB(pcbShareCodeTb); var list = pcbEntities.PCB_ShareCodeTB.Where(p => p.EffectDatetime < DateTime.Now); foreach (var item in list) { pcbEntities.DeleteObject(item); } result.IsOK = Convert.ToBoolean(pcbEntities.SaveChanges()); if (!result.IsOK) { result.Description = "生成失败"; return(result); } result.Description = "生成成功"; result.ExtData = shareCode; } catch (Exception ex) { LogHelper.WriteLog(GetType()).Info(ex.StackTrace); result.IsOK = false; result.Description = ex.Message; } return(result); }
public Result DelSysParams(string key) { Result result = new Result(); result.StateCodeID = 0; result.IsOK = false; try { PCBEntities pCBEntities = new PCBEntities(); //PCB_ConfigTB configSys = ParameterAPI.GetConfig(key); PCB_ConfigTB configSys = pCBEntities.PCB_ConfigTB.FirstOrDefault(p => p.ConfigCode == key); if (configSys == null) { result.IsOK = false; result.Description = "无对应项"; return(result); } else { //del pCBEntities.DeleteObject(configSys); result.IsOK = Convert.ToBoolean(pCBEntities.SaveChanges()); //result = Common.Common.UpdateConfigTB(key, value, remark); if (result.IsOK) { result.Description = "删除" + key + "成功"; } } return(result); } catch (Exception ex) { LogHelper.WriteLog(GetType()).Info(ex.StackTrace); result.IsOK = false; result.Description = ex.Message; } return(result); }
public Result CreateEngineer(string account, string accountName, string password, string phoneNo, string mailAddress, string weChatAccount) { // LogHelper.WriteLog(GetType()).Info("CreateEngineer"); Result result = new Result(); try { result.IsOK = true; if (string.IsNullOrEmpty(account)) { result.IsOK = false; result.Description = "注册账号不能为空"; return(result); } if (string.IsNullOrEmpty(accountName)) { result.IsOK = false; result.Description = "注册账号名称不能为空"; return(result); } if (string.IsNullOrEmpty(password)) { result.IsOK = false; result.Description = "注册账号密码不能为空"; return(result); } if (string.IsNullOrEmpty(mailAddress)) { result.IsOK = false; result.Description = "注册邮箱账号不能为空"; return(result); } if (string.IsNullOrEmpty(weChatAccount)) { result.IsOK = false; result.Description = "注册微信账号不能为空"; return(result); } PCBEntities pCBEntities = new PCBEntities(); PCB_EngineerInfo engineerInfo = pCBEntities.PCB_EngineerInfo.FirstOrDefault(p => p.Account == account || p.MailAddress == mailAddress); if (engineerInfo != null || engineerInfo != default(PCB_EngineerInfo)) { if (engineerInfo.StateCode) { if (engineerInfo.Account == account) { result.Description = "用户" + account + "已经存在"; } if (engineerInfo.MailAddress == mailAddress) { result.Description = "邮箱" + mailAddress + "已经存在"; } result.IsOK = false; return(result); } else { TimeSpan UseTime = DateTime.Now - engineerInfo.CreateDateTime; if (UseTime.TotalSeconds <= 60) { result.Description = "已经提交申请,请勿重复操作"; result.IsOK = false; return(result); } else //超过60s删除预注册信息 { pCBEntities.DeleteObject(engineerInfo); } } } engineerInfo = new PCB_EngineerInfo(); engineerInfo.EngineerID = System.Guid.NewGuid(); engineerInfo.Account = account; engineerInfo.Password = password; engineerInfo.AccountName = accountName; engineerInfo.MailAddress = mailAddress; engineerInfo.PhoneNo = phoneNo; engineerInfo.WeChatAccount = weChatAccount; engineerInfo.CreateDateTime = DateTime.Now; engineerInfo.StateCode = false; pCBEntities.AddToPCB_EngineerInfo(engineerInfo); result = Common.Common.SendMail(mailAddress, engineerInfo.CreateDateTime.ToString()); if (!result.IsOK) { return(result); } result.IsOK = Convert.ToBoolean(pCBEntities.SaveChanges()); if (!result.IsOK) { result.Description = "注册账号失败"; return(result); } } catch (Exception ex) { LogHelper.WriteLog(GetType()).Info(ex.StackTrace); result.IsOK = false; result.Description = ex.InnerException.Message; } return(result); }