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