private void btnRefuseReturns_Click(object sender, System.EventArgs e)
{
ManagerHelper.CheckPrivilege(Privilege.OrderReturnsApplyRefuse);
OrderInfo orderInfo = OrderHelper.GetOrderInfo(this.hidOrderId.Value);
OrderHelper.CheckReturn(orderInfo, HiContext.Current.User.Username, 0m, this.hidAdminRemark.Value, int.Parse(this.hidRefundType.Value), false);
this.BindReturns();
this.ShowMsg("成功的拒绝了订单退货", true);
}
private void btnImportItem_Click(object sender, System.EventArgs e)
{
try
{
if (Request["RadioGroup"] == null || Request["RadioGroup"].Length < 0)
{
this.ShowMsg("请选择要导入数据", false);
return;
}
var member = HiContext.Current.User;
if (member == null || member.IsLockedOut)
{
this.ShowMsg("获取用户信息失败，请重新登录", false);
return;
}
//是否有权限,是否自己的，是否在可变更状态
ManagerHelper.CheckPrivilege(Privilege.POAdd);
DataSet ds = PurchaseOrderHelper.GetPurchaseOrder(1, string.Format("IsDel=0 and id={0} AND POStatus=0 and CreateUserId={1}", Request["RadioGroup"].ToString(), member.UserId));
if (ds == null || ds.Tables.Count <= 0 || ds.Tables[0].Rows.Count <= 0)
{
this.ShowMsg("导入失败，请检查您是否有权限，或订单状态是否允许修改", false);
return;
}
if (!this.fileUploader.HasFile)
{
this.ShowMsg("请先选择一个数据文件", false);
return;
}
if (this.fileUploader.PostedFile.ContentLength == 0 || this.fileUploader.PostedFile.ContentType != "application/vnd.ms-excel")
{
this.ShowMsg("请上传正确的数据文件", false);
return;
}
if (!Directory.Exists(this._dataPath))
{
Directory.CreateDirectory(this._dataPath);
}
string fileName = System.IO.Path.GetFileName(this.fileUploader.PostedFile.FileName);
this.fileUploader.PostedFile.SaveAs(System.IO.Path.Combine(this._dataPath, fileName));
DataTable dt = ExcelDataSource(this._dataPath + "/" + fileName);
if (dt != null && dt.Rows.Count > 0)
{
SavePOItem(int.Parse(Request["RadioGroup"].ToString()), dt, member.UserId);
}
else
{
this.ShowMsg("导入文档无数据", false);
}
}
catch (Exception ex)
{
this.ShowMsg("导入失败" + ex.Message, false);
}
}
public static bool CheckPurchaseReplace(string purchaseOrderId, string adminRemark, bool accept)
{
ManagerHelper.CheckPrivilege(Privilege.PurchaseOrderReplaceApply);
if (GetPurchaseOrder(purchaseOrderId).PurchaseStatus != OrderStatus.ApplyForReplacement)
{
return(false);
}
return(SalesProvider.Instance().CheckPurchaseReplace(purchaseOrderId, adminRemark, accept));
}
public static bool DeleteProductType(int typeId)
{
ManagerHelper.CheckPrivilege(Privilege.DeleteProductType);
bool flag = new ProductTypeDao().DeleteProducType(typeId);
if (flag)
{
EventLogs.WriteOperationLog(Privilege.DeleteProductType, string.Format(CultureInfo.InvariantCulture, "删除了编号为”{0}”的商品类型", new object[] { typeId }));
}
return flag;
}
private void btnCreateReport_Click(object sender, System.EventArgs e)
{
ManagerHelper.CheckPrivilege(Privilege.SuppliersSalesExcel);
DbQueryResult balanceDetails = MemberHelper.GetVendorSalesReport(new VendorSalesReportQuery
{
SupplierName = this.SupplierName,
StartDate = this.dateStart,
EndDate = this.dateEnd,
PageIndex = this.pager.PageIndex,
PageSize = int.MaxValue,
TradeType = TradeTypes.DrawRequest
});
string text = string.Empty;
text += "供应商名称";
text += ",销售总金额";
text += ",订单总数\r\n";
foreach (System.Data.DataRow dataRow in ((System.Data.DataTable)balanceDetails.Data).Rows)
{
text += dataRow["SupplierName"];
text = text + "," + dataRow["OrderTotal"];
text = text + "," + dataRow["OrderCount"];
object obj = text;
text = string.Concat(new object[]
{
obj,
",",
"\r\n"
});
}
this.Page.Response.Clear();
this.Page.Response.Buffer = false;
this.Page.Response.Charset = "GB2312";
//this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=BalanceDetailsStatistics.csv");
if (!(this.calendarStart.SelectedDate.HasValue && this.calendarEnd.SelectedDate.HasValue))
{
this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=供应商销售统计报表.csv");
}
else
{
this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=供应商销售统计报表_" + this.dateStart.Value.ToString("yyyyMMdd") + "-" + this.dateEnd.Value.ToString("yyyyMMdd") + ".csv");
}
this.Page.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
this.Page.Response.ContentType = "application/octet-stream";
this.Page.EnableViewState = false;
this.Page.Response.Write(text);
EventLogs.WriteOperationLog(Privilege.SuppliersSalesExcel, string.Format(CultureInfo.InvariantCulture, "用户{0}，生成供应商为{1}供应商销售成功", new object[]
{
this.User.Identity.Name,
this.SupplierName
}));
this.Page.Response.End();
}
public static bool ClosePurchaseOrder(PurchaseOrderInfo purchaseOrder)
{
ManagerHelper.CheckPrivilege(Privilege.EditPurchaseorder);
bool flag = SalesProvider.Instance().ClosePurchaseOrder(purchaseOrder);
if (flag)
{
EventLogs.WriteOperationLog(Privilege.EditPurchaseorder, string.Format(CultureInfo.InvariantCulture, "关闭了编号为\"{0}\"的采购单", new object[] { purchaseOrder.PurchaseOrderId }));
}
return(flag);
}
public static bool SavePurchaseOrderRemark(PurchaseOrderInfo purchaseOrder)
{
ManagerHelper.CheckPrivilege(Privilege.PurchaseorderMark);
bool flag = SalesProvider.Instance().SavePurchaseOrderRemark(purchaseOrder);
if (flag)
{
EventLogs.WriteOperationLog(Privilege.PurchaseorderMark, string.Format(CultureInfo.InvariantCulture, "对编号为\"{0}\"的采购单备注", new object[] { purchaseOrder.PurchaseOrderId }));
}
return(flag);
}
public static int PenetrationProducts(IList <int> productIds)
{
ManagerHelper.CheckPrivilege(Privilege.PackProduct);
int num = ProductProvider.Instance().PenetrationProducts(productIds);
if (num > 0)
{
EventLogs.WriteOperationLog(Privilege.PackProduct, string.Format(CultureInfo.InvariantCulture, "对 “{0}” 件商品进行了铺货", new object[] { productIds.Count }));
}
return(num);
}
public static int DeleteOrders(string orderIds)
{
ManagerHelper.CheckPrivilege(Privilege.DeleteOrder);
int num = SalesProvider.Instance().DeleteOrders(orderIds);
if (num > 0)
{
EventLogs.WriteOperationLog(Privilege.DeleteOrder, string.Format(CultureInfo.InvariantCulture, "删除了编号为\"{0}\"的订单", new object[] { orderIds }));
}
return(num);
}
public static bool DeleteProductLine(int lineId)
{
ManagerHelper.CheckPrivilege(Privilege.DeleteProductLine);
bool result;
if (result = ProductProvider.Instance().DeleteProductLine(lineId))
{
EventLogs.WriteOperationLog(Privilege.DeleteProductLine, string.Format(CultureInfo.InvariantCulture, "删除了一条产品线", new object[0]));
}
return(result);
}
public static bool DeleteMemberGrade(int gradeId)
{
ManagerHelper.CheckPrivilege(Privilege.DeleteMemberGrade);
bool flag = new MemberGradeDao().DeleteMemberGrade(gradeId);
if (flag)
{
EventLogs.WriteOperationLog(Privilege.DeleteMemberGrade, string.Format(CultureInfo.InvariantCulture, "删除了编号为 “{0}” 的会员等级", new object[] { gradeId }));
}
return(flag);
}
public static bool huifu(int userId)
{
ManagerHelper.CheckPrivilege(Privilege.DeleteMember);
bool flag = new MemberDao().Huifu(userId);
if (flag)
{
EventLogs.WriteOperationLog(Privilege.DeleteMember, string.Format(CultureInfo.InvariantCulture, "恢复了编号为 “{0}” 的会员", new object[] { userId }));
}
return(flag);
}
public static int removeOrders(string orderIds)
{
ManagerHelper.CheckPrivilege(Privilege.DeleteOrder);
int num = new OrderDao().removeOrders(orderIds);
if (num > 0)
{
EventLogs.WriteOperationLog(Privilege.DeleteOrder, string.Format(CultureInfo.InvariantCulture, "回收了编号为\"{0}\"的订单", new object[] { orderIds }));
}
return(num);
}
public static bool SaveRemark(OrderInfo order)
{
ManagerHelper.CheckPrivilege(Privilege.RemarkOrder);
bool flag = new OrderDao().UpdateOrder(order, null);
if (flag)
{
EventLogs.WriteOperationLog(Privilege.RemarkOrder, string.Format(CultureInfo.InvariantCulture, "对订单“{0}”进行了备注", new object[] { order.OrderId }));
}
return(flag);
}
public static CategoryActionStatus DeleteCategory(int categoryId)
{
ManagerHelper.CheckPrivilege(Privilege.DeleteProductCategory);
CategoryActionStatus status = ProductProvider.Instance().DeleteCategory(categoryId);
if (status == CategoryActionStatus.Success)
{
EventLogs.WriteOperationLog(Privilege.DeleteProductCategory, string.Format(CultureInfo.InvariantCulture, "删除了编号为 “{0}” 的店铺分类", new object[] { categoryId }));
HiCache.Remove("DataCache-Categories");
}
return(status);
}
public static bool DeleteCategory(int categoryId)
{
ManagerHelper.CheckPrivilege(Privilege.DeleteProductCategory);
bool flag = new CategoryDao().DeleteCategory(categoryId);
if (flag)
{
EventLogs.WriteOperationLog(Privilege.DeleteProductCategory, string.Format(CultureInfo.InvariantCulture, "删除了编号为 “{0}” 的店铺分类", new object[] { categoryId }));
HiCache.Remove("DataCache-Categories");
}
return(flag);
}
public static bool Delete2(int userId)
{
ManagerHelper.CheckPrivilege(Privilege.DeleteMember);
bool flag = new MemberDao().Delete2(userId);
if (flag)
{
HiCache.Remove(string.Format("DataCache-Member-{0}", userId));
EventLogs.WriteOperationLog(Privilege.DeleteMember, string.Format(CultureInfo.InvariantCulture, "逻辑删除了编号为 “{0}” 的会员", new object[] { userId }));
}
return(flag);
}
public static bool ConfirmPay(OrderInfo order)
{
ManagerHelper.CheckPrivilege(Privilege.CofimOrderPay);
bool flag = false;
if (order.CheckAction(OrderActions.SELLER_CONFIRM_PAY))
{
OrderDao orderDao = new OrderDao();
order.OrderStatus = OrderStatus.BuyerAlreadyPaid;
order.PayDate = new DateTime?(DateTime.Now);
flag = orderDao.UpdateOrder(order, null);
string text = "";
if (flag)
{
orderDao.UpdatePayOrderStock(order);
foreach (LineItemInfo current in order.LineItems.Values)
{
ProductDao productDao = new ProductDao();
text = text + "'" + current.SkuId + "',";
ProductInfo productDetails = productDao.GetProductDetails(current.ProductId);
productDetails.SaleCounts += current.Quantity;
productDetails.ShowSaleCounts += current.Quantity;
productDao.UpdateProduct(productDetails, null);
}
if (!string.IsNullOrEmpty(text))
{
orderDao.UpdateItemsStatus(order.OrderId, 2, text.Substring(0, text.Length - 1));
}
if (!string.IsNullOrEmpty(order.ActivitiesId))
{
ActivitiesDao activitiesDao = new ActivitiesDao();
activitiesDao.UpdateActivitiesTakeEffect(order.ActivitiesId);
}
MemberHelper.SetOrderDate(order.UserId, 1);
try
{
if (order != null)
{
Messenger.SendWeiXinMsg_OrderPay(order);
}
}
catch (Exception var_8_180)
{
}
EventLogs.WriteOperationLog(Privilege.CofimOrderPay, string.Format(CultureInfo.InvariantCulture, "确认收款编号为\"{0}\"的订单", new object[]
{
order.OrderId
}));
}
}
return(flag);
}
public static bool UpdateLineItem(string string_0, OrderInfo order, int quantity)
{
ManagerHelper.CheckPrivilege(Privilege.EditOrders);
Database database = DatabaseFactory.CreateDatabase();
bool result;
bool flag;
using (System.Data.Common.DbConnection dbConnection = database.CreateConnection())
{
dbConnection.Open();
System.Data.Common.DbTransaction dbTransaction = dbConnection.BeginTransaction();
try
{
SalesProvider salesProvider = SalesProvider.Instance();
order.LineItems[string_0].Quantity = quantity;
order.LineItems[string_0].ShipmentQuantity = quantity;
order.LineItems[string_0].ItemAdjustedPrice = order.LineItems[string_0].ItemListPrice;
if (!salesProvider.UpdateLineItem(order.OrderId, order.LineItems[string_0], dbTransaction))
{
dbTransaction.Rollback();
result = false;
return(result);
}
if (!salesProvider.UpdateOrderAmount(order, dbTransaction))
{
dbTransaction.Rollback();
result = false;
return(result);
}
dbTransaction.Commit();
flag = true;
}
catch (Exception)
{
dbTransaction.Rollback();
flag = false;
}
finally
{
dbConnection.Close();
}
}
if (flag)
{
EventLogs.WriteOperationLog(Privilege.EditOrders, string.Format(CultureInfo.InvariantCulture, "修改了订单号为\"{0}\"的订单商品数量", new object[]
{
order.OrderId
}));
}
result = flag;
return(result);
}
private void grdMemberList_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
ManagerHelper.CheckPrivilege(Privilege.DeleteMember);
int userId = (int)this.grdMemberList.DataKeys[e.RowIndex].Value;
if (!MemberHelper.Delete(userId))
{
this.ShowMsg("未知错误", false);
return;
}
this.BindData();
this.ShowMsg("成功删除了选择的会员", true);
}
public static bool CloseTransaction(OrderInfo order)
{
ManagerHelper.CheckPrivilege(Privilege.EditOrders);
order.OrderStatus = OrderStatus.Closed;
bool flag = new OrderDao().UpdateOrder(order, null);
if (flag)
{
new OrderDao().UpdateItemsStatus(order.OrderId, 4, "all");
EventLogs.WriteOperationLog(Privilege.EditOrders, string.Format(CultureInfo.InvariantCulture, "关闭了订单“{0}”", new object[] { order.OrderId }));
}
return(flag);
}
public static int RealDeleteOrders(string orderIds, DateTime?orderDate)
{
ManagerHelper.CheckPrivilege(Privilege.DeleteOrder);
int num = new OrderDao().RealDeleteOrders(orderIds);
if (num > 0)
{
string retInfo = "";
bool flag = new ShopStatisticDao().StatisticsOrdersByRecDate(orderDate.Value, UpdateAction.AllUpdate, 0, out retInfo);
EventLogs.WriteOperationLog(Privilege.DeleteOrder, string.Format(CultureInfo.InvariantCulture, "删除了编号为\"{0}\"的订单", new object[] { orderIds }));
}
return(num);
}
public static bool Delete(int userId)
{
ManagerHelper.CheckPrivilege(Privilege.DeleteMember);
IUser user = Users.GetUser(userId);
bool flag = MemberProvider.Instance().Delete(userId);
if (flag)
{
Users.ClearUserCache(user);
EventLogs.WriteOperationLog(Privilege.DeleteMember, string.Format(CultureInfo.InvariantCulture, "删除了编号为 “{0}” 的会员", new object[] { userId }));
}
return(flag);
}
private void grdSupplier_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
ManagerHelper.CheckPrivilege(Privilege.SitesDelete);
int SitesId = (int)this.grdSupplier.DataKeys[e.RowIndex].Value;
if (SitesManagementHelper.DeleteSites(SitesId))
{
this.BindSites();
this.ShowMsg("删除成功", true);
return;
}
this.ShowMsg("删除失败", false);
}
private void btnCreateReport_Click(object sender, System.EventArgs e)
{
ManagerHelper.CheckPrivilege(Privilege.ProductSaleAsBrandExcel);
SaleStatisticsQuery saleStatisticsQuery = new SaleStatisticsQuery();
saleStatisticsQuery.StartDate = this.dateStart;
saleStatisticsQuery.EndDate = this.dateEnd;
saleStatisticsQuery.PageSize = this.pager.PageSize;
saleStatisticsQuery.SortBy = "b.BrandId";
saleStatisticsQuery.SortOrder = SortAction.Asc;
saleStatisticsQuery.BrandId = this.dropBrandList.SelectedValue.HasValue ? this.dropBrandList.SelectedValue : null;
int num = 0;
System.Data.DataTable productSalesNoPage = SalesHelper.GetProductSaleAsBrandNoPage(saleStatisticsQuery, out num);
string text = string.Empty;
text += "品牌名称";
//text += ",排行";
text += ",商品名称";
text += ",商家编码";
text += ",销售量";
text += ",销售额";
text += ",利润\r\n";
foreach (System.Data.DataRow dataRow in productSalesNoPage.Rows)
{
text += dataRow["BrandName"].ToString();
//text = text + "," + dataRow["IDOfSaleTotals"].ToString();
text = text + "," + dataRow["ProductName"].ToString();
text = text + "," + dataRow["SKU"].ToString();
text = text + "," + dataRow["ProductSaleCounts"].ToString();
text = text + "," + dataRow["ProductSaleTotals"].ToString();
text = text + "," + dataRow["ProductProfitsTotals"].ToString() + "\r\n";
}
this.Page.Response.Clear();
this.Page.Response.Buffer = false;
this.Page.Response.Charset = "GB2312";
//this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=ProductSaleAsBrand.csv");
if (!(this.calendarStartDate.SelectedDate.HasValue && this.calendarEndDate.SelectedDate.HasValue))
{
this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=按品牌汇总商品销售.csv");
}
else
{
this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=按品牌汇总商品销售_" + this.dateStart.Value.ToString("yyyyMMdd") + "-" + this.dateEnd.Value.ToString("yyyyMMdd") + ".csv");
}
this.Page.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
this.Page.Response.ContentType = "application/octet-stream";
this.Page.EnableViewState = false;
this.Page.Response.Write(text);
this.Page.Response.End();
}
public static bool UpdateOrderShippingMode(OrderInfo order)
{
ManagerHelper.CheckPrivilege(Privilege.EditOrders);
if (order.CheckAction(OrderActions.MASTER_SELLER_MODIFY_SHIPPING_MODE))
{
bool flag = SalesProvider.Instance().UpdateOrderShippingMode(order);
if (flag)
{
EventLogs.WriteOperationLog(Privilege.EditOrders, string.Format(CultureInfo.InvariantCulture, "修改了订单“{0}”的配送方式", new object[] { order.OrderId }));
}
return(flag);
}
return(false);
}
public static bool MondifyAddress(OrderInfo order)
{
ManagerHelper.CheckPrivilege(Privilege.EditOrders);
if (order.CheckAction(OrderActions.MASTER_SELLER_MODIFY_DELIVER_ADDRESS))
{
bool flag = SalesProvider.Instance().SaveShippingAddress(order);
if (flag)
{
EventLogs.WriteOperationLog(Privilege.EditOrders, string.Format(CultureInfo.InvariantCulture, "修改了订单“{0}”的收货地址", new object[] { order.OrderId }));
}
return(flag);
}
return(false);
}
public static bool CloseTransaction(OrderInfo order)
{
ManagerHelper.CheckPrivilege(Privilege.EditOrders);
if (order.CheckAction(OrderActions.SELLER_CLOSE))
{
bool flag = SalesProvider.Instance().CloseTransaction(order);
if (flag)
{
EventLogs.WriteOperationLog(Privilege.EditOrders, string.Format(CultureInfo.InvariantCulture, "关闭了订单“{0}”", new object[] { order.OrderId }));
}
return(flag);
}
return(false);
}
public static bool DeleteProductType(int typeId)
{
ManagerHelper.CheckPrivilege(Privilege.DeleteProductType);
bool result;
if (result = ProductProvider.Instance().DeleteProducType(typeId))
{
EventLogs.WriteOperationLog(Privilege.DeleteProductType, string.Format(CultureInfo.InvariantCulture, "删除了编号为”{0}”的商品类型", new object[]
{
typeId
}));
}
return(result);
}
public static bool UpdatePurchaseOrderShippingMode(PurchaseOrderInfo purchaseOrder)
{
ManagerHelper.CheckPrivilege(Privilege.EditPurchaseorder);
if (purchaseOrder.CheckAction(PurchaseOrderActions.MASTER__MODIFY_SHIPPING_MODE))
{
bool flag = SalesProvider.Instance().UpdatePurchaseOrderShippingMode(purchaseOrder);
if (flag)
{
EventLogs.WriteOperationLog(Privilege.EditPurchaseorder, string.Format(CultureInfo.InvariantCulture, "修改了编号为\"{0}\"的采购单的配送方式", new object[] { purchaseOrder.PurchaseOrderId }));
}
return(flag);
}
return(false);
}
