public ActionResult SubmitExpressInfo(ExpressModel model) { using (var dbcontext = new ExpressDBContext()) { if (model.ExpressType == ExpressType.Receive) { var express = new ExpressReceiveInfo(); express.ExpressNo = model.ExpressNo; express.MailType = model.MailType; express.Phone = model.Phone; express.ReceiveTime = DateTime.Now; express.Status = MailReceiveStatus.WaitForSign; express.Name = model.Name; dbcontext.ExpressReceiveInfos.Add(express); } else { var express = new ExpressSendInfo(); express.ExpressNo = model.ExpressNo; express.MailType = model.MailType; express.Phone = model.Phone; express.ReceiveTime = DateTime.Now; express.Status = MailSendStatus.WaitSend; express.Name = model.Name; dbcontext.ExpressSendInfos.Add(express); } dbcontext.SaveChanges(); } return(Json(new { Success = true }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ExpressModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ExpressTab set "); strSql.Append("express=@express,"); strSql.Append("Expressdata=@Expressdata,"); strSql.Append("recommend=@recommend"); strSql.Append(" where expressID=@expressID"); SqlParameter[] parameters = { new SqlParameter("@expressID", SqlDbType.Int, 4), new SqlParameter("@express", SqlDbType.NVarChar, 3000), new SqlParameter("@Expressdata", SqlDbType.DateTime), new SqlParameter("@recommend", SqlDbType.Int, 4) }; parameters[0].Value = model.expressID; parameters[1].Value = model.express; parameters[2].Value = model.Expressdata; parameters[3].Value = model.recommend; int rows = DBHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public int Add(ExpressModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ExpressTab("); strSql.Append("express,Expressdata,recommend)"); strSql.Append(" values ("); strSql.Append("@express,@Expressdata,@recommend)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@express", SqlDbType.NVarChar, 3000), new SqlParameter("@Expressdata", SqlDbType.DateTime), new SqlParameter("@recommend", SqlDbType.Int, 4) }; parameters[0].Value = model.express; parameters[1].Value = model.Expressdata; parameters[2].Value = model.recommend; object obj = DBHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
private void ComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e) { ExpressModel expTempLate = expCB.SelectedValue as ExpressModel; if (expTempLate != null) { double zoom = 0.8; expressGrid.ShowExpress(expTempLate, zoom); expBorder.Width = expGrid.Width - 88 * zoom; } }
private void bindModel(int id) { model = bll.GetModel(id); txtUrlAdd.Text = model.express; if (model.recommend == 0) { rdoNo.Checked = true; } else { rdoYes.Checked = true; } }
public int PostExpress(ExpressModel model) { try { string msg = $"ExpressController 进行了添加操作 数据为{JsonConvert.SerializeObject(model)}"; LogHelper.Logger.Info(msg); string sql = $"insert into express VALUES(DEFAULT(express.ExpressId),'{model.ExpBH}','{model.ExpCompany}','{model.ExpInfo}')"; int n = DBHelper.ExecuteNonQuery(sql); return(n); } catch (Exception ex) { string msg = $"错误ExpressController 进行了添加操作 数据为{JsonConvert.SerializeObject(model)}"; LogHelper.Logger.Error(msg, ex); throw; } }
protected void btnUpdate_Click(object sender, EventArgs e) { int expressId = int.Parse(Request.QueryString["expressId"].ToString()); model = bll.GetModel(expressId); model.express = txtUrlAdd.Text.Trim(); if (rdoYes.Checked) { model.recommend = 1; } else { model.recommend = 0; } if (!bll.Update(model)) { Response.Write("<script>alert('更新失败!');document.location='ExpressMange.aspx'</script>"); } else { Response.Redirect("ExpressMange.aspx"); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ExpressModel GetModel(int expressID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 expressID,express,Expressdata,recommend from ExpressTab "); strSql.Append(" where expressID=@expressID"); SqlParameter[] parameters = { new SqlParameter("@expressID", SqlDbType.Int, 4) }; parameters[0].Value = expressID; ExpressModel model = new ExpressModel(); DataSet ds = DBHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["expressID"].ToString() != "") { model.expressID = int.Parse(ds.Tables[0].Rows[0]["expressID"].ToString()); } model.express = ds.Tables[0].Rows[0]["express"].ToString(); if (ds.Tables[0].Rows[0]["Expressdata"].ToString() != "") { model.Expressdata = DateTime.Parse(ds.Tables[0].Rows[0]["Expressdata"].ToString()); } if (ds.Tables[0].Rows[0]["recommend"].ToString() != "") { model.recommend = int.Parse(ds.Tables[0].Rows[0]["recommend"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 编辑联系人 /// </summary> /// <param name="ID">联系人ID</param> public ContactEditVM(Guid ID) { 联系人信息 = Global.SQL.IDSelectContact <ContactModel>(ID); if (联系人信息 != null) { isNewInfo = false; //------名称------ _名称 = 联系人信息.称; //------公司------ Guid _公司ID = 联系人信息.公司ID; CompanyModel companyInfo = Global.AllCompanies.FirstOrDefault(_func => _func.ID == _公司ID); if (companyInfo == null) { _公司名称 = "未找到所在公司"; } else { _公司名称 = companyInfo.称; } //------性别------ if (联系人信息.性别 == true) { 男 = true; } else if (联系人信息.性别 == false) { 女 = true; } //------标题------ _标题 = string.Format("{0} - 联系人管理>>编辑[{1}]信息", Global.User.公司名称, _名称); //------_快递ID------ Guid?_快递ID = 联系人信息.快递ID; if (_快递ID == null || _快递ID == Guid.Empty) { _快递 = "无"; } else { ExpressModel expressInfo = Global.AllExpresses.FirstOrDefault(_func => _func.ID == _快递ID); if (expressInfo == null) { _快递 = "无"; } else { _快递 = expressInfo.称; } } //------_说明------ _说明 = string.Format("ID:{0}\r\n信息创建于 {1}", 联系人信息.ID, 联系人信息.CreateTime.ToLongDateString()); if (联系人信息.CreateTime != 联系人信息.UpdateTime) { _说明 += string.Format("\r\n最后一次更改与{0}", 联系人信息.UpdateTime.ToLongDateString()); } //------初始化构造函数重载共同部分------ Initialize(); } else { throw new ArgumentOutOfRangeException("[联系人ID]无效"); } }
/// <summary> /// 非燕文货物也存临时表 /// </summary> /// <param name="model"></param> /// <param name="orders"></param> /// <returns></returns> public Result <bool> SaveExpress(EpcCombineModel model, List <string> orders) { var result = new Result <bool>() { HasError = false }; var value = GetCombineOrderModel(orders).total_value; var carrierModel = GetCarrier(model.carrier.ToString(), 0); if (carrierModel == null) { result.HasError = true; result.ErrorMsg = $"没有找到对应carrier[{model.carrier}]的服务配置!请配置"; return(result); } using (var conn = OpenConnection()) { using (var tx = conn.BeginTransaction()) { try { var express = new ExpressModel() { }; express.WaybillNumber = model.BarCode; express.OrderCode = ""; express.ExchangeNumber = model.BarCode; express.Piece = orders.Count; express.Weight = model.Weight; express.SupplierWeight = model.Weight; express.TrueWeight = model.Weight; express.ApSpecialAmount = value; express.ApDeclaredValue = value; express.ArDeclaredValue = value; express.ArDeclaredValue = value; express.CompanyCode = "10"; express.SourceId = 12; express.CreateId = "92315"; express.CustomerCode = 30045174; express.RegionId = 2860; express.PostCode = "523000"; express.CreateTime = DateTime.Now; express.AscanTime = DateTime.Now; express.ReceiveDate = DateTime.Now; express.PlatformOrderTime = DateTime.Now; express.EPReceiveDate = DateTime.Now; express.CustomerDiscountLevel = "0"; express.AreaCode = "1003"; express.ServiceCode = carrierModel.ServiceCode; express.SupplierCode = carrierModel.SupplierCode; express.ProductCode = carrierModel.YanWenProductCode; express.PrintSortingCode = $"{express.CompanyCode}-{express.SupplierCode}-{express.ServiceCode}-{carrierModel.RuleCode}"; express.SettlementCompanyCode = "10"; express.OutWarehouse = "10"; //快件信息临时表保存 SaveTamExpressDal.Instance.Insert(express, conn, tx); tx.Commit(); } catch (Exception e) { tx.Rollback(); result.HasError = true; result.ErrorMsg = "保存快件临时表出错 " + e.Message; return(result); } } } return(result); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ExpressModel model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ExpressModel model) { return(dal.Add(model)); }
public int Insert(ExpressModel model, IDbConnection conn, IDbTransaction tx) { var sql = "Insert into [dbo].[EPC_TemExpress] (StatusId ,WaybillNumber,ExchangeNumber,OrderCode,CustomerCode, " + "ServiceCode,SupplierCode, RegionId, ReceiveDate, TrueWeight, ExpressLength, ExpressWidth, " + "ExpressHigh,CompanyCode, Piece, Memo, CreateId, CreateTime, SourceId, ArDeclaredValue, " + "ApDeclaredValue,DeclaredCurrencyId, SettlementCompanyCode,YanwenNumber,PrintSortingCode, " + "NeedRemoteSurcharge,NeedOverLength,CustomerDiscountLevel,ProductCode,PostCode, " + "IsArSpecial,IsApSpecial,ArSpecialAmount,ApSpecialAmount,AreaCode,EPReceiveDate,OutWarehouse, " + "DestinationWarehouse,SupplierWeight,[SalesCode],PlatformOrderTime,WarehouseSurcharge) " + "values(@StatusId,@WaybillNumber,@ExchangeNumber,@OrderCode,@CustomerCode,@ServiceCode, " + "@SupplierCode,@RegionId,@ReceiveDate,@TrueWeight,@ExpressLength,@ExpressWidth,@ExpressHigh, " + "@CompanyCode,@Piece,@Memo,@CreateId,@CreateTime,@SourceId,@ArDeclaredValue,@ApDeclaredValue, " + "@DeclaredCurrencyId,@SettlementCompanyCode,@YanwenNumber,@PrintSortingCode,@NeedRemoteSurcharge, " + "@NeedOverLength,@CustomerDiscountLevel,@ProductCode,@PostCode,@IsArSpecial,@IsApSpecial, " + "@ArSpecialAmount,@ApSpecialAmount,@AreaCode,@EPReceiveDate,@OutWarehouse,@DestinationWarehouse, " + "@SupplierWeight,@SalesCode,@PlatformOrderTime,@WarehouseSurcharge)"; var count = conn.Execute(sql, new { StatusId = model.StatusId != 10 ? 1 : model.StatusId, model.WaybillNumber, model.ExchangeNumber, model.OrderCode, model.CustomerCode, model.ServiceCode, model.SupplierCode, model.RegionId, model.ReceiveDate, model.TrueWeight, model.ExpressLength, model.ExpressWidth, model.ExpressHigh, model.CompanyCode, model.Piece, Memo = model.Memo ?? string.Empty, model.CreateId, model.CreateTime, model.SourceId, model.ArDeclaredValue, ApDeclaredValue = model.ArDeclaredValue, model.DeclaredCurrencyId, model.SettlementCompanyCode, YanwenNumber = model.YanwenNumber ?? "", model.PrintSortingCode, model.NeedRemoteSurcharge, model.NeedOverLength, model.CustomerDiscountLevel, model.ProductCode, PostCode = model.PostCode.Trim(), IsArSpecial = false, IsApSpecial = false, ArSpecialAmount = 0, ApSpecialAmount = 0, model.AreaCode, model.EPReceiveDate, OutWarehouse = model.OutWarehouse ?? "10",//默认东莞 DestinationWarehouse = model.DestinationWarehouse ?? "", model.SupplierWeight, model.SalesCode, model.PlatformOrderTime, model.WarehouseSurcharge, }, tx); return(count); }