private void btnSearch_Click(object sender, EventArgs e)
{
try
{
dsFkxx = new DataSet();
string strWhere = ""; if (this.cmbGrzt.SelectedValue.ToString().Trim() != "00")
{
strWhere = "AND " + "ZT='" + cmbGrzt.SelectedValue.ToString().Trim() + "'";
} if (this.cmbZhlx.SelectedValue.ToString().Trim() != "00")
{
strWhere =strWhere + "AND " + "ZJLX='" + cmbZhlx.SelectedValue.ToString().Trim() + "'";
} if (this.txtKhh.Text.ToString().Trim() != "")
{
strWhere =strWhere + "AND " + "KHH='" + txtKhh.Text.ToString().Trim() + "'";
} if (this.txtZgxm.Text.ToString().Trim() != "")
{
strWhere = strWhere + "AND " + "XM='" + txtZgxm.Text.ToString().Trim() + "'";
} if (this.txtZjhm.Text.ToString().Trim() != "")
{
strWhere = strWhere + "AND " + "ZJHM='" + txtZjhm.Text.ToString().Trim() + "'";
}
////////////////////////////////
dsFkxx = dbTool.GetGrxxbySql(strWhere); dsFkxx.Tables[0].Columns.Add("YJCE", typeof(System.String)); //月缴存额
dsFkxx.Tables[0].Columns.Add("YJJCBL", typeof(System.String)); //月缴存额
dsFkxx.Tables[0].Columns.Add("ZJXZMC", typeof(System.String));
foreach (DataRow drow in dsFkxx.Tables[0].Rows)
{
decimal decJcbl = decimal.Parse(drow["DWBL"].ToString().Trim());
decimal decJfjs = decimal.Parse(drow["JFJS"].ToString().Trim()); if (drow["ZT"].ToString().Trim() == "1")
{
drow["ZT"] = "正常";
}
else
{
drow["ZT"] = "停缴";
}
drow["ZJXZMC"] = global.dsZhlx.Tables[0].Select("DM='" + drow["ZJLX"].ToString().Trim() + "'")[0]["MC"].ToString().Trim();
//这里会报错提示索引超出了数组界限
decimal decYjce = decJcbl * decJfjs;
drow["YJCE"] = decYjce.ToString("0");
if (drow["ZJLX"].ToString().Trim() == "11")
{
drow["YJCE"] = drow["YJCE"].ToString().Trim();
}
else
{
drow["YJCE"] = Convert.ToString(decimal.Parse(drow["YJCE"].ToString().Trim()) * 2);
}
decimal decYjjcbl = decimal.Parse(drow["DWBL"].ToString().Trim()) * 100;
drow["YJJCBL"] = decYjjcbl.ToString("0"); } //重新绑定数据绑定数据
this.dgList.DataSource = dsFkxx.Tables[0];
pmonthmoney = 0;
ppeoplecount = 0;
for (int i = 0; i < dsFkxx.Tables[0].Rows.Count; i++)
{
pmonthmoney = pmonthmoney + double.Parse(dsFkxx.Tables[0].Rows[i]["YJCE"].ToString());
}
ppeoplecount = dsFkxx.Tables[0].Rows.Count;
benyeinfor.Text = "缴存人数:" + ppeoplecount.ToString() + "\n\n月缴存额:" + pmonthmoney.ToString("F2");
benyeinfor.Visible = true;
benye.Visible = true; CurrencyManager cm = (CurrencyManager)this.BindingContext[this.dgList.DataSource, this.dgList.DataMember];
((DataView)cm.List).AllowNew = false;
if (dsFkxx.Tables[0].Rows.Count == 0)
{
MessageBox.Show("没有符合查询条件的记录!");
}
}
catch (MsgException ex)
{
MessageBox.Show(ex.MsgDes, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}看看上面错在哪里求解!!
{
try
{
dsFkxx = new DataSet();
string strWhere = ""; if (this.cmbGrzt.SelectedValue.ToString().Trim() != "00")
{
strWhere = "AND " + "ZT='" + cmbGrzt.SelectedValue.ToString().Trim() + "'";
} if (this.cmbZhlx.SelectedValue.ToString().Trim() != "00")
{
strWhere =strWhere + "AND " + "ZJLX='" + cmbZhlx.SelectedValue.ToString().Trim() + "'";
} if (this.txtKhh.Text.ToString().Trim() != "")
{
strWhere =strWhere + "AND " + "KHH='" + txtKhh.Text.ToString().Trim() + "'";
} if (this.txtZgxm.Text.ToString().Trim() != "")
{
strWhere = strWhere + "AND " + "XM='" + txtZgxm.Text.ToString().Trim() + "'";
} if (this.txtZjhm.Text.ToString().Trim() != "")
{
strWhere = strWhere + "AND " + "ZJHM='" + txtZjhm.Text.ToString().Trim() + "'";
}
////////////////////////////////
dsFkxx = dbTool.GetGrxxbySql(strWhere); dsFkxx.Tables[0].Columns.Add("YJCE", typeof(System.String)); //月缴存额
dsFkxx.Tables[0].Columns.Add("YJJCBL", typeof(System.String)); //月缴存额
dsFkxx.Tables[0].Columns.Add("ZJXZMC", typeof(System.String));
foreach (DataRow drow in dsFkxx.Tables[0].Rows)
{
decimal decJcbl = decimal.Parse(drow["DWBL"].ToString().Trim());
decimal decJfjs = decimal.Parse(drow["JFJS"].ToString().Trim()); if (drow["ZT"].ToString().Trim() == "1")
{
drow["ZT"] = "正常";
}
else
{
drow["ZT"] = "停缴";
}
drow["ZJXZMC"] = global.dsZhlx.Tables[0].Select("DM='" + drow["ZJLX"].ToString().Trim() + "'")[0]["MC"].ToString().Trim();
//这里会报错提示索引超出了数组界限
decimal decYjce = decJcbl * decJfjs;
drow["YJCE"] = decYjce.ToString("0");
if (drow["ZJLX"].ToString().Trim() == "11")
{
drow["YJCE"] = drow["YJCE"].ToString().Trim();
}
else
{
drow["YJCE"] = Convert.ToString(decimal.Parse(drow["YJCE"].ToString().Trim()) * 2);
}
decimal decYjjcbl = decimal.Parse(drow["DWBL"].ToString().Trim()) * 100;
drow["YJJCBL"] = decYjjcbl.ToString("0"); } //重新绑定数据绑定数据
this.dgList.DataSource = dsFkxx.Tables[0];
pmonthmoney = 0;
ppeoplecount = 0;
for (int i = 0; i < dsFkxx.Tables[0].Rows.Count; i++)
{
pmonthmoney = pmonthmoney + double.Parse(dsFkxx.Tables[0].Rows[i]["YJCE"].ToString());
}
ppeoplecount = dsFkxx.Tables[0].Rows.Count;
benyeinfor.Text = "缴存人数:" + ppeoplecount.ToString() + "\n\n月缴存额:" + pmonthmoney.ToString("F2");
benyeinfor.Visible = true;
benye.Visible = true; CurrencyManager cm = (CurrencyManager)this.BindingContext[this.dgList.DataSource, this.dgList.DataMember];
((DataView)cm.List).AllowNew = false;
if (dsFkxx.Tables[0].Rows.Count == 0)
{
MessageBox.Show("没有符合查询条件的记录!");
}
}
catch (MsgException ex)
{
MessageBox.Show(ex.MsgDes, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}看看上面错在哪里求解!!
global.dsZhlx.Tables[0].Select("DM='" + drow["ZJLX"].ToString().Trim() + "'")[0]["MC"].ToString().Trim();
如果没有找到满足条件"DM='" + drow["ZJLX"].ToString().Trim() + "'"的结果,那么就不存在第一行[0]