private void outputDatagridview(DataGridView dataGridView1)
{
//获取行数
int count = dataGridView1.Rows.Count - 1;
//分配数组,列数为输出表格的列数,共11列
string[,] str = new string[count, 11];
//利用一个For循环,完成对每一次餐费的填充,每一次循环为一行的填充,存在数组里
for (int i = 0; i <= count - 1; i++)
{
//0外业时间String.Format( "yyyy-MM-dd ",yourDateTime);
DateTime time = (DateTime)dataGridView1["WYSJ", i].Value;
str[i, 0] = time.ToString("yyyy-MM-dd");
//1项目名称
str[i, 1] = dataGridView1["GCMC", i].Value.ToString();
//3餐费
str[i, 3] = dataGridView1["YCFY", i].Value.ToString();
//6用餐人数
string CTGCG = dataGridView1["CTGCG", i].Value.ToString();
string CTFZG = dataGridView1["CTFZG", i].Value.ToString();
string DTGCG = dataGridView1["DTGCG", i].Value.ToString();
string DTFZG = dataGridView1["DTFZG", i].Value.ToString();
string GXFZG = dataGridView1["GXFZG", i].Value.ToString();
string GXTCCG = dataGridView1["GXTCCG", i].Value.ToString();
string QTGCFUG = dataGridView1["QTGCFZG", i].Value.ToString();
string QTGCGCG = dataGridView1["QTGCGCG", i].Value.ToString();
string sj = dataGridView1["SJ", i].Value.ToString();
string all = CTGCG + CTFZG + DTGCG + DTFZG + GXFZG + GXTCCG + QTGCFUG + QTGCGCG;
int no;
if (sj == "" || sj == null || sj == "无")
{
string[] num = all.Split(',');
no = num.Length - 1;
str[i, 6] = no.ToString();
}
else
{
if (all.Contains(sj))
{
string[] num = all.Split(',');
no = num.Length - 1;
str[i, 6] = no.ToString();
}
else
{
//获取行数
int count = dataGridView1.Rows.Count - 1;
//分配数组,列数为输出表格的列数,共11列
string[,] str = new string[count, 11];
//利用一个For循环,完成对每一次餐费的填充,每一次循环为一行的填充,存在数组里
for (int i = 0; i <= count - 1; i++)
{
//0外业时间String.Format( "yyyy-MM-dd ",yourDateTime);
DateTime time = (DateTime)dataGridView1["WYSJ", i].Value;
str[i, 0] = time.ToString("yyyy-MM-dd");
//1项目名称
str[i, 1] = dataGridView1["GCMC", i].Value.ToString();
//3餐费
str[i, 3] = dataGridView1["YCFY", i].Value.ToString();
//6用餐人数
string CTGCG = dataGridView1["CTGCG", i].Value.ToString();
string CTFZG = dataGridView1["CTFZG", i].Value.ToString();
string DTGCG = dataGridView1["DTGCG", i].Value.ToString();
string DTFZG = dataGridView1["DTFZG", i].Value.ToString();
string GXFZG = dataGridView1["GXFZG", i].Value.ToString();
string GXTCCG = dataGridView1["GXTCCG", i].Value.ToString();
string QTGCFUG = dataGridView1["QTGCFZG", i].Value.ToString();
string QTGCGCG = dataGridView1["QTGCGCG", i].Value.ToString();
string sj = dataGridView1["SJ", i].Value.ToString();
string all = CTGCG + CTFZG + DTGCG + DTFZG + GXFZG + GXTCCG + QTGCFUG + QTGCGCG;
int no;
if (sj == "" || sj == null || sj == "无")
{
string[] num = all.Split(',');
no = num.Length - 1;
str[i, 6] = no.ToString();
}
else
{
if (all.Contains(sj))
{
string[] num = all.Split(',');
no = num.Length - 1;
str[i, 6] = no.ToString();
}
else