private void btnImport_Click(object sender, EventArgs e)
{
ztinfo zt = (ztinfo)cmbZTList.SelectedItem;
int ztid = zt.ID;
string ztname = zt.Name;
ztname = ztname.Replace(zt.DbType.ToUpper(), "").Trim();
switch (zt.DbType.ToUpper())
{
case "CPRS":
import = new CPRSImport(txtFileName.Text.Trim(), ztname, ztid);
break;
case "WPI":
import = new WPIImport(txtFileName.Text.Trim(), ztname, ztid);
break;
case "EPODOC":
import = new EPODOCImport(txtFileName.Text.Trim(), ztname, ztid);
break;
}
import.SetMaxProcess += new SetMaxValueEventHander(SetMax);
import.ShowProcess += new ValueChangedEventHandler(ShowProcess);
//import.Import();
ac = new Func <bool>(import.Import);
ar = ac.BeginInvoke(CallBack, ac);
//MessageBox.Show("开始导入");
btnCen.Enabled = true;
this.btnImport.Enabled = false;
}
private void list_template_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex == -1)
{
return;
}
if (e.ColumnIndex == -1)
{
return;
}
ztinfo zt = (ztinfo)cmbZTList.SelectedItem;
string type = zt.DbType;
string id = this.dgwtemplate.Rows[e.RowIndex].Cells["Id"].Value.ToString();
string tmpname = this.dgwtemplate.Rows[e.RowIndex].Cells["name"].Value.ToString();
if (Path.GetExtension(this.txtFileName.Text.Trim()).IndexOf(".xls") >= 0)
{
ExcelProView ex = new ExcelProView(this.txtFileName.Text, tmpname, type, id);
if (ex.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
this.tmplate = ex.tmp;
this.txtTemplate.Text = tmplate.Name;
this.panTemplate.Visible = false;
}
}
else
{
this.txtTemplate.Text = tmpname;
this.panTemplate.Visible = false;
}
}
private void cmbZTList_SelectedIndexChanged(object sender, EventArgs e)
{
ztinfo zt = (ztinfo)cmbZTList.SelectedItem;
string type = zt.DbType;
TemplateListHelper.IniDropDownList(dgwtemplate, type, "");
}
private void btnQuery_Click(object sender, EventArgs e)
{
ztinfo zt = (ztinfo)cmbZtLst.SelectedItem;
int ztid = zt.ID;
nPtCount = PtDataHelper.getPtDataCount(string.Format("ztid={0}", ztid));
nPageCount = Convert.ToInt32(Math.Ceiling(Convert.ToDouble(nPtCount) / Convert.ToDouble(nPageSize)));
if (nPageCount < 1)
{
nCuurentPage = 0;
btnSY.Enabled = false;
btnPre.Enabled = false;
btnNext.Enabled = false;
btnEnd.Enabled = false;
groupBox2.Text = string.Format("共{0}条数据", nPtCount, nCuurentPage, nPageCount);
dgvListData.DataSource = null;
dgvListData.Refresh();
}
else
{
nCuurentPage = 1;
BingData(nCuurentPage, nPageSize);
}
}
private void btnQuery_Click(object sender, EventArgs e)
{
ztinfo zt = (ztinfo)cmbZtLst.SelectedItem;
int ztid = zt.ID;
strDbType = zt.DbType;
strZtID = ztid.ToString();
LoadData(false);
}
private void btnImport_Click(object sender, EventArgs e)
{
if (txtFileName.Text.Trim() == "")
{
MessageBox.Show("请选择数据源！", "提示");
return;
}
if (this.txtTemplate.Text.Trim() == "")
{
MessageBox.Show("请选择模板！", "提示");
return;
}
ztinfo zt = (ztinfo)cmbZTList.SelectedItem;
ztid = zt.ID;
strname = zt.Name;
type = zt.DbType;
string ztname = zt.Name;
ztname = ztname.Replace(zt.DbType.ToUpper(), "").Trim();
if (Path.GetExtension(this.txtFileName.Text.Trim()).IndexOf(".xls") >= 0)
{
import = new ExcelImport(txtFileName.Text.Trim(), ztname, ztid, type, tmplate);
}
else
{
switch (zt.DbType.ToUpper())
{
case "CPRS":
import = new CPRSImport(txtFileName.Text.Trim(), ztname, ztid);
break;
case "WPI":
import = new WPIImport(txtFileName.Text.Trim(), ztname, ztid);
break;
case "EPODOC":
import = new EPODOCImport(txtFileName.Text.Trim(), ztname, ztid);
break;
}
}
import.Skip = this.rbSkip.Checked;
import.SetMaxProcess += new SetMaxValueEventHander(SetMax);
import.ShowProcess += new ValueChangedEventHandler(ShowProcess);
//import.Import();
ac = new Func <bool>(import.Import);
ar = ac.BeginInvoke(CallBack, ac);
//MessageBox.Show("开始导入");
//btnCen.Enabled = true;
this.btnImport.Enabled = false;
}
private void txtFileName_TextChanged(object sender, EventArgs e)
{
string file = txtFileName.Text.Trim();
if (file == "")
{
return;
}
string filetype = Path.GetExtension(this.txtFileName.Text.Trim()).Trim('.');
ztinfo zt = (ztinfo)cmbZTList.SelectedItem;
string type = zt.DbType;
TemplateListHelper.IniDropDownList(dgwtemplate, type, filetype);
}
private void btnstat_Click(object sender, EventArgs e)
{
ztinfo zt = (ztinfo)cmbZtLst.SelectedItem;
int ztid = zt.ID;
strDbType = zt.DbType;
strZtID = ztid.ToString();
frmstat st = new frmstat(zt.Name, ztid, strDbType);
st.MdiParent = this.MdiParent;
st.WindowState = FormWindowState.Maximized;
st.Show();
this.Close();
}
private void button2_Click(object sender, EventArgs e)
{
ztinfo zt = (ztinfo)cmbZtLst.SelectedItem;
int ztid = zt.ID;
strDbType = zt.DbType;
strZtID = ztid.ToString();
frmFilter frm = new frmFilter(zt.Name, ztid, strDbType);
if (frm.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
//MessageBox.Show(frm.allsql);
strfilterSql = frm.allsql;
LoadData(false);
}
}
private void txtTemplate_Enter(object sender, EventArgs e)
{
string file = txtFileName.Text.Trim();
if (file == "")
{
return;
}
string filetype = Path.GetExtension(this.txtFileName.Text.Trim()).Trim('.');
ztinfo zt = (ztinfo)cmbZTList.SelectedItem;
string type = zt.DbType;
TemplateListHelper.IniDropDownList(dgwtemplate, type, filetype);
this.panTemplate.Location = new Point(groupTmplate.Location.X + txtTemplate.Location.X, groupTmplate.Location.Y + this.txtTemplate.Location.Y + this.txtTemplate.Height);
this.panTemplate.Width = this.txtTemplate.Width;
this.panTemplate.Visible = true;
this.panTemplate.Update();
this.Update();
}
private void BingData(int nPageidx, int nPageSize)
{
if (nPageCount == 0)
{
return;
}
if (nPageidx > nPageCount)
{
nPageidx = nPageCount;
}
else if (nPageidx < 1)
{
nPageidx = 1;
}
btnSY.Enabled = true;
btnPre.Enabled = true;
btnNext.Enabled = true;
btnEnd.Enabled = true;
if (nPageidx == 1)
{
btnSY.Enabled = false;
btnPre.Enabled = false;
}
if (nPageidx == nPageCount)
{
btnNext.Enabled = false;
btnEnd.Enabled = false;
}
ztinfo zt = (ztinfo)cmbZtLst.SelectedItem;
int ztid = zt.ID;
dgvListData.DataSource = PtDataHelper.getPtData(string.Format("ztid={0}", ztid), nPageidx, nPageSize);
nCuurentPage = nPageidx;
groupBox2.Text = string.Format("共{0}条数据,第{1}页/共{2}页 双击可查看专利的详细信息.", nPtCount, nCuurentPage, nPageCount);
}
private void BingData(int nPageidx, int nPageSize)
{
//if (nPageCount == 0)
// return;
if (nPageidx > nPageCount)
{
nPageidx = nPageCount;
}
else if (nPageidx < 1)
{
nPageidx = 1;
}
btnSY.Enabled = true;
btnPre.Enabled = true;
btnNext.Enabled = true;
btnEnd.Enabled = true;
if (nPageidx == 1)
{
btnSY.Enabled = false;
btnPre.Enabled = false;
}
if (nPageidx == nPageCount)
{
btnNext.Enabled = false;
btnEnd.Enabled = false;
}
ztinfo zt = (ztinfo)cmbZtLst.SelectedItem;
int ztid = zt.ID;
switch (cbxOrder.Text)
{
case "申请号降序":
strOrder = "a1.an desc";
break;
case "申请号升序":
strOrder = "a1.an";
break;
case "申请日降序":
//strOrder = "ad desc";
strOrder = "date_format(REPLACE(REPLACE(REPLACE(a1.ad,'年','-'),'月','-'),'日',''),'%Y-%m-%d') desc";
break;
case "申请日升序":
//strOrder = "ad ";
strOrder = "date_format(REPLACE(REPLACE(REPLACE(a1.ad,'年','-'),'月','-'),'日',''),'%Y-%m-%d')";
break;
case "公开日降序":
//strOrder = "pd desc";
strOrder = "date_format(REPLACE(REPLACE(REPLACE(a1.pd,'年','-'),'月','-'),'日',''),'%Y-%m-%d') desc";
break;
case "公开日升序":
//strOrder = "pd ";
strOrder = "date_format(REPLACE(REPLACE(REPLACE(a1.pd,'年','-'),'月','-'),'日',''),'%Y-%m-%d')";
break;
default:
strOrder = "a1.id";
break;
}
strOrderShowText = cbxOrder.Text;
string strWhereTmp = string.IsNullOrEmpty(strfilterSql) ? string.Format(" where a1.ztid={0}", strZtID) :
string.Format(",({1}) f1 where a1.ztid={0} and a1.sid=f1.sid", strZtID, strfilterSql);
dgvListData.DataSource = PtDataHelper.getPtData(strWhereTmp, strOrder, nPageidx, nPageSize, strDbType);
nCuurentPage = nPageidx;
groupBox2.Text = string.Format("共{0}条数据,第{1}页/共{2}页,[双击]可查看专利的详细信息.", nPtCount, nCuurentPage, nPageCount);
}
