/// <summary>
/// 添加 本地订单包裹
/// </summary>
/// <param name="local_package"></param>
/// <returns></returns>
public bool addLocalPackage(LocalPackage local_package)
{
bool flag = false;
string sql = "insert into tb_local_package values('" + local_package.Wm_track_no + "','" + local_package.Order_number + "','" + local_package.Name + "','" + local_package.Cd_track_no + "','" + local_package.Ea_track_no + "','" + local_package.S_track_no + "','" + local_package.Local_track + "','" + local_package.Shipmentpurpose + "','"
+ local_package.Packagedescription + "'," + local_package.Packagevalue + "," + local_package.Weight + ",'" + local_package.Servicecode + "','" + local_package.Is_pay + "'," + local_package.Insurance + "," + local_package.Pay_before_discount + "," + local_package.Discount + "," + local_package.Pay_after_discount + "," + local_package.Less_pay + "," + local_package.True_weight + ")";
if (new DBOperateCommon().excuteNoQuery(sql))
{
flag = true;
}
return(flag);
}
public bool updateLocalTrackNo(LocalPackage local_package)
{
bool flag = false;
string sql = "update tb_local_package set local_track='" + local_package.Local_track + "' where ea_track_no='" + local_package.Ea_track_no + "'";
if (new DBOperateCommon().excuteNoQuery(sql))
{
flag = true;
}
return(flag);
}
/// <summary>
/// 通过本地单号获取本地订单
/// </summary>
/// <param name="orderno"></param>
/// <returns></returns>
public ArrayList getLocalPackageByOrderNo(string orderno)
{
ArrayList array = new ArrayList();
string sql = "select * from tb_local_package where order_no='" + orderno + "'";
DataTable table = new DBOperateCommon().excuteQuery(sql);
for (int i = 0; i < table.Rows.Count; i++)
{
LocalPackage local_package = new LocalPackage();
local_package.Wm_track_no = table.Rows[i]["wm_track_no"].ToString();
local_package.Order_number = table.Rows[i]["order_no"].ToString();
local_package.Name = table.Rows[i]["name"].ToString();
local_package.Cd_track_no = table.Rows[i]["cd_track_no"].ToString();
local_package.Ea_track_no = table.Rows[i]["ea_track_no"].ToString();
local_package.S_track_no = table.Rows[i]["s_track_no"].ToString();
local_package.Local_track = table.Rows[i]["local_track"].ToString();
local_package.Shipmentpurpose = table.Rows[i]["shipmentpurpose"].ToString();
local_package.Packagedescription = table.Rows[i]["packagedescription"].ToString();
local_package.Packagevalue = Convert.ToSingle(table.Rows[i]["packagevalue"].ToString());
local_package.Weight = Convert.ToSingle(table.Rows[i]["package_weight"].ToString());
local_package.Servicecode = table.Rows[i]["servicecode"].ToString();
local_package.Is_pay = table.Rows[i]["is_pay"].ToString();
local_package.Insurance = Convert.ToSingle(table.Rows[i]["insurance"].ToString());
local_package.Pay_before_discount = Convert.ToSingle(table.Rows[i]["pay_before_discount"].ToString());
local_package.Discount = Convert.ToSingle(table.Rows[i]["discount"].ToString());
local_package.Pay_after_discount = Convert.ToSingle(table.Rows[i]["pay_after_discount"].ToString());
local_package.Less_pay = Convert.ToSingle(table.Rows[i]["less_pay"].ToString());
local_package.True_weight = Convert.ToSingle(table.Rows[i]["true_weight"].ToString());
array.Add(local_package);
}
return(array);
}
