using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; namespace Pub_Control { public partial class frmBillQueryCondition_Base : Form { public frmBillQueryCondition_Base() { InitializeComponent(); } const int IDCol = 0; const int BracketLCol = 1; const int FieldNameCol = 2; const int ControlCol = 3; const int ConditionCol = 4; const int BracketRCol = 5; const int RelationCol = 6; //gridorder const Int16 OrFieldNameCol = 0; const Int16 OrDescCol = 1; //gridfield const Int16 FiNoCol = 0; const Int16 FiFieldNameCol = 1; //字段名 const Int16 FiShowCol = 2; //是否显示列 const Int16 FiDuiQiCol = 3; //对齐方式列 const Int16 FiDecCol = 4; //小数列 // public string SqlStr=""; public string FieldsArray = ""; private string mvarViewName=""; private int CopyRow=0; private string CopyField=""; private string CopyDataType = ""; private bool Copyed; public Form oFrm; public string ViewName; public string ModName; public bool bFst; Pub_Class.ClsSqlHelper oCn = new Pub_Class.ClsSqlHelper(); Clsxt_ICSchemeMain oItem = new Clsxt_ICSchemeMain(); public Pub_Class.ClsPub.Enum_BillStatus BillStatus; //是否需要显示 记账和红蓝单 //当前选中方案ID Int64 HInterID=0; //初始化 2个GRID和一个LIST 将视图加载到GRID public void SetViewName(string sViewName,bool b) { string[] tArray; DataSet Ds=new DataSet(); int j; if( Pub_Class.ClsPub.isStrNull(sViewName).Length==0) { return; } mvarViewName = sViewName; //得到视图 字段信息 Ds=oCn.RunProcReturn("select column_name,data_type from information_schema.columns where table_name ='" + ViewName.Trim() + "' order by ORDINAL_POSITION", "information"); //清空 grdCondition.RowCount = 1; grdField.RowCount = 1; grdOrder.RowCount = 1; lstOrder.Items.Clear(); // for(int i=0;i"); sCellCom.Items.Add(">="); sCellCom.Items.Add("<"); sCellCom.Items.Add("<="); sCellCom.Items.Add("<>"); sCellCom.Items.Add("包含"); sCellCom.Items.Add("左包含"); sCellCom.Items.Add("右包含"); sCellCom.Items.Add("不包含"); grdCondition.Rows[i].Cells[ControlCol] = sCellCom; //对齐列 //grdfield grdField.RowCount = i + 1; DataGridViewComboBoxCell sCellDQ = new DataGridViewComboBoxCell(); sCellDQ.FlatStyle = FlatStyle.System; sCellDQ.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing; sCellDQ.DropDownWidth = 10; sCellDQ.Items.Add("左对齐"); sCellDQ.Items.Add("居中"); sCellDQ.Items.Add("右对齐"); grdField.Rows[i].Cells[FiDuiQiCol] = sCellDQ; grdField.Rows[i].Cells[FiNoCol].Value=Convert.ToString(grdField.RowCount - 1); grdField.Rows[i].Cells[FiFieldNameCol].Value=Ds.Tables[0].Rows[i]["column_name"].ToString().Trim(); grdField.Rows[i].Cells[FiShowCol].Value = "1"; grdField.Rows[i].Cells[FiDuiQiCol].Value = "左对齐"; grdField.Rows[i].Cells[FiDecCol].Value = ""; // DataGridViewCheckBoxCell sCell = new DataGridViewCheckBoxCell(); sCell.ThreeState = false; sCell.Value = 1; grdField.Rows[i].Cells[FiShowCol] = sCell; // if (Ds.Tables[0].Rows[i]["column_name"].ToString().Trim().ToUpper().Substring(0, 1) == "H")//H开头的列隐藏 { grdCondition.Rows[i].Visible=false; grdField.Rows[i].Visible = false; } else { //gridorder lstorder lstOrder.Items.Add(Ds.Tables[0].Rows[i]["column_name"].ToString().Trim()); } } //加载方案 if (!b) { Sub_GetSchemeInfo(); } // } //读取方案信息 private void Sub_GetSchemeInfo() //Lock { //当前选中方案，若没有选中则为 默认方案,若不存在默认方案则自动新增 if (HInterID == 0) { if (oItem.ShowDefault(this.ModName)) { HInterID = oItem.HInterID; } else//不存在则 生成默认方案 { return; } } if (!oItem.ShowBill(HInterID, ref Pub_Class.ClsPub.sExeReturnInfo)) return; foreach (Clsxt_ICSchemeSub oSub in oItem.DetailColl) { //循环控件,找到则赋值 foreach (Control ct in this.tabPage1.Controls) { if (oSub.HKey.Trim().ToLower() == ct.Name.Trim().ToLower()) { if (ct.Name.Trim().ToLower().Substring(0, 3) == "txt" || ct.Name.Trim().ToLower().Substring(0, 3) == "cmb" ) { ct.Text = oSub.HValue.Trim(); } } } foreach (Control ct in this.panel8.Controls) { if (oSub.HKey.Trim().ToLower() == ct.Name.Trim().ToLower()) { if (ct.Name.Trim().ToLower().Substring(0, 3) == "txt" || ct.Name.Trim().ToLower().Substring(0, 3) == "cmb") { ct.Text = oSub.HValue.Trim(); } } } foreach (Control ct in this.panel9.Controls) { if (oSub.HKey.Trim().ToLower() == ct.Name.Trim().ToLower()) { if (ct.Name.Trim().ToLower().Substring(0, 3) == "txt" || ct.Name.Trim().ToLower().Substring(0, 3) == "cmb") { ct.Text = oSub.HValue.Trim(); } } } } //得到3个GRID try { Pub_Class.ClsSqlHelper oCn2 = new Pub_Class.ClsSqlHelper(); DataSet DSet; for (int i = 0; i < grdCondition.RowCount; i++) { DSet = oCn2.RunProcReturn("select * from Xt_grdCondition where HInterID=" + HInterID.ToString() + " and HRow=" + i, "Xt_grdCondition"); if (Pub_Class.ClsPub.isInt(DSet.Tables[0].Rows.Count) != 0) { grdCondition.Rows[i].Cells[0].Value = DSet.Tables[0].Rows[0]["HIDCol"]; grdCondition.Rows[i].Cells[1].Value = DSet.Tables[0].Rows[0]["HBracketLCol"]; grdCondition.Rows[i].Cells[2].Value = DSet.Tables[0].Rows[0]["HFieldNameCol"]; grdCondition.Rows[i].Cells[3].Value = DSet.Tables[0].Rows[0]["HControlCol"]; grdCondition.Rows[i].Cells[4].Value = DSet.Tables[0].Rows[0]["HConditionCol"]; grdCondition.Rows[i].Cells[5].Value = DSet.Tables[0].Rows[0]["HBracketRCol"]; grdCondition.Rows[i].Cells[6].Value = DSet.Tables[0].Rows[0]["HRelationCol"]; if (DSet.Tables[0].Rows[0]["HFieldNameCol"].ToString().Trim().ToUpper().Substring(0, 1) == "H")//H开头的列隐藏 { grdCondition.Rows[i].Visible = false; } else { grdCondition.Rows[i].Visible = true; } } } DSet = null; for (int i = 0; i < grdField.RowCount; i++) { DSet = oCn2.RunProcReturn("select * from Xt_grdField where HInterID=" + HInterID.ToString() + " and HRow=" + i, "Xt_grdField"); if (Pub_Class.ClsPub.isInt(DSet.Tables[0].Rows.Count) != 0) { grdField.Rows[i].Cells[0].Value = DSet.Tables[0].Rows[0]["HFiFieldName"]; grdField.Rows[i].Cells[1].Value = DSet.Tables[0].Rows[0]["HFiNo"]; grdField.Rows[i].Cells[2].Value = Pub_Class.ClsPub.isBool(DSet.Tables[0].Rows[0]["HFiShow"]); if (Pub_Class.ClsPub.isStrNull(DSet.Tables[0].Rows[0]["HFiDuiQi"]) == "") { grdField.Rows[i].Cells[3].Value = "左对齐"; } else { grdField.Rows[i].Cells[3].Value = DSet.Tables[0].Rows[0]["HFiDuiQi"]; } if (Pub_Class.ClsPub.isInt(DSet.Tables[0].Rows[0]["HDec"]) < 0 || Pub_Class.ClsPub.isInt(DSet.Tables[0].Rows[0]["HDec"]) >9) { grdField.Rows[i].Cells[4].Value = ""; } else { grdField.Rows[i].Cells[4].Value = Pub_Class.ClsPub.isInt(DSet.Tables[0].Rows[0]["HDec"]); } if (DSet.Tables[0].Rows[0]["HFiNo"].ToString().Trim().ToUpper().Substring(0, 1) == "H")//H开头的列隐藏 { grdField.Rows[i].Visible = false; } else { grdField.Rows[i].Visible = true; } } } oCn2.CnClose(); oCn2.CnDispose(); } catch (Exception e) { return; } } // private bool Sub_DeleteSchemeInfo() { if (lvScheme.FocusedItem == null) { return false; } if (lvScheme.FocusedItem.Text == "默认方案") { MessageBox.Show("不能删除默认方案！"); return false; } Int64 sInterID = Pub_Class.ClsPub.isLong(lvScheme.FocusedItem.Tag); if (sInterID != 0) { oItem.DeleteBillMain(sInterID); lvScheme.Items.RemoveAt(lvScheme.FocusedItem.Index); return true; } return false; } //保存方案 private bool Sub_SaveSchemeInfo() //Lock { if (HInterID == 0) { if (oItem.ShowDefault(this.ViewName))//保存当前选中方案，若没有选中则为 默认方案 { HInterID = oItem.HInterID; BillStatus =Pub_Class.ClsPub.Enum_BillStatus.BillStatus_Modify; } else//不存在则 生成默认方案 { BillStatus = Pub_Class.ClsPub.Enum_BillStatus.BillStatus_AddNew; } } else { BillStatus = Pub_Class.ClsPub.Enum_BillStatus.BillStatus_Modify; } //加载到类 oItem.HBillName = ModName; oItem.HBillType = oItem.MvarItemKey; oItem.HStopflag = false; oItem.HUserCode = Pub_Class.ClsPub.CurUserName; // oItem.DetailColl.Clear(); foreach (Control ct in this.tabPage1.Controls) { Clsxt_ICSchemeSub oSub = new Clsxt_ICSchemeSub(); if (ct.Name.Trim().ToLower().Substring(0, 3) == "txt" || ct.Name.Trim().ToLower().Substring(0, 3) == "cmb" ) { oSub.HKey = ct.Name.Trim(); oSub.HValue = ct.Text.Trim(); oSub.HInterID = this.HInterID; oItem.DetailColl.Add(oSub); } } foreach (Control ct in this.panel8.Controls) { Clsxt_ICSchemeSub oSub = new Clsxt_ICSchemeSub(); if (ct.Name.Trim().ToLower().Substring(0, 3) == "txt" || ct.Name.Trim().ToLower().Substring(0, 3) == "cmb") { oSub.HKey = ct.Name.Trim(); oSub.HValue = ct.Text.Trim(); oSub.HInterID = this.HInterID; oItem.DetailColl.Add(oSub); } } foreach (Control ct in this.panel9.Controls) { Clsxt_ICSchemeSub oSub = new Clsxt_ICSchemeSub(); if (ct.Name.Trim().ToLower().Substring(0, 3) == "cmb") { oSub.HKey = ct.Name.Trim(); oSub.HValue = ct.Text.Trim(); oSub.HInterID = this.HInterID; oItem.DetailColl.Add(oSub); } } // if (lvScheme.FocusedItem == null) { oItem.HName = "默认方案"; } else { oItem.HName = lvScheme.FocusedItem.Text; } if (BillStatus == Pub_Class.ClsPub.Enum_BillStatus.BillStatus_Modify) { if (!oItem.ModifyBill(HInterID, ref Pub_Class.ClsPub.sExeReturnInfo)) return false; } else if (BillStatus == Pub_Class.ClsPub.Enum_BillStatus.BillStatus_AddNew) { if (!oItem.AddBill(ref Pub_Class.ClsPub.sExeReturnInfo, HInterID)) return false; else HInterID = oItem.HInterID; } else { return false; } //保存3个GRID try { Pub_Class.ClsSqlHelper oCn1 = new Pub_Class.ClsSqlHelper(); oCn1.RunProc("delete Xt_grdCondition where HInterID=" + HInterID.ToString()); for (int i = 0; i < grdCondition.RowCount; i++) { oCn1.RunProc("Insert Into Xt_grdCondition " + "(HInterID,HUserID,HBillName,HRow,HIDCol,HBracketLCol,HFieldNameCol,HControlCol" + ",HConditionCol,HBracketRCol,HRelationCol" + ") " + " values(" + HInterID.ToString() + ",'" + Pub_Class.ClsPub.CurUserName + "','" + ViewName.Trim() + "'," + i + ",'" + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[0].Value) + "'" + ",'" + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[1].Value) + "'" + ",'" + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[2].Value) + "'" + ",'" + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[3].Value) + "'" + ",'" + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[4].Value).Replace("'", "''") + "'" + ",'" + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[5].Value).Replace("'", "''") + "'" + ",'" + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[6].Value) + "')"); } oCn1.RunProc("delete Xt_grdField where HinterID=" + HInterID.ToString()); for (int i = 0; i < grdField.RowCount; i++) { oCn1.RunProc("Insert Into Xt_grdField " + "(HInterID,HUserID,HBillName,HRow,HFiFieldName,HFiNo,HFiShow,HFiDuiQi" + ") " + " values("+HInterID.ToString()+",'" + Pub_Class.ClsPub.CurUserName + "','" + ViewName.Trim() + "'," + i + ",'" + Pub_Class.ClsPub.isStrNull(grdField.Rows[i].Cells[0].Value) + "'" + ",'" + Pub_Class.ClsPub.isStrNull(grdField.Rows[i].Cells[1].Value) + "'" + "," + Convert.ToString(Pub_Class.ClsPub.isBool(grdField.Rows[i].Cells[2].Value) ? 1 : 0) + ",'"+Pub_Class.ClsPub.isStrNull(grdField.Rows[i].Cells[3].Value)+"'"+ ")"); } oCn1.CnClose(); oCn1.CnDispose(); return true; } catch (Exception e) { Pub_Class.ClsPub.sExeReturnInfo = Pub_Class.ClsPub.sExeReturnInfo + e.Message; return false; } } //取消 private void cmdCancel_Click(object sender, EventArgs e) { this.Tag = "CANCEL"; //Sub_SaveSchemeInfo(); this.Visible = false; } private string GetShowItem()//Lock { string sSql = ""; for (int i = 0; i < grdField.RowCount; i++) { if (grdField.Rows[i].Visible == false || Pub_Class.ClsPub.isBool(grdField.Rows[i].Cells[FiShowCol].Value) != false) { sSql = sSql + ",[" + Pub_Class.ClsPub.isStrNull(grdField.Rows[i].Cells[FiFieldNameCol].Value) + "]"; } } if (sSql.Trim() == "") { return "*"; } else { return sSql.Trim().Substring(1, sSql.Trim().Length - 1); } } //得到过滤条件和排序条件 private bool GetSql()//Lock { string tSql = ""; string tFilter = ""; string sEngCondi = ""; string sLinkCondi = ""; FieldsArray = tSql; //得到显示项目 string HeadSql = ""; HeadSql=GetShowItem(); // long ShowCount = 0; if (Pub_Class.ClsPub.isLong(txtHShowCount.Text) < 1) { ShowCount = 1; } else { ShowCount = Pub_Class.ClsPub.isLong(txtHShowCount.Text); } // tSql = "select Top " + ShowCount.ToString() + " " + HeadSql + " from " + mvarViewName.Trim() + " Where 1=1 "; for (int i = 0; i < grdCondition.RowCount; i++) { sEngCondi = CHStoENG(Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[3].Value)); sLinkCondi = CHStoENG(Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[6].Value)); // and or if (sEngCondi.Trim().Length != 0) { switch (sEngCondi.Trim().ToUpper()) { case "LIKE": tFilter = tFilter + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[1].Value) + " [" + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[2].Value) + "] " + " LIKE '%" + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[4].Value).Trim().Replace("'", "''") + "%' " + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[5].Value) + " " + sLinkCondi.Trim() + " "; break; case "NOLIKE": tFilter = tFilter + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[1].Value) + " [" + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[2].Value) + "] " + " NOT LIKE '%" + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[4].Value).Trim().Replace("'", "''") + "%' " + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[5].Value) + " " + sLinkCondi.Trim() + " "; break; case "LIKEL": tFilter = tFilter + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[1].Value) + " [" + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[2].Value) + "] " + " LIKE '" + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[4].Value).Trim().Replace("'", "''") + "%' " + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[5].Value) + " " + sLinkCondi.Trim() + " "; break; case "LIKER": tFilter = tFilter + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[1].Value) + " [" + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[2].Value) + "] " + " LIKE '%" + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[4].Value).Trim().Replace("'", "''") + "' " + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[5].Value) + " " + sLinkCondi.Trim() + " "; break; default: switch (Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[0].Value).Trim().ToUpper()) { case "BIT": tFilter = tFilter + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[1].Value) + " [" + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[2].Value) + "] " + sEngCondi + " " + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[4].Value).Trim() + " " + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[5].Value) + " " + sLinkCondi.Trim() + " "; break; case "MONEY": tFilter = tFilter + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[1].Value) + " [" + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[2].Value) + "] " + sEngCondi + "" + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[4].Value) + " " + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[5].Value) + " " + sLinkCondi.Trim() + " "; break; case "DECIMAL": tFilter = tFilter + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[1].Value) + " [" + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[2].Value) + "] " + sEngCondi + "" + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[4].Value) + " " + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[5].Value) + " " + sLinkCondi.Trim() + " "; break; default: tFilter = tFilter + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[1].Value) + " [" + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[2].Value) + "] " + sEngCondi + "'" + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[4].Value) + "' " + Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[5].Value) + " " + sLinkCondi.Trim() + " "; break; } break; } } else { if (Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[1].Value).Trim().Length != 0 || Pub_Class.ClsPub.isStrNull(grdCondition.Rows[i].Cells[5].Value).Trim().Length != 0) { MessageBox.Show("第" + i.ToString() + "行没有条件,不应该有括号出现,请取消此括号！", "提示"); return false; } } } if (tFilter.Trim().Length != 0) { tFilter = tFilter.Substring(0, tFilter.Trim().Length - 3); SqlStr = tSql + " AND " + tFilter; } else { SqlStr = tSql; } //审核 if (cmbCheck.Text.Trim() != "全部") { if (cmbCheck.Text.ToString() == "已审") { SqlStr = SqlStr + " AND 审核人<>''"; } else { SqlStr = SqlStr + " AND 审核人=''"; } } //关闭 if (cmbClose.Text.Trim() != "全部") { if (cmbClose.Text.ToString() == "已关闭") { SqlStr = SqlStr + " AND 关闭人<>''"; } else { SqlStr = SqlStr + " AND 关闭人=''"; } } //作废 if (cmbDelete.Text.Trim() != "全部") { if (cmbDelete.Text.ToString() == "作废") { SqlStr = SqlStr + " AND 作废人<>''"; } else { SqlStr = SqlStr + " AND 作废人=''"; } } //时间 if(cmbTime.Text.Trim()!="全部") { if (cmbTime.Text.Trim() == "本日") { SqlStr = SqlStr + " AND DATEDIFF(dd, 日期, getdate())=0 "; } else if (cmbTime.Text.Trim() == "本周") { SqlStr = SqlStr + " AND DATEDIFF(week,日期,getdate())=0 "; } else if (cmbTime.Text.Trim() == "本期") { SqlStr = SqlStr + " AND DATEDIFF(month,日期,getdate())=0 "; } else if (cmbTime.Text.Trim() == "上一周") { SqlStr = SqlStr + " AND 日期 between convert(varchar(10),dateadd(d,-7,getdate()),120) and convert(varchar(10),getdate(),120) "; } else if (cmbTime.Text.Trim() == "下一周") { SqlStr = SqlStr + " AND 日期 between convert(varchar(10),getdate(),120) and convert(varchar(10),dateadd(d,7,getdate()),120) "; } else { } } return true; } //确认 private void cmdOk_Click(object sender, EventArgs e) { Sub_SaveSchemeInfo(); if (GetSql()) { this.Tag = "OK"; this.Visible=false; } } //初始化网格 private void initGrid() { // grdCondition.RowTemplate.Height = 18; grdCondition.RowTemplate.MinimumHeight = 18; grdCondition.ColumnHeadersHeight = 35; grdCondition.RowHeadersVisible = false; grdCondition.ColumnHeadersVisible = true; grdCondition.ColumnCount = 7; grdCondition.RowCount = 1; grdCondition.EnableHeadersVisualStyles = false; grdCondition.AllowUserToAddRows = false; //是否允许自增--否 grdCondition.AllowUserToDeleteRows = false; //是否允许删除--否 grdCondition.AllowUserToResizeColumns = true; //允许调整列宽--是 grdCondition.AllowUserToResizeRows = false; //允许调整行高--否 grdCondition.AllowUserToOrderColumns = false; grdCondition.GridColor = Color.LightGray; grdCondition.Columns[BracketLCol].HeaderText = "左括号"; grdCondition.Columns[FieldNameCol].HeaderText = "字段名称"; grdCondition.Columns[ControlCol].HeaderText = "比较关系"; grdCondition.Columns[ConditionCol].HeaderText = "数值"; grdCondition.Columns[BracketRCol].HeaderText = "右括号"; grdCondition.Columns[RelationCol].HeaderText = "逻辑"; // grdCondition.EditMode = DataGridViewEditMode.EditOnEnter; //编辑模式 grdCondition.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft; grdCondition.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; grdCondition.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing; //允许用户调整列宽 grdCondition.Columns[IDCol].Visible = false; grdCondition.Columns[BracketLCol].Width = 50; grdCondition.Columns[FieldNameCol].Width = 120; grdCondition.Columns[ControlCol].Width = 60; grdCondition.Columns[ConditionCol].Width = 90; grdCondition.Columns[BracketRCol].Width = 50; grdCondition.Columns[RelationCol].Width = 50; for (int i = 0; i < grdCondition.ColumnCount; i++) { grdCondition.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable; } //grdCondition.set_ColWidth(BracketLCol, 700); //grdCondition.set_ColWidth(FieldNameCol, 1500); //grdCondition.set_ColWidth(ControlCol, 800); //grdCondition.set_ColWidth(ConditionCol, 1500); //grdCondition.set_ColWidth(BracketRCol, 800); //grdCondition.set_ColWidth(RelationCol, 500); //grdorder //grdOrder.Cols =2; //grdOrder.Rows = 1; //grdOrder.set_TextMatrix(0, OrFieldNameCol, "排序字段"); //grdOrder.set_TextMatrix(0, OrDescCol, "升降序"); //grdOrder.set_ColComboList(OrDescCol, "升序|降序"); //grdOrder.Editable = VSFlex7.EditableSettings.flexEDKbdMouse; //grdOrder.set_FixedAlignment(-1, VSFlex7.AlignmentSettings.flexAlignCenterCenter); //grdOrder.ExtendLastCol = false; //grdOrder.RowHeightMin = 280; //grdOrder.set_RowHeight(0, 450); //grdOrder.set_ColWidth(OrFieldNameCol, 1500); //grdOrder.set_ColWidth(OrDescCol, 1500); //grdfield // grdField.RowTemplate.Height = 18; grdField.RowTemplate.MinimumHeight = 18; grdField.ColumnHeadersHeight = 35; grdField.RowHeadersVisible = false; grdField.ColumnHeadersVisible = true; grdField.ColumnCount = 5; grdField.RowCount = 1; grdField.Columns[FiFieldNameCol].HeaderText = "字段名称"; grdField.Columns[FiNoCol].HeaderText = "序号"; grdField.Columns[FiShowCol].HeaderText = "显示"; grdField.Columns[FiDuiQiCol].HeaderText = "对齐方式"; grdField.EnableHeadersVisualStyles = false; grdField.AllowUserToAddRows = false; //是否允许自增--否 grdField.AllowUserToDeleteRows = false; //是否允许删除--否 grdField.AllowUserToResizeColumns = true; //允许调整列宽--是 grdField.AllowUserToResizeRows = false; //允许调整行高--否 grdField.AllowUserToOrderColumns = false; grdField.GridColor = Color.LightGray; // grdField.ReadOnly = false; grdField.EditMode = DataGridViewEditMode.EditOnEnter; //编辑模式 grdField.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; grdField.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; grdField.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing; //允许用户调整列宽 // grdField.Columns[FiFieldNameCol].Width = 150; grdField.Columns[FiNoCol].Width = 50; grdField.Columns[FiShowCol].Width = 100; for (int i = 0; i < grdField.ColumnCount; i++) { grdField.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable; } } //将中文转为英文 private string CHStoENG(string sCHS) { switch (sCHS) { case "包含": return "LIKE"; case "左包含": return "LIKEL"; case "右包含": return "LIKER"; case "不包含": return "NOLIKE"; case "并且": return "AND"; case "或者": return "OR"; default: return sCHS; } } //初始化 private void frmBillQueryCondition_Base_Load(object sender, EventArgs e) { this.cmbCheck.Text = "全部"; this.cmbClose.Text = "全部"; this.cmbDelete.Text = "全部"; this.cmbTime.Text = "全部"; this.cmbHComplete.Text = "是"; tabControl1.TabPages.Remove(tabPage2); initGrid(); } //初始化2 private void timer1_Tick(object sender, EventArgs e) { timer1.Enabled = false; //加载方案 SetScheme(); // SetViewName(ViewName,false); // if (bFst) { //当第一次加载时，判断是否默认方案 if (cmbDefault.Text == "是") { cmdOk_Click(sender, e); } } } // //获取 方案项目 private void SetScheme() { lvScheme.Items.Clear(); ListViewItem oSub = new ListViewItem(); oSub.Tag = 0; oSub.Text = "默认方案"; oSub.ImageIndex = 0; lvScheme.Items.Add(oSub); // if (oItem.GetBillList(this.ModName, ref Pub_Class.ClsPub.sExeReturnInfo)) { foreach (Clsxt_ICSchemeMain oMain in oItem.MainColl) { ListViewItem oSub2 = new ListViewItem(); oSub2.Tag = oMain.HInterID; oSub2.Text = oMain.HName; oSub2.ImageIndex = 0; lvScheme.Items.Add(oSub2); } } // } //加括号 private void cmdBracket_Click(object sender, EventArgs e) { int BRow = -1, ERow = 0; if (grdCondition.SelectedCells == null || grdCondition.SelectedCells.Count==0) { return; } //找最大行，最小行 for (int i = 0; i < grdCondition.SelectedCells.Count; i++) { if (grdCondition.SelectedCells[i].RowIndex > ERow) { ERow = grdCondition.SelectedCells[i].RowIndex; } if (BRow == -1) { BRow = grdCondition.SelectedCells[i].RowIndex; } else { if (grdCondition.SelectedCells[i].RowIndex < BRow) { BRow = grdCondition.SelectedCells[i].RowIndex; } } } // if (BRow != -1) { grdCondition.Rows[BRow].Cells[BracketLCol].Value = Pub_Class.ClsPub.isStrNull(grdCondition.Rows[BRow].Cells[BracketLCol].Value) + "("; grdCondition.Rows[ERow].Cells[BracketRCol].Value = Pub_Class.ClsPub.isStrNull(grdCondition.Rows[ERow].Cells[BracketRCol].Value) + ")"; } } //减括号 private void cmdUNBracket_Click(object sender, EventArgs e) { int BRow = -1, ERow = 0; if (grdCondition.SelectedCells == null || grdCondition.SelectedCells.Count == 0) { return; } //找最大行，最小行 for (int i = 0; i < grdCondition.SelectedCells.Count; i++) { if (grdCondition.SelectedCells[i].RowIndex > ERow) { ERow = grdCondition.SelectedCells[i].RowIndex; } if (BRow == -1) { BRow = grdCondition.SelectedCells[i].RowIndex; } else { if (grdCondition.SelectedCells[i].RowIndex < BRow) { BRow = grdCondition.SelectedCells[i].RowIndex; } } } // if(Pub_Class.ClsPub.isStrNull(grdCondition.Rows[BRow].Cells[BracketLCol].Value)!="" && Pub_Class.ClsPub.isStrNull(grdCondition.Rows[ERow].Cells[BracketRCol].Value)!="" ) { string s; s = Pub_Class.ClsPub.isStrNull(grdCondition.Rows[BRow].Cells[BracketLCol].Value); grdCondition.Rows[BRow].Cells[BracketLCol].Value = s.Substring(0, s.Length - 1); s = ""; s = Pub_Class.ClsPub.isStrNull(grdCondition.Rows[ERow].Cells[BracketRCol].Value); grdCondition.Rows[ERow].Cells[BracketRCol].Value = s.Substring(0, s.Length - 1); } else { if (Pub_Class.ClsPub.isStrNull(grdCondition.Rows[BRow].Cells[BracketLCol].Value) == "") { MessageBox.Show("选择的第一行没有括号！", "提示"); } else { MessageBox.Show("选择的最后一行没有括号！", "提示"); } } } //复制 private void cmdCopy_Click(object sender, EventArgs e) { if (grdCondition.CurrentRow!=null) { CopyField =Pub_Class.ClsPub.isStrNull(grdCondition.Rows[grdCondition.CurrentRow.Index].Cells[FieldNameCol].Value); CopyDataType = Pub_Class.ClsPub.isStrNull(grdCondition.Rows[grdCondition.CurrentRow.Index].Cells[IDCol].Value); cmdPaste.Enabled = true; } } //黏贴 private void cmdPaste_Click(object sender, EventArgs e) { grdCondition.Rows.Insert(grdCondition.CurrentRow.Index,1); // grdCondition.Rows[grdCondition.CurrentRow.Index-1].Cells[IDCol].Value=CopyDataType; grdCondition.Rows[grdCondition.CurrentRow.Index-1].Cells[FieldNameCol].Value= CopyField; // DataGridViewComboBoxCell sCellRel = new DataGridViewComboBoxCell(); sCellRel.FlatStyle = FlatStyle.System; sCellRel.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing; sCellRel.DropDownWidth = 10; sCellRel.Items.Add("并且"); sCellRel.Items.Add("或者"); grdCondition.Rows[grdCondition.CurrentRow.Index - 1].Cells[RelationCol] = sCellRel; grdCondition.Rows[grdCondition.CurrentRow.Index - 1].Cells[RelationCol].Value = "并且"; // DataGridViewComboBoxCell sCellCom = new DataGridViewComboBoxCell(); sCellCom.FlatStyle = FlatStyle.System; sCellCom.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing; sCellCom.DropDownWidth = 10; sCellCom.Items.Add(" "); sCellCom.Items.Add("="); sCellCom.Items.Add(">"); sCellCom.Items.Add(">="); sCellCom.Items.Add("<"); sCellCom.Items.Add("<="); sCellCom.Items.Add("<>"); sCellCom.Items.Add("包含"); sCellCom.Items.Add("左包含"); sCellCom.Items.Add("右包含"); sCellCom.Items.Add("不包含"); grdCondition.Rows[grdCondition.CurrentRow.Index - 1].Cells[ControlCol] = sCellCom; // } //删除 private void cmdDelete_Click(object sender, EventArgs e) { if (grdCondition.CurrentRow!=null) { //if (ClsPub.isStrNull(grdCondition.get_TextMatrix(grdCondition.Row, BracketLCol)) != "" // || ClsPub.isStrNull(grdCondition.get_TextMatrix(grdCondition.Row, BracketRCol)) != "") //{ // MessageBox.Show("被删除行不能有括号！", "提示"); // return; //} grdCondition.Rows.RemoveAt(grdCondition.CurrentRow.Index); } } //恢复 private void cmdRestore_Click(object sender, EventArgs e) { SetViewName(ViewName,true); } private void bc_Click(object sender, EventArgs e) { if (lvScheme.FocusedItem == null) { MessageBox.Show("没有选中方案!"); return; } if (MessageBox.Show("确定要保存当前方案到数据库？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.Cancel) { return; } Int64 sInterID = 0; sInterID = Pub_Class.ClsPub.isLong(lvScheme.FocusedItem.Tag); if (sInterID == 0) { MessageBox.Show("错误的方案!"); return; } HInterID = sInterID; Sub_SaveSchemeInfo(); } private void sc_Click(object sender, EventArgs e) { if (MessageBox.Show("确定要删除当前项目？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.Cancel) { return; } Sub_DeleteSchemeInfo(); } //private void grdField_BeforeEdit(object sender, AxVSFlex7._IVSFlexGridEvents_BeforeEditEvent e) //{ // if (e.col != FiShowCol) // { // e.cancel = true; // } //} private void cmdAllSelect_Click(object sender, EventArgs e) { for (int i = 0; i < grdField.RowCount; i++) { grdField.Rows[i].Cells[FiShowCol].Value = true; } } private void cmdAllClear_Click(object sender, EventArgs e) { for (int i = 0; i < grdField.RowCount; i++) { grdField.Rows[i].Cells[FiShowCol].Value = false; } } //加载到GRID private void LoadToGrid() { //if (lstOrder.SelectedIndex >= 0) //{ // //是否存在 // string sSelectItem = ""; // sSelectItem=lstOrder.Items[lstOrder.SelectedIndex].ToString(); // for (int i = grdOrder.FixedRows; i < grdOrder.Rows; i++) // { // if (ClsPub.isStrNull(grdOrder.get_TextMatrix(i, OrFieldNameCol)) == sSelectItem) // { // MessageBox.Show("您选择的项目已存在！"); // return; // } // } // //加载到GRID // grdOrder.AddItem(""); // grdOrder.set_TextMatrix(grdOrder.Rows - 1, OrFieldNameCol, sSelectItem); // grdOrder.set_TextMatrix(grdOrder.Rows - 1, OrDescCol, "升序"); // grdOrder.set_ColComboList(OrDescCol, "升序|降序"); //} } // private void cmdAddNew_Click(object sender, EventArgs e) { LoadToGrid(); } private void lstOrder_DoubleClick(object sender, EventArgs e) { LoadToGrid(); } private void cmdDel_Click(object sender, EventArgs e) { if (grdOrder.CurrentRow!=null) { grdOrder.Rows.RemoveAt(grdOrder.CurrentRow.Index); } } private void grdCondition_KeyDown(object sender, KeyEventArgs e) { Sub_GridKeyView(e.KeyValue, grdCondition.CurrentRow.Index, grdCondition.CurrentCell.ColumnIndex, grdCondition, EditingControl); } private void grdField_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e) { if (grdField.CurrentCell.ColumnIndex != FiShowCol && grdField.CurrentCell.ColumnIndex != FiDuiQiCol) { e.Cancel = true; } else { // } } private void grdCondition_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e) { if (grdCondition.CurrentCell.ColumnIndex != ControlCol && grdCondition.CurrentCell.ColumnIndex != ConditionCol && grdCondition.CurrentCell.ColumnIndex != RelationCol) { e.Cancel = true; } else { // } } DataGridViewTextBoxEditingControl EditingControl; private void EditingControl_KeyDown(object sender, KeyEventArgs e) { //业务处理 Sub_GridKeyView(e.KeyValue, grdCondition.CurrentRow.Index, grdCondition.CurrentCell.ColumnIndex, grdCondition, EditingControl); } private void grdCondition_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e) { if (grdCondition.CurrentCell != null) { if (e.Control is DataGridViewTextBoxEditingControl) { this.EditingControl = (DataGridViewTextBoxEditingControl)e.Control; //增加委托处理 this.EditingControl.KeyDown += new KeyEventHandler(this.EditingControl_KeyDown); } } } private void grdCondition_CellEndEdit(object sender, DataGridViewCellEventArgs e) { if (this.EditingControl != null) { EditingControl.KeyDown -= new KeyEventHandler(this.EditingControl_KeyDown); this.EditingControl = null; } } public virtual void Sub_GridKeyView(int sKeyCode, int sRow, int sCol, DataGridView grdCondition,DataGridViewTextBoxEditingControl oEdit) { // } private void cmdUp2_Click(object sender, EventArgs e) { if (grdField.CurrentRow == null) return; if (grdField.CurrentRow.Index > 0) { } } private void cmdDown2_Click(object sender, EventArgs e) { } private void cmdUp_Click(object sender, EventArgs e) { } private void cmdDown_Click(object sender, EventArgs e) { } frm_SetName ofrmDlg = new frm_SetName(); //新增方案 private void xz_Click(object sender, EventArgs e) { //弹出框 设置方案名字 ofrmDlg.ShowDialog(); if (ofrmDlg.isOk) { string s = ""; Int64 sInterID=0; s = ofrmDlg.txtHName.Text; //判断方案名是否重复 for (int i = 0; i < lvScheme.Items.Count; i++) { if (s.Trim() == lvScheme.Items[i].Text.Trim()) { MessageBox.Show("已存在相同的方案名,请重新录入！"); return; } } // sInterID = Pub_Class.ClsPub.CreateBillID("0001", ref Pub_Class.ClsPub.sExeReturnInfo); //获取新ID if (s.Trim() != "" && sInterID !=0) { ListViewItem oSub = new ListViewItem(); oSub.Tag = sInterID; oSub.Text = s; oSub.ImageIndex = 0; lvScheme.Items.Add(oSub); } } } //选择方案 改变时 private void lvScheme_SelectedIndexChanged(object sender, EventArgs e) { if (lvScheme.FocusedItem == null) { return; } Int64 sInterID = 0; sInterID = Pub_Class.ClsPub.isLong(lvScheme.FocusedItem.Tag); HInterID = sInterID; SetViewName(ViewName, false); } } }