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) { } } }