protected void save()
{
try
{
using (VisitMgtDataContext vmdc = new VisitMgtDataContext())
{
visit_main vm = new visit_main
{
v_id = this.ID,
v_gate = this.Gate.GateID,
v_card = this.Card.Id,
v_life = this.Life,
v_visitor = this.Visitor.Id,
v_hasID = this.HasID,
v_type = this.vType,
v_reason = this.vReason,
v_nums = this.Nums,
v_entry = this.Entry,
v_respondent = this.Respondent.Id,
v_status = this.status,
v_intime = this.InTime,
v_outtime = this.OutTime
};
vmdc.visit_main.InsertOnSubmit(vm);
vmdc.SubmitChanges();
}
}
catch (Exception ex)
{
throw new Exception("保存访问记录失败", ex);
}
}
public void Delete()
{
if (this.Id != null)
{
using (VisitMgtDataContext vmdc = new VisitMgtDataContext())
{
vmdc.respondent.DeleteOnSubmit(vmdc.respondent.Single(q => q.respondent_id == this.Id));
vmdc.SubmitChanges();
}
}
}
public void Delete()
{
try
{
using (VisitMgtDataContext vmdc = new VisitMgtDataContext())
{
visitor_cert vc = vmdc.visitor_cert.Single(q => q.cert_id == CertID);
vmdc.visitor_cert.DeleteOnSubmit(vc);
vmdc.SubmitChanges();
}
}
}
public void Postponed(int i)
{
if (this.ID != null)
{
using (VisitMgtDataContext vmdc = new VisitMgtDataContext())
{
visit_main vm = vmdc.visit_main.Single(q => q.v_id == this.ID);
vm.v_life += i;
vmdc.SubmitChanges();
}
}
}
public void Save()
{
using (VisitMgtDataContext vmdc = new VisitMgtDataContext())
{
visitor v = new visitor {
visitor_name = this.Name,
visitor_sex = this.Sex.ToString()
};
if (!isnew)
{
v.visitor_id = this.Id;
}
vmdc.visitor.InsertOnSubmit(v);
vmdc.SubmitChanges();
}
}
public void Delete()
{
try
{
if (CheckCodeEmpty())
{
using (VisitMgtDataContext vmdc = new VisitMgtDataContext())
{
cert_type ct = vmdc.cert_type.Single(q => q.cert_type_code == this.TypeCode);
vmdc.cert_type.DeleteOnSubmit(ct);
vmdc.SubmitChanges();
}
}
}
catch (Exception ex) {
throw new Exception("删除证件类型失败", ex);
}
}
public void Delete()
{
if (GateID != null)
{
try
{
using (VisitMgtDataContext vmdc = new VisitMgtDataContext())
{
vmdc.gate.DeleteOnSubmit(vmdc.gate.Single(q => q.gate_id == this.GateID));
vmdc.SubmitChanges();
}
}
catch (Exception ex)
{
throw new Exception("删除门信息失败", ex);
}
}
}
public void Delete()
{
if (this.Code != null)
{
try
{
using (VisitMgtDataContext vmdc = new VisitMgtDataContext())
{
vmdc.plant.DeleteOnSubmit(vmdc.plant.Single(q => q.plant_code == this.Code));
vmdc.SubmitChanges();
}
}
catch (Exception ex)
{
throw new Exception("删除工厂失败", ex);
}
}
}
public void Delete()
{
if (!isnew && Id != null)
{
try
{
using (VisitMgtDataContext vmdc = new VisitMgtDataContext())
{
vmdc.visitor.DeleteOnSubmit(vmdc.visitor.Single(q => q.visitor_id == this.Id));
vmdc.visitor_cert.DeleteAllOnSubmit(vmdc.visitor_cert.Where(q => q.cert_host == this.Id));
vmdc.SubmitChanges();
}
}
catch (Exception ex)
{
throw new Exception("删除方可信息失败", ex);
}
}
}
public void New()
{
try
{
using (VisitMgtDataContext vmdc = new VisitMgtDataContext())
{
fire_train ft = new fire_train {
train_id = Guid, visitor = this.People.Id, train_date = this.TrainDate
};
vmdc.fire_train.InsertOnSubmit(ft);
visitor v = vmdc.visitor.Single(q => q.visitor_id == this.People.Id);
v.visitor_lastcheck = this.TrainDate;
vmdc.SubmitChanges();
}
}
catch (Exception ex)
{
throw new Exception("培训失败", ex);
}
}
public void Create()
{
try
{
if (CheckCodeEmpty() && CheckDescEmpty())
{
using (VisitMgtDataContext vmdc = new VisitMgtDataContext())
{
cert_type ct = new cert_type {
cert_type_code = this.TypeCode, cert_type_desc = this.TypeDesc
};
vmdc.cert_type.InsertOnSubmit(ct);
vmdc.SubmitChanges();
}
}
}
catch (Exception ex) {
throw new Exception("创建证件更新失败", ex);
}
}
public void save()
{
try
{
using (VisitMgtDataContext vmdc = new VisitMgtDataContext())
{
gate g = new gate {
gate_plant = this.Plant.Code, gate_name = this.Name
};
if (GateID != null)
{
g.gate_id = GateID;
}
vmdc.gate.InsertOnSubmit(g);
vmdc.SubmitChanges();
}
}
catch (Exception ex)
{
throw new Exception("更新门信息失败", ex);
}
}
public void save()
{
try
{
using (VisitMgtDataContext vmdc = new VisitMgtDataContext())
{
plant po = new plant {
plant_name = this.CNName, plant_name_en = this.ENName, plant_address = this.Address
};
if (this.Code != null)
{
po.plant_code = this.Code;
}
vmdc.plant.InsertOnSubmit(po);
vmdc.SubmitChanges();
}
}
catch (Exception ex)
{
throw new Exception("更新工厂信息失败", ex);
}
}
