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