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