private void button1_Click(object sender, EventArgs e)
{
DateTime datetime = new DateTime(dateTimePicker1.Value.Year, dateTimePicker1.Value.Month, 1);
strSql = "select count(*) from ydsb where yzz060='" + dateTimePicker1.Value.ToString("yyyy") + "' and yzz061='" + dateTimePicker1.Value.ToString("MM") + "' and flag=1 and aae140 = '" + aae140 + "'";
sqlDataReader = db.GetDataReader(strSql);
sqlDataReader.Read();
if (sqlDataReader.GetValue(0).ToString() == "1")
{
button2.Text = "回退";
}
else
{
button2.Text = "提交";
}
if (button2.Text == "提交")
{
strSql = "select sfsb.aac002,sfsb.aac043,sfsb.aac044,sfsb.aac003,"
+ "sfsb.aab301,gxjzdj.ykc700,fyjs.ykc618,gxjzdj.ykc701,cydj.ykc702,"
+ "cydj.akb063,fyjs.akc194,gxjzdj.akc050,cydj.akc185,fyjs.akc264,"
+ "fyjs.akb068,fyjs.ykc630,gxjzdj.aka130,aae140,gxjzdj.akc190,fyjs.yzz139,'无' as aae013"
+ " from gxjzdj,sfsb,fyjs,cydj "
+ " where gxjzdj.id = sfsb.id and sfsb.id = fyjs.id and sfsb.id = cydj.id "
+ " and fyjs.akc194 between '" + datetime.ToString("yyyyMMdd") + "' and '" + datetime.AddMonths(1).AddDays(-1).ToString("yyyyMMdd") + "'"
+ " and aae140 = '" + aae140 + "'";
sqlDataAdapter = db.GetDataAdapter(strSql);
dataSet = new DataSet();
sqlDataAdapter.Fill(dataSet, "caigou");
dataGridView1.DataSource = dataSet.Tables["caigou"].DefaultView;
strSql = "select SUM(cast(akc264 as numeric(18,2))),COUNT(*) from fyjs where aae140 = '" + aae140 + "' and left(CONVERT(varchar(100), akc194, 112),6)='" + dateTimePicker1.Value.ToString("yyyyMM") + "'";
sqlDataReader = db.GetDataReader(strSql);
sqlDataReader.Read();
label3.Text = sqlDataReader.GetValue(1).ToString();
label6.Text = sqlDataReader.GetValue(0).ToString();
}
else
{
strSql = "select transid,yzz060,yzz061,yzz062,aae140 from ydsb where flag=1 and aae140 = '" + aae140 + "' and yzz060='" + dateTimePicker1.Value.ToString("yyyy") + "' and yzz061='" + dateTimePicker1.Value.ToString("MM") + "'";
sqlDataAdapter = db.GetDataAdapter(strSql);
dataSet = new DataSet();
sqlDataAdapter.Fill(dataSet, "caigou");
DataTable dt = dataSet.Tables[0];
dt = qj.ppdt(dt);
dataGridView1.DataSource = dt;
strSql = "select ROW_NUMBER() OVER (ORDER BY fyjs.akc194 ASC) AS 序号,aac003 as "
+ " 姓名,sfsb.aab301 as 参保地,sfsb.aac002 as 身份证号码,akc190 as 住院号 "
+ " ,ykc701 as 入院日期,ykc702 as 出院日期,CONVERT(varchar(100), fyjs.akc194, 112) as 结算日期,akc050 "
+ " as 入院诊断,cydj.akc185 as 出院诊断,fyjs.akc264 as 医疗费总额,ykc624 "
+ " as 个人自负,akb068 as 统筹支付,ykc630 as 大病统筹,gxjzdj.aka130 as "
+ " 医疗类别,'' as 备注 from sfsb, gxjzdj, cydj, fyjs where "
+ " sfsb.id = gxjzdj.id and sfsb.id = cydj.id and sfsb.id = fyjs.id "
+ " and aae140 = '" + aae140 + "' and fyjs.akc194 between '" + datetime.ToString("yyyyMMdd") + "' and '" + datetime.AddMonths(1).AddDays(-1).ToString("yyyyMMdd") + "'";
sqlDataAdapter = db.GetDataAdapter(strSql);
dataSet = new DataSet();
sqlDataAdapter.Fill(dataSet, "caigou");
DataTable dt1 = dataSet.Tables[0];
dt1 = qj.ppdt(dt1);
dataGridView2.DataSource = dt1;
strSql = "select ROW_NUMBER() OVER (ORDER BY fyjs.akc194 ASC) AS 序号,"
+ " cydj.aab301 as 参保地,COUNT(*) as 就医人数,COUNT(*) as 就医人次,"
+ " SUM(cast(akc264 as numeric(18, 2))) as 医疗费总额,"
+ " SUM(cast(ykc624 as numeric(18, 2))) as 个人自负金额,"
+ " SUM(cast(akb068 as numeric(18, 2))) as 记账金额,"
+ " SUM(cast(ykc630 as numeric(18, 2))) as 大病金额,'' as 备注"
+ " from fyjs, cydj where cydj.id = fyjs.id"
+ " and aae140 = '" + aae140 + "' and fyjs.akc194 between '" + datetime.ToString("yyyyMMdd") + "' and '" + datetime.AddMonths(1).AddDays(-1).ToString("yyyyMMdd") + "'"
+ " group by fyjs.akc194,cydj.aab301";
sqlDataAdapter = db.GetDataAdapter(strSql);
dataSet = new DataSet();
sqlDataAdapter.Fill(dataSet, "caigou");
DataTable dt2 = dataSet.Tables[0];
dt2 = qj.ppdt(dt2);
dataGridView3.DataSource = dt2;
}
}