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