/// <summary> /// 更新POS机状态表 /// </summary> /// <returns></returns> public int UpdatePosStatus(t_sys_pos_status posStatus) { return(dal.UpdatePosStatus(posStatus)); }
/// <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); }