private int InserirPedidoVenda(SAPbobsCOM.Company oCompany, OrderPluggto pedidoPluggto)
{
try
{
if (oCompany.Connected)
{
OrdersDAL orderDAL = new OrdersDAL(oCompany);
string messageError = "";
int oOrderNum = 0;
Boolean inserir = true;
foreach (Item item in pedidoPluggto.Order.items)
{
if (string.IsNullOrEmpty(item.sku) && inserir)
{
this.log.WriteLogTable(oCompany, EnumTipoIntegracao.PedidoVenda, pedidoPluggto.Order.id, "", EnumStatusIntegracao.Erro, "Um ou mais item(s) do pedido está com o código de referência inválido.");
this.log.WriteLogPedido("Um ou mais item(s) do pedido está com o código de referência inválido.");
inserir = false;
}
}
if (inserir)
{
oOrderNum = orderDAL.InsertOrder(pedidoPluggto.Order, out messageError);
}
}
return(0);
}
catch (Exception e)
{
this.log.WriteLogPedido("Exception InserirPedidoVenda " + e.Message);
throw;
}
}
public IHttpActionResult UpdateBakeryItem(int id)
{
OrdersDAL dal = new OrdersDAL();
dal.ChangeActivityBakery(id);
return(Ok());
}
private int InserirPedidoVenda(SAPbobsCOM.Company oCompany, Order pedidoMl)
{
try
{
if (oCompany.Connected)
{
OrdersDAL orderDAL = new OrdersDAL(oCompany);
string messageError = "";
int oOrderNum = 0;
Boolean inserir = true;
foreach (Order_Items item in pedidoMl.order_items)
{
if (item.item.seller_custom_field == null && inserir)
{
this.log.WriteLogTable(oCompany, EnumTipoIntegracao.PedidoVenda, pedidoMl.id.ToString(), "", EnumStatusIntegracao.Erro, "Um ou mais item(s) do pedido está com o código de referência inválido.");
//throw new ArgumentException("Não foi possível criar o Pedido de Venda para o pedido "+pedidoVtex.orderId+" pois um ou mais item(s) do pedido está com o código de referência inválido.");
inserir = false;
}
}
if (inserir)
{
oOrderNum = orderDAL.InsertOrder(pedidoMl, out messageError);
}
}
return(0);
}
catch (Exception e)
{
this.log.WriteLogPedido("Exception InserirPedidoVenda " + e.Message);
throw;
}
}
public ActionResult Orders(int permissionLevel = 0)
{
AllOrdersModel orders = new AllOrdersModel();
OrdersDAL dal = new OrdersDAL();
orders.User = Session["User"] as UserInfoModel;
//admin
if (permissionLevel == 1 || orders.User.IsAdmin)
{
orders.DeliOrders = dal.GetAllDeliOrders();
orders.BakeryOrders = dal.GetAllBakeryOrders();
}
//bakery
else if (permissionLevel == 2 || orders.User.IsBakery)
{
orders.BakeryOrders = dal.GetAllBakeryOrders();
}
//deli
else if (permissionLevel == 3 || orders.User.IsDeli)
{
orders.DeliOrders = dal.GetAllDeliOrders();
}
return(View("Orders", orders));
}
private void BindData()
{
OrdersDAL orders = new OrdersDAL();
DataSet ds = orders.GetAllOrders();
gvOrders.DataSource = ds;
gvOrders.DataBind();
}
protected void ddlOrderDate_SelectedIndexChanged(object sender, EventArgs e)
{
OrdersDAL orders = new OrdersDAL();
DataSet ds = orders.GetOrdersByDateType(ddlOrderDate.SelectedValue);
gvOrders.DataSource = ds;
gvOrders.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.Label1.Text = OrdersDAL.selectOrderState(1).ToString();
this.Label2.Text = OrdersDAL.selectOrderState(2).ToString();
this.Label3.Text = OrdersDAL.selectOrderState(3).ToString();
this.Label4.Text = OrdersDAL.selectOrderState(4).ToString();
}
}
protected void gvOrders_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = gvOrders.Rows[e.RowIndex];
int customerId = Convert.ToInt32(((Label)row.FindControl("lblCustID")).Text);
string address = ((TextBox)row.FindControl("Address_Txt_Box")).Text;
OrdersDAL orders = new OrdersDAL();
orders.UpdateCustomerAddress(address, customerId);
gvOrders.EditIndex = -1;
BindData();
}
public ActionResult DeliOrder(DeliOrderModel order)
{
OrdersDAL dal = new OrdersDAL();
if (dal.SaveDeliOrder(order))
{
return(RedirectToAction("Orders"));
}
else
{
return(View("DeliOrder", order));
}
}
/// <summary>
/// 获取购物车列表
/// </summary>
/// <param name="ordertype"></param>
/// <param name="userid"></param>
/// <returns></returns>
public static List <ProductDetail> GetShoppingCart(EnumDocType ordertype, string userid)
{
DataTable dt = OrdersDAL.GetShoppingCart((int)ordertype, userid);
List <ProductDetail> list = new List <ProductDetail>();
foreach (DataRow dr in dt.Rows)
{
ProductDetail model = new ProductDetail();
model.FillData(dr);
list.Add(model);
}
return(list);
}
protected void BtnQuery_Click(object sender, EventArgs e)
{
string orderDateFilterValue = ddlOrderDate.SelectedValue == "" ? "Last 6 Months" : ddlOrderDate.SelectedValue;
string customerId = txtBoxCustomerID.Text == "" ? null : txtBoxCustomerID.Text;
string custName = txtBoxUserName.Text == "" ? null : txtBoxUserName.Text;
string salesMgr = ddlSalesManager.SelectedValue == "" ? null : ddlSalesManager.SelectedValue;
OrdersDAL orders = new OrdersDAL();
DataSet ds = orders.GetOrdersWithFilterOptions(orderDateFilterValue, customerId, custName, salesMgr);
gvOrders.DataSource = ds;
gvOrders.DataBind();
}
private void button2_Click(object sender, EventArgs e)
{
OrdersDAL sqlbase;
sqlbase = new OrdersDAL();
sqlbase.OpenConnection(ConfigurationManager.ConnectionStrings[
"Vmax44Parser.Properties.Settings.vmax44parserConnectionString"].ToString());
int orderid = sqlbase.LookUpOrderId(comboBox1.SelectedItem.ToString());
sqlbase.InsertParsedDataCollection(orderid, dataBase);
sqlbase.CloseConnection();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["AID"] == null)
{
Response.Redirect("Default.aspx");
}
if (!IsPostBack)
{
string OID = Request.QueryString["OID"];
this.Repeater1.DataSource = OrdersDAL.getOrdersByOID(OID);
this.Repeater1.DataBind();
this.Repeater2.DataSource = OrderDetailsDAL.getOrderDetailByOID(OID);
this.Repeater2.DataBind();
}
}
/// <summary>
/// 获取单据列表
/// </summary>
/// <param name="userid">创建人（拥有者）</param>
/// <param name="type">类型</param>
/// <param name="status">状态</param>
/// <param name="keywords">关键词</param>
/// <param name="pageSize">页Size</param>
/// <param name="pageIndex">页码</param>
/// <param name="totalCount">总数</param>
/// <param name="pageCount"><总页/param>
/// <param name="clientID">客户端ID</param>
/// <returns></returns>
public static List <StorageDoc> GetStorageDocList(string userid, EnumDocType type, EnumDocStatus status, string keywords, int pageSize, int pageIndex, ref int totalCount, ref int pageCount, string clientID)
{
DataSet ds = OrdersDAL.GetStorageDocList(userid, (int)type, (int)status, keywords, pageSize, pageIndex, ref totalCount, ref pageCount, clientID);
List <StorageDoc> list = new List <StorageDoc>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
StorageDoc model = new StorageDoc();
model.FillData(dr);
model.CreateUser = OrganizationBusiness.GetUserByUserID(model.CreateUserID, clientID);
model.StatusStr = GetDocStatusStr(model.DocType, model.Status);
list.Add(model);
}
return(list);
}
public void CreateOrder()
{
var order = new Order();
order.CustomerID = "VINET";
order.EmployeeID = 5;
order.OrderDate = DateTime.Now;
order.ShipVia = 1;
order.Freight = 10.05m;
order.ShipName = "Toms Spezialitäten";
order.ShipAddress = "Luisenstr. 48";
order.ShipCity = "Münster";
order.ShipPostalCode = "44087";
order.ShipCountry = "Germany";
var dal = new OrdersDAL();
dal.CreateNewOrder(order);
}
protected void Button1_Click(object o, EventArgs e)
{
//1>.构建订单表对象:
Order orders = new Order();
orders.OID = OrdersDAL.GetNewOrderID(); //订单编号
orders.MID = Convert.ToInt32(Session["login"]);
orders.ODate = Convert.ToDateTime(DateTime.Now.ToString());
orders.OConsignee = this.txtName.Text;
orders.OAddress = this.txtAddress.Text;
orders.OTelephone = this.txtTel.Text;
orders.OState = 1; //新订单
//2>.构建订单详细表集合
List <OrderDetails> listDetails = new List <OrderDetails>();
//得到购物车集合
if (Request.QueryString["ids"] == null)
{
return;
}
string ids = Request.QueryString["ids"];
ids = ids.Substring(0, ids.Length - 1);
List <Trade> listTrade = TradeDAL.getTradeByMIDAndBIDS(Convert.ToInt32(Session["login"]), ids);
foreach (Trade trade in listTrade)
{
OrderDetails details = new OrderDetails();
details.OID = orders.OID; //订单编号
details.BID = trade.BID; //书籍编号
details.BPrice = trade.BPrice; //书籍价格
details.BCount = trade.BCount; //购买数量
listDetails.Add(details);
}
orders.OSumPrice = Convert.ToInt32(this.Label1.Text); //总计;
//保存订单:
int count = OrdersDAL.SavaOrder(orders, listDetails);
//if (txtName.Text!=null && txtTel.Text!=null && txtAddress!=null)
//{
if (count > 0)
{
Response.Redirect("done.aspx?OID=" + orders.OID);
}
}
public ActionResult BakeryOrder(BakeryOrderModel order)
{
if (order.Kitname == null)
{
order.Kitname = "n/a";
}
OrdersDAL dal = new OrdersDAL();
if (dal.SaveBakeryOrder(order))
{
return(RedirectToAction("Orders"));
}
else
{
return(View("BakeryOrder", order));
}
}
public IEnumerable <DeliOrderModel> GetDeliOrderModels(int id)
{
var output = new DeliOrderModel();
OrdersDAL dal = new OrdersDAL();
List <DeliOrderModel> orders = dal.GetAllDeliOrders();
for (int i = 0; i < orders.Count; i++)
{
if (orders[i].Id == id)
{
output = orders[i];
}
}
List <DeliOrderModel> outputt = new List <DeliOrderModel>();
outputt.Add(output);
return(outputt);
}
public Form1()
{
InitializeComponent();
dataBase = new ParsedDataCollection();
dataCollectionBindingSource.DataSource = dataBase;
dataGridView1.DataSource = dataCollectionBindingSource;
OrdersDAL sqlbase = new OrdersDAL();
sqlbase.OpenConnection(ConfigurationManager.ConnectionStrings[
"Vmax44Parser.Properties.Settings.vmax44parserConnectionString"].ToString());
DataTable orders = sqlbase.GetAllOrdersAsDataTable();
foreach (DataRow row in orders.Rows)
{
comboBox1.Items.Add(row.Field <string>("OrderNumber"));
}
sqlbase.CloseConnection();
}
/// <summary>
/// 创建单据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static string CreateStorageDoc(StorageDoc model, string userid, string operateip, string clientid)
{
string docid = Guid.NewGuid().ToString();
SqlConnection conn = new SqlConnection(OrdersDAL.ConnectionString);
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
bool bl = OrdersDAL.AddStorageDoc(docid, model.DocType, model.TotalMoney, model.CityCode, model.Address, model.Remark, userid, operateip, clientid, tran);
if (bl)
{
//单据明细
foreach (var detail in model.Details)
{
if (!OrdersDAL.AddStorageDocDetail(docid, detail.AutoID, detail.ProductDetailID, detail.Quantity, detail.Price, detail.TotalMoney, detail.BatchCode, clientid, tran))
{
tran.Rollback();
conn.Dispose();
return("");
}
}
tran.Commit();
conn.Dispose();
return(docid);
}
else
{
tran.Rollback();
conn.Dispose();
return("");
}
}
catch (Exception ex)
{
tran.Rollback();
conn.Dispose();
return("");
}
}
/// <summary>
/// 获取单据详情
/// </summary>
/// <param name="docid">单据ID</param>
/// <param name="clientid">客户端ID</param>
/// <returns></returns>
public static StorageDoc GetStorageDetail(string docid, string clientid)
{
DataSet ds = OrdersDAL.GetStorageDetail(docid, clientid);
StorageDoc model = new StorageDoc();
if (ds.Tables.Contains("Doc") && ds.Tables["Doc"].Rows.Count > 0)
{
model.FillData(ds.Tables["Doc"].Rows[0]);
model.CreateUser = OrganizationBusiness.GetUserByUserID(model.CreateUserID, clientid);
model.StatusStr = GetDocStatusStr(model.DocType, model.Status);
model.Details = new List <StorageDetail>();
foreach (DataRow item in ds.Tables["Details"].Rows)
{
StorageDetail details = new StorageDetail();
details.FillData(item);
model.Details.Add(details);
}
}
return(model);
}
/// <summary>
/// Configuring order by asking customer.
/// </summary>
private void ProcessingOrder()
{
if (_botMoodState != BotEmotionalStatus.Friendly)
{
CalmBot();
}
WriteLineWithSpecColor("Now i'll show you our menu.");
string answer = string.Empty;
bool IsExitAnswer = true;
Food food = new Food();
FoodDAL fDAL = new FoodDAL();
while (IsExitAnswer)
{
ShowMenu();
WriteLineWithSpecColor("Enter food number:");
answer = GetNumericAnswer().ToString();
while (!fDAL.IsIdFound(int.Parse(answer)))
{
WriteLineWithSpecColor("No such food number.");
answer = GetNumericAnswer().ToString();
}
food = fDAL.GetFoodByFoodID(int.Parse(answer));
WriteLineWithSpecColor("How much?");
answer = GetNumericAnswer().ToString();
food.Count = int.Parse(answer);
_order.AddFoodInOrder(food);
food = new Food();
WriteLineWithSpecColor("Wanna continue?");
IsExitAnswer = GetSimpleUserAnswer();
}
WriteLineWithSpecColor($"Total order price:{_order.TotalPrice}");
OrdersDAL ordersDAL = new OrdersDAL();
ordersDAL.SendOrderToDB(_order);
}
/// <summary>
/// 添加
///</summary>
public static int AddOrders(Orders OrdersModel)
{
return(OrdersDAL.AddOrders(OrdersModel));
}
/// <summary>
/// 保存订单
/// </summary>
/// <returns></returns>
public static int SavaOrder(Order order, List <OrderDetails> listDeta)
{
return(OrdersDAL.SavaOrder(order, listDeta));
}
/// <summary>
/// 生成新订单编号
/// </summary>
/// <returns></returns>
public static string GetNewOrderID()
{
return(OrdersDAL.GetNewOrderID());
}
/// <summary>
/// 查询条数
///</summary>
public static int CountNumber(string NewWHere)
{
return(OrdersDAL.CountNumber(NewWHere));
}
/// <summary>
/// 修改
///</summary>
public static int UpdateOrders(Orders OrdersModel)
{
return(OrdersDAL.UpdateOrders(OrdersModel));
}
public void GetOrderDetail()
{
var dal = new OrdersDAL();
var order = dal.GetOrderDetails(11082);
}
public OrdersBL()
{
orderDAL = new OrdersDAL();
}
/// <summary>
/// 根据主键删除
///</summary>
public static int DeleteOrders(int Id)
{
return(OrdersDAL.DeleteOrders(Id));
}
/// <summary>
/// 分页
///</summary>
public static List <Orders> PageSelectOrders(int pageSize, int pageIndex, string WhereSrc, string PXzd, string PXType)
{
pageIndex = pageIndex - 1;
return(OrdersDAL.PageSelectOrders(pageSize, pageIndex, WhereSrc, PXzd, PXType));
}
public void MakeComplete()
{
var dal = new OrdersDAL();
dal.MakeComplete(11082, DateTime.Now);
}
/// <summary>
/// 查询全部
///</summary>
public static List <Orders> AllData(string NewWHere)
{
return(OrdersDAL.AllData(NewWHere));
}
public void TakeOrder()
{
var dal = new OrdersDAL();
dal.TakeOrder(11082, DateTime.Now);
}
/// <summary>
/// 根据主键查询实体
///</summary>
public static Orders GetIdByOrders(int Id)
{
return(OrdersDAL.GetIdByOrders(Id));
}
public void GetOrders()
{
var order1 = new OrdersDAL();
Assert.IsTrue(order1.GetAllOrders().Count > 0);
}
