/// <summary>
/// 查询单个数据
/// </summary>
/// <returns></returns>
public object SelectYzsy(SelectParam select)
{
using (CompassDbContext dbContext = new CompassDbContext())
{
try
{
var obj = dbContext.Yzsys.Where(r => r.MDirection.Equals(select.MDirection) && r.WDirection.Equals(select.WDirection) && r.CDirection.Equals(select.CDirection)).FirstOrDefault();
if (obj == null)
{
var _obj = dbContext.Yzsys.Where(r => r.MDirection.Equals(select.MDirection) && r.WDirection.Equals(select.WDirection)).FirstOrDefault();
if (_obj != null)
{
_obj.DescribeF = string.Empty;
}
return(_obj);
}
return(obj);
}
catch (Exception ex)
{
MessageBox.Show($"数据库单个查询YZSY失败，{ex.ToString()}");
}
}
return(null);
}
public OperationResult FindAllByUploadedDate(DateTime uploadedDateStart, DateTime uploadedDateEnd)
{
string date1 = uploadedDateStart.ToString("yyyy-MM-dd hh:mm:ss");
string date2 = uploadedDateEnd.ToString("yyyy-MM-dd hh:mm:ss");
string where = "(UploadedDate >= Convert.ToDateTime(\"" + date1 + "\") && ";
where += "UploadedDate <= Convert.ToDateTime(\"" + date2 + "\") )";
SelectParam selectParam = new SelectParam(where);
return(this.FindAll(selectParam, null, null));
}
public string FindUploadedFileList(string keyword, string page, string size)
{
SelectParam selectParam = new SelectParam();
selectParam.Keyword = keyword;
if (keyword == "all")
{
selectParam.Keyword = null;
}
IBusinessService businessService = Factory.Create <IBusinessService>("UploadedFile", ClassType.clsTypeBusinessService);
OperationResult result = businessService.FindAllByKeyword(selectParam, Convert.ToInt16(page), Convert.ToInt16(size));
return(Serializer.Json.Serialize(result));
}
public Stream FindApplicationItem(string keyword, string page, string max)
{
BaseBusinessService <ApplicationItem> businessService = (BaseBusinessService <ApplicationItem>)BusinessFactory.Create(Keywords.FindApplicationItem);
SelectParam selectParam = new SelectParam();
selectParam.Keyword = keyword;
if (keyword.ToLower() == "all")
{
selectParam.Keyword = "";
}
OperationResult result = businessService.FindAll(selectParam, Convert.ToInt16(page), Convert.ToInt16(max));
return(result.ToJsonStream());
}
public OperationResult SendUnsentEmailInDatabase()
{
IBusinessService emailSentBusinessService = new EmailSentBusinessService();
SelectParam selectParam = new SelectParam();
selectParam.Where = null;
selectParam.Where = "IsSent = 0";
OperationResult result = emailSentBusinessService.FindAll(selectParam, null, null);
List <object> emailSentList = (List <object>)result.Data;
foreach (object emailSent in emailSentList)
{
OperationResult resultSendEmail = SendUnsentEmailItem(emailSent);
emailSent.GetType().GetProperty("SentDate").SetValue(emailSent, DateTime.Now, null);
if (resultSendEmail.Result)
{
emailSent.GetType().GetProperty("IsSent").SetValue(emailSent, 1, null);
}
else
{
string errorMessage = "";
Exception e = (Exception)resultSendEmail.Data;
errorMessage = e.Message + "\n\n";
if (e.InnerException != null)
{
errorMessage += e.InnerException.Message;
}
emailSent.GetType().GetProperty("IsSent").SetValue(emailSent, 0, null);
emailSent.GetType().GetProperty("FailReason").SetValue(emailSent, errorMessage, null);
}
try
{
emailSentBusinessService.Update(emailSent);
}
catch (Exception err)
{
result.Data = err;
}
}
return(result);
}
public string FindEmailSentList(string keyword, string page, string size)
{
SelectParam selectParam = new SelectParam();
selectParam.Keyword = keyword;
if (keyword == "all")
{
selectParam.Keyword = null;
}
selectParam.AddOrderBy("SentDate DESC");
IBusinessService businessService = Factory.Create <IBusinessService>("EmailSent", ClassType.clsTypeBusinessService);
OperationResult result = businessService.FindAllByKeyword(selectParam, Convert.ToInt16(page), Convert.ToInt16(size));
return(Serializer.Json.Serialize(result));
}
private void ComboBoxZ_SelectedIndexChanged(object sender, EventArgs e)
{
SelectParam selectParam = new SelectParam()
{
MDirection = this.comboBox1.SelectedItem.ToString(),
WDirection = this.comboBox2.SelectedItem.ToString(),
CDirection = this.comboBox3.SelectedItem.ToString(),
};
Tb_YZSY obj = YzsyManament.GetInstance().SelectYzsy(selectParam) as Tb_YZSY;
if (obj != null)
{
this.textBox1.Text = obj.DescribeZ;
this.textBox2.Text = obj.DescribeF;
}
else
{
this.textBox1.Text = string.Empty;
this.textBox2.Text = string.Empty;
}
}
public OperationResult FindAllByFileInfo(string fileInfo)
{
SelectParam selectParam = new SelectParam("FileInfo.Contains(\"" + fileInfo + "\")");
return(this.FindAll(selectParam, null, null));
}
public OperationResult FindAllByTargetFileName(string targetFileName)
{
SelectParam selectParam = new SelectParam("TargetFileName.Contains(\"" + targetFileName + "\")");
return(this.FindAll(selectParam, null, null));
}
public OperationResult FindAllByOriginalFileName(string originalFileName)
{
SelectParam selectParam = new SelectParam("OriginalFileName.Contains(\"" + originalFileName + "\")");
return(this.FindAll(selectParam, null, null));
}
public OperationResult FindAllBySmtpServer(string smtpServer)
{
SelectParam selectParam = new SelectParam("SmtpServer.Contains(\"" + smtpServer + "\")");
return(this.FindAll(selectParam, null, null));
}
public OperationResult FindAllByTag(string tag)
{
SelectParam selectParam = new SelectParam("Tag.Contains(\"" + tag + "\")");
return(this.FindAll(selectParam, null, null));
}
public OperationResult FindAllByEmailSubject(string emailSubject)
{
SelectParam selectParam = new SelectParam("EmailSubject.Contains(\"" + emailSubject + "\")");
return(this.FindAll(selectParam, null, null));
}
public OperationResult FindAllByReceiverInfo(string receiverInfo)
{
SelectParam selectParam = new SelectParam("ReceiverInfo.Contains(\"" + receiverInfo + "\")");
return(this.FindAll(selectParam, null, null));
}
protected override SelectParam SetAdditionalParameter(SelectParam selectParam)
{
selectParam.AddOrderBy("SentDate DESC");
return(selectParam);
}
public OperationResult FindAllByEmailAccountPassword(string emailAccountPassword)
{
SelectParam selectParam = new SelectParam("EmailAccountPassword.Contains(\"" + emailAccountPassword + "\")");
return(this.FindAll(selectParam, null, null));
}
public OperationResult FindAllByFilename(string filename)
{
SelectParam param = new SelectParam("Filename.Contains(\"" + filename + "\")");
return(FindAll(param, null, null));
}
public OperationResult FindAllBySenderEmail(string senderEmail)
{
SelectParam selectParam = new SelectParam("SenderEmail.Contains(\"" + senderEmail + "\")");
return(this.FindAll(selectParam, null, null));
}
