/// <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;
}
}
