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