private void button1_Click(object sender, EventArgs e) { SqlStr sqls = SqlStr.newSql();//进行过滤的条件 if (this.selTextInpt1.Value == null || this.selTextInpt1.Value.Trim() == "") { WJs.alert("请选择一个科室!"); selTextInpt1.Focus(); return; } DataRow dr1 = EQKind_ytTreeView.getSelectRow(); if (EQKind_ytTreeView.SelectedNode != EQKind_ytTreeView.Nodes[0]) { sqls.Add(" AND EQID IN (SELECT EQID FROM LKEQ.DICTEQ WHERE KINDCODE= " + dr1["KINDCODE"].ToString() + ")"); } if (this.dateTimePicker1.Value.CompareTo(this.dateTimePicker2.Value) > 0) { WJs.alert("起始日期必须小于末尾日期!"); return; } //select * from LKEQ.EQCARDREC WHERE CHOSCODE =? AND DEPTID=? [Condition] AND OUTDATE>? AND OUTDATE <? this.dataGView1.reLoad(new object[] { His.his.Choscode, this.selTextInpt1.Value, dateTimePicker1.Value, dateTimePicker2.Value }, sqls); this.dataGView1.setFocus(0, 1); dataGView1_SelectionChanged(null, null); }
//查询 private void button1_Click(object sender, EventArgs e) { SqlStr sqls = SqlStr.newSql();//进行过滤的条件 if (this.selTextInpt1.Value == null || this.selTextInpt1.Value.Trim() == "") { WJs.alert("请选择一个科室!"); selTextInpt1.Focus(); return; } DataRow dr1 = EQKind_ytTreeView.getSelectRow(); DataRow dr2 = UseStatus_ytTreeView.getSelectRow(); if (EQKind_ytTreeView.SelectedNode != EQKind_ytTreeView.Nodes[0]) { sqls.Add(" AND EQID IN (SELECT EQID FROM LKEQ.DICTEQ WHERE KINDCODE= " + dr1["KINDCODE"].ToString() + ")"); } if (UseStatus_ytTreeView.SelectedNode != UseStatus_ytTreeView.Nodes[0]) { sqls.Add(" AND STATUSCODE=" + dr2["STATUSCODE"].ToString()); } if (this.ytComboBox1.SelectedIndex == 0) { sqls.Add(" AND STATUS=0 "); } if (this.ytComboBox1.SelectedIndex == 1) { sqls.Add(" AND STATUS=1 "); } if (this.ytComboBox1.SelectedIndex == 2) { sqls.Add(" AND STATUS=2 "); } if (this.ytComboBox1.SelectedIndex == 3) { sqls.Add(" AND STATUS=6 "); } if (this.ytComboBox1.SelectedIndex == 4) { sqls.Add(" AND STATUS=7 "); } else { sqls.Add(" AND 1=1 "); } this.dataGView1.reLoad(new object[] { this.selTextInpt1.Value, His.his.Choscode.ToString() }, sqls); this.TiaoSu.Text = this.dataGView1.RowCount.ToString() + "笔"; this.JinEHeJi.Text = this.dataGView1.Sum("价格").ToString() + "元"; this.label6.Text = this.dataGView1.Sum("原值").ToString() + "元"; }
public EQUseManag() { InitializeComponent(); //这个是从共享建卡过来的 this.selTextInpt1.Sql = "FindDeptidInCard"; this.selTextInpt1.SelParam = His.his.Choscode + "|{key}|{key}|{key}"; EQKind_ytTreeView.vFiled = "KINDCODE"; EQKind_ytTreeView.tFiled = "KINDNAME"; EQKind_ytTreeView.pFiled = "SUPERCODE"; EQKind_ytTreeView.pValue = ""; EQKind_ytTreeView.sql = "FindEQKindInCard"; EQKind_ytTreeView.FormatText += new YtWinContrl.com.events.TextFormatEventHandle(EQKind_ytTreeView_FormatText); EQKind_ytTreeView.reLoad(new object[] { His.his.Choscode.ToString() }); }
public EQChangeManag() { InitializeComponent(); this.selTextInpt1.Sql = "FindDeptidInCard"; this.selTextInpt1.SelParam = His.his.Choscode + "|{key}|{key}|{key}"; EQKind_ytTreeView.vFiled = "KINDCODE"; EQKind_ytTreeView.tFiled = "KINDNAME"; EQKind_ytTreeView.pFiled = "SUPERCODE"; EQKind_ytTreeView.pValue = ""; EQKind_ytTreeView.sql = "FindEQKindInCard"; EQKind_ytTreeView.FormatText += new YtWinContrl.com.events.TextFormatEventHandle(EQKind_ytTreeView_FormatText); EQKind_ytTreeView.reLoad(new object[] { His.his.Choscode.ToString() }); //从设备使用共享过来 this.dataGView1.Url = "LoadZhuBiaoInfoSelect_EQUseManag"; this.dataGView2.Url = "LoadXiBiaoInfoIn_EQChangeManag"; }
public EQKeepFitManag() { InitializeComponent(); this.selTextInpt1.Sql = "EQKeep_FindKSID"; this.selTextInpt1.SelParam = His.his.Choscode + "|{key}|{key}|{key}"; //this.dateDuanSel1.Start = DateTime.Now.AddMonths(-1); //this.dateDuanSel1.End = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 23, 59, 59); EQKind_ytTreeView.vFiled = "KINDCODE"; EQKind_ytTreeView.tFiled = "KINDNAME"; EQKind_ytTreeView.pFiled = "SUPERCODE"; EQKind_ytTreeView.pValue = ""; EQKind_ytTreeView.sql = "FindEQKindInCard"; EQKind_ytTreeView.FormatText += new YtWinContrl.com.events.TextFormatEventHandle(EQKind_ytTreeView_FormatText); EQKind_ytTreeView.reLoad(new object[] { His.his.Choscode.ToString() }); this.dataGView1.Url = "LoadZhuBiaoInfoSelect_EQKeepFit"; this.dataGView2.Url = "LoadXiBiaoInfoSelect_EQKeepFit"; }
void ReLoad() { EQKind_ytTreeView.reLoad(new object[] { His.his.Choscode.ToString() }); UseStatus_ytTreeView.reLoad(new object[] { His.his.Choscode.ToString() }); }