private void dataGridView1_DataSourceChanged(object sender, EventArgs e) { foreach (DataGridViewRow row in dataGridView1.Rows) { string syscolumnname = row.Cells["syscolumnname"].Value.ToString(); if (syscolumnname == "") { syscolumnname = row.Cells[0].Value.ToString(); } DataGridViewComboBoxCell cell = row.Cells[1] as DataGridViewComboBoxCell; if (cell != null) { bool hasfind = false; foreach (var x in cell.Items) { CfGSTColumn item = x as CfGSTColumn; if (item.ShownAme == syscolumnname) { cell.Value = item.ShownAme; hasfind = true; break; } } if (!hasfind) { cell.Value = "忽略"; } } } }
private void textBox1_Enter(object sender, EventArgs e) { CfGSTColumn col = (CfGSTColumn)cmbColName.SelectedItem; if (col.ShownAme.IndexOf("日") >= 0) { monthCalendar1.Visible = true; monthCalendar1.Top = this.textBox1.Top + this.textBox1.Height + 10; monthCalendar1.Left = textBox1.Left + 10; monthCalendar1.Update(); } }
private void button1_Click(object sender, EventArgs e) { tmp.ColumnMapping.Clear(); foreach (DataGridViewRow row in dataGridView1.Rows) { DataGridViewComboBoxCell cell = row.Cells[1] as DataGridViewComboBoxCell; string excelname = row.Cells[0].Value.ToString(); string splitchar = row.Cells[2].Value.ToString(); if (cell != null) { if (cell.Value.ToString() == "忽略") { continue; } string colname = cell.Value.ToString(); CfGSTColumn configst = (from x in ddl where x.ShownAme == colname select x).First(); ColumnMapping tmpmapping = new ColumnMapping(); tmpmapping.SplitChar = splitchar; tmpmapping.SystemColumnName = configst.ColName; tmpmapping.Tablename = configst.TBName; tmpmapping.Coltype = configst.ClType; tmpmapping.ExcelColumnName = excelname; tmpmapping.SystemColumnShowName = configst.ShownAme; tmp.ColumnMapping.Add(excelname, tmpmapping); } } tmp.IsWPIDefault = chkWPI_AN.Checked; tmp.IsEPODCODefault = chkEPO_AN.Checked; if (tmp.Name != this.txtTemple.Text.Trim()) { TemplateHelper.Delete(tmp.Type + "_" + tmp.Name); } tmp.Name = this.txtTemple.Text; tmp.Type = this.cmbType.Text; TemplateHelper.SaveTemplate(tmp); this.DialogResult = System.Windows.Forms.DialogResult.OK; }
private void button2_Click(object sender, EventArgs e) { if (this.textBox1.Text.Trim() == "") { MessageBox.Show("请输入过滤条件", "提示"); return; } monthCalendar1.Visible = false; CfGSTColumn col = (CfGSTColumn)cmbColName.SelectedItem; string filtertype = cmbFilterType.Text; string stroperator = ""; string values = this.textBox1.Text.Trim(); if (col.ShownAme.IndexOf("") > 0) { if (col.TBName != "show_base") { values = values.FormatDate(); } } switch (filtertype) { case "等于": stroperator = "="; break; case "不等于": stroperator = "<>"; break; case "大于": stroperator = ">"; break; case "小于": stroperator = "<"; break; case "包含": stroperator = "like"; values = "%" + values + "%"; break; case "不包含": stroperator = "not like"; values = "%" + values + "%"; break; case "前方一致": stroperator = "like"; values = values + "%"; break; case "后方一致": stroperator = "like"; values = "%" + values; break; } string sql = ""; switch (col.ShownAme) { case "是否合作申请": case "是否国外来华": case "是否三局": case "是否五局": case "是否公知技术": if (values == "是") { values = "1"; sql = string.Format("{0}.{1} {2} {3}", col.TBName, col.ColName, stroperator, values); } if (values == "否") { values = "0"; sql = string.Format("({0}.{1} {2} {3} or {0}.{1} is null)", col.TBName, col.ColName, stroperator, values); } break; default: switch (col.ClType) { case "varchar": values = "'" + values + "'"; break; } sql = string.Format("{0}.{1} {2} {3}", col.TBName, col.ColName, stroperator, values); break; } var res = from x in dt.AsEnumerable() where x["Tabl_ColName"].ToString() == col.ColName && x["Tablename"].ToString() == col.TBName select x; DataRow f; if (res.Count() == 0) { f = dt.NewRow(); } else { f = res.First(); } string andor = " and "; if (cmbLuoJi.Text == "或者") { andor = " or "; } f["luoji"] = cmbLuoJi.Text; f["Colname"] = col.ShownAme; f["Tablename"] = col.TBName; f["Tabl_ColName"] = col.ColName; if (res.Count() == 0) { f["Sql"] += sql; f["Colopererator"] += col.ShownAme + " " + filtertype + " " + values + " "; } else { f["Sql"] += andor + sql; f["Colopererator"] += cmbLuoJi.Text + " " + col.ShownAme + " " + filtertype + " " + values + " "; } if (res.Count() == 0) { dt.Rows.Add(f); } BindData(); ff(); }
private void cmbColName_SelectedIndexChanged(object sender, EventArgs e) { CfGSTColumn col = (CfGSTColumn)cmbColName.SelectedItem; this.textBox1.Text = ""; List <string> filtertype = null; List <string> yesorno = new List <string>(); switch (col.ClType) { case "int": filtertype = new List <string> { "等于", "不等于", "大于", "小于" }; break; case "varchar": filtertype = new List <string> { "等于", "不等于", "包含", "不包含", "前方一致", "后方一致" }; break; case "tinyint": filtertype = new List <string> { "等于", "不等于", "大于", "小于" }; break; } cmbFilterType.Items.Clear(); switch (col.ShownAme) { case "是否合作申请": case "是否国外来华": case "是否三局": case "是否五局": case "是否公知技术": filtertype = new List <string> { "等于" }; yesorno = new List <string>() { "是", "否" }; break; case "专利类型": filtertype = new List <string> { "等于", "不等于" }; yesorno = new List <string>() { "发明专利", "实用新型", "外观专利" }; break; case "专利类型(含PCT)": filtertype = new List <string> { "等于", "不等于" }; yesorno = new List <string>() { "发明专利", "发明专利PCT", "实用新型", "实用新型PCT", "外观专利" }; break; case "申请人类型": case "主申请人类型": filtertype = new List <string> { "等于", "不等于" }; yesorno = new List <string>() { "企业", "高校", "科研单位", "事业单位", "个人" }; break; } if (col.ShownAme.IndexOf("日") >= 0) { filtertype = new List <string> { "等于", "不等于", "大于", "小于" }; } if (yesorno.Count > 0) { cmbvalue.Items.Clear(); cmbvalue.Visible = true; textBox1.Visible = false; textBox1.Text = ""; foreach (var s in yesorno) { cmbvalue.Items.Add(s); } cmbvalue.SelectedIndex = 0; } else { cmbvalue.Visible = false; textBox1.Visible = true; } foreach (var s in filtertype) { cmbFilterType.Items.Add(s); } cmbFilterType.SelectedIndex = 0; }