public int AddOrder(string passCode, int oType, int StoresSupplierID,
string oCustomersName, string oCustomersContact, string oCustomersTel, string oCustomersAddress, string oCustomersOrderID, string oCustomersNameB,
int oPrepay, string oReMake, string _OrderListDataJson)
{
int StaffID = 0;
int UserID = 0;
int OrderID = 0;
if (checkPassCode(passCode))
{
StaffInfo _sf = new StaffInfo();
UserInfo _ui = new UserInfo();
GeneralConfigInfo _cf = new GeneralConfigInfo();
_cf = GeneralConfigs.GetConfig();
if (_cf.Server_Staff.Trim() != "")
{
_sf = tbStaffInfo.GetStaffInfoModelByName(_cf.Server_Staff.Trim());
if (_sf != null)
{
StaffID = _sf.StaffID;
}
}
if (_cf.Server_User.Trim() != "")
{
_ui = tbUserInfo.GetUserInfoModelByUserName(_cf.Server_User.Trim());
if (_ui != null)
{
UserID = _ui.UserID;
}
}
/*
* _OrderListDataJson = {"ProductsCode":"","StorageCode":"","Quantity":0,"Money":0}
*/
_OrderListDataJson = "";
OrderInfo oi = new OrderInfo();
oi.oOrderNum = "----------";
oi.oType = oType;
oi.StoresID = StoresSupplierID;
oi.oCustomersName = oCustomersName;
oi.oCustomersContact = oCustomersContact;
oi.oCustomersTel = oCustomersTel;
oi.oCustomersAddress = oCustomersAddress;
oi.oCustomersOrderID = oCustomersOrderID;
oi.oCustomersNameB = oCustomersNameB;
oi.StaffID = StaffID;
oi.UserID = UserID;
oi.oAppendTime = DateTime.Now;
oi.oOrderDateTime = DateTime.Now;
oi.oState = 0;
oi.oSteps = 1;
oi.oPrepay = oPrepay;
oi.oReMake = oReMake;
oi.OrderListDataJson = (OrderListDataJson)JavaScriptConvert.DeserializeObject(_OrderListDataJson, typeof(OrderListDataJson));
OrderID = Orders.AddOrderInfoAndList(oi);
if (OrderID > 0)
{
OrderWorkingLogInfo owl = new OrderWorkingLogInfo();
owl.OrderID = OrderID;
owl.UserID = 0;
owl.oType = 0;
owl.oMsg = "";
owl.pAppendTime = DateTime.Now;
Orders.AddOrderWorkingLogInfo(owl);
}
}
return(OrderID);
}
protected virtual void Page_Load(object sender, EventArgs e)
{
string Act = HTTPRequest.GetString("Act");
int pagesize = HTTPRequest.GetInt("pagesize", 0);
int page = HTTPRequest.GetInt("page", 0);
ProductList = tbProductsInfo.GetProductsInfoList("").Tables[0];
if (Act != "")
{
Response.ClearContent();
Response.Buffer = true;
Response.ExpiresAbsolute = System.DateTime.Now.AddYears(-1);
Response.Expires = 0;
string Json_Str = "";
if (ispost)
{
if (Act == "Add")
{
try
{
string JsonStr = HTTPRequest.GetString("json");
Order oo = (Order)JavaScriptConvert.DeserializeObject(JsonStr, typeof(Order));
if (oo != null)
{
if (oo.O_ORDERNUM.Trim() != "")
{
if (!Orders.ExistsOrderInfo(oo.O_ORDERNUM))
{
bool isneworder = false;
OrderInfo oi = new OrderInfo();
oi.oOrderNum = oo.O_ORDERNUM;
oi.oType = (oo.O_REMARK == "4") ? 1 : (oo.O_REMARK == "8") ? 2 : (oo.O_REMARK == "1") ? 3 : (oo.O_REMARK == "5") ? 4 : (oo.O_REMARK == "2") ? 5 : (oo.O_REMARK == "3") ? 6 : (oo.O_REMARK == "7") ? 7 : (oo.O_REMARK == "6") ? 10 : 0;
switch (oi.oType)
{
case 1:
case 2: //供货商
SupplierInfo si = new SupplierInfo();
try
{
si = tbSupplierInfo.GetSupplierInfoModelByName(oo.c_name);
if (si != null)
{
oi.StoresID = si.SupplierID;
oi.oCustomersName = si.sName;
oi.oCustomersContact = si.sLinkMan;
oi.oCustomersTel = si.sTel;
oi.oCustomersAddress = si.sAddress;
}
}
finally
{
si = null;
}
break;
case 3:
case 4:
case 5:
case 6:
case 7:
StoresInfo sti = new StoresInfo();
try
{
sti = tbStoresInfo.GetStoresInfoModelByName(oo.c_name);
if (sti != null)
{
oi.StoresID = sti.StoresID;
oi.oCustomersName = sti.sName;
oi.oCustomersContact = sti.sContact;
oi.oCustomersTel = sti.sTel;
oi.oCustomersAddress = sti.sAddress;
}
}
finally
{
sti = null;
}
break;
case 10:
oi.StoresID = 0;
oi.oCustomersName = "";
oi.oCustomersContact = "";
oi.oCustomersTel = "";
oi.oCustomersAddress = "";
break;
}
oi.oCustomersOrderID = oo.C_ORDERID;
oi.oCustomersNameB = oo.C_MD;
StaffInfo sai = new StaffInfo();
sai = tbStaffInfo.GetStaffInfoModelByName(oo.sa_name);
if (sai != null)
{
oi.StaffID = sai.StaffID;
}
oi.UserID = this.userid;
oi.oAppendTime = Convert.ToDateTime(oo.O_TIME);
oi.oOrderDateTime = Convert.ToDateTime(oo.O_CREATETIME);
oi.oState = 0;
oi.oSteps = 1;
isneworder = (oo.O_ISCHECK == "1") ? true : false;
string tListStr = "";
if (oo.OrderData != null)
{
foreach (OrderData od in oo.OrderData)
{
ProductsInfo pi = new ProductsInfo();
try
{
pi = tbProductsInfo.GetProductsInfoModelByName(od.p_name);
if (pi == null)
{
pi = tbProductsInfo.GetProductsInfoModelByBarcode(od.p_code);
}
tListStr += "{\"OrderListID\":0,\"OrderID\":0,\"StorageID\":1,\"ProductsID\":" + pi.ProductsID + ",\"oQuantity\":" + Convert.ToDecimal(od.s_quantity) + ",\"oPrice\":" + Convert.ToDecimal(od.s_price) + ",\"oMoney\":" + Convert.ToDecimal(od.s_total) + ",\"StoresSupplierID\":" + oi.StoresSupplierID + ",\"IsPromotions\":0,\"oWorkType\":0,\"oAppendTime\":\"" + oi.oAppendTime + "\"," +
"\"OrderFieldValueInfo\":[{\"OrderFieldValueID\":0,\"OrderFieldID\":1,\"OrderListID\":0,\"oFieldValue\":\"" + od.makedate + "\",\"IsVerify\":0,\"oAppendTime\":\"" + oi.oAppendTime + "\"}," +
"{\"OrderFieldValueID\":0,\"OrderFieldID\":2,\"OrderListID\":0,\"oFieldValue\":\"" + od.Manufacturers + "\",\"IsVerify\":0,\"oAppendTime\":\"" + oi.oAppendTime + "\"}," +
"{\"OrderFieldValueID\":0,\"OrderFieldID\":3,\"OrderListID\":0,\"oFieldValue\":\"" + od.Durability + "\",\"IsVerify\":0,\"oAppendTime\":\"" + oi.oAppendTime + "\"}]},";
}
finally
{
pi = null;
}
}
}
if (tListStr.Trim() != "")
{
tListStr = tListStr.Substring(0, tListStr.Length - 1);
}
tListStr = "{\"OrderListJson\":[" + tListStr + "]}";
oi.OrderListDataJson = (OrderListDataJson)JavaScriptConvert.DeserializeObject(tListStr, typeof(OrderListDataJson));;
int OrderID = Orders.AddOrderInfoAndList(oi);
{
oi = Orders.GetOrderInfoModel(OrderID);
//完成审核操作
Orders.VerifyOrder(oi.OrderID);
tbProductsInfo.UpdateProductsStorageByOrderID(OrderID);//更新当前在途库存情况
OrderWorkingLogInfo owl = new OrderWorkingLogInfo();
owl.OrderID = oi.OrderID;
owl.UserID = this.userid;
owl.oType = 2;
owl.oMsg = "数据迁移,系统自动处理";
owl.pAppendTime = oi.oAppendTime;
Orders.AddOrderWorkingLogInfo(owl);
if (!isneworder)
{
//完成发货操作
oi.oSteps = 3;
Orders.UpdateOrderInfo(oi);
tbProductsInfo.UpdateProductsStorageByOrderID(OrderID);//更新当前在途库存情况
owl = new OrderWorkingLogInfo();
owl.OrderID = oi.OrderID;
owl.UserID = this.userid;
owl.oType = 3;
owl.oMsg = "数据迁移,系统自动处理";
owl.pAppendTime = oi.oAppendTime;
Orders.AddOrderWorkingLogInfo(owl);
//完成收货操作
oi.oSteps = 4;
Orders.UpdateOrderInfo(oi);
tbProductsInfo.UpdateProductsStorageByOrderID(OrderID);//更新当前在途库存情况
owl = new OrderWorkingLogInfo();
owl.OrderID = oi.OrderID;
owl.UserID = this.userid;
owl.oType = 4;
owl.oMsg = "数据迁移,系统自动处理";
owl.pAppendTime = oi.oAppendTime;
Orders.AddOrderWorkingLogInfo(owl);
//完成核销操作
oi.oSteps = 5;
Orders.UpdateOrderInfo(oi);
tbProductsInfo.UpdateProductsStorageByOrderID(OrderID);//更新当前在途库存情况
owl = new OrderWorkingLogInfo();
owl.OrderID = oi.OrderID;
owl.UserID = this.userid;
owl.oType = 5;
owl.oMsg = "数据迁移,系统自动处理";
owl.pAppendTime = oi.oAppendTime;
Orders.AddOrderWorkingLogInfo(owl);
}
else
{
//完成发货操作
oi.oSteps = 3;
Orders.UpdateOrderInfo(oi);
tbProductsInfo.UpdateProductsStorageByOrderID(OrderID);//更新当前在途库存情况
owl = new OrderWorkingLogInfo();
owl.OrderID = oi.OrderID;
owl.UserID = this.userid;
owl.oType = 3;
owl.oMsg = "数据迁移,系统自动处理";
owl.pAppendTime = oi.oAppendTime;
}
}
Json_Str = "{\"results\": true,\"msg\":\"" + oi.OrderID + "\",\"orderid\":\"" + oo.O_ORDERNUM + "\"}";
}
else
{
Json_Str = "{\"results\": false,\"msg\":\"单据已存在.\",\"orderid\":\"" + oo.O_ORDERNUM + "\"}";
}
}
else
{
Json_Str = "{\"results\": false,\"msg\":\"对象为空.\"}";
}
}
else
{
Json_Str = "{\"results\": false,\"msg\":\"单号为空.\"}";
}
}
catch (Exception ex)
{
Json_Str = "{\"results\": false,\"msg\":\"" + ex.Message + "," + ex.Data + "\"}";
}
Response.Charset = "utf-8";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
Response.ContentType = "application/json";
Response.Write(Json_Str);
}
if (Act == "PAttribute")
{
int ProductID = HTTPRequest.GetInt("pid", 0);
string JsonStr = HTTPRequest.GetString("JsonStr");
int PriceClassID = 0;
decimal Price = 0;
if (ProductID > 0 && JsonStr.Trim() != "")
{
PAttribute oo = (PAttribute)JavaScriptConvert.DeserializeObject(JsonStr, typeof(PAttribute));
if (oo != null)
{
foreach (PAttributePrice pa in oo.PAttributePrice)
{
if (pa != null)
{
if (pa.pr_Name.Trim() != "")
{
try
{
Price = Convert.ToDecimal(pa.a_Price);
PriceClassID = DataClass.GetPriceClassInfoModel(pa.pr_Name).PriceClassID;
tbPriceClassDefaultPriceInfo.SavePriceClassDefaultPrice(PriceClassID, ProductID, Price, 0);
}
catch
{
}
}
}
}
}
Response.Charset = "utf-8";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
Response.ContentType = "application/json";
Response.Write("{\"results\": true,\"msg\":\"OK.\",\"PID\":" + ProductID + "}");
}
}
}
else
{
if (Act == "GetOrderList" || Act == "GetPAttribute")
{
WebClient client = new WebClient();
byte[] bytes = null;
if (Act == "GetOrderList")
{
bytes = client.DownloadData(new Uri("http://erp.bdu9.com/datapost.aspx?Act=" + Act + "&pagesize=" + pagesize + "&page=" + page + ""));
}
if (Act == "GetPAttribute")
{
bytes = client.DownloadData(new Uri("http://erp.bdu9.com/datapost.aspx?Act=" + Act + "&pid=" + HTTPRequest.GetInt("pid", 0) + "&pname=" + tbProductsInfo.GetProductsInfoModel(HTTPRequest.GetInt("pid", 0)).pName));
}
if (bytes.Length == 0)
{
Response.ContentType = "text/plain";
Response.Write("(not loaded)");
}
else
{
Response.BinaryWrite(bytes);
}
}
}
Response.End();
}
}
public DataTable StorageList = new DataTable();//仓库列表
protected virtual void Page_Load(object sender, EventArgs e)
{
if (this.userid > 0)
{
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-4-2"))
{
OrderID = HTTPRequest.GetInt("orderid", 0);
OrderType = HTTPRequest.GetInt("ordertype", 0);
if (OrderID > 0)
{
oi = Orders.GetOrderInfoModel(OrderID);
if (oi != null)
{
if (!ispost)
{
dList = Orders.GetOrderNOFullList(OrderID);
StorageList = tbStorageInfo.GetStorageInfoList("").Tables[0];
}
else
{
int loop_count = HTTPRequest.GetInt("loop_count", 0);
if (loop_count > 0)
{
int s_StorageID = 0;
int ProductsID = 0;
decimal Quantity = 0;
int t_StorageID = 0;
string _OrderListDataJson = "";
for (int i = 1; i <= loop_count; i++)
{
s_StorageID = HTTPRequest.GetInt("s_StorageID_" + i, 0);
ProductsID = HTTPRequest.GetInt("ProductsID_" + i, 0);
t_StorageID = HTTPRequest.GetInt("t_StorageID_" + i, 0);
Quantity = HTTPRequest.GetString("Quantity_" + i).Trim() != "" ? Convert.ToDecimal(HTTPRequest.GetString("Quantity_" + i).Trim()) : 0;
if (s_StorageID > 0 && ProductsID > 0)
{
if (t_StorageID > 0)
{
_OrderListDataJson += "{\"OrderListID\":0," +
"\"OrderID\":0," +
"\"StorageID\":" + s_StorageID + "," +
"\"ProductsID\":" + ProductsID + "," +
"\"oQuantity\":" + (0 - Quantity) + "," +
"\"oPrice\":0," +
"\"oMoney\":0," +
"\"StoresSupplierID\":0," +
"\"IsPromotions\":0," +
"\"oWorkType\":0," +
"\"oAppendTime\":\"" + DateTime.Now + "\"},";
_OrderListDataJson += "{\"OrderListID\":0," +
"\"OrderID\":0," +
"\"StorageID\":" + t_StorageID + "," +
"\"ProductsID\":" + ProductsID + "," +
"\"oQuantity\":" + Quantity + "," +
"\"oPrice\":0," +
"\"oMoney\":0," +
"\"StoresSupplierID\":0," +
"\"IsPromotions\":0," +
"\"oWorkType\":0," +
"\"oAppendTime\":\"" + DateTime.Now + "\"},";
}
else
{
_OrderListDataJson += "{\"OrderListID\":0," +
"\"OrderID\":0," +
"\"StorageID\":" + s_StorageID + "," +
"\"ProductsID\":" + ProductsID + "," +
"\"oQuantity\":" + (0 - Quantity) + "," +
"\"oPrice\":0," +
"\"oMoney\":0," +
"\"StoresSupplierID\":0," +
"\"IsPromotions\":0," +
"\"oWorkType\":0," +
"\"oAppendTime\":\"" + DateTime.Now + "\"},";
_OrderListDataJson += "{\"OrderListID\":0," +
"\"OrderID\":0," +
"\"StorageID\":" + s_StorageID + "," +
"\"ProductsID\":" + ProductsID + "," +
"\"oQuantity\":" + Quantity + "," +
"\"oPrice\":0," +
"\"oMoney\":0," +
"\"StoresSupplierID\":0," +
"\"IsPromotions\":0," +
"\"oWorkType\":0," +
"\"oAppendTime\":\"" + DateTime.Now + "\"},";
}
}
}
if (_OrderListDataJson.Trim() != "")
{
_OrderListDataJson = "{\"OrderListJson\":[" + Utils.ReSQLSetTxt(_OrderListDataJson) + "]}";
}
OrderInfo _oi = new OrderInfo();
OrderNOFullInfo _of = new OrderNOFullInfo();
_oi.oOrderNum = Orders.GetNewOrderNum();
_oi.oType = 9;//调拨
_oi.StoresID = 0;
_oi.oCustomersName = "";
_oi.oCustomersContact = "";
_oi.oCustomersTel = "";
_oi.oCustomersAddress = "";
_oi.oCustomersOrderID = "";
_oi.oCustomersNameB = "";
_oi.StaffID = 0;
_oi.UserID = this.userid;
_oi.oAppendTime = DateTime.Now;
_oi.oOrderDateTime = DateTime.Now;
_oi.oState = 0;
_oi.oSteps = 1;
_oi.OrderListDataJson = (OrderListDataJson)JavaScriptConvert.DeserializeObject(_OrderListDataJson, typeof(OrderListDataJson));
int ToOrderID = Orders.AddOrderInfoAndList(_oi);
if (ToOrderID > 0)
{
for (int i = 1; i <= loop_count; i++)
{
s_StorageID = HTTPRequest.GetInt("s_StorageID_" + i, 0);
ProductsID = HTTPRequest.GetInt("ProductsID_" + i, 0);
t_StorageID = HTTPRequest.GetInt("t_StorageID_" + i, 0);
Quantity = HTTPRequest.GetString("Quantity_" + i).Trim() != "" ? Convert.ToDecimal(HTTPRequest.GetString("Quantity_" + i).Trim()) : 0;
if (s_StorageID > 0 && ProductsID > 0)
{
if (t_StorageID > 0)
{
_of.OrderID = OrderID;
_of.OrderToID = ToOrderID;
_of.ProductsID = ProductsID;
_of.FormStorageID = s_StorageID;
_of.ToStorageID = t_StorageID;
_of.oQuantity = Quantity;
_of.oState = 0;
_of.oAppendTimie = DateTime.Now;
_of.UserID = this.userid;
Orders.AddOrderNOFullInfo(_of);
}
else
{
_of.OrderID = OrderID;
_of.OrderToID = ToOrderID;
_of.ProductsID = ProductsID;
_of.FormStorageID = s_StorageID;
_of.ToStorageID = s_StorageID;
_of.oQuantity = Quantity;
_of.oState = 0;
_of.oAppendTimie = DateTime.Now;
_of.UserID = this.userid;
Orders.AddOrderNOFullInfo(_of);
}
}
}
//审核
_oi = Orders.GetOrderInfoModel(ToOrderID);
Orders.VerifyOrder(_oi.OrderID);
tbProductsInfo.UpdateProductsStorageByOrderID(OrderID);//更新当前在途库存情况
OrderWorkingLogInfo owl = new OrderWorkingLogInfo();
//原单操作记录
owl.OrderID = oi.OrderID;
owl.UserID = this.userid;
owl.oType = 7;
owl.oMsg = "非全额单据,调拨处理,系统自动完成,原单据:" + oi.oOrderNum + ",调拨单据:" + _oi.oOrderNum;
owl.pAppendTime = DateTime.Now;
Orders.AddOrderWorkingLogInfo(owl);
//调拨单操作记录
owl.OrderID = _oi.OrderID;
owl.UserID = this.userid;
owl.oType = 2;
owl.oMsg = "非全额单据,调拨处理,系统自动完成,原单据:" + oi.oOrderNum;
owl.pAppendTime = DateTime.Now;
Orders.AddOrderWorkingLogInfo(owl);
_oi.oSteps = 3;
Orders.UpdateOrderInfo(_oi);
tbProductsInfo.UpdateProductsStorageByOrderID(ToOrderID);//更新当前在途库存情况
owl = new OrderWorkingLogInfo();
owl.OrderID = _oi.OrderID;
owl.UserID = this.userid;
owl.oType = 3;
owl.oMsg = "非全额单据,调拨处理,系统自动完成,原单据:" + oi.oOrderNum;
owl.pAppendTime = DateTime.Now;
Orders.AddOrderWorkingLogInfo(owl);
//完成收货操作
_oi.oSteps = 4;
Orders.UpdateOrderInfo(_oi);
tbProductsInfo.UpdateProductsStorageByOrderID(ToOrderID);//更新当前在途库存情况
owl = new OrderWorkingLogInfo();
owl.OrderID = _oi.OrderID;
owl.UserID = this.userid;
owl.oType = 4;
owl.oMsg = "非全额单据,调拨处理,系统自动完成,原单据:" + oi.oOrderNum;
owl.pAppendTime = DateTime.Now;
Orders.AddOrderWorkingLogInfo(owl);
//完成核销操作
_oi.oSteps = 5;
Orders.UpdateOrderInfo(_oi);
tbProductsInfo.UpdateProductsStorageByOrderID(ToOrderID);//更新当前在途库存情况
owl = new OrderWorkingLogInfo();
owl.OrderID = _oi.OrderID;
owl.UserID = this.userid;
owl.oType = 5;
owl.oMsg = "非全额单据,调拨处理,系统自动完成,原单据:" + oi.oOrderNum;
owl.pAppendTime = DateTime.Now;
Orders.AddOrderWorkingLogInfo(owl);
AddMsgLine("非全额收获单处理完成!转调拨单:" + _oi.oOrderNum);
AddScript("window.setTimeout('parent.location=parent.location;',2000);");
}
else
{
AddErrLine("操作失败!");
}
}
else
{
AddErrLine("数据错误!");
}
}
}
else
{
AddErrLine("参数错误,单据不存在!");
}
}
else
{
AddErrLine("参数错误!");
}
}
else
{
AddErrLine("权限不足!");
}
}
else
{
AddErrLine("请先登录!");
SetBackLink("login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
SetMetaRefresh(1, "login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
}
}
protected virtual void Page_Load(object sender, EventArgs e)
{
if (this.userid > 0)
{
if (CheckUserPopedoms("X") || CheckUserPopedoms("8-3-2-1"))
{
Act = HTTPRequest.GetString("Act");
m_TradeInfoID_Str = HTTPRequest.GetString("m_TradeInfoID");
if (m_TradeInfoID_Str.Trim() != "")
{
m_TradeInfoID_Str = Utils.ReSQLSetTxt("," + m_TradeInfoID_Str + ",");
if (ispost)
{
OrderInfo oi = new OrderInfo();
string receiver_state = Utils.ChkSQL(HTTPRequest.GetString("receiver_state"));
string receiver_city = Utils.ChkSQL(HTTPRequest.GetString("receiver_city"));
string receiver_district = Utils.ChkSQL(HTTPRequest.GetString("receiver_district"));
string receiver_address = Utils.ChkSQL(HTTPRequest.GetString("receiver_address"));
string receiver_zip = Utils.ChkSQL(HTTPRequest.GetString("receiver_zip"));
string receiver_name = Utils.ChkSQL(HTTPRequest.GetString("receiver_name"));
string receiver_mobile = Utils.ChkSQL(HTTPRequest.GetString("receiver_mobile"));
string receiver_phone = Utils.ChkSQL(HTTPRequest.GetString("receiver_phone"));
string from_name = Utils.ChkSQL(HTTPRequest.GetString("from_name"));
string from_state = Utils.ChkSQL(HTTPRequest.GetString("from_state"));
string from_city = Utils.ChkSQL(HTTPRequest.GetString("from_city"));
string from_district = Utils.ChkSQL(HTTPRequest.GetString("from_district"));
string from_address = Utils.ChkSQL(HTTPRequest.GetString("from_address"));
string from_zip = Utils.ChkSQL(HTTPRequest.GetString("from_zip"));
string from_mobile = Utils.ChkSQL(HTTPRequest.GetString("from_mobile"));
string from_phone = Utils.ChkSQL(HTTPRequest.GetString("from_phone"));
int ExpName = HTTPRequest.GetInt("ExpName", 0);
string ExpNO = Utils.ChkSQL(HTTPRequest.GetString("ExpNO"));
string tMsg = Utils.ChkSQL(HTTPRequest.GetString("tMsg"));
int m_SendGoodsID = HTTPRequest.GetInt("m_SendGoodsID", 0);
string _OrderListDataJson = HTTPRequest.GetString("OrderListDataJson");
//创建发货单
if (Act == "Add")
{
try {
oi.oOrderNum = "----------";// Orders.GetNewOrderNum();
//if (!Orders.ExistsOrderInfo(oi.oOrderNum))
{
oi.oType = 3; //销售发货单
oi.StoresID = M_Config.StoresID; //系统客户编号
oi.oCustomersName = M_Config.StoresName; //客户名称,
oi.oCustomersContact = receiver_name; //联系人
oi.oCustomersTel = receiver_mobile + "," + receiver_phone; //联系电话
oi.oCustomersAddress = receiver_address; //地址
oi.oCustomersOrderID = m_TradeInfoID_Str; //客户订单号
oi.oCustomersNameB = "";
oi.StaffID = 0; //业务员暂留空
oi.UserID = this.userid;
oi.oAppendTime = DateTime.Now;
oi.oOrderDateTime = DateTime.Now;
oi.oState = 0;
oi.oSteps = 1;
oi.oPrepay = 0;
oi.OrderListDataJson = (OrderListDataJson)JavaScriptConvert.DeserializeObject(_OrderListDataJson, typeof(OrderListDataJson));
int OrderID = Orders.AddOrderInfoAndList(oi);
if (OrderID > 0)
{
OrderWorkingLogInfo owl = new OrderWorkingLogInfo();
owl.OrderID = OrderID;
owl.UserID = this.userid;
owl.oType = 0;
owl.oMsg = M_Config.StoresName + "-" + M_Config.m_Name + ",下单:" + m_TradeInfoID_Str;
owl.pAppendTime = DateTime.Now;
Orders.AddOrderWorkingLogInfo(owl);
//网店发货单
SendGoods.m_ConfigInfoID = M_Config.m_ConfigInfoID;
SendGoods.OrderID = OrderID;
SendGoods.m_TradeInfoID = m_TradeInfoID_Str;
SendGoods.receiver_name = receiver_name;
SendGoods.receiver_state = receiver_state;
SendGoods.receiver_city = receiver_city;
SendGoods.receiver_district = receiver_district;
SendGoods.receiver_address = receiver_address;
SendGoods.receiver_zip = receiver_zip;
SendGoods.receiver_mobile = receiver_mobile;
SendGoods.receiver_phone = receiver_phone;
SendGoods.from_name = M_Config.StoresName;
SendGoods.from_state = from_state;
SendGoods.from_city = from_city;
SendGoods.from_district = from_district;
SendGoods.from_address = from_address;
SendGoods.from_zip = from_zip;
SendGoods.from_mobile = from_mobile;
SendGoods.from_phone = from_phone;
SendGoods.mExpName = ExpName;
SendGoods.mExpNO = ExpNO;
SendGoods.mMemo = tMsg;
SendGoods.mState = 0;
SendGoods.mAppendTime = DateTime.Now;
m_SendGoodsID = M_Utils.AddM_SendGoodsInfo(SendGoods);
if (m_SendGoodsID > 0)
{
AddMsgLine("单据创建成功!<p class=\"SendGood\"><br>查看发货单据?-><a href=\"javascript:void(0);\" onclick=\"javascript:OrderDO.Show(" + OrderID + ");\">查看</a></p>");
#region 发送邮件给审核人员
try
{
oi = Orders.GetOrderInfoModel(OrderID);
UsersUtils.SendUserMailByPopedom("3-2-1-2", "销售发货单 需审核,单号:" + oi.oOrderNum, "销售发货单 需审核,单号:" + oi.oOrderNum);
}
catch
{
}
#endregion
}
else //网店订单生成失败,作废系统订单
{
oi = Orders.GetOrderInfoModel(OrderID);
oi.oState = 1;
Orders.UpdateOrderInfo(oi);
tbProductsInfo.UpdateProductsStorageByOrderID(OrderID);//更新当前在途库存情况
OrderWorkingLogInfo _owl = new OrderWorkingLogInfo();
owl.OrderID = oi.OrderID;
owl.UserID = this.userid;
owl.oType = -1;
owl.oMsg = "网店订单生成失败,系统自动作废发货单!网店单号:" + m_TradeInfoID_Str;
owl.pAppendTime = DateTime.Now;
Orders.AddOrderWorkingLogInfo(owl);
}
}
else
{
AddErrLine("新建单据失败,请重试!");
}
}
//else
{
// AddErrLine("发货单据号重复,单据添加失败,请重试!");
}
}
finally
{
oi = null;
}
}
//修改操作
if (Act == "Edit")
{
int m_TradeInfoID = HTTPRequest.GetInt("m_TradeInfoID", 0);
SendGoods = M_Utils.GetM_SendGoodsInfoModelBym_TradeInfoID(m_TradeInfoID);
if (SendGoods != null)
{
oi = Orders.GetOrderInfoModel(SendGoods.OrderID);
oi.oCustomersContact = receiver_name; //联系人
oi.oCustomersTel = receiver_mobile + "," + receiver_phone; //联系电话
oi.oCustomersAddress = receiver_address; //地址
oi.StaffID = 0; //业务员暂留空
oi.OrderListDataJson = (OrderListDataJson)JavaScriptConvert.DeserializeObject(_OrderListDataJson, typeof(OrderListDataJson));
if (Orders.UpdateOrderInfoAndList(oi))
{
OrderWorkingLogInfo owl = new OrderWorkingLogInfo();
owl.OrderID = oi.OrderID;
owl.UserID = this.userid;
owl.oType = 1;
owl.oMsg = "网购订单修改操作!";
owl.pAppendTime = DateTime.Now;
Orders.AddOrderWorkingLogInfo(owl);
SendGoods.receiver_name = receiver_name;
SendGoods.receiver_state = receiver_state;
SendGoods.receiver_city = receiver_city;
SendGoods.receiver_district = receiver_district;
SendGoods.receiver_address = receiver_address;
SendGoods.receiver_zip = receiver_zip;
SendGoods.receiver_mobile = receiver_mobile;
SendGoods.receiver_phone = receiver_phone;
SendGoods.from_name = M_Config.StoresName;
SendGoods.from_state = from_state;
SendGoods.from_city = from_city;
SendGoods.from_district = from_district;
SendGoods.from_address = from_address;
SendGoods.from_zip = from_zip;
SendGoods.from_mobile = from_mobile;
SendGoods.from_phone = from_phone;
SendGoods.mExpName = ExpName;
SendGoods.mExpNO = ExpNO;
SendGoods.mMemo = tMsg;
M_Utils.UpdateM_SendGoodsInfo(SendGoods);
AddMsgLine("更新成功!");
}
else
{
AddErrLine("发货单更新失败!");
}
}
else
{
AddErrLine("参数错误!");
}
}
}
else
{
Sender = tbStoresInfo.GetStoresInfoModel(M_Config.StoresID);
if (Act == "Edit")
{
//取 TradeID
int m_TradeInfoID = HTTPRequest.GetInt("m_TradeInfoID", 0);
SendGoods = M_Utils.GetM_SendGoodsInfoModelBym_TradeInfoID(m_TradeInfoID);
if (SendGoods != null)
{
SendGoods.m_TradeInfoID = Utils.ReSQLSetTxt("0," + SendGoods.m_TradeInfoID + ",");
tList = M_Utils.GetM_TradeInfoList(" m_ConfigInfoID=" + M_Config.m_ConfigInfoID + " and m_TradeInfoID in(" + SendGoods.m_TradeInfoID + ")").Tables[0];
oList = M_Utils.GetM_OrderInfoList(" m_ConfigInfoID=" + M_Config.m_ConfigInfoID + " and m_TradeInfoID in(" + SendGoods.m_TradeInfoID + ")").Tables[0];
DataTable OrderListData = Orders.GetOrderListInfoList(" OrderID=" + SendGoods.OrderID + " and oWorkType=1 order by OrderListID asc").Tables[0];
if (OrderListData != null)
{
foreach (DataRow dr_OrderListData in OrderListData.Rows)
{
OrderListDataJsonStr += "{\"OrderListID\":" + dr_OrderListData["OrderListID"].ToString() + "," +
"\"OrderID\":" + dr_OrderListData["OrderID"].ToString() + "," +
"\"StorageID\":" + dr_OrderListData["StorageID"].ToString() + "," +
"\"StorageName\":\"" + dr_OrderListData["StorageName"].ToString() + "\"," +
"\"ProductsID\":" + dr_OrderListData["ProductsID"].ToString() + "," +
"\"ProductsName\":\"" + dr_OrderListData["ProductsName"].ToString() + "\"," +
"\"oQuantity\":" + dr_OrderListData["oQuantity"].ToString() + "," +
"\"oPrice\":" + dr_OrderListData["oPrice"].ToString() + "," +
"\"oMoney\":" + dr_OrderListData["oMoney"].ToString() + "," +
"\"StoresSupplierID\":" + dr_OrderListData["StoresSupplierID"].ToString() + "," +
"\"IsPromotions\":" + dr_OrderListData["IsPromotions"].ToString() + "," +
"\"oWorkType\":" + dr_OrderListData["oWorkType"].ToString() + "," +
"\"IsGifts\":" + dr_OrderListData["IsGifts"].ToString() + "," +
"\"PriceClassID\":" + dr_OrderListData["PriceClassID"].ToString() + "," +
"\"oAppendTime\":\"" + dr_OrderListData["oAppendTime"].ToString() + "\"},";
}
if (OrderListDataJsonStr.Trim() != "")
{
OrderListDataJsonStr = "{\"OrderListJson\":[" + Utils.ReSQLSetTxt(OrderListDataJsonStr) + "]}";
}
}
}
else
{
AddErrLine("该交易的发货单不存在!");
}
}
else
{
oList = M_Utils.GetM_OrderInfoList(" m_ConfigInfoID=" + M_Config.m_ConfigInfoID + " and m_TradeInfoID in(" + m_TradeInfoID_Str + ")").Tables[0];
tList = M_Utils.GetM_TradeInfoList(" m_ConfigInfoID=" + M_Config.m_ConfigInfoID + " and m_TradeInfoID in(" + m_TradeInfoID_Str + ")").Tables[0];
}
eList = M_Utils.GetM_ExpressTemplatesInfoList(" m_ConfigInfoID=" + M_Config.m_ConfigInfoID + " order by mAppendTime desc").Tables[0];
}
}
else
{
AddErrLine("参数错误!");
}
}
else
{
AddErrLine("权限不足!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
}
else
{
AddErrLine("请先登录!");
SetBackLink("login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
SetMetaRefresh(1, "login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
}
}
