/// <summary> /// 终端采购主信息 /// </summary> /// <returns></returns> public string InPMSheetMaster(t_pm_sheet_master _sheetMaster) { int num; //总价格 decimal?sheetAmt = 0; List <t_pm_sheet_detail> sheetDetail = new List <t_pm_sheet_detail>(_sheetMaster.detailList); foreach (t_pm_sheet_detail _sd in sheetDetail) { DataTable dt = (DataTable)this.GetItemInfo(_sd.item_no).Tables[0]; sheetAmt = Convert.ToDecimal(dt.Rows[0]["price"].ToString()) * _sd.real_qty; } _sheetMaster.sheet_no = "YH" + _sheetMaster.branch_no + this.GetSheetMasterNo(); SqlParameter[] parameters = { new SqlParameter("@sheet_no", _sheetMaster.sheet_no), new SqlParameter("@trans_no", "YH"), new SqlParameter("@db_no", "+"), new SqlParameter("@branch_no", _sheetMaster.branch_no), new SqlParameter("@d_branch_no", _sheetMaster.d_branch_no), new SqlParameter("@supcust_no", _sheetMaster.oper_id), new SqlParameter("@approve_flag", '0'), new SqlParameter("@oper_date", DateTime.Now), new SqlParameter("@order_status", "0"), new SqlParameter("@oper_id", _sheetMaster.oper_id), new SqlParameter("@confirm_man", ""), new SqlParameter("@sale_way", "A"), new SqlParameter("@sheet_amt", sheetAmt), new SqlParameter("@memo", "测试") }; SqlTransaction tran = null; try { tran = SqlTransHelper.GetSqlTransaction(); num = SqlHelper.ExecteNonQuery(SqlTransHelper.conn, tran, CommandType.Text, this.GetSqlInsertSheetMaster(), parameters); num = this.InsertSheetDetailList(new List <t_pm_sheet_detail>(_sheetMaster.detailList), _sheetMaster, tran); } catch (Exception exception) { tran.Rollback(); SqlTransHelper.Close(); tran.Dispose(); throw exception; } tran.Commit(); tran.Dispose(); SqlTransHelper.Close(); return(_sheetMaster.sheet_no); }
public bool InPayFlowList(List <t_rm_payflow> payFlow) { int num = 0; bool iscomplete = true; SqlTransaction tran = null; try { tran = SqlTransHelper.GetSqlTransaction(); foreach (t_rm_payflow _payFlow in payFlow) { SqlParameter[] parameters = { new SqlParameter("@flow_id", _payFlow.flow_id), new SqlParameter("@flow_no", _payFlow.flow_no), new SqlParameter("@sale_amount", _payFlow.sale_amount), new SqlParameter("@branch_no", _payFlow.branch_no), new SqlParameter("@pay_way", _payFlow.pay_way), new SqlParameter("@sell_way", _payFlow.sell_way), new SqlParameter("@card_no", _payFlow.card_no == null?"":_payFlow.card_no), new SqlParameter("@vip_no", _payFlow.vip_no == null?"":_payFlow.vip_no), new SqlParameter("@coin_no", _payFlow.coin_no), new SqlParameter("@coin_rate", _payFlow.coin_rate), new SqlParameter("@pay_amount", _payFlow.pay_amount), new SqlParameter("@oper_date", _payFlow.oper_date), new SqlParameter("@oper_id", _payFlow.oper_id), new SqlParameter("@counter_no", "0001"), new SqlParameter("@sale_man", "9999"), new SqlParameter("@memo", _payFlow.memo), new SqlParameter("@voucher_no", _payFlow.voucher_no == null?"":_payFlow.voucher_no), new SqlParameter("@remote_flag", ""), new SqlParameter("@exchange_flag", ""), new SqlParameter("@shift_no", "0"), new SqlParameter("@com_flag", ""), new SqlParameter("@posid", _payFlow.posid == null?"":_payFlow.posid), new SqlParameter("@uptime", _payFlow.uptime == null?DBNull.Value as object:_payFlow.uptime), new SqlParameter("@is_jxc", "1"), new SqlParameter("@real_date", _payFlow.oper_date) }; num = SqlHelper.ExecteNonQuery(SqlTransHelper.conn, tran, CommandType.Text, this.GetSqlInsertPayFlow(), parameters); if (num > 0) { if (_payFlow.saleFlowlList != null) { num = this.InsertSaleFlow(new List <t_rm_saleflow>(_payFlow.saleFlowlList), tran); if (num <= 0) { iscomplete = false; break; } } } else { iscomplete = false; break; } } if (iscomplete) { tran.Commit(); } } catch (Exception exception) { tran.Rollback(); throw exception; } finally { SqlTransHelper.Close(); if (tran != null) { tran.Dispose(); } } return(num > 0 ? true : false); }
/// <summary> /// POS机状态表 /// </summary> /// <returns></returns> public int UpdatePosStatus(t_sys_pos_status posStatus) { if (posStatus.branch_no.Trim().Equals("")) { return(1001); } if (posStatus.posid.Trim().Equals("")) { return(1002); } if (posStatus.lasttime.ToString().Equals("")) { return(1003); } if (posStatus.lastcashier.Trim().Equals("")) { return(1004); } if (posStatus.load_flag.Trim() == "") { return(1005); } StringBuilder strSql = new StringBuilder(); int num = 0;; strSql.Append("UPDATE t_sys_pos_status SET"); strSql.Append(" (branch_no=@branch_no,posid=@posid,posdesc=@posdesc, hostip=@hostip,"); strSql.Append(" hostname=@hostname, operdate=@operdate, amount=@amount,orderqty=@orderqty,"); strSql.Append(" orderqty=@orderqty, lasttime=@lasttime, lastcashier=@lastcashier, status=@status,"); strSql.Append(" other=@other, com_flag=@com_flag, load_flag=@load_flag)"); SqlTransaction tran = null; try { tran = SqlTransHelper.GetSqlTransaction(); SqlParameter[] parameters = { new SqlParameter("@branch_no", posStatus.branch_no), new SqlParameter("@posid", posStatus.posid), new SqlParameter("@posdesc", posStatus.posid), new SqlParameter("@hostip", posStatus.posid), new SqlParameter("@hostname", posStatus.posid), new SqlParameter("@operdate", posStatus.posid), new SqlParameter("@amount", posStatus.amount), new SqlParameter("@orderqty", posStatus.orderqty), new SqlParameter("@lasttime", posStatus.lasttime), new SqlParameter("@lastcashier", posStatus.lastcashier), new SqlParameter("@status", posStatus.status), new SqlParameter("@other", posStatus.other), new SqlParameter("@com_flag", posStatus.com_flag.Trim().Equals("")?"0":posStatus.com_flag), new SqlParameter("@load_flag", posStatus.load_flag) }; DataTable dtTemp = GetPosStatus(posStatus.branch_no).Tables[0]; SqlParameter[] parms = { new SqlParameter("@branch_no", dtTemp.Rows[0]["branch_no"]), new SqlParameter("@posid", dtTemp.Rows[0]["posid"]), new SqlParameter("@posdesc", dtTemp.Rows[0]["posdesc"]), new SqlParameter("@hostip", dtTemp.Rows[0]["hostip"]), new SqlParameter("@hostname", dtTemp.Rows[0]["hostname"]), new SqlParameter("@operdate", dtTemp.Rows[0]["operdate"]), new SqlParameter("@amount", dtTemp.Rows[0]["amount"]), new SqlParameter("@orderqty", dtTemp.Rows[0]["orderqty"]), new SqlParameter("@lasttime", dtTemp.Rows[0]["lasttime"]), new SqlParameter("@lastcashier", dtTemp.Rows[0]["lastcashier"]), new SqlParameter("@status", dtTemp.Rows[0]["status"]), new SqlParameter("@other", dtTemp.Rows[0]["other"]), new SqlParameter("@com_flag", dtTemp.Rows[0]["com_flag"]), new SqlParameter("@load_flag", dtTemp.Rows[0]["load_flag"]) }; num = SqlHelper.ExecteNonQuery(SqlTransHelper.conn, tran, CommandType.Text, this.GetSqlInsertPosStatus(), parms); num = SqlHelper.ExecteNonQuery(SqlTransHelper.conn, tran, CommandType.Text, strSql.ToString(), parameters); } catch (Exception exception) { tran.Rollback(); SqlTransHelper.Close(); tran.Dispose(); throw exception; throw exception; } tran.Commit(); tran.Dispose(); SqlTransHelper.Close(); return(num); }