/// <summary>
/// 读取文本数据
/// </summary>
/// <param name="lst"></param>
/// <returns></returns>
private List<WorkLogData> ConvertList(List<string> lst)
{
int nIndex = -1;
string strTmp = "";
List<WorkLogData> RetLst = new List<WorkLogData>();
for (int i = 0; i < lst.Count; i++)
{
string str = lst[i];
WorkLogData WLD = new WorkLogData();
// DateTime
nIndex = str.IndexOf("--");
if (nIndex == -1)
{
MessageBox.Show("Error Text format!");
Application.Exit();
break;
}
strTmp = str.Substring(0, nIndex);
str = str.Substring(nIndex + 2);
WLD.DtWorkLog = Convert.ToDateTime(strTmp);
//PlanDate
nIndex = str.IndexOf("--");
strTmp = str.Substring(0, nIndex);
str = str.Substring(nIndex + 2);
WLD.PlanDate = Convert.ToDateTime(strTmp);
// Plan
nIndex = str.IndexOf("--");
strTmp = str.Substring(0, nIndex);
str = str.Substring(nIndex + 2);
WLD.StrPlan = strTmp;
// Detail
nIndex = str.IndexOf("--");
strTmp = str.Substring(0, nIndex);
str = str.Substring(nIndex + 2);
WLD.StrDetail = strTmp;
// IsDone
nIndex = str.IndexOf("--");
strTmp = str.Substring(0, nIndex);
str = str.Substring(nIndex + 2);
if (strTmp == "0")
WLD.IsDone = false;
else
WLD.IsDone = true;
// Name
nIndex = str.IndexOf("--");
strTmp = str.Substring(0, nIndex);
str = str.Substring(nIndex + 2);
WLD.Name = strTmp;
//Remark
WLD.Remark = str;
RetLst.Add(WLD);
}
return RetLst;
}
private bool saveTable(ref List<WorkLogData> lst)
{
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
WorkLogData WLD = new WorkLogData();
// 日期
DateTime tmpDt = new DateTime();
if (!DateTime.TryParse(dataGridView1.Rows[i].Cells[1].Value.ToString().Trim(), out tmpDt))
{
MessageBox.Show("第" + i.ToString() + "行的日期格式不正确!");
return false;
}
WLD.DtWorkLog = tmpDt;
//计划日期
DateTime tmpDt1 = new DateTime();
if (!DateTime.TryParse(dataGridView1.Rows[i].Cells[2].Value.ToString().Trim(), out tmpDt1))
{
MessageBox.Show("第" + i.ToString() + "行的日期格式不正确!");
return false;
}
WLD.PlanDate = tmpDt1;
// 计划
if (dataGridView1.Rows[i].Cells[3].Value == null)
{
WLD.StrPlan = " ";
}
else
{
WLD.StrPlan = dataGridView1.Rows[i].Cells[3].Value.ToString().Trim();
}
// 详细信息
if (dataGridView1.Rows[i].Cells[4].Value == null)
{
WLD.StrDetail = " ";
}
else
{
WLD.StrDetail = dataGridView1.Rows[i].Cells[4].Value.ToString().Trim();
}
// 完成
if (dataGridView1.Rows[i].Cells[5].Value == null)
{
WLD.IsDone = false;
}
else
{
WLD.IsDone = dataGridView1.Rows[i].Cells[5].Value.ToString().Trim() == "True" ? true : false;
}
// 相关人员
if (dataGridView1.Rows[i].Cells[6].Value == null)
{
WLD.Name = " ";
}
else
{
WLD.Name = dataGridView1.Rows[i].Cells[6].Value.ToString().Trim();
}
// 备注
if (dataGridView1.Rows[i].Cells[7].Value == null)
{
WLD.Remark = " ";
}
else
{
WLD.Remark = dataGridView1.Rows[i].Cells[7].Value.ToString().Trim();
}
lst.Add(WLD);
}
return true;
}
