/// <summary> /// /// </summary> private void Add(DB db) { //DB db = DBFactory.GetDB(); tblPerson p = new tblPerson(); p.PersonName = this.txtPersonName.Text; p.tblTM = GetSelectedTm(db); db.tblPerson.InsertOnSubmit(p); db.SubmitChanges(); }
/// <summary> /// /// </summary> /// <returns></returns> private bool CheckInput(DB db) { if ( this.txtPersonName.Text.Trim().Length == 0 ) { NUnit.UiKit.UserMessage.DisplayFailure("名称不能为空"); return false; } if (GetSelectedTm(db) == null) { NUnit.UiKit.UserMessage.DisplayFailure("请选择TM卡"); return false; } return true; }
/// <summary> /// /// </summary> private void Edit(DB db) { //DB db = DBFactory.GetDB(); var r = from q in db.tblPerson where q.PersonID == this.TblPerson.PersonID select q; tblPerson person = r.First(); person.PersonName = this.txtPersonName.Text.Trim(); person.tblTM = this.GetSelectedTm(db); db.SubmitChanges(); }
/// <summary> /// /// </summary> /// <param name="db"></param> /// <returns></returns> private tblTM GetSelectedTm(DB db) { if (this.txtTM.Text.Trim().Length == 0) { return null; } else { var r = from q in db.tblTM where q.TmSN == this.txtTM.Text.Trim() select q; tblTM tm = r.First(); return tm; } }
public frmMain() { InitializeComponent(); _db = DBFactory.GetDB(); }
private void FillGroup(DB db) { // fill group // var r = from q in db.tblGroup select q; this.cmbGroup.DisplayMember = "GroupName"; this.cmbGroup.ValueMember = "GroupID"; this.cmbGroup.DataSource = r; }
/// <summary> /// /// </summary> /// <param name="db"></param> /// <returns></returns> private int GetTMID(DB db, int personID) { var r = from q in db.tblPerson where q.PersonID == personID select q; tblPerson p = r.First(); if (p.tblTM != null) { return p.tblTM.TmID; } return -1; }
private int GetSelectedTmID(DB db) { int personID = (int)this.cmbPerson.SelectedValue; return GetTMID(db, personID); }
private void FillStation(DB db) { var r = from q in db.tblDevice where q.DeviceType == "xgdevice" orderby q.tblStation.StationName select new { q.tblStation.StationName, q.DeviceID }; this.cmbStation.DisplayMember = "StationName"; this.cmbStation.ValueMember = "DeviceID"; this.cmbStation.DataSource = r; }
/// <summary> /// /// </summary> /// <param name="_db"></param> /// <param name="groupID"></param> private void FillPerson(DB db, int groupID) { var r = from q in db.tblPerson where q.GroupID == groupID orderby q.PersonName select q; this.cmbPerson.DisplayMember = "PersonName"; this.cmbPerson.ValueMember = "PersonID"; this.cmbPerson.DataSource = r; }
private int GetSelectedPersonTMID(DB db) { var r = from q in db.tblPerson where q.PersonID == SelectedPersonID select q.TmID; if (r.Count() > 0 && r.First() != null) { return (int)r.First(); } else { return -1; } }