public void DeleteRentAttribute(RentAttribute rentAttribute) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); strSql1.Append(" Update Rent_Rent set IsAvailable=0"); strSql1.Append(" where RentNo = '" + rentAttribute.RentNo + "'"); //Update strSql.Append(" Update Rent_RentAttribute set RRAIsActive=1, RRAStatus='5', "); strSql.Append(" RRAModifiedBy='" + rentAttribute.RRAModifiedBy + "',"); strSql.Append(" RRAModifiedDate='" + rentAttribute.RRAModifiedDate.Value.ToString("yyyy-MM-dd hh:mm:ss") + "'"); strSql.Append(" where RRAID = '" + rentAttribute.RRAID + "'"); SysLogHelper.AddLog(rentAttribute.RRAModifiedBy, "删除租赁信息ID:" + rentAttribute.RentNo, "删除-租赁信息"); List <SqlCommand> listSQL = new List <SqlCommand>(); listSQL.Add(MySQLHelper.CreateCommand(strSql.ToString())); listSQL.Add(MySQLHelper.CreateCommand(strSql1.ToString())); MySQLHelper.ExecuteNonQueryTrans(SqlConnString, listSQL); //清除密码和IC卡信息 ClearPasswordToLock(rentAttribute.RRAID.ToString()); }
public void UpdateOrderInfo(string id, string appId, string body, string mchId, string tradeNo, string fee, string prepayId) { StringBuilder strSql = new StringBuilder(); strSql.Append(" Update Rent_RentAttribute set "); strSql.Append(" AppId='" + appId + "',"); strSql.Append(" Body='" + body + "',"); strSql.Append(" MchId='" + mchId + "',"); strSql.Append(" TradeNO='" + tradeNo + "',"); strSql.Append(" TotalFee=" + fee + ","); strSql.Append(" PrepayID='" + prepayId + "'"); strSql.Append(" where RRAID = " + id); SysLogHelper.AddLog("0", "更新租赁订单信息ID:" + id, "修改-租赁信息"); List <SqlCommand> listSQL = new List <SqlCommand>(); listSQL.Add(MySQLHelper.CreateCommand(strSql.ToString())); //listSQL.Add(MySQLHelper.CreateCommand(strSql1.ToString())); MySQLHelper.ExecuteNonQueryTrans(SqlConnString, listSQL); }
public void UpdateRentAttribute(RentAttribute rentAttribute) { StringBuilder strSql = new StringBuilder(); strSql.Append(" Update Rent_RentAttribute set "); strSql.Append(" RRAContactName='" + rentAttribute.RRAContactName + "',"); strSql.Append(" RRAContactTel='" + rentAttribute.RRAContactTel + "',RRANationName='" + rentAttribute.RRANationName + "',"); strSql.Append(" RRAIDCard = '" + rentAttribute.RRAIDCard + "', RRentPrice = '" + rentAttribute.RRentPrice + "',"); strSql.Append(" RRAContactProvince='" + rentAttribute.RRAContactProvince + "',"); strSql.Append(" RRAStartDate='" + rentAttribute.RRAStartDate + "',RRAEndDate='" + rentAttribute.RRAEndDate + "',"); strSql.Append(" RRADescription='" + rentAttribute.RRADescription + "',"); strSql.Append(" RRAModifiedBy='" + rentAttribute.RRAModifiedBy + "',"); strSql.Append(" RRAModifiedDate='" + rentAttribute.RRAModifiedDate.Value.ToString("yyyy-MM-dd HH:mm:ss") + "'"); strSql.Append(" where RRAID = '" + rentAttribute.RRAID + "'"); SysLogHelper.AddLog(rentAttribute.RRAModifiedBy, "修改租赁信息ID:" + rentAttribute.RentNo, "修改-租赁信息"); List <SqlCommand> listSQL = new List <SqlCommand>(); listSQL.Add(MySQLHelper.CreateCommand(strSql.ToString())); //listSQL.Add(MySQLHelper.CreateCommand(strSql1.ToString())); MySQLHelper.ExecuteNonQueryTrans(SqlConnString, listSQL); }