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