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);
}
public Result GetQaFileByShareCoed(string shareCode)
{
var result = new Result();
try
{
var account = Common.Common.Decrypt(shareCode).Split(',')[1];
var qaFolderId = new Guid(Common.Common.Decrypt(shareCode).Split(',')[0]);
var pcbEntities = new PCBEntities();
var pcbShareCodeTb = pcbEntities.PCB_ShareCodeTB.FirstOrDefault(p => p.ShareCode == shareCode &&
p.CreateAccount == account && p.QAFolderID == qaFolderId && p.EffectDatetime >= DateTime.Now);
if (pcbShareCodeTb == null || pcbShareCodeTb == default(PCB_ShareCodeTB))
{
result.IsOK = false;
result.Description = "该分享码失效或者不存在";
return(result);
}
result = GetOwnQaFile(qaFolderId.ToString(), account);
}
catch (Exception ex)
{
LogHelper.WriteLog(GetType()).Info(ex.StackTrace);
result.IsOK = false;
result.Description = ex.Message;
}
return(result);
}
public Result GetEngineerInfoByAccount(string account)
{
Result result = new Result();
try
{
PCBEntities pCBEntities = new PCBEntities();
if (string.IsNullOrEmpty(account))
{
result.IsOK = false;
result.Description = "账号不能为空";
return(result);
}
var info = pCBEntities.PCB_EngineerInfo.Where(p => p.Account == account || p.MailAddress == account).Select(p => new { p.Account, p.AccountName, p.CreateDateTime, p.PhoneNo, p.MailAddress, p.WeChatAccount });
result.IsOK = true;
result.ExtData = JsonConvert.SerializeObject(info);
}
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);
}
/// <summary>
/// 更新订单表记录
/// </summary>
/// <param name="account"></param>
/// <param name="tradeNO"></param>
/// <param name="flag"></param>
/// <returns></returns>
public static Result UpdateOrderTB(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);
if (PCBOrderTB != null)
{
PCBOrderTB.IsPay = true;
PCBOrderTB.UpdateDateTime = DateTime.Now;
pCBEntities.Refresh(System.Data.Objects.RefreshMode.ClientWins, PCBOrderTB);
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 FileIsPublish(string fileCoverID, string account, string setPrice, int publishStatus)
{
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);
}
pCB_FileCoverTB.Price = setPrice;
pCB_FileCoverTB.IsPublish = Convert.ToBoolean(publishStatus);
pCB_FileCoverTB.UpdateDateTime = DateTime.Now;
pCBEntities.Refresh(System.Data.Objects.RefreshMode.ClientWins, pCB_FileCoverTB);
result.IsOK = Convert.ToBoolean(pCBEntities.SaveChanges());
if (!result.IsOK)
{
result.Description = "发布失败";
return(result);
}
result.Description = "发布成功";
}
catch (Exception ex)
{
LogHelper.WriteLog(GetType()).Info(ex.StackTrace);
result.IsOK = false;
result.Description = ex.InnerException.Message;
}
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
string context = "hand?" + Common.Common.Decrypt(HttpContext.Current.Request.Url.Query.TrimStart('?'));
HttpContext.Current.RewritePath(context);
string mailAddress = HttpContext.Current.Request.QueryString.Get("mailAddress");
string dateTime = HttpContext.Current.Request.QueryString.Get("dateTime");
TimeSpan UseTime = DateTime.Now - Convert.ToDateTime(dateTime);
if (UseTime.Seconds >= 60)
{
Response.Redirect(ParameterAPI.GetConfig("RegisterFURL").ConfigValue + "?mailaddr=" + mailAddress, false);
}
else
{
PCBEntities pCBEntities = new PCBEntities();
PCB_EngineerInfo engineerInfo = pCBEntities.PCB_EngineerInfo.FirstOrDefault(p => p.MailAddress == mailAddress);
if (engineerInfo != null && engineerInfo != default(PCB_EngineerInfo))
{
engineerInfo.UpdateDateTime = DateTime.Now;
engineerInfo.StateCode = true;
pCBEntities.Refresh(System.Data.Objects.RefreshMode.ClientWins, engineerInfo);
bool isok = Convert.ToBoolean(pCBEntities.SaveChanges());
if (isok)
{
Response.Redirect(ParameterAPI.GetConfig("RegisterSURL").ConfigValue + "?mailaddr=" + mailAddress + "&isconfirm=true", false);
}
else
{
Response.Redirect(ParameterAPI.GetConfig("RegisterFURL").ConfigValue + "?mailaddr=" + mailAddress, false);
}
}
}
}
public Result UploadQaFile(byte[] qaFile, string qaFolderName, string account, string fileExtension, string qaFileName)
{
var result = new Result();
var saveToUrl = @ParameterAPI.GetConfig("ShareQAFile").ConfigValue + @"\\" + account + @"\\" + qaFolderName + @"\\" + qaFileName + "." + fileExtension;
try
{
var pcbEntities = new PCBEntities();
var pcbQaFolderTb = pcbEntities.PCB_QAFolderTB.FirstOrDefault(p => p.QAFolderName == qaFolderName && p.CreateAccount == account);
if (pcbQaFolderTb == null || pcbQaFolderTb == default(PCB_QAFolderTB))
{
result.IsOK = false;
result.Description = "找不到该目录";
return(result);
}
var count = pcbEntities.PCB_QAFileTB.Count <PCB_QAFileTB>(p => p.QAFolderID == pcbQaFolderTb.QAFolderID && p.CreateAccount == account && p.QAFileName == qaFileName && p.FileExtension == fileExtension);
if (count > 0)
{
result.IsOK = false;
result.Description = "该目录已经存在改文件";
return(result);
}
result = Common.Common.FileWrite(saveToUrl, qaFile);
if (!result.IsOK)
{
return(result);
}
var pcbQaFileTb = new PCB_QAFileTB();
pcbQaFileTb.QAFileID = Guid.NewGuid();
pcbQaFileTb.QAFolderID = pcbQaFolderTb.QAFolderID;
pcbQaFileTb.QAFileName = qaFileName;
pcbQaFileTb.QAFileURL = ParameterAPI.GetConfig("DowLoadShareFileURL").ConfigValue + "//" + account + "//" + qaFolderName + "//" + qaFileName + "." + fileExtension;
pcbQaFileTb.FileExtension = fileExtension;
pcbQaFileTb.CreateAccount = account;
pcbQaFileTb.FileMD5 = Common.Common.GetMD5Hash(qaFile);
pcbQaFileTb.FileSize = qaFile.Length.ToString();
pcbQaFileTb.CreateDateTime = DateTime.Now;
pcbEntities.AddToPCB_QAFileTB(pcbQaFileTb);
result.IsOK = Convert.ToBoolean(pcbEntities.SaveChanges());
if (!result.IsOK)
{
File.Delete(saveToUrl);
result.Description = "上传失败";
return(result);
}
}
catch (Exception ex)
{
LogHelper.WriteLog(GetType()).Info(ex.StackTrace);
result.IsOK = false;
result.Description = ex.Message;
}
return(result);
}
public Result EditFileCover(string fileCoverID, string fileExtension, string fileCoverName, string account, Byte[] newFileData)
{
string saveToUrl = "";
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);
}
String dir = @ParameterAPI.GetConfig("FileURL").ConfigValue + @"\\" + account + @"\\" + fileCoverID;
string oldUrl = dir + @"\\" + pCB_FileCoverTB.FileCoverName + "." + pCB_FileCoverTB.FileExtension;
if (string.IsNullOrEmpty(fileCoverName))
{
pCB_FileCoverTB.FileCoverName = fileCoverName;
}
if (newFileData.Length > 0)
{
pCB_FileCoverTB.FileSize = newFileData.Length.ToString();
pCB_FileCoverTB.FileMD5 = Common.Common.GetMD5Hash(newFileData);
pCB_FileCoverTB.FileCoverURL = ParameterAPI.GetConfig("DowLoadFileURL").ConfigValue + "//" + account + "//" + g + "//" + fileCoverName + "." + fileExtension;
saveToUrl = dir + @"\\" + fileCoverName + "." + fileExtension;
result = Common.Common.FileWrite(saveToUrl, newFileData);
if (!result.IsOK)
{
return(result);
}
pCB_FileCoverTB.UpdateDateTime = DateTime.Now;
pCBEntities.Refresh(System.Data.Objects.RefreshMode.ClientWins, pCB_FileCoverTB);
result.IsOK = Convert.ToBoolean(pCBEntities.SaveChanges());
if (!result.IsOK)
{
File.Delete(saveToUrl);
result.Description = "编辑失败";
return(result);
}
File.Delete(oldUrl);
result.Description = "编辑成功";
}
}
catch (Exception ex)
{
File.Delete(saveToUrl);
LogHelper.WriteLog(GetType()).Info(ex.StackTrace);
result.IsOK = false;
result.Description = ex.InnerException.Message;
}
return(result);
}
public Result UploadFileCover(Byte[] fileData, string account, string fileExtension, string fileCoverName)
{
Result result = new Result();
try
{
//byte[] coverPhoto = Convert.FromBase64String(fileData);
//MemoryStream ms = new MemoryStream(coverPhoto);
//Bitmap bmp = new Bitmap(ms);
PCB_FileCoverTB pCB_FileCoverTB = new PCB_FileCoverTB();
pCB_FileCoverTB.FileCoverID = System.Guid.NewGuid();
pCB_FileCoverTB.FileCoverName = fileCoverName;
pCB_FileCoverTB.FileMD5 = Common.Common.GetMD5Hash(fileData);
pCB_FileCoverTB.FileExtension = fileExtension;
pCB_FileCoverTB.FileSize = fileData.Length.ToString();
pCB_FileCoverTB.IsPublish = false;
pCB_FileCoverTB.FileCoverURL = ParameterAPI.GetConfig("DowLoadFileURL").ConfigValue + "//" + account + "//" + pCB_FileCoverTB.FileCoverID.ToString() + "//" + pCB_FileCoverTB.FileCoverName + "." + fileExtension;
pCB_FileCoverTB.CreateAccount = account;
pCB_FileCoverTB.CreateDateTime = DateTime.Now;
String dir = @ParameterAPI.GetConfig("FileURL").ConfigValue + @"\\" + account + @"\\" + pCB_FileCoverTB.FileCoverID.ToString();
if (!Directory.Exists(dir))
{
Directory.CreateDirectory(dir);
}
string saveToUrl = dir + @"\\" + pCB_FileCoverTB.FileCoverName + "." + fileExtension;
result = Common.Common.FileWrite(saveToUrl, fileData);
if (!result.IsOK)
{
return(result);
}
//bmp.Save(saveDir);
//bmp.Dispose();
//ms.Close();
PCBEntities pCBEntities = new PCBEntities();
pCBEntities.AddToPCB_FileCoverTB(pCB_FileCoverTB);
result.IsOK = Convert.ToBoolean(pCBEntities.SaveChanges());
if (!result.IsOK)
{
Directory.Delete(dir, true);
result.Description = "上传失败";
return(result);
}
}
catch (Exception ex)
{
LogHelper.WriteLog(GetType()).Info(ex.StackTrace);
result.IsOK = false;
result.Description = ex.InnerException.Message;
}
return(result);
}
public Result GetSysParams(string strSysParamsKey)
{
Result result = new Result();
result.StateCodeID = 0;
result.IsOK = false;
try
{
PCBEntities pcbEntities = new PCBEntities();
//collcetDictionary<string, string, string> configTB = new collcetDictionary<string, string, string>();
var configTBList = from cTB in pcbEntities.PCB_ConfigTB
select new { key = cTB.ConfigCode, value = cTB.ConfigValue, remark = cTB.Remark };
if (string.IsNullOrEmpty(strSysParamsKey))
{
//configTB.Clear();
//foreach (PCB_ConfigTB c in pcbEntities.PCB_ConfigTB)
//{
// configTB.Add(c.ConfigCode, c.ConfigValue, c.Remark);
//}
result.ExtData = JsonConvert.SerializeObject(configTBList);
result.IsOK = true;
result.StateCodeID = 1;
result.Description = "查询成功";
}
else
{
PCB_ConfigTB configSysTB = pcbEntities.PCB_ConfigTB.FirstOrDefault(p => p.ConfigCode == strSysParamsKey);
if (configSysTB == null)
{
result.IsOK = false;
result.Description = "无对应项";
return(result);
}
//configTB.Clear();
//configTB.Add(configSysTB.ConfigCode, configSysTB.ConfigValue, configSysTB.Remark);
result.ExtData = JsonConvert.SerializeObject(configTBList);
result.IsOK = true;
result.StateCodeID = 1;
result.Description = "查询成功";
}
}
catch (Exception ex)
{
LogHelper.WriteLog(GetType()).Info(ex.StackTrace);
result.IsOK = false;
result.Description = ex.Message;
}
return(result);
}
public Result UpdateSysParams(string key, string value, string remark)
{
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)
{
////增加
//PCB_ConfigTB confignew = new PCB_ConfigTB();
//confignew.ConfigID = new Guid();
//confignew.ConfigCode = key;
//confignew.ConfigValue = value;
//confignew.Remark = remark;
//pCBEntities.AddToPCB_ConfigTB(confignew);
//result.IsOK = Convert.ToBoolean(pCBEntities.SaveChanges());
//if (result.IsOK)
// result.Description = "增加" + key + "成功";
result.IsOK = false;
result.StateCodeID = 1;
result.Description = "没有找到需要更新对应项";
return(result);
}
else
{
//更新
configSys.ConfigValue = value;
configSys.Remark = remark;
pCBEntities.Refresh(System.Data.Objects.RefreshMode.ClientWins, configSys);
result.IsOK = Convert.ToBoolean(pCBEntities.SaveChanges());
//result = Common.Common.UpdateConfigTB(key, value, remark);
if (result.IsOK)
{
result.Description = "更新" + key + "成功";
}
}
}
catch (Exception ex)
{
LogHelper.WriteLog(GetType()).Info(ex.StackTrace);
result.IsOK = false;
result.Description = ex.Message;
}
return(result);
}
public Result NewQaFolder(string qaFolderName, string account)
{
var result = new Result();
try
{
var pcbEntities = new PCBEntities();
var count = pcbEntities.PCB_QAFolderTB.Count <PCB_QAFolderTB>(p => p.QAFolderName == qaFolderName && p.CreateAccount == account);
if (count > 0)
{
result.IsOK = false;
result.Description = "改目录名称已经存在，请重新命名";
return(result);
}
var dir = @ParameterAPI.GetConfig("ShareQAFile").ConfigValue + @"\\" + account + @"\\" + qaFolderName;
if (!Directory.Exists(dir))
{
Directory.CreateDirectory(dir);
}
//byte[] coverPhoto = Convert.FromBase64String(fileData);
//MemoryStream ms = new MemoryStream(coverPhoto);
//Bitmap bmp = new Bitmap(ms);
var pcbQaFolderTb = new PCB_QAFolderTB
{
QAFolderID = System.Guid.NewGuid(),
QAFolderName = qaFolderName,
CreateAccount = account,
CreateDateTime = DateTime.Now
};
pcbEntities.AddToPCB_QAFolderTB(pcbQaFolderTb);
result.IsOK = Convert.ToBoolean(pcbEntities.SaveChanges());
if (!result.IsOK)
{
result.Description = "创建失败";
Directory.Delete(dir, true);
return(result);
}
result.Description = "创建成功";
}
catch (Exception ex)
{
LogHelper.WriteLog(GetType()).Info(ex.StackTrace);
result.IsOK = false;
result.Description = ex.Message;
}
return(result);
}
/// <summary>
/// 获取配置信息
/// </summary>
/// <param name="configCoede"></param>
/// <returns></returns>
public static PCB_ConfigTB GetConfig(string configCoede)
{
PCB_ConfigTB config = null;
try
{
PCBEntities pCBEntities = new PCBEntities();
config = pCBEntities.PCB_ConfigTB.FirstOrDefault(p => p.ConfigCode == configCoede);
}
catch (Exception ex)
{
throw new Exception(ex.InnerException.Message);
}
return(config);
}
public Result ChangePassword(string account, string oldPassword, string newPassword)
{
Result result = new Result();
try
{
PCBEntities pCBEntities = new PCBEntities();
PCB_EngineerInfo engineerInfo = pCBEntities.PCB_EngineerInfo.FirstOrDefault(p => (p.Account == account || p.MailAddress == account) && p.StateCode == true);
if (engineerInfo == null || engineerInfo == default(PCB_EngineerInfo))
{
result.IsOK = false;
result.Description = "输入的用户" + account + "不存在";
return(result);
}
if (oldPassword != engineerInfo.Password)
{
result.IsOK = false;
result.Description = "输入的旧密码有误";
return(result);
}
if (string.IsNullOrEmpty(newPassword))
{
result.IsOK = false;
result.Description = "输入的新密码不能为空";
return(result);
}
engineerInfo.Password = newPassword;
engineerInfo.UpdateDateTime = DateTime.Now;
pCBEntities.Refresh(System.Data.Objects.RefreshMode.ClientWins, engineerInfo);
result.IsOK = Convert.ToBoolean(pCBEntities.SaveChanges());
if (!result.IsOK)
{
result.Description = "修改密码失败";
return(result);
}
result.Description = "账号" + account + "的密码修改成功";
}
catch (Exception ex)
{
LogHelper.WriteLog(GetType()).Info(ex.StackTrace);
result.IsOK = false;
result.Description = ex.InnerException.Message;
}
return(result);
}
public Result EditeAccountInfo(string account, string password, string accountName, string phoneNo, string weChatAccount)
{
Result result = new Result();
try
{
PCBEntities pCBEntities = new PCBEntities();
PCB_EngineerInfo pCB_EngineerInfo = pCBEntities.PCB_EngineerInfo.FirstOrDefault(p => p.Account == account && p.Password == password && p.StateCode == true);
if (pCB_EngineerInfo == null)
{
result.IsOK = false;
result.Description = "没有该账号信息";
return(result);
}
if (!string.IsNullOrEmpty(accountName))
{
pCB_EngineerInfo.AccountName = accountName;
}
if (!string.IsNullOrEmpty(phoneNo))
{
pCB_EngineerInfo.PhoneNo = phoneNo;
}
if (!string.IsNullOrEmpty(weChatAccount))
{
pCB_EngineerInfo.WeChatAccount = weChatAccount;
}
pCB_EngineerInfo.UpdateDateTime = DateTime.Now;
pCBEntities.Refresh(System.Data.Objects.RefreshMode.ClientWins, pCB_EngineerInfo);
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);
}
/// <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 GetOwnFileCoverList(string account)
{
Result result = new Result();
try
{
PCBEntities pCBEntities = new PCBEntities();
var infoList = pCBEntities.PCB_FileCoverTB.Where(p => p.CreateAccount == account).Select(p => new { p.FileCoverID, p.FileCoverName, p.FileCoverURL, p.FileExtension, p.FileSize, p.Price, p.IsPublish, p.CreateAccount, p.CreateDateTime, p.UpdateDateTime });
result.IsOK = true;
result.ExtData = JsonConvert.SerializeObject(infoList);
}
catch (Exception ex)
{
LogHelper.WriteLog(GetType()).Info(ex.StackTrace);
result.IsOK = false;
result.Description = ex.InnerException.Message;
}
return(result);
}
public Result GetOwnQaFolder(string account)
{
var result = new Result();
try
{
var pcbEntities = new PCBEntities();
var list = pcbEntities.PCB_QAFolderTB.Select(p => new{ p.QAFolderID, p.QAFolderName, p.CreateAccount, p.CreateDateTime }).Where(p => p.CreateAccount == account);
result.IsOK = true;
result.ExtData = JsonConvert.SerializeObject(list);
}
catch (Exception ex)
{
LogHelper.WriteLog(GetType()).Info(ex.StackTrace);
result.IsOK = false;
result.Description = ex.Message;
}
return(result);
}
public Result GetOwnAccessFile(string account, string fileCoverID)
{
Result result = new Result();
try
{
Guid g = new Guid(fileCoverID);
PCBEntities pCBEntities = new PCBEntities();
var infoList = pCBEntities.PCB_AccessFileTB.Where(p => p.CreateAccount == account && p.FileCoverID == g).Select(p => new { p.FileCoverID, p.AccessFileName, p.AccessFileURL, p.FileExtension, p.FileSize, p.FileMD5, p.CreateDateTime, p.CreateAccount });
result.IsOK = true;
result.ExtData = JsonConvert.SerializeObject(infoList);
}
catch (Exception ex)
{
LogHelper.WriteLog(GetType()).Info(ex.StackTrace);
result.IsOK = false;
result.Description = ex.InnerException.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 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);
}
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);
}
/// <summary>
/// 构造支付请求数据
/// </summary>
/// <returns>请求数据集</returns>
public static AlipayTradePrecreateContentBuilder BuildPrecreateContent(string account, string fileCoverID)
{
//线上联调时，请输入真实的外部订单号。
//string out_trade_no = "";
//if (String.IsNullOrEmpty(WIDout_request_no.Text.Trim()))
AlipayTradePrecreateContentBuilder builder = new AlipayTradePrecreateContentBuilder();
//{
try
{
string out_trade_no = System.DateTime.Now.ToString("yyyyMMddHHmmss") + "0000" + (new Random()).Next(1, 10000).ToString();
//收款账号
builder.seller_id = Config.pid;
//订单编号
builder.out_trade_no = out_trade_no;
PCBEntities pCBEntities = new PCBEntities();
Guid g = new Guid(fileCoverID);
//订单总金额
var pcbfilecoverTB = pCBEntities.PCB_FileCoverTB.FirstOrDefault(p => p.FileCoverID == g);
if (pcbfilecoverTB != null)
{
builder.total_amount = pcbfilecoverTB.Price;
}
else
{
throw new ArgumentNullException("without the data of fileCover");
}
//参与优惠计算的金额
//builder.discountable_amount = "";
//不参与优惠计算的金额
//builder.undiscountable_amount = "";
//订单名称
builder.subject = ParameterAPI.GetConfig("Subject").ConfigValue;// "xxxx";// WIDsubject.Text.Trim();
//自定义超时时间
builder.timeout_express = ParameterAPI.GetConfig("Timeout").ConfigValue;
//订单描述
builder.body = ParameterAPI.GetConfig("BuilderBody").ConfigValue;
//门店编号，很重要的参数，可以用作之后的营销
builder.store_id = ParameterAPI.GetConfig("StoreID").ConfigValue;
//操作员编号，很重要的参数，可以用作之后的营销
builder.operator_id = ParameterAPI.GetConfig("OperatorID").ConfigValue;
//传入商品信息详情
List <GoodsInfo> gList = new List <GoodsInfo>();
GoodsInfo goods = new GoodsInfo();
goods.goods_id = "goods id";
goods.goods_name = "goods name";
goods.price = "0.01";
goods.quantity = "1";
gList.Add(goods);
builder.goods_detail = gList;
//系统商接入可以填此参数用作返佣
//ExtendParams exParam = new ExtendParams();
//exParam.sysServiceProviderId = "20880000000000";
//builder.extendParams = exParam;
}
catch (Exception ex)
{
throw new Exception(ex.InnerException.Message);
}
return(builder);
}
public Result UploadAccessFile(byte[] accessFile, string fileCoverID, string account, string fileExtension, string accessFileName)
{
Result result = new Result();
string saveToUrl = @ParameterAPI.GetConfig("FileURL").ConfigValue + @"\\" + account + @"\\" + fileCoverID + @"\\" + accessFileName + "." + fileExtension;
try
{
Guid g = new Guid(fileCoverID);
PCBEntities pCBEntities = new PCBEntities();
int count = pCBEntities.PCB_FileCoverTB.Count <PCB_FileCoverTB>(p => p.FileCoverID == g);
if (count <= 0)
{
result.IsOK = false;
result.Description = "封面ID不存在";
return(result);
}
PCB_AccessFileTB pCB_AccessFileTB = pCBEntities.PCB_AccessFileTB.FirstOrDefault(p => p.CreateAccount == account && p.FileExtension == fileExtension && 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);
}
//string fileName=Guid.NewGuid().ToString();
result = Common.Common.FileWrite(saveToUrl, accessFile);
if (!result.IsOK)
{
return(result);
}
pCB_AccessFileTB = new PCB_AccessFileTB();
pCB_AccessFileTB.AccessFileID = Guid.NewGuid();
pCB_AccessFileTB.AccessFileName = accessFileName;
pCB_AccessFileTB.FileCoverID = new Guid(fileCoverID);
pCB_AccessFileTB.AccessFileURL = ParameterAPI.GetConfig("DowLoadFileURL").ConfigValue + "//" + account + "//" + fileCoverID + "//" + accessFileName + "." + fileExtension;
pCB_AccessFileTB.FileExtension = fileExtension;
pCB_AccessFileTB.CreateAccount = account;
pCB_AccessFileTB.FileMD5 = Common.Common.GetMD5Hash(accessFile);
pCB_AccessFileTB.FileSize = accessFile.Length.ToString();
pCB_AccessFileTB.CreateDateTime = DateTime.Now;
pCBEntities.AddToPCB_AccessFileTB(pCB_AccessFileTB);
result.IsOK = Convert.ToBoolean(pCBEntities.SaveChanges());
if (!result.IsOK)
{
File.Delete(saveToUrl);
result.Description = "上传失败";
return(result);
}
//Bitmap bmp = new Bitmap(Imagefilename);
//MemoryStream ms = new MemoryStream();
//bmp.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
//byte[] arr = new byte[ms.Length];
//ms.Position = 0;
//ms.Read(arr, 0, (int)ms.Length);
//ms.Close();
//string r = Convert.ToBase64String(arr);
//Result ret = UpdateFileCover(r, "chenc");
}
catch (Exception ex)
{
File.Delete(saveToUrl);
LogHelper.WriteLog(GetType()).Info(ex.StackTrace);
result.IsOK = false;
result.Description = ex.InnerException.Message;
}
return(result);
}
public Result CheckAndPreCreate(string account, string filecoverID)
{
Result result = new Result();
try
{
result.IsOK = true;
PCBEntities pcbEntities = new PCBEntities();
Guid fid = new Guid(filecoverID);
PCB_FileCoverTB pcbfilecoverTB = pcbEntities.PCB_FileCoverTB.FirstOrDefault(p => p.FileCoverID == fid);
if (pcbfilecoverTB == null)
{
result.IsOK = false;
result.Description = "未查询到指定数据";
return(result);
}
var accessFileList = from accessfile in pcbEntities.PCB_AccessFileTB
where accessfile.FileCoverID == fid
select new
{
AccessFileName = accessfile.AccessFileName,
AccessFileURL = accessfile.AccessFileURL,
FileExtension = accessfile.FileExtension,
FileSize = accessfile.FileSize,
FileMD5 = accessfile.FileMD5
};
decimal filecoverprice;
if (decimal.TryParse(pcbfilecoverTB.Price, out filecoverprice))
{
if (filecoverprice > 0)
{
//金额>0，查询预下单记录
LogHelper.WriteLog(GetType()).Info(filecoverprice.ToString());
PCB_OrderTB pcborderTB = pcbEntities.PCB_OrderTB.FirstOrDefault(p => p.FileCoverID == fid);
if (pcborderTB != null)
{
//LogHelper.WriteLog(GetType()).Info(pcborderTB);
//有记录
if (pcborderTB.IsPay)
{
result.Description = "文件已支付，返回数据类型为：文件下载地址";
result.ExtData = JsonConvert.SerializeObject(accessFileList);
}
else
{
result = PreCreate(account, filecoverID);
//result.Description = "文件需支付，返回数据类型为：文件价格";
//result.ExtData = pcbfilecoverTB.Price;
//pcbEntities.DeleteObject(pcborderTB);
//pcbEntities.SaveChanges();
}
}
else
{
//LogHelper.WriteLog(GetType()).Info(pcborderTB);
//result.ExtData = pcbfilecoverTB.Price;
//result.Description = "文件需支付，返回数据类型为：文件价格";
result = PreCreate(account, filecoverID);
}
}
else
{
//金额==0，返回下载地址
LogHelper.WriteLog(GetType()).Info(filecoverprice.ToString());
result.ExtData = JsonConvert.SerializeObject(accessFileList);
result.Description = "文件无需支付，返回数据类型为：文件下载地址";
}
}
else
{
throw new Exception("封面金额转换错误，pcbfilecoverTB.Price : " + pcbfilecoverTB.Price);
}
}
catch (Exception ex)
{
LogHelper.WriteLog(GetType()).Info(ex.StackTrace);
result.IsOK = false;
result.Description = ex.Message;
}
return(result);
}
