private void btnOK_Click(object sender, EventArgs e) { if (!dxValidationProvider1.Validate()) return; var odrs = gcOrder.GetDataSource<t_order>(); if (odrs == null || odrs.Count < 1) { MsgBox.ShowMessage("提示", "没有添加商品不能保存!"); return; } if (EditMode == Ultra.Web.Core.Enums.EnViewEditMode.New) { var trdnew = new t_trade() { Guid = GuidKey, ReceiverName = memgcEdt.GetSelectedValue().ReceiverName, ReceiverMobile = memgcEdt.GetSelectedValue().ReceiverMobile, ReceiverAddress = memgcEdt.GetSelectedValue().ReceiverAddress, MemberGuid = memgcEdt.GetSelectedValue().Guid, DeliveryDate = dateDeliveryDate.DateTime, CreateDate = TimeSync.Default.CurrentSyncTime, Creator = this.CurUser, }; using (var db = new Database()) { try { db.BeginTransaction(); db.Save(trdnew); odrs.ForEach(k => db.Save(k)); db.CompleteTransaction(); } catch (Exception) { db.AbortTransaction(); throw; } } } else if (EditMode == Ultra.Web.Core.Enums.EnViewEditMode.Edit) { using (var db = new Database()) { var trd = db.FirstOrDefault<t_trade>(" where guid=@0", GuidKey); trd.ReceiverName = memgcEdt.GetSelectedValue().ReceiverName; trd.ReceiverMobile = txtMobile.Text; trd.ReceiverAddress = txtReceiverAddress.Text; trd.MemberGuid = memgcEdt.GetSelectedValue().Guid; trd.DeliveryDate = TimeSync.Default.CurrentSyncTime; trd.DeliveryDate = dateDeliveryDate.DateTime; try { db.BeginTransaction(); db.Save(trd); db.Execute("delete t_order where tradeguid=@0", trd.Guid); odrs.ForEach(k => { k.Id = 0; db.Save(k); }); db.CompleteTransaction(); } catch (Exception) { db.AbortTransaction(); throw; } } } DialogResult = System.Windows.Forms.DialogResult.OK; Close(); }
private void btnOK_Click(object sender, EventArgs e) { if (!dxValidationProvider1.Validate()) return; using (var db = new Database()) { if (EditMode == Web.Core.Enums.EnViewEditMode.Edit) { var kt = db.FirstOrDefault<t_location>("where locname=@0 and guid <> @1", txtName.Text,GuidKey); if (null != kt) { MsgBox.ShowMessage("提示", "库位名称已存在!"); txtName.Select(); return; } var et = db.FirstOrDefault<t_location>(" where guid=@0", this.GuidKey); et.WareName = wareGridEdit1.GetSelectedValue().WareName; et.WareCode = wareGridEdit1.GetSelectedValue().WareCode; et.AreaName = areaGridEdit1.GetSelectedValue().AreaName; et.AreaCode = areaGridEdit1.GetSelectedValue().AreaCode; et.LocName = txtName.Text; et.LocCode = txtCode.Text; et.IsUsing = chk.Checked; db.Save(et); } else { var kt = db.FirstOrDefault<t_location>("where locname=@0", txtName.Text); if (null != kt) { MsgBox.ShowMessage("提示", "库位名称已存在!"); txtName.Select(); return; } var et = new t_location { Guid= Guid.NewGuid(), WareName = wareGridEdit1.GetSelectedValue().WareName, WareCode = wareGridEdit1.GetSelectedValue().WareCode, AreaName = areaGridEdit1.GetSelectedValue().AreaName, AreaCode = areaGridEdit1.GetSelectedValue().AreaCode, LocCode = txtCode.Text, LocName = txtName.Text, IsUsing = chk.Checked, Creator=this.CurUser, CreateDate=TimeSync.Default.CurrentSyncTime }; db.Save(et); } } DialogResult = System.Windows.Forms.DialogResult.OK; Close(); }
//public static Payment recordPayment(Rider rider, double amount, string branch, string username, string account) //{ // Payment payment = new Payment(); // payment.rider = rider.name; // payment.amount = amount; // payment.paid_date = DateTime.Now; // payment.bank_branch = branch; // payment.bank_username = username; // payment.bank_account = account; // Database db = new PetaPoco.Database(ModelConfig.connectionStringName("bikes")); // db.Insert(payment); // return payment; //} //public static void deletePayment(int id) //{ // Database db = new PetaPoco.Database("bikes-clunie"); // db.Execute("DELETE FROM payment WHERE id = @0", id); //} internal void save() { using (Database db = new PetaPoco.Database(ModelConfig.connectionStringName("bikes"))) { db.Save(this); } }
void IClass.BatchBuildClass(CheckIn.Model.Class classInfo, DateTime startTime, CycleEnum cycle, int time) { for (int i = 1; i < time; i++) { Entity.ClassEntity entity = new Entity.ClassEntity(); entity.ClassLevel = classInfo.Level; entity.ClassTime = classInfo.ClassTime; entity.Description = classInfo.Description; entity.StartTime = getTime(startTime, cycle, i); entity.EndTime = entity.StartTime.AddMinutes(Common.GlobalVariable.ClassTimeMinute); entity.InputTime = DateTime.Now; entity.InputUser = classInfo.InputUser; entity.Name = classInfo.Name; entity.Teacher = classInfo.Teacher; entity.Type = classInfo.Type; _db.Save(entity); } }
public void save() { using (Database db = new PetaPoco.Database(ModelConfig.connectionStringName("bikes"))) { if (id == Bike.DefaultId) { //cannot change name for the default bike name = DefaultName; } db.Save(this); } }
private void btnOK_Click(object sender, EventArgs e) { using (var db = new Database()) { if (EditMode == Web.Core.Enums.EnViewEditMode.Edit) { var kt = db.FirstOrDefault<t_ware>("where warename=@0 and guid <> @1", txtName.Text,GuidKey); if (null != kt) { MsgBox.ShowMessage("提示", "仓库名称已存在!"); txtName.Select(); return; } var et = db.FirstOrDefault<t_ware>(" where guid=@0", this.GuidKey); et.WareName = txtName.Text; et.WareCode = txtCode.Text; et.IsUsing = chk.Checked; db.Save(et); } else { var kt = db.FirstOrDefault<t_ware>("where warename=@0", txtName.Text); if (null != kt) { MsgBox.ShowMessage("提示", "仓库名称已存在!"); txtName.Select(); return; } var et = new t_ware { Guid= Guid.NewGuid(), WareCode = txtCode.Text, WareName = txtName.Text, IsUsing = chk.Checked, Creator=this.CurUser, CreateDate=TimeSync.Default.CurrentSyncTime }; db.Save(et); } } DialogResult = System.Windows.Forms.DialogResult.OK; Close(); }
private void btnOK_Click(object sender, EventArgs e) { if (!dxValidationProvider1.Validate()) return; if (MsgBox.ShowYesNoMessage(null, "确定要保存修改吗?") == System.Windows.Forms.DialogResult.No) return; if (txtpwd.Text != txtrepwd.Text) { MsgBox.ShowMessage("", "两次输入的密码不一致!"); txtpwd.Select(); return; } var pwd = string.IsNullOrEmpty(txtpwd.Text) ? "888" : txtpwd.Text; var pwde = Util.EncryptPwd(pwd); if (EditMode == Ultra.Web.Core.Enums.EnViewEditMode.New) { using (var db = new Database()) { //检查用户名唯一性 var kt = db.FirstOrDefault<t_user>("select * from t_user where UserName=@0", txtusr.Text); if (null != kt) { MsgBox.ShowMessage("用户已存在", "用户已存在!"); txtusr.Select(); return; } db.Save(new t_user() { Guid = Guid.NewGuid(), UserName = txtusr.Text, Pwd = pwde, CreateDate = TimeSync.Default.CurrentSyncTime, Creator=this.CurUser, IsUsing=chk.Checked, Remark=string.Empty }); } } else if (EditMode == Ultra.Web.Core.Enums.EnViewEditMode.Edit) { using (var db = new Database()) { var et = db.FirstOrDefault<t_user>("where Guid=@0", GuidKey); if (null != et) { et.Guid = Guid.NewGuid(); et.UserName = txtusr.Text; et.Pwd = pwde; et.CreateDate = TimeSync.Default.CurrentSyncTime; et.Creator=this.CurUser; et.IsUsing=chk.Checked; et.Remark = string.Empty; } } } DialogResult = System.Windows.Forms.DialogResult.OK; Close(); }
public static Response QueryHelper <T>(string Query = "", string httpVerb = "GET", dynamic payload = null, bool getOneElement = false) where T : class { try { using (var db = new PetaPoco.Database("SWATDB")) { if (httpVerb == "GET") { if (!getOneElement) { var elements = db.Query <T>(Query).ToList(); return(ResponseHelper(ResponseContent: elements, Verb: httpVerb)); } else { var elements = db.FirstOrDefault <T>(Query); return(ResponseHelper(ResponseContent: elements, Verb: httpVerb)); } } if (httpVerb == "DELETE") { var elements = db.Execute(Query); return(ResponseHelper(ResponseCode: HttpStatusCode.OK, Verb: httpVerb)); } if (httpVerb == "POST" && payload != null) { var element = db.Insert(payload); return(ResponseHelper(ResponseContent: element, Verb: httpVerb)); } if (httpVerb == "PUT" && payload != null) { db.Save(payload); return(ResponseHelper(Verb: httpVerb)); } return(null); } } catch (Exception ex) { ConsoleMessage(httpVerb, string.Format("Error in {0} Query", typeof(T).GetType()), ex.Message); return(HttpStatusCode.InternalServerError); } }
private void btnOK_Click(object sender, EventArgs e) { if (!dxValidationProvider1.Validate()) return; if (EditMode == Ultra.Web.Core.Enums.EnViewEditMode.New) { using (var db = new Database()) { var kt = db.FirstOrDefault<t_item>("select * from t_item where itemno=@0", txtItemNo.Text); if (null != kt) { MsgBox.ShowMessage("编码已存在", "编码已存在!"); txtItemNo.Select(); return; } db.Save(new t_item() { Guid = Guid.NewGuid(), ItemName = txtItemName.Text, ItemNo = txtItemNo.Text, Price=spnPrice.Value, CostPrice=spnCostPrice.Value, CreateDate = TimeSync.Default.CurrentSyncTime, Creator=this.CurUser, IsUsing=chk.Checked, Remark=string.Empty }); } } else if (EditMode == Ultra.Web.Core.Enums.EnViewEditMode.Edit) { using (var db = new Database()) { var et = db.FirstOrDefault<t_item>("where Guid=@0", GuidKey); if (null != et) { et.ItemName = txtItemName.Text; et.ItemNo = txtItemNo.Text; et.Price=spnPrice.Value; et.CostPrice = spnCostPrice.Value; et.IsUsing=chk.Checked; et.Remark = string.Empty; } db.Save(et); } } DialogResult = System.Windows.Forms.DialogResult.OK; Close(); }
private void btnOK_Click(object sender, EventArgs e) { if (MsgBox.ShowYesNoMessage(null, "确定要保存吗?") == System.Windows.Forms.DialogResult.No) return; var usr = GetCurUser<t_user>(); for (int i = 0; i < memedt.Lines.Length; i++) { memedt.Lines[i] = memedt.Lines[i].Replace("-", string.Empty); } var exp = memedt.Lines.ToList().Where(k=>!string.IsNullOrEmpty(k.Trim().Replace("\r",string.Empty).Replace("\n",string.Empty))).Except(LstMac.Select(k => k.Mac).ToList()).ToList(); var ndel = LstMac.Select(k => k.Mac).ToList().Except(memedt.Lines.ToList().Where(k => !string.IsNullOrEmpty(k.Trim().Replace("\r", string.Empty).Replace("\n", string.Empty))).ToList()).ToList(); if (null != exp && exp.Count > 0) { using (var db = new Database()) { exp.ForEach(k => { db.Save(new t_mac { Guid = Guid.NewGuid(), IsUsing = true, Mac = k, Creator = usr.UserName, CreateDate=TimeSync.Default.CurrentSyncTime }); }); } } if (null != ndel && ndel.Count > 0) { var ins = ndel.Select(k=>"'"+k+"'").Aggregate((s1,s2)=> s1+","+s2).ToString(); SqlHelper.ExecuteNonQuery(ConnString,CommandType.Text, string.Format("delete from t_mac where mac in ({0})", ins)); } //MsgBox.ShowMessage(null, "保存成功!"); DialogResult = System.Windows.Forms.DialogResult.OK; Close(); }
private void btnOK_Click(object sender, EventArgs e) { if (!dxValidationProvider1.Validate()) return; if (EditMode == Ultra.Web.Core.Enums.EnViewEditMode.New) { using (var db = new Database()) { var et = db.FirstOrDefault<t_role>("where Name=@0", txtname.Text.Trim()); if (null != et) { MsgBox.ShowMessage(null, "名称已存在,不可重复添加!"); return; } db.Save(new t_role { Guid = Guid.NewGuid(), IsUsing = chk.Checked, Name = txtname.Text.Trim(), Creator = this.CurUser, Desc=txtdesc.Text.Trim(), CreateDate=TimeSync.Default.CurrentSyncTime, Remark=string.Empty }); } } else if (EditMode == Ultra.Web.Core.Enums.EnViewEditMode.Edit) { using (var db = new Database()) { var et = db.FirstOrDefault<t_role>(" where guid=@0", GuidKey); if (et != null) { db.Update<t_role>(" set isusing=@0,[desc]=@1 where guid=@2", chk.Checked, txtdesc.Text.Trim(), et.Guid); } } } DialogResult = System.Windows.Forms.DialogResult.OK; Close(); }
private void btnOK_Click(object sender, EventArgs e) { if (!dxValidationProvider1.Validate()) return; if (EditMode == Ultra.Web.Core.Enums.EnViewEditMode.New) { using (var db = new Database()) { db.Save(new t_member() { Guid = Guid.NewGuid(), ReceiverNo = txtReceiverNo.Text, ReceiverName = txtReceiverName.Text, ReceiverMobile=txtReceiverMobile.Text, ReceiverAddress=txtReceiverAddress.Text, CreateDate = TimeSync.Default.CurrentSyncTime, Creator=this.CurUser, IsUsing=chk.Checked, Remark=txtRemark.Text }); } } else if (EditMode == Ultra.Web.Core.Enums.EnViewEditMode.Edit) { using (var db = new Database()) { var et = db.FirstOrDefault<t_member>("where Guid=@0", GuidKey); if (null != et) { et.ReceiverNo = txtReceiverNo.Text; et.ReceiverName = txtReceiverName.Text; et.ReceiverMobile=txtReceiverMobile.Text; et.ReceiverAddress=txtReceiverAddress.Text; et.IsUsing=chk.Checked; et.Remark = txtRemark.Text; } db.Save(et); } } DialogResult = System.Windows.Forms.DialogResult.OK; Close(); }
string IStudent.ImportStudent(string file) { var ds = GetExcelData(file); int i = 0, j = 0; string msg = ""; foreach (DataRow dr in ds.Tables[0].Rows) { try { var saveStudent = new entity.StudentEntity(); saveStudent.Name = dr[1].ToString(); saveStudent.FatherTelephone = dr[2].ToString(); saveStudent.MotherTelephone = dr[3].ToString(); _db.Save(saveStudent); i++; } catch (Exception e) { j++; } } return(string.Format("成功导入数据{0}条,失败{1}条", i, j)); }
protected void SaveNewUpd(bool flgChkAuto) { bool flgNew = false; bool flgValid = false; try { //Validate first... flgValid = validateFields(); // if (!flgValid) { return; } // Create a PetaPoco database object var db = new PetaPoco.Database("Shell_AutoArchDBConnectionString"); // Get a record var a = db.SingleOrDefault <planning>("SELECT * FROM shell_Planning WHERE UniqueId=@0", txt_uniqueid.Text); //Test if record exists... if (null == a) { a = new planning(); flgNew = true; } //if update, check if status is not equal to CVR... or Closed... else if (flgChkAuto) { if (txt_status.Text.IndexOf("Archival Order Closed") == -1) { if ((a.Status.IndexOf("Rejected") >= 0) || (a.Status.IndexOf("CVR Created") >= 0)) //Rejected { ClrFields(false); return; } } } // Change it // if (txt_actaoenddate.Text != a.ActAOEndDate.ToString("yyyy-MM-dd HH:mm:ss.ttt")) { a.ActAOEndDate = DateTime.Parse(txt_actaoenddate.Text); } // if (txt_actaoreceivedate.Text != a.ActAOReceiveDate.ToString("yyyy-MM-dd HH:mm:ss.ttt")) { a.ActAOReceiveDate = DateTime.Parse(txt_actaoreceivedate.Text); } // if (txt_actaostartdate.Text != a.ActAOStartDate.ToString("yyyy-MM-dd HH:mm:ss.ttt")) { a.ActAOStartDate = DateTime.Parse(txt_actaostartdate.Text); } // if (txt_colsitenum.Text != "") { if (Convert.ToInt16(txt_colsitenum.Text) != a.ColSiteNum) { a.ColSiteNum = Convert.ToInt16(txt_colsitenum.Text); } } // if (txt_comment.Text != a.Comment) { a.Comment = txt_comment.Text; } // if (chk_dataexpctrchk.Checked) { a.DataExpCtrChk = 1; } else { a.DataExpCtrChk = 0; } // if (txt_duname.Text != a.DUName) { a.DUName = txt_duname.Text; } // // if ((txt_actaostartdate.Text != "") && (txt_actaoenddate.Text != "")) { DateTime dtf = DateTime.Parse(txt_actaostartdate.Text); DateTime dtt = DateTime.Parse(txt_actaoenddate.Text); a.DurationWorkDays = GetWorkingDays(dtf, dtt); } else if (Convert.ToInt16(txt_durationworkdays.Text) != a.DurationWorkDays) { a.DurationWorkDays = Convert.ToInt16(txt_durationworkdays.Text); } // // if (txt_operatorname.Text != a.OperatorName) { a.OperatorName = txt_operatorname.Text; } // if (txt_planaoenddate.Text != a.PlanAOEndDate.ToString("yyyy-MM-dd HH:mm:ss.ttt")) { a.PlanAOEndDate = DateTime.Parse(txt_planaoenddate.Text); } // if (txt_planaoreceivedate.Text != a.PlanAOReceiveDate.ToString("yyyy-MM-dd HH:mm:ss.ttt")) { a.PlanAOReceiveDate = DateTime.Parse(txt_planaoreceivedate.Text); } // if (txt_planaostartdate.Text != a.PlanAOStartDate.ToString("yyyy-MM-dd HH:mm:ss.ttt")) { a.PlanAOStartDate = DateTime.Parse(txt_planaostartdate.Text); } // if (txt_status.Text != a.Status) { a.Status = txt_status.Text; } // if (txt_instanceid.Text != a.InstanceId) { a.InstanceId = txt_instanceid.Text; } // if ((float)Convert.ToDouble(txt_volumegb.Text) != a.VolumeGB) { a.VolumeGB = (float)Convert.ToDouble(txt_volumegb.Text); } // if (chk_waiverchk.Checked) { a.WaiverChk = 1; } else { a.WaiverChk = 0; } // string msg = "Archiving Order updated! - "; if (flgNew) { a.UniqueId = txt_uniqueid.Text; msg = "New Archiving Order inserted! - "; db.Save(a); } else { db.Update(a); } if (flgChkAuto) { divMessage.InnerHtml += "<span id='msg' style='color:#FF3300;font-size:Smaller;font-weight:bold;'>" + msg + txt_uniqueid.Text + " </span><br>"; } else { divMessage.InnerHtml = "<span id='msg' style='color:#FF3300;font-size:Smaller;font-weight:bold;'>" + msg + txt_uniqueid.Text + " </span>"; } } catch (Exception eg) { if (flgChkAuto) { divMessage.InnerHtml += "<span id='msg' style='color:#FF3300;font-size:Smaller;font-weight:bold;'>" + "Error Message: " + eg.Message + " </span>"; } else { divMessage.InnerHtml = "<span id='msg' style='color:#FF3300;font-size:Smaller;font-weight:bold;'>" + "Error Message: " + eg.Message + " </span>"; } } }
public static string CrearCiudad(Ciudad ciudad) { try { using (var db = new Database("riesgos")) { var cuenta = db.SingleOrDefault<int>("select count(id) from ciudad where nombre = @0", ciudad.Nombre); if (cuenta > 0) return "Ya existe una ciudad con el mismo nombre"; db.Save("ciudad", "id", ciudad); return ""; } } catch (Exception ex) { return "Error de ejecución: " + ex.Message; } }
private void btnOK_Click(object sender, EventArgs e) { var items = gcItem.GetDataSource<t_instockitem>(); if (items == null || items.Count < 1) { MsgBox.ShowMessage("", "没有商品信息,不能保存!"); return; } if (items.Any(K => string.IsNullOrEmpty(K.ItemNo))) { MsgBox.ShowMessage("", "商品信息不完整!"); return; } if (EditMode == Web.Core.Enums.EnViewEditMode.Edit) { using (var db = new Database()) { try { db.BeginTransaction(); db.Execute("delete t_instockitem where instockno=@0", InStockNo); InStock.Remark = txtRemark.Text; InStock.Num = items.Sum(k => k.Num); InStock.OuterNo = txtOuterNo.Text; db.Save(InStock); items.ForEach(k => { k.Id = 0; db.Save(k); }); db.CompleteTransaction(); } catch (Exception) { db.AbortTransaction(); throw; } } } else { InStock = new t_instock(); InStock.Remark = txtRemark.Text; InStock.Guid = GuidKey; InStock.InStockNo = InStockNo; InStock.OuterNo = txtOuterNo.Text; InStock.Creator = this.CurUser; InStock.AuditDate = InStock.CreateDate = TimeSync.Default.CurrentSyncTime; InStock.Num = items.Sum(k => k.Num); using (var db = new Database()) { try { db.BeginTransaction(); db.Save(InStock); items.ForEach(k => db.Save(k)); db.CompleteTransaction(); } catch (Exception) { db.AbortTransaction(); throw; } } } DialogResult = DialogResult.OK; Close(); }
private void btnSaveToSvr_Click(object sender, EventArgs e) { if (MsgBox.ShowYesNoMessage("", "确定要保存菜单至服务器?") == System.Windows.Forms.DialogResult.No) return; using (var db = new Database()) { var mnu = db.FirstOrDefault<t_menu>("select * from t_menu"); if (mnu == null) { mnu = new t_menu { Guid = Guid.NewGuid(), Version = "1.0", MenuXml = BuildMenuXml(), CreateDate = TimeSync.Default.CurrentSyncTime }; } else { mnu.MenuXml = BuildMenuXml(); } db.Save(mnu); } MsgBox.ShowMessage("", "保存成功!"); }
private void btnOK_Click(object sender, EventArgs ea) { var k = roleGridEdit1.GetSelectedValue(); if (null == k) return; List<MenuCtlData> lst = new List<MenuCtlData>(100); foreach (TreeListNode td in treeCtl1.Nodes) { var mnugrp = td.GetValue(0).ToString(); foreach (TreeListNode tds in td.Nodes) { var mnuname = tds.GetValue(0).ToString(); foreach (TreeListNode tmd in tds.Nodes) { var mcd = tmd.Tag as MenuCtlData; if (null != mcd) { mcd.IsEnabled = tmd.Checked; mcd.MenuGrpName = mnugrp; mcd.MenuName = mnuname; lst.Add(mcd); } foreach (TreeListNode tkd in tmd.Nodes) { var md = tkd.Tag as MenuCtlData; if (null == md) continue; md.IsEnabled = tkd.Checked; md.MenuGrpName = mnugrp; md.MenuName = mnuname; lst.Add(md); } } } } var usr = GetCurUser<t_user>(); using (var db = new Database()) { var et = db.FirstOrDefault<t_roleset>("select * from t_roleset where RoleId=@0", k.Id); var roleset = et; if (et != null) { roleset.RoleSetTree = Ultra.Web.Core.Common.ObjectHelper.SerializeJson(lst); } else { roleset = new t_roleset { RoleSetTree = Ultra.Web.Core.Common.ObjectHelper.SerializeJson(lst), RoleId = k.Id, IsUsing = true, RoleName = k.Name, Guid = Guid.NewGuid(), Creator =this.CurUser, CreateDate = TimeSync.Default.CurrentSyncTime }; } db.Save(roleset); } MsgBox.ShowMessage(null, "保存成功!"); }
private void btnOK_Click(object sender, EventArgs e) { if (!dxValidationProvider1.Validate()) return; var odrs = gcOrder.GetDataSource<t_retorder>(); if (odrs == null || odrs.Count < 1) { MsgBox.ShowMessage("提示", "没有退货商品不能保存退货单!"); return; } if (odrs.Any(k=>string.IsNullOrEmpty(k.LocName))) { MsgBox.ShowMessage("提示", "所有商品都必须选择库位!"); return; } if (EditMode == Ultra.Web.Core.Enums.EnViewEditMode.New) { var rettrd = this.Trade; rettrd.Guid = Guid.NewGuid(); rettrd.Id = 0; rettrd.IsAudit = false; using (var db = new Database()) { try { db.BeginTransaction(); db.Save(rettrd); odrs.ForEach(k => { k.Guid = Guid.NewGuid(); k.Id = 0; k.TradeGuid = rettrd.Guid; db.Save(k); }); db.CompleteTransaction(); } catch (Exception) { db.AbortTransaction(); throw; } } } else if (EditMode == Ultra.Web.Core.Enums.EnViewEditMode.Edit) { using (var db = new Database()) { var trd = db.FirstOrDefault<t_rettrade>(" where guid=@0", GuidKey); trd.ReceiverName = Trade.ReceiverName; trd.ReceiverMobile = txtMobile.Text; trd.ReceiverAddress = txtReceiverAddress.Text; trd.MemberGuid = Trade.Guid; trd.DeliveryDate = TimeSync.Default.CurrentSyncTime; trd.DeliveryDate = dateDeliveryDate.DateTime; try { db.BeginTransaction(); db.Save(trd); db.Execute("delete t_retorder where tradeguid=@0", trd.Guid); odrs.ForEach(k => { k.Id = 0; db.Save(k); }); db.CompleteTransaction(); } catch (Exception) { db.AbortTransaction(); throw; } } } DialogResult = System.Windows.Forms.DialogResult.OK; Close(); }
public void setAsPaid(int paymentId) { payment_id = paymentId; paid = true; using (Database db = new PetaPoco.Database(ModelConfig.connectionStringName("bikes"))) { db.Save(this); } }