/// <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);
}
