private void fmSearch_Load(object sender, EventArgs e) { this.dtpFrom.Value = DateTime.Now.Date; this.dtpTo.Value = DateTime.Now; cbbStatus.SelectedIndex = 0; cbbQC.SelectedIndex = 0; cbbPart.SelectedIndex = 0; cbbLoad.SelectedIndex = 0; InitQc(); OcrDBPmsServerList = SearchBLL.GetOcrDBPmsServer(); }
private DataSet GetFields() { DataSet fileds = new SearchBLL().GetSearchFields(CompanyID, TableType); if (fileds == null) { return(null); } DataSet ds = fileds.Copy(); ds.Tables[0].Columns.Add("DatabaseFieldAndType"); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DataRow dr = ds.Tables[0].Rows[i]; dr["DatabaseFieldAndType"] = dr["FieldName"].ToString() + "|" + dr["FieldType"].ToString(); } return(ds); }
protected void btnView_Click(object sender, EventArgs e) { SearchBLL bll = new SearchBLL(); //Search By policy Number #region Search y Policy Number if (ddlSearchPolicy.SelectedIndex == 0) { int policyNum = int.Parse(txtEnterPolicyNumber.Text); list = bll.SearchByPolicyNumber(policyNum); gvSearchResult.DataSource = list; gvSearchResult.DataBind(); } #endregion //Search By Customer ID #region Search by Customer ID if (ddlSearchPolicy.SelectedIndex == 1) { int custId = int.Parse(txtEnterCustomerID.Text); list = bll.SearchByCustomerId(custId); gvSearchResult.DataSource = list; gvSearchResult.DataBind(); } #endregion //Search By Name and DOB #region Search by Name and DOB if (ddlSearchPolicy.SelectedIndex == 2) { string Cname = txtEnterCustomerName.Text; string d = txtDOB.Text.ToString(); DateTime dob = Convert.ToDateTime(d); list = bll.SearchByName(Cname, dob); gvSearchResult.DataSource = list; gvSearchResult.DataBind(); } #endregion }
//加载图片 private void LoadPhotos(decimal dock_id, decimal pms_id, string dir) { using (OCR.Model.OcrPhoto.T_OCR_PHOTODataTable ds = SearchBLL.GetPhoto(dock_id)) { OCR.Model.OcrDBPmsServer pms = OcrDBPmsServerList[Convert.ToInt32(pms_id)]; if (pms == null) { throw new Exception("图片服务器设置异常"); } string path = string.Format(@"http://{0}:{1}", pms.Ip, pms.Port); foreach (OCR.Model.OcrPhoto.T_OCR_PHOTORow dr in ds) { //int photo_pos = Convert.ToInt32(dr["PHOTO_POS"]); string url = string.Format(@"{0}{1}", path, dr.PHOTO_URL); SavePic(url, string.Format(@"{0}\{1}.jpg", dir, dr.PHOTO_ID)); } } }
public object SearchExtend(QuerySearchModel query) { if (query == null) { return new { Rcode = -1, Rmsg = "错误请求" } } ; string errmsg = null; TimeSpan usetime = new TimeSpan(); SearchResult result = SearchBLL.SearchQuery(query, ref usetime, ref errmsg); if (!string.IsNullOrEmpty(errmsg) || result == null) { return new { Rcode = -1, Rmsg = errmsg } } ; else if (result.TotalCount == 0) { return new { Rcode = 0, total = 0, Rmsg = "没有符合条件的数据" } } ; else { if (string.IsNullOrEmpty(query.groupName)) { DataTable rdt = new DataTable(); // int pagecount = result.ResultCount % query.rows == 0 ? result.ResultCount / query.rows : result.ResultCount / query.rows + 1; if (result.Attrs != null && result.Attrs.Length > 0) { rdt.Columns.Add(new DataColumn("seqid")); foreach (AttrMatch am in result.Attrs) { rdt.Columns.Add(new DataColumn(am.AttrName)); } } DataRow dr; foreach (ResultMatches match in result.Matches) { dr = rdt.NewRow(); dr["seqid"] = match.DocumentID; foreach (DataColumn dc in rdt.Columns) { if (dc.ColumnName != "seqid") { dr[dc.ColumnName] = match.GetAttrValue(dc.ColumnName); } } rdt.Rows.Add(dr); } return(new { Rcode = 1, list = rdt, total = result.TotalCount, PageCount = result.TotalCount, usetime = usetime.TotalMilliseconds }); } else { int classparentid = 12; string _errmsg; List <Options> optionlist = null; switch (query.groupName.Trim()) { case "restype": SearchBLL.GetResTypeOptions(out _errmsg); optionlist = SearchBLL.restypeList; break; case "classid": SearchBLL.GetClassOptions(classparentid, out _errmsg); optionlist = SearchBLL.classList[classparentid]; break; case "languageid": SearchBLL.GetDicOptions(out _errmsg); optionlist = SearchBLL.dictList["language"]; break; case "authorstr": SearchBLL.GetAuthorOptions(out _errmsg); optionlist = SearchBLL.authorsList; break; } List <SearchGroupModel> grouplist = new List <SearchGroupModel>(); SearchGroupModel group; foreach (ResultMatches match in result.Matches) { group = new SearchGroupModel(); group.groupvalue = match.GetAttrValue("@groupby").ToString().Trim(); group.groupcount = int.Parse(match.GetAttrValue("@count").ToString()); Options option = optionlist != null?optionlist.Find(o => o.id == group.groupvalue) : null; if (option != null) { group.groupname = option.text; } else { group.groupname = group.groupvalue; } grouplist.Add(group); } if (query.groupName.Trim().Equals("classid")) { grouplist = SearchBLL.GetClassGroupTree(classparentid, grouplist); } return(new { Rcode = 1, list = grouplist, total = result.TotalCount, PageCount = result.TotalCount, usetime = usetime.TotalMilliseconds }); } } }
//¼ÓÔØͼƬ private void LoadPhotos() { using (OcrPhoto.T_OCR_PHOTODataTable ds = SearchBLL.GetPhoto(dock_id)) { string url1 = string.Empty; string url2 = string.Empty; string url3 = string.Empty; string url4 = string.Empty; string url5 = string.Empty; string url6 = string.Empty; string url7 = string.Empty; string url8 = string.Empty; OcrDBPmsServer pms = OcrDBPmsServerList[Convert.ToInt32(pms_id)]; if (pms == null) { throw new Exception("ͼƬ·þÎñÆ÷ÉèÖÃÒì³£"); } string path = string.Format(@"http://{0}:{1}", pms.Ip, pms.Port); foreach (OcrPhoto.T_OCR_PHOTORow dr in ds) { //int photo_pos = Convert.ToInt32(dr["PHOTO_POS"]); string url = string.Format(@"{0}{1}", path, dr.PHOTO_URL); switch (Convert.ToInt32(dr.PHOTO_POS)) { case 1: url1 = url; break; case 2: url2 = url; break; case 3: url3 = url; break; case 4: url4 = url; break; case 5: url5 = url; break; case 6: url6 = url; break; case 7: url7 = url; break; case 8: url8 = url; break; } } ThreadPool.QueueUserWorkItem(new WaitCallback(LoadPhotoAsy), new LoadPhotoState(pb1, url1)); ThreadPool.QueueUserWorkItem(new WaitCallback(LoadPhotoAsy), new LoadPhotoState(pb2, url2)); ThreadPool.QueueUserWorkItem(new WaitCallback(LoadPhotoAsy), new LoadPhotoState(pb3, url4)); ThreadPool.QueueUserWorkItem(new WaitCallback(LoadPhotoAsy), new LoadPhotoState(pb4, url3)); ThreadPool.QueueUserWorkItem(new WaitCallback(LoadPhotoAsy), new LoadPhotoState(pb5, url5)); ThreadPool.QueueUserWorkItem(new WaitCallback(LoadPhotoAsy), new LoadPhotoState(pb6, url6)); ThreadPool.QueueUserWorkItem(new WaitCallback(LoadPhotoAsy), new LoadPhotoState(pb7, url7)); ThreadPool.QueueUserWorkItem(new WaitCallback(LoadPhotoAsy), new LoadPhotoState(pb8, url8)); } }
private void fmShowPics_Load(object sender, EventArgs e) { OcrDBPmsServerList = SearchBLL.GetOcrDBPmsServer(); LoadPhotos(); }
private void btnExport_Click(object sender, EventArgs e) { this.Cursor = Cursors.WaitCursor; try { if (string.IsNullOrEmpty(txtCarrierCode.Text.Trim())) { throw new Exception("请输入船名简称"); } if (string.IsNullOrEmpty(txtVoyageOut.Text.Trim())) { throw new Exception("请输入出口航次"); } using (DataSet ds = SearchBLL.SelectReport(string.Format("{0}{1}", txtCarrierCode.Text.Trim(), txtVoyageOut.Text.Trim()), fmMain.CompanyCode)) { if (ds.Tables[0].Rows.Count == 0) { throw new Exception("该船无作业数据!"); } DialogResult drt = folderBrowserDialog1.ShowDialog(this); if (drt == DialogResult.OK) { string dir = string.Format(@"{0}\{1}{2}", folderBrowserDialog1.SelectedPath, txtCarrierCode.Text.Trim(), txtVoyageOut.Text.Trim()); if (!Directory.Exists(dir)) { Directory.CreateDirectory(dir); } //拆成装、卸、倒柜 三个EXCEL文件 DataSet load = new DataSet(); DataSet dis = new DataSet(); DataSet restow = new DataSet(); SplitDataset(ds, ref load, ref dis, ref restow); //作业清单 string fileName = string.Empty; if (load.Tables[0].Rows.Count > 0) { fileName = string.Format(@"{0}\{1}{2}-装船.xls", dir, txtCarrierCode.Text.Trim(), txtVoyageOut.Text.Trim()); CCT.SystemFramework.Office.ExcelHelper.ExportToExcel(load, fileName); } if (dis.Tables[0].Rows.Count > 0) { fileName = string.Format(@"{0}\{1}{2}-卸船.xls", dir, txtCarrierCode.Text.Trim(), txtVoyageOut.Text.Trim()); CCT.SystemFramework.Office.ExcelHelper.ExportToExcel(dis, fileName); } if (restow.Tables[0].Rows.Count > 0) { fileName = string.Format(@"{0}\{1}{2}-倒柜.xls", dir, txtCarrierCode.Text.Trim(), txtVoyageOut.Text.Trim()); CCT.SystemFramework.Office.ExcelHelper.ExportToExcel(restow, fileName); } if (ckbPic.Checked) { //图片 string dirPic = string.Format(@"{0}\图片", dir); if (!Directory.Exists(dirPic)) { Directory.CreateDirectory(dirPic); } foreach (DataRow dr in ds.Tables[0].Rows) { //每张图片一个文件夹 string dirPic1 = string.Format(@"{0}\{1}", dirPic, dr["箱号"].ToString()); if (!Directory.Exists(dirPic1)) { Directory.CreateDirectory(dirPic1); } LoadPhotos(Convert.ToDecimal(dr["dock_id"]), Convert.ToDecimal(dr["pms_id"]), dirPic1); } } MessageBox.Show("导出成功!"); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { this.Cursor = Cursors.Default; } }