void UIRefreshRow(int row, FaultLogs f)
{
BeginInvoke(new Action(() =>
{
DgvData.Rows[row].SetValues(new object[] {
DgvData.Rows.Count + 1,
f.CreateTime,
f.FinishTime,
f.Ip,
f.Phone,
f.Address,
f.System,
f.Problem,
f.Solution,
f.Postscript,
f.Id
});
}));
// DgvData.Rows[row].Cells["DgvDataNo
// DgvData.Rows[row].Cells["DgvDataCreateTime
//DgvData.Rows[row].Cells["DgvDataFinishTime
//DgvData.Rows[row].Cells["DgvDataIp
//DgvData.Rows[row].Cells["DgvDataPhone
//DgvData.Rows[row].Cells["DgvDataAddress
//DgvData.Rows[row].Cells["DgvDataSystem
//DgvData.Rows[row].Cells["DgvDataProblem
//DgvData.Rows[row].Cells["DgvDataSolution
//DgvData.Rows[row].Cells["DgvDataPostscript
//DgvData.Rows[row].Cells["DgvDataId
}
public bool SaveInfo()
{
using (var db = new Muse())
{
FaultLogs fl = db.Get <FaultLogs>(x => x.Id == Id, null);
if (fl != null)
{
fl.Address = TbAddress.Text;
fl.Ip = TbIp.Text;
fl.Phone = TbPhone.Text;
fl.Postscript = TbPostscript.Text;
fl.Problem = TbProblem.Text;
fl.Solution = TbSolution.Text;
fl.System = CbSystem.Text;
if (CbIsFinish.Checked && !fl.IsFinish)
{
fl.IsFinish = true;
fl.FinishTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
}
if (!CbIsFinish.Checked && fl.IsFinish)
{
fl.IsFinish = false;
fl.FinishTime = "";
}
int flag = db.Update(fl, true);
return(flag > 0);
}
}
return(false);
}
void UIAddRow(FaultLogs f)
{
BeginInvoke(new Action(() =>
{
DgvData.Rows.Add(new object[] {
DgvData.Rows.Count + 1,
f.CreateTime,
f.FinishTime,
f.Ip,
f.Phone,
f.Address,
f.System,
f.Problem,
f.Solution,
f.Postscript,
f.Id
});
}));
}
public void InitInfo(int id)
{
Id = id;
using (var db = new Muse())
{
FaultLogs faultLog = db.Get <FaultLogs>(x => x.Id == id, null);
if (faultLog != null)
{
TbIp.Text = faultLog.Ip;
TbPhone.Text = faultLog.Phone;
TbAddress.Text = faultLog.Address;
TbProblem.Text = faultLog.Problem;
TbSolution.Text = faultLog.Solution;
TbPostscript.Text = faultLog.Postscript;
CbSystem.Text = faultLog.System;
if (faultLog.IsFinish)
{
CbIsFinish.Checked = true;
}
}
}
}
private void BtAdd_Click(object sender, EventArgs e)
{
FaultLogs fl = new FaultLogs()
{
Ip = TbIp.Text,
Phone = TbPhone.Text,
Address = TbAddress.Text,
Problem = TbProblem.Text,
Solution = TbSolution.Text,
Postscript = TbPostscript.Text,
System = CbSystem.Text,
CreateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
IsFinish = CbIsFinish.Checked,
FinishTime = CbIsFinish.Checked ? DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") : "",
};
UICleanInput();
Task.Factory.StartNew(() =>
{
UIAddButton(false);
using (var db = new Muse())
{
db.Add(fl);
var fls = db.Do <FaultLogs>().SqlQuery("SELECT * FROM faultlogs WHERE createtime LIKE @p0", DateTime.Now.ToString("yyyy-MM-dd") + "%");
if (ListTool.HasElements(fls))
{
foreach (var f in fls)
{
UIAddRow(f);
}
}
}
UIAddButton(true);
});
}
private void DgvData_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
//int id = (int)DgvData.Rows[e.RowIndex].Cells["DgvDataId"].Value;
//MessageBox.Show(id.ToString());
try
{
int id = (int)DgvData.Rows[e.RowIndex].Cells["DgvDataId"].Value;
if (new ModifyForm(id).ShowDialog() == DialogResult.OK)
{
using (var db = new Muse())
{
FaultLogs f = db.Get <FaultLogs>(x => x.Id == id, null);
if (f != null)
{
UIRefreshRow(e.RowIndex, f);
}
}
}
}
catch (Exception ex) { }
}
}
