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