/// <summary> /// 接口站点下单方法 /// </summary> /// <param name="model">订单主表信息</param> /// <param name="modelList">订单明细集合</param> /// <returns>true:成功,false:失败</returns> public static bool Create(WebSiteSellOrderModel model, List<WebSiteSellOrderDetailModel> modelList) { bool res= Data.CustomAPI.CustomWebSite.WebSiteOrderDBHelper.Create(model, modelList); //如果下单成功 则短信通知 return res; }
/// <summary> /// 接口站点下单方法 /// </summary> /// <param name="model">订单主表信息</param> /// <param name="modelList">订单明细集合</param> /// <returns>true:成功,false:失败</returns> public static bool Create(WebSiteSellOrderModel model, List<WebSiteSellOrderDetailModel> modelList) { /*用不保存SQL命令*/ List<SqlCommand> CmdList = new List<SqlCommand>(); #region 主表信息 StringBuilder sbSql = new StringBuilder(); sbSql.AppendLine(" INSERT INTO " + SYS_SCHEMANAME + ".WebStieSellOrder "); sbSql.AppendLine(" (OrderNo,CompanyCD,CustomID,Title,OrderDate,ConsignmentDate,Status,LoginID) VALUES "); sbSql.AppendLine(" (@OrderNo,@CompanyCD,@CustomID,@Title,@OrderDate,@ConsignmentDate,@Status,@LoginID )"); SqlParameter[] Params = new SqlParameter[8]; int index = 0; Params[index++] = SqlHelper.GetParameter("@OrderNo", model.OrderNo); Params[index++] = SqlHelper.GetParameter("@CompanyCD", model.CompanyCD); Params[index++] = SqlHelper.GetParameter("@CustomID", model.CustomID); Params[index++] = SqlHelper.GetParameter("@Title", model.Title); Params[index++] = SqlHelper.GetParameter("@OrderDate", model.OrderDate); Params[index++] = SqlHelper.GetParameter("@ConsignmentDate", model.ConsignmentDate); Params[index++] = SqlHelper.GetParameter("@Status", model.Status); Params[index++] = SqlHelper.GetParameter("@LoginID", model.LoginID); SqlCommand mainCmd = new SqlCommand(sbSql.ToString()); mainCmd.Parameters.AddRange(Params); CmdList.Add(mainCmd); #endregion #region 明细信息 foreach (WebSiteSellOrderDetailModel item in modelList) { SqlParameter[] DetailParams = null; SqlCommand cmd = new SqlCommand(GetDetailSql(item,ref DetailParams)); cmd.Parameters.AddRange(DetailParams); CmdList.Add(cmd); } #endregion return SqlHelper.ExecuteTransWithCollections(CmdList); }
/// <summary> /// 修改订单方法 /// </summary> /// <param name="model">站点订单主表信息</param> /// <param name="modelList">站点订单明细信息</param> /// <returns>true:成功,false:失败</returns> public static bool Edit(WebSiteSellOrderModel model, List<WebSiteSellOrderDetailModel> modelList) { /*保存SQL命令*/ List<SqlCommand> CmdList = new List<SqlCommand>(); #region 主表信息 StringBuilder sbSql = new StringBuilder(); sbSql.AppendLine(" UPDATE " + SYS_SCHEMANAME + ".WebStieSellOrder SET "); sbSql.AppendLine(" Title=@Title,OrderDate=@OrderDate,ConsignmentDate=@ConsignmentDate ,Status=@Status"); sbSql.AppendLine(" WHERE ID=@ID "); SqlParameter[] Params = new SqlParameter[5]; int index = 0; Params[index++] = SqlHelper.GetParameter("@Title", model.Title); Params[index++] = SqlHelper.GetParameter("@OrderDate", model.OrderDate); Params[index++] = SqlHelper.GetParameter("@ConsignmentDate", model.ConsignmentDate); Params[index++] = SqlHelper.GetParameter("@Status", model.Status); Params[index++] = SqlHelper.GetParameter("@ID", model.ID); SqlCommand MainCmd = new SqlCommand(sbSql.ToString()); MainCmd.Parameters.AddRange(Params); CmdList.Add(MainCmd); #endregion #region 明细信息 #region 清空以前的明细信息 StringBuilder sbDel = new StringBuilder(); sbDel.AppendLine(" DELETE " + SYS_SCHEMANAME + ".WebSiteSellOrderDetail WHERE OrderNo=@OrderNo AND CompanyCD=@CompanyCD "); SqlParameter[] DelParams = new SqlParameter[2]; DelParams[0] = SqlHelper.GetParameter("@OrderNo", model.OrderNo); DelParams[1] = SqlHelper.GetParameter("@CompanyCD", model.CompanyCD); SqlCommand delCmd = new SqlCommand(sbDel.ToString()); delCmd.Parameters.AddRange(DelParams); #endregion #region 添加新的明细 foreach (WebSiteSellOrderDetailModel item in modelList) { SqlParameter[] detailParams = null; SqlCommand detailCmd = new SqlCommand(GetDetailSql(item, ref detailParams)); detailCmd.Parameters.AddRange(detailParams); CmdList.Add(detailCmd); } #endregion #endregion return SqlHelper.ExecuteTransWithCollections(CmdList); }
/// <summary> /// 修改订单方法 /// </summary> /// <param name="model">站点订单主表信息</param> /// <param name="modelList">站点订单明细信息</param> /// <returns>true:成功,false:失败</returns> public static bool Edit(WebSiteSellOrderModel model, List<WebSiteSellOrderDetailModel> modelList) { return Data.CustomAPI.CustomWebSite.WebSiteOrderDBHelper.Edit(model, modelList); }
public bool CreateOrder(WebSiteSellOrderModel model, List<WebSiteSellOrderDetailModel> modelList) { return WebSiteOrderBus.Create(model, modelList); }