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);
}
