//如下数据会一直追加,不会覆盖
private void bttJB_Click(object sender, EventArgs e)
{
try
{
DataTableToTxt(this.dgwWCL, "前台交班.txt", 3, "未完成的问题");
DataTableToTxt(this.dgwSM, "前台交班.txt", 2, "需要上门");
System.Diagnostics.Process.Start("前台交班.txt", System.AppDomain.CurrentDomain.BaseDirectory);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
finally { }
}
public static bool DataTableToTxt(DataGridView gridview, string fileName,int showcell,string type)
{
if (gridview == null || gridview.Rows.Count == 0)
return false;
FileStream fileStream = new FileStream(fileName, FileMode.Append);
StreamWriter streamWriter = new StreamWriter(fileStream, System.Text.Encoding.UTF8);
StringBuilder strBuilder = new StringBuilder(); //追加的形式
try
{
streamWriter.WriteLine("【"+DateTime.Now.ToString("MM-dd")+type+"】");//有2个DGW,在开始前面弄名称好区分
for (int i = 0; i < gridview.Rows.Count; i++)
{
strBuilder = new StringBuilder();
for (int j = showcell; j < gridview.Columns.Count; j++) //有2个DGW,想从指定的列开始导出showcell
{
strBuilder.Append(gridview.Rows[i].Cells[j].Value.ToString()+",");
}
//strBuilder.Remove(strBuilder.Length - 1, 1); // 将最后添加的一个strSplit删除掉
streamWriter.WriteLine(strBuilder.ToString());
}
}
catch (Exception ex)
{
string strErrorMessage = ex.Message;
return false;
}
finally
{
streamWriter.Close();
fileStream.Close();
}
return true;
}
private void bttJB_Click(object sender, EventArgs e)
{
try
{
DataTableToTxt(this.dgwWCL, "前台交班.txt", 3, "未完成的问题");
DataTableToTxt(this.dgwSM, "前台交班.txt", 2, "需要上门");
System.Diagnostics.Process.Start("前台交班.txt", System.AppDomain.CurrentDomain.BaseDirectory);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
finally { }
}
public static bool DataTableToTxt(DataGridView gridview, string fileName,int showcell,string type)
{
if (gridview == null || gridview.Rows.Count == 0)
return false;
FileStream fileStream = new FileStream(fileName, FileMode.Append);
StreamWriter streamWriter = new StreamWriter(fileStream, System.Text.Encoding.UTF8);
StringBuilder strBuilder = new StringBuilder(); //追加的形式
try
{
streamWriter.WriteLine("【"+DateTime.Now.ToString("MM-dd")+type+"】");//有2个DGW,在开始前面弄名称好区分
for (int i = 0; i < gridview.Rows.Count; i++)
{
strBuilder = new StringBuilder();
for (int j = showcell; j < gridview.Columns.Count; j++) //有2个DGW,想从指定的列开始导出showcell
{
strBuilder.Append(gridview.Rows[i].Cells[j].Value.ToString()+",");
}
//strBuilder.Remove(strBuilder.Length - 1, 1); // 将最后添加的一个strSplit删除掉
streamWriter.WriteLine(strBuilder.ToString());
}
}
catch (Exception ex)
{
string strErrorMessage = ex.Message;
return false;
}
finally
{
streamWriter.Close();
fileStream.Close();
}
return true;
}