private void butref_Click(object sender, System.EventArgs e)
{
try
{
if (chkghdw.Checked == false && chkdjh.Checked == false && chkdjsj.Checked == false && rdo2.Checked == true)
{
MessageBox.Show("查询的记录范围太大，请重新选择查询条件"); return;
}
if (txtghdw.Text.Trim() == "" && txtghdw.Enabled == true)
{
MessageBox.Show("请输入药房名称"); return;
}
if (txtdjh.Text.Trim() == "" && txtdjh.Enabled == true)
{
MessageBox.Show("请输入单据号"); return;
}
ParameterEx[] parameters = new ParameterEx[11];
parameters[0].Value = _menuTag.FunctionTag.Trim();
parameters[1].Value = this.chkghdw.Checked == true?Convert.ToInt32(this.txtghdw.Tag) : 0;
parameters[2].Value = chkdjsj.Checked == true?dtp1.Value.ToShortDateString() : "";
parameters[3].Value = chkdjsj.Checked == true?dtp2.Value.ToShortDateString() : "";
parameters[4].Value = chkdjh.Checked == true?Convert.ToInt64(Convertor.IsNull(txtdjh.Text, "0")) : 0;
parameters[5].Value = "";
parameters[6].Value = "";
parameters[7].Value = this.rdo1.Checked == true?0:1;
parameters[8].Value = Convert.ToInt32(Convertor.IsNull(cmbck.SelectedValue, "0"));
parameters[9].Value = _menuTag.Function_Name.Trim();
parameters[10].Value = InstanceForm.BCurrentDept.DeptId;
parameters[0].Text = "@ywlx";
parameters[1].Text = "@wldw";
parameters[2].Text = "@dtp1";
parameters[3].Text = "@dtp2";
parameters[4].Text = "@djh";
parameters[5].Text = "@fph";
parameters[6].Text = "@shdh";
parameters[7].Text = "@shbz";
parameters[8].Text = "@deptid";
parameters[9].Text = "@functionname";
parameters[10].Text = "@p_deptid";
DataTable tb = InstanceForm.BDatabase.GetDataTable("sp_yk_selectDj", parameters, 30);
FunBase.AddRowtNo(tb);
tb.TableName = "Tb";
this.myDataGrid1.DataSource = tb;
FunBase.myGridSelect(this.myDataGrid1, this.myDataGrid1.TableStyles[0].GridColumnStyles);
}
catch (System.Exception err)
{
MessageBox.Show(err.ToString());
}
}
private void Frmzjtc_Load(object sender, System.EventArgs e)
{
try
{
FunBase.CsDataGrid(this.myDataGrid1, this.myDataGrid1.TableStyles[0], "Tb");
FunBase.CsDataGrid(this.myDataGrid2, this.myDataGrid2.TableStyles[0], "Tbmx");
FunBase.myGridSelect(this.myDataGrid1, this.myDataGrid1.TableStyles[0].GridColumnStyles);
this.AddDataMydataGrid1(0);
}
catch (System.Exception err)
{
MessageBox.Show("发生错误" + err.Message);
}
}
private void butref_Click(object sender, System.EventArgs e)
{
try
{
if (txtdjh.Text.Trim() == "" && txtdjh.Enabled == true)
{
MessageBox.Show("请输入单据号"); return;
}
ParameterEx[] parameters = new ParameterEx[11];
parameters[0].Value = _menuTag.FunctionTag.Trim();
parameters[1].Value = 0;
parameters[2].Value = chkdjsj.Checked == true?dtp1.Value.ToShortDateString() : "";
parameters[3].Value = chkdjsj.Checked == true?dtp2.Value.ToShortDateString() : "";
parameters[4].Value = chkdjh.Checked == true?Convert.ToInt64(Convertor.IsNull(txtdjh.Text, "0")) : 0;
parameters[5].Value = "";
parameters[6].Value = "";
parameters[7].Value = 1;
parameters[8].Value = InstanceForm.BCurrentDept.DeptId;
parameters[9].Value = _menuTag.Function_Name;
parameters[10].Value = 0;
parameters[0].Text = "@ywlx";
parameters[1].Text = "@wldw";
parameters[2].Text = "@dtp1";
parameters[3].Text = "@dtp2";
parameters[4].Text = "@djh";
parameters[5].Text = "@fph";
parameters[6].Text = "@shdh";
parameters[7].Text = "@shbz";
parameters[8].Text = "@deptid";
parameters[9].Text = "@functionname";
parameters[10].Text = "@P_deptid";
DataTable tb = InstanceForm.BDatabase.GetDataTable("sp_yf_selectDj", parameters, 30);
FunBase.AddRowtNo(tb);
tb.TableName = "Tb";
this.myDataGrid1.DataSource = tb;
FunBase.myGridSelect(this.myDataGrid1, this.myDataGrid1.TableStyles[0].GridColumnStyles);
this.dataGridTableStyle1.ForeColor = System.Drawing.Color.FromArgb(((System.Byte)(0)), ((System.Byte)(0)), ((System.Byte)(192)));
}
catch (System.Exception err)
{
MessageBox.Show(err.ToString());
}
}
public Frmcffy_cx()
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
FunBase.CsDataGrid(this.myDataGrid1, this.myDataGrid1.TableStyles[0], "tb");
FunBase.CsDataGrid(this.myDataGrid2, this.myDataGrid2.TableStyles[0], "tbmx");
FunBase.myGridSelect(this.myDataGrid1, this.myDataGrid1.TableStyles[0].GridColumnStyles);
this.Text = this.Text + " [" + InstanceForm._menuTag.Jgbm + "]";
//
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
//
}
private void butref_Click(object sender, System.EventArgs e)
{
try
{
ParameterEx[] parameters = new ParameterEx[11];
parameters[0].Text = "@ywlx";
parameters[0].Value = _menuTag.FunctionTag.Trim();
parameters[1].Text = "@wldw";
parameters[1].Value = 0;
parameters[2].Text = "@dtp1";
parameters[2].Value = chkdjsj.Checked == true?dtp1.Value.ToShortDateString() : "";
parameters[3].Text = "@dtp2";
parameters[3].Value = chkdjsj.Checked == true?dtp2.Value.ToShortDateString() : "";
parameters[4].Text = "@djh";
parameters[4].Value = 0;
parameters[5].Text = "@fph";
parameters[5].Value = "";
parameters[6].Text = "@shdh";
parameters[6].Value = "";
parameters[7].Text = "@shbz";
parameters[7].Value = this.rdo1.Checked == true?0:1;
parameters[8].Text = "@deptid";
parameters[8].Value = Convert.ToInt32(Convertor.IsNull(cmbck.SelectedValue, "0"));
parameters[9].Text = "@functionname";
parameters[9].Value = _menuTag.Function_Name;
parameters[10].Text = "@p_deptid";
parameters[10].Value = InstanceForm.BCurrentDept.DeptId;
DataTable tb = InstanceForm.BDatabase.GetDataTable("sp_yk_selectDj", parameters, 30);
FunBase.AddRowtNo(tb);
tb.TableName = "Tb";
this.myDataGrid1.DataSource = tb;
FunBase.myGridSelect(this.myDataGrid1, this.myDataGrid1.TableStyles[0].GridColumnStyles);
}
catch (System.Exception err)
{
MessageBox.Show(err.Message);
}
finally
{
this.Cursor = Cursors.Arrow;
}
}
private void butref_Click(object sender, System.EventArgs e)
{
try
{
string ssql = "select 0 序号,dbo.fun_getdeptname(deptid) 仓库名称,jhcgrq 计划采购日期,djh 单据号,djsj 登记时间,dbo.fun_getempname(djy) 登记员," +
" shrq as 审核时间,dbo.fun_getempname(SHy) 审核员,bz 备注,id from yf_cg " +
" where djsj>='" + dtp1.Value.ToShortDateString() + " 00:00:00' and djsj<='" + dtp2.Value.ToShortDateString() + " 23:59:59' ";
if (this.rdo1.Checked == true)
{
ssql = ssql + " and shbz=0 ";
}
else
{
ssql = ssql + " and shbz=1 ";
}
if (Convert.ToInt32(Convertor.IsNull(cmbck.SelectedValue, "0")) > 0)
{
ssql = ssql + "and deptid=" + Convert.ToInt32(Convertor.IsNull(cmbck.SelectedValue, "0")) + "";
}
else
{
ssql = ssql + " and deptid in( select deptid from yp_yjks_gx where p_deptid=" + InstanceForm.BCurrentDept.DeptId + " )";
}
DataTable tb = InstanceForm.BDatabase.GetDataTable(ssql);
FunBase.AddRowtNo(tb);
tb.TableName = "Tb";
this.myDataGrid1.DataSource = tb;
FunBase.myGridSelect(this.myDataGrid1, this.myDataGrid1.TableStyles[0].GridColumnStyles);
}
catch (System.Exception err)
{
MessageBox.Show(err.Message);
}
}
private void btnRefresh_Click(object sender, EventArgs e)
{
try
{
ParameterEx[] parameters = new ParameterEx[12];
parameters[0].Value = 0;
parameters[1].Value = InstanceForm.BCurrentDept.WardId.Trim();
parameters[2].Value = rdorq1.Checked == true?"": this.dateTimePicker1.Value.ToShortDateString() + " 00:00:01";
parameters[3].Value = rdorq1.Checked == true ? "" : this.dateTimePicker2.Value.ToShortDateString() + " 23:59:59";
int bprint = 8;
if (rdowdy.Checked == true)
{
bprint = 3;
}
if (rdoydy.Checked == true)
{
bprint = 4;
}
parameters[4].Value = bprint;
parameters[5].Value = txtzyh.Text.Trim();
parameters[6].Value = txtcwh.Text.Trim();
parameters[7].Value = txtname.Text.Trim();
parameters[8].Value = txttxm.Text.Trim();
parameters[9].Value = rdorq1.Checked == false ? "" : this.dateTimePicker1.Value.ToShortDateString() + " 00:00:01";
parameters[10].Value = rdorq1.Checked == false ? "" : this.dateTimePicker2.Value.ToShortDateString() + " 23:59:59";
parameters[11].Value = InstanceForm.BCurrentDept.DeptId;
parameters[0].Text = "@lx";
parameters[1].Text = "@wardid";
parameters[2].Text = "@sqrq1";
parameters[3].Text = "@sqrq2";
parameters[4].Text = "@dybz";
parameters[5].Text = "@zyh";
parameters[6].Text = "@cwh";
parameters[7].Text = "@name";
parameters[8].Text = "@txm";
parameters[9].Text = "@qrrq1";
parameters[10].Text = "@qrrq2";
parameters[11].Text = "@zxks";
DataTable tb = InstanceForm.BDatabase.GetDataTable("SP_zyhs_getjchy", parameters, 30);
FunBase.AddRowtNo(tb);
tb.TableName = "Tb";
//if (rdorq2.Checked == true)
//{
// for (int i = 0; i <= tb.Rows.Count - 1; i++)
// tb.Rows[i]["选择"] = (short)1;
//}
this.myDataGrid1.DataSource = tb;
FunBase.myGridSelect(this.myDataGrid1, this.myDataGrid1.TableStyles[0].GridColumnStyles);
//if (rdowdy.Checked == true && tb.Rows.Count != 0)
//{
// if (MessageBox.Show("您要确认该费用吗？", "询问窗", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
// {
// this.btnfyqr_Click(sender, e);
// txttxm.Focus();
// txttxm.SelectAll();
// }
//}
}
catch (System.Exception err)
{
MessageBox.Show(err.ToString());
}
}