/// <summary> /// 批量增加产品匹配 /// </summary> /// <returns></returns> public bool Add_Gpo_Product_Map_Batch(string [] sArray) { using (DbTransaction dbTran = DbFacade.BeginTransaction(DbFacade.OpenConnection())) { try { bool bFlag = DbFacade.SQLExecuteNonQuery(sArray, dbTran); DbFacade.CommitTransaction(dbTran); return(bFlag); } catch { DbFacade.RollbackTransaction(dbTran); throw; } } }
/// <summary> /// 订单明细作废--业务逻辑方法 /// </summary> /// <param name="input"></param> /// <returns>订单主表ID</returns> public string doOrderItemCancel(OrderItemInputModel input) { string orderItemId = input.OrderItemId; string userId = input.UserId; string userName = input.UserName; //(1)把原订单明细表的item_status设为5作废(order_type设为0蓝票),往订单状态表中插入一条记录 ///先取出记录作为备份。 DataTable gpoOrderItemTable = RetrieveByPK(orderItemId); string orderId = ""; foreach (DataRow row in gpoOrderItemTable.Rows) { orderId = row["ORDER_ID"].ToString(); } using (DbTransaction transaction = base.DbFacade.BeginTransaction(base.DbFacade.OpenConnection())) { try { UpdateOrderItem(orderItemId, "5", "0", userId); //往订单状态表中插入一条记录 //AddGpoItemStatus(orderItemId, "5", userId, userName); //(2)往订单明细表中增加一条与原订单明细相同的信息(订购量为原来的负值,order_type设为2 红冲)创建时间为原订单明细的时间, long newItemId = CopyGpoOrderItem(orderItemId, input.HighId); //往订单状态表中插入一条记录 //AddGpoItemStatus(newItemId, "2", userId, userName); //更新订单主表的状态 UpdateOrderState(orderId, userId); //更新订单主表的订购金额 UpdateRequestTotalByOrder(orderId, userId); DbFacade.CommitTransaction(transaction); } catch { base.DbFacade.RollbackTransaction(transaction); throw; } } //返回orderId return(orderId); }
//对接产品对照表 新增记录 public bool Add_Gpo_Product_Map(Gpo_Product_MapModel input, out string strID) { bool flag = false; using (DbTransaction dbTran = DbFacade.BeginTransaction(DbFacade.OpenConnection())) { try { DbFacade.SQLExecuteNonQuery(CreateProductComprison(input, out strID)); flag = true; DbFacade.CommitTransaction(dbTran); } catch (Exception ex) { DbFacade.RollbackTransaction(dbTran); throw ex; } } return(flag); }
/// <summary> /// 重载取消匹配 /// </summary> public void cancelmatch(string sRecord_ID) { string sCommand = "update gpo_corp_map set org_id = null,data_org_id = null,ismap = '0', sync_state = '0' where id ='" + sRecord_ID + "'"; int iCount = 0; using (DbTransaction dbTran = DbFacade.BeginTransaction(DbFacade.OpenConnection())) { try { iCount = DbFacade.SQLExecuteNonQuery(sCommand); if (iCount > 0) { DbFacade.CommitTransaction(dbTran); } } catch { DbFacade.RollbackTransaction(dbTran); throw; } } }
/// <summary> /// 更新退货明细表 /// </summary> /// <param name="Keys"></param> /// <param name="ui"></param> /// <param name="status">1--同意/0--拒绝/other--错误</param> /// <returns></returns> public bool UpdateReturnStatus(SalerReturnModel[] Keys, UserInfo ui, string status) { bool flg = false; int result; int result1 = 1; string sql; string sql1; if (status.Equals("1")) { sql = "UPDATE ORD_ORDER_RETURN SET RETURN_STATE = '3',SALER_REMARK = :REMARK ,MODIFY_USERID = :USERID,MODIFY_DATE = SYSDATE WHERE ID = :ID"; } else if (status.Equals("0")) { sql = "UPDATE ORD_ORDER_RETURN SET RETURN_STATE = '4',SALER_REMARK = :REMARK ,MODIFY_USERID = :USERID,MODIFY_DATE = SYSDATE WHERE ID = :ID"; } else { return(false); } DbParameter paraUserID = this.DbFacade.CreateParameter(); paraUserID.ParameterName = "USERID"; paraUserID.DbType = DbType.String; paraUserID.Value = ui.UserId; using (DbTransaction transaction = base.DbFacade.BeginTransaction(base.DbFacade.OpenConnection())) { try { for (int i = 0; i < Keys.Length; i++) { DbParameter paraRemark = this.DbFacade.CreateParameter(); paraRemark.ParameterName = "REMARK"; paraRemark.DbType = DbType.String; paraRemark.Value = Keys[i].Remark; DbParameter paraID = this.DbFacade.CreateParameter(); paraID.ParameterName = "ID"; paraID.DbType = DbType.String; paraID.Value = Keys[i].Id; result = DbFacade.SQLExecuteNonQuery(sql, transaction, paraRemark, paraUserID, paraID); if (status.Equals("1")) { //sql1 = "UPDATE ORD_ORDER_RECEIVE SET RECEIVE_QTY = :RECEIVE_QTY WHERE ID = :RECEIVE_ID"; sql1 = "UPDATE ORD_ORDER_RECEIVE SET RECEIVE_QTY = " + Keys[i].StrReceiveQty.ToString() + " WHERE ID = '" + Keys[i].StrReceiveID + "'"; //DbParameter paraReceiveID = this.DbFacade.CreateParameter(); //paraReceiveID.ParameterName = "RECEIVE_ID"; //paraReceiveID.DbType = DbType.String; //paraReceiveID.Value = Keys[i].StrReceiveID; //DbParameter paraReceiveQty = this.DbFacade.CreateParameter(); //paraReceiveQty.ParameterName = "RECEIVE_QTY"; //paraReceiveQty.DbType = DbType.Double; //paraReceiveQty.Value = Keys[i].StrReceiveQty; //result1 = DbFacade.SQLExecuteNonQuery(sql1, transaction, paraReceiveQty, paraReceiveID); result1 = DbFacade.SQLExecuteNonQuery(sql1, transaction); } if (result > 0 && result1 > 0) { flg = true; } else { flg = false; base.DbFacade.RollbackTransaction(transaction); break; } } DbFacade.CommitTransaction(transaction); } catch { base.DbFacade.RollbackTransaction(transaction); throw; } } return(flg); }