/// <summary>
///
/// </summary>
private void TestInsertReply()
{
BxdbDataContext dc = new BxdbDataContext();
tblReply t = new tblReply();
t.rp_worker = "ww";
dc.tblReply.InsertOnSubmit(t);
dc.SubmitChanges();
}
/// <summary>
///
/// </summary>
private void TestDiffDataContext()
{
BxdbDataContext dc1 = new BxdbDataContext();
BxdbDataContext dc2 = new BxdbDataContext();
tblOperator opFromDc1 = dc1.tblOperator.ToArray()[0];
tblReply rp = new tblReply();
rp.tblOperator = opFromDc1;
dc2.tblOperator.Attach(opFromDc1);
//dc2.tblReply.InsertOnSubmit(rp);
dc2.SubmitChanges();
}
private void TestInsertReplyAndRelation()
{
BxdbDataContext dc = new BxdbDataContext();
tblReply t = new tblReply();
t.rp_worker = "work - reply - flow";
tblFlow flow =dc.tblFlow.Single();
flow.fl_status = 30;
Debug.Assert(flow != null);
flow.tblReply = t;
//db.tblReply.InsertOnSubmit(t);
dc.SubmitChanges();
}
/// <summary>
///
/// </summary>
/// <param name="db"></param>
/// <param name="dest"></param>
/// <returns></returns>
public tblIntroducer UpdateIntroducer(BxdbDataContext db, tblIntroducer it)
{
// TODO: dest.id != old.id
//
tblIntroducer old = this.It;
it.it_id = old.it_id;
it.it_address = old.it_address;
it.it_name = old.it_name;
it.it_phone = old.it_phone;
it.it_remark = old.it_remark;
return it;
}
/// <summary>
///
/// </summary>
/// <param name="db"></param>
/// <returns></returns>
public tblIntroducer GetIntroducer(BxdbDataContext db)
{
tblIntroducer old = this.It;
tblIntroducer it = new tblIntroducer();
it.it_id = old.it_id;
it.it_address = old.it_address;
it.it_name = old.it_name;
it.it_phone = old.it_phone;
it.it_remark = old.it_remark;
if (it.it_id == 0)
{
db.tblIntroducer.InsertOnSubmit(it);
}
return it;
}
/// <summary>
///
/// </summary>
/// <param name="db"></param>
/// <param name="tblReceive"></param>
/// <returns></returns>
internal tblReceive UpdateReceive(BxdbDataContext db, tblReceive tblReceive)
{
if (this.Rc == null)
{
return null;
}
if (tblReceive == null)
{
tblReceive = new tblReceive();
}
tblReceive.rc_dt = this.dtpReceived.Value;
tblReceive.tblOperator = db.tblOperator.First(c => c.op_id == App.Default.LoginOperator.op_id);
if (tblReceive.rc_id == 0)
{
db.tblReceive.InsertOnSubmit(tblReceive);
}
return tblReceive;
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public static BxdbDataContext CreateDataContext()
{
BxdbDataContext dc = new BxdbDataContext();
//dc.Log = Console.Out;
return dc;
}
/// <summary>
///
/// </summary>
/// <param name="db"></param>
/// <param name="ml"></param>
/// <returns></returns>
private tblMaintainLevel GetMaintainLevel(BxdbDataContext db, tblMaintainLevel ml)
{
var v = db.tblMaintainLevel.First(c => c.ml_id == ml.ml_id);
return v;
}
/// <summary>
///
/// </summary>
/// <param name="db"></param>
/// <param name="mt"></param>
/// <returns></returns>
public tblMaintain UpdateMaintain(BxdbDataContext db, tblMaintain mt)
{
tblMaintain old = this.Maintain;
//tblMaintain mt = new tblMaintain();
mt.mt_id = old.mt_id;
mt.mt_create_dt = old.mt_create_dt;
mt.mt_pose_dt = old.mt_pose_dt;
mt.mt_begin_dt = old.mt_begin_dt;
mt.mt_content = old.mt_content;
mt.mt_timeout_dt = old.mt_timeout_dt;
mt.tblMaintainLevel = GetMaintainLevel(db, (tblMaintainLevel)this.cmbML.SelectedItem);
mt.tblOperator = db.tblOperator.First(c => c.op_id == App.Default.LoginOperator.op_id);
return mt;
}
